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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Linked Servers

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-29 : 12:06:53
Teresa writes "SQL Server 7.0/Windows 2000

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

Issue:

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,
Teresa"

nr
SQLTeam MVY

12543 Posts

Posted - 2001-12-29 : 14:57:03
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

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2001-12-30 : 02:10:53
Looks like we got duplicate requests...

[url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=11647[/url]

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

TJ
Posting Yak Master

201 Posts

Posted - 2001-12-31 : 11:54:03
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

TJ
Posting Yak Master

201 Posts

Posted - 2002-01-04 : 18:25:34
quote:

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
   

- Advertisement -