SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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  

AskSQLTeam
Ask SQLTeam Question

USA
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.

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

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

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

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

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

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

TJ
Posting Yak Master

USA
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

TJ
Posting Yak Master

USA
201 Posts

Posted - 01/04/2002 :  18:25:34  Show Profile
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
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000