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 |
|
tjmelcher
Starting Member
3 Posts |
 Posted - 2008-08-14 : 17:16:07
|
| I am having a problem with a linked server. I have 52 linked servers on one server. All of the connections work correctly but one. On this one, I can run a select from my source server to the problem server and it runs fine. When I run a job against it that runs stored procedures, I get the following error.SQLState = 42000, NativeError = 7202Error = [Microsoft][SQL Native Client][SQL Server]Could not find server 'Myserver' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.NULLThe server name exists in the linked servers with the correct security.If anyone has come across this problem, please let me know how you fixed it.Thank you in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-14 : 18:49:43
|
| where do you run Job? Source or linked? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-14 : 23:05:24
|
| Did you query master.sys.servers to see if it's in result? |
|
|
|
tjmelcher
Starting Member
3 Posts |
Posted - 2008-08-15 : 10:13:52
|
| I run the job on the source and link to 'Myserver'When i query the master.sys.servers, I can see the Linked server in the results. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-15 : 11:06:00
|
| How does you SP look like? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-16 : 18:08:17
|
| Who is job owner? How did you map user in linked server? |
|
|
|
tjmelcher
Starting Member
3 Posts |
Posted - 2008-08-22 : 11:41:14
|
| The owner of the job is the sql service. It works on all other linked servers other than this one. |
|
|
|
|
|
|
Linked Server Error