SQL Server Performance Forum – Threads Archive

Linked Server error

Hi,
I am getting an error when I run my job from one the server. The job error says that i have to run execuate sp_addlinked sever? The job which runs on the server uses linked server. can someone explain why would I get this error? I have linked set up correctly and it does run my other jobs without any error. Any comments would be appreciate…pls help –puja

What’s the name of the linked server? Can you post the snippet of code that’s failing? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

Hi,
Here is what I do with my stored procedure.. I have production server(Server1) and I have another server which I run my
sql job (SERVER2). The production server is lined using link login to connect the SERVER2. The server2 has job which runs the stored procedure from server1(prod server.) as SERVER1.employee.dbo.sp_employeex stored precedure. This stored procedure creates
the tables inot tempdb database and insert the data into tables. once everything is inserted, the server2 selects the data from server1 tempdb table… I believe is that the way security is set on my tempdb table but I am not seem to figure it out. I hope this helps to help my where do I exactly fix my error. The error says :Error string: could not find server "SERVER1" in sysservers. EXECUATE sp_addlinkedserver to add the server to sysservers. This error comes when I run the job from SERVER2 machine. pls help..

Is the problem associated with SQL Server 2005?
As the error message refers use SP_ADDLINKEDSERVER to add the specified server2, refer
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp fyi.
Ensure SQLagent has required privileges on both the servers. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

yes, I am using sql 2005 for my production box. The job which run is using sql 2000. thanks, I will try to run the SP_addlined sever query to my server2 box. i hope this helps…

Also check and ensure the SQLAgent startup account privileges. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>