Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Linked Servers
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 12/29/2001 :  12:06:53  Show Profile  Visit AskSQLTeam's Homepage
Teresa writes "SQL Server 7.0/Windows 2000

I wasn't sure which forum to post this in. Any help would be appreciated.


I have two servers which I've successfully linked together.

I am able to link server2 to server1, run a query that extracts data from server1 and inserted it into server2.

Once the data in server2 is updated, I then need to link server1 to server2, read in the data, and update fields on server1.

I can connect and log onto Server2 from Server1. However, when I run a select statement

ie: select * from NTSSQL2.ih_accounts.dbo.ih_accounts

I get the following error message:

'Specified SQL server not found.'

This is not an issue when running the select from server2 to server1.

Please advise on how to resolve this issue.

Thank you!

Best regards,


United Kingdom
12543 Posts

Posted - 12/29/2001 :  14:57:03  Show Profile  Visit nr's Homepage
What do you mean log in to server2 from server1 - presumably not via the linked server as the message is saying that the linked server does not exist.
Have you created the linked server entry for NTSSQL2 on server1?
What happens when you click on the linked server entry in enterprise mmanager.

Cursors are useful if you don't know sql.
Beer is not cold and it isn't fizzy.
Go to Top of Page

SQL Slashing Gunting Master

3246 Posts

Posted - 12/30/2001 :  02:10:53  Show Profile  Visit AjarnMark's Homepage
Looks like we got duplicate requests...

1000 Posts, Here I come! I wonder what my new title will be...
Go to Top of Page

Posting Yak Master

201 Posts

Posted - 12/31/2001 :  11:54:03  Show Profile
This is still an issue, albeit not the most important one. I was never able to get server1 to select, update, etc to server2. I could link them and log on but I couldn't get it to do any work. I still get the error message. I had to work around this issue and do all of the work from server2 to server1 because that was the link that worked.

Have a safe and happy holiday!

Go to Top of Page

Posting Yak Master

201 Posts

Posted - 01/04/2002 :  18:25:34  Show Profile

This issue has been resolved. It didn't work because I was linking to an 'alias' instead of the actual server name.

Thanks for the help!

Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000