Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kumar16
Starting Member
3 Posts |
 Posted - 2009-01-13 : 07:11:45
|
| Hi All, I have SQL Server 2000 installed one on windows 2000 and another on windows XP Service pack2 . I am able to connect both the servers locally on corresponding machines , But whenever I am trying to connect the Server from second machine I am not able to connect the server.Please help. |
|
|
GRAYWOLF
Posting Yak Master
106 Posts |
Posted - 2009-01-13 : 07:14:30
|
| Are you trying to link them?---------------------------Working until "the morning sun sets the midnight sky on fire"! |
 |
|
|
kumar16
Starting Member
3 Posts |
Posted - 2009-01-13 : 07:28:59
|
what do you mean by link ? I want to use query analyzer of Server running on XP on windows 2000.quote:
Originally posted by GRAYWOLF
Are you trying to link them?---------------------------Working until "the morning sun sets the midnight sky on fire"!
|
|
|
|
GRAYWOLF
Posting Yak Master
106 Posts |
Posted - 2009-01-13 : 07:35:45
|
| If you want SQL on one server to talk to SQL on another server they have to be linked. Open Enterprise Manager, right click on Linked Servers in the Security folder. Click New Linked Server...Fill in the blanks in the wizard. This will link the servers giving you the ability to communicate between them.---------------------------Working until "the morning sun sets the midnight sky on fire"! |
|
|
|
kumar16
Starting Member
3 Posts |
Posted - 2009-01-13 : 07:43:56
|
Ok I have linked the server and and i give Server name over there But still not able to connectquote:
Originally posted by GRAYWOLF
If you want SQL on one server to talk to SQL on another server they have to be linked. Open Enterprise Manager, right click on Linked Servers in the Security folder. Click New Linked Server...Fill in the blanks in the wizard. This will link the servers giving you the ability to communicate between them.---------------------------Working until "the morning sun sets the midnight sky on fire"!
|
|
|
|
GRAYWOLF
Posting Yak Master
106 Posts |
Posted - 2009-01-13 : 08:42:11
|
| How are you trying to connect? Did the attempt to link the servers cause any errors?Try this code on a small table, substituting actual server name, DB and tables:select * from [server].[DB].dbo.[table]---------------------------Working until "the morning sun sets the midnight sky on fire"! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-13 : 10:44:46
|
| Does login exist in other server? |
|
|
|
|
|
|
Unable to connect to server