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 |
|
TJ
Posting Yak Master
201 Posts |
 Posted - 2001-12-21 : 15:21:36
|
| I thought I'd post this issue in this forum today since I received such wonderful help yesterday. If you are unable to help me, but know of another site that could, please let me know. Thanks in advance!TeresaIssue: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. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2001-12-22 : 19:39:11
|
| I take it you do have a linked server NTSSQL2 on server1>> I then need to link server1 to server2Sounds like you may be adding a linked server? If this is done in the same SP as the select then this will fail to compile as it won't be ab;e to resolve the server.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
TJ
Posting Yak Master
201 Posts |
Posted - 2001-12-26 : 12:47:19
|
| I dropped the link from server2 to server1 and then ran another proc that linked server1 to server2. It creates the link and logs onto server2, but when I try to run code it says it cannot find the specified sql server. I'm doing all of this linking, logging, etc. as sa. Is there a setting on the server that needs turned on, reallocated, something? |
|
|
|
|
|
|
|
|
SQL Server Error