|
Can you please explain how to setup a linked server between a SQL Server (A) and a SQL Server Express (B) scenario.
Server A is SQL Server 2000, whereas Server B is SQL Server 2005 Express.
I have set these up in the past, but none where connected to ...
Started by Billy Logan on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
server Express supports linked servers.
|
|
Please explain what is required to set up a SQL Server linked server.
Server A is SQL 2005 windows logins only Server B is the same (SQL 2005 windows logins only)
Server A runs windows XP Server B runs Windows Server 2003
Both SQL Server services are ...
Started by ScottStonehouse on
, 7 posts
by 6 people.
Answer Snippets (Read the full thread at serverfault):
You can also use SQL Server Management Studio (SSMS SSMS and connect to one of the instances of SQL Server you want to link Expand "Server Objects" in Object Explorer Right click "Linked....
This in the past on SQL 2000 with no issues .
|
|
I want to connect to sql server from my home computer to my servers sql server.
I know people say this is a security issue, but rackspace cloud sites seems to be allowing it? :)
Anyhow, how hard is it to do?
Answer Snippets (Read the full thread at serverfault):
In your SQL connection, you then use the IP address (or the FQDN if it has one) of your don't mention the SQL Server version....
The SQL port is usually SQL server.
You need to have the SQL server port opened through your office firewall.
|
Ask your Facebook Friends
|
I have 3 seperate physical servers:
Old Webserver (IIS6; Windows Server 2003) New Webserver (IIS7; Windows Server 2008) DB Server (SQL 2008; Windows Server 2008) These are all non-domain standalone machines.
The sites on the new webserver connect to the...
Started by Ronnie Overby on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
That works with file shares and even authenticating people via web apps, but SQL Server itself treats the local machine like are:
Use SQL Server Integrated Authentication....
To use Pass-Through authentication in this fashion with SQL Server.
|
|
Hello, Im using SQL Server Management Studio 2008 (ssms.exe) connected with a local SQL Server 2000, so I notice that every time I try enter on Linked Server option It crash inmediatly so I want to delete all the servers linkeds there for try again.
What...
Started by Angel Escobedo on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You'll have to (at a minimum) open a connection to each server and run some form of script or command for each linked server....
I think you can only delete on linked server at a time, using sp_dropserver :
http from every server.
|
|
I'm setting up a dedicated SQL Server 2005 box on Windows Server 2008 this week, and would like to pare it down to be as barebones as possible while still being fully functional.
To that end, the "Server Core" option sounds appealing, but I'm not clear...
Started by Dave Ward on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Run the ....
Run the DHCP server role.
Run the Directory Services role.
Run the Hyper-V virtualization server role.
Not sure how credible this source is , but:
The Windows Server 2008 Core edition can:
Run the file server role.
|
|
Is it possible to configure Windows Servers that reside on the same domain such that when a web service call is made from a web app using an IP address, the request does not go via a proxy server?
The web service is running on one of the servers on the...
Answer Snippets (Read the full thread at stackoverflow):
I'm thinking that I should be able somehow to configure the server that hosts the app that needs!
It seems to me that the change would need to be made on the server hosting the app (classic ASP) so.
|
|
Hi everyone, i am moving to a new file server under Server 2008 Standard 32bit edition. I will refer to the older server as just "server", the new one i named as server2.
i have updated server2 and patched it. I have also joined the domain as member server...
Started by dasko on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
I am assuming....
It works that while undomained.
Which is to say, you CAN do it just like you found out .
Server 2008 may be different, but in general I try to avoid renaming Windows servers whenever of renaming a long-standing server.
|
|
Hi, I've setup a Server 2003 R2 as AD & DC. I created some test users on the dc. I also setup a Server 2003 R2 as a Terminal Server. I got licensing etc. working. What i cant get to work is that users can login to the terminal server. What i dont understand...
Started by Oscar on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
The terminal server will check the DC by being joined to the AD domain that your....
Have you joined the terminal server to the AD domain? Without joining it to a domain you will only be able to use local logins on the terminal server.
|
|
I have:
1 Linux "backup" server (Ubuntu 9.10 server) (plenty of disk, new server) 2 Gentoo servers 2 CentOS servers 3 Windows 2003 servers I'd like to backup all of the servers as disk-to-disk backups to the Ubuntu backup server.
HOW?
Please be gentle...
Started by TheCleaner on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
Have another....
On windows, there is a great rsync front end called DeltaCopy
In both cases, you will get incremental backups so that you aren't absorbing that disk space too fast .
For linux, it can be set up with cron jobs .
I would probably go with rsync.
|
