SQL Server Error 7202 Could not find server

5 pts.
Tags:
SQL error messages
SQL Server
SQL Server errors
SQL Server stored procedures
Hi all, I am currently running into the following error when run a stored procedure with BEGIN TRANS:
 "Could not find server 'VS-DEVELOPERDEVELOPER_SQL' in sysservers. Execute sp_addlinkedserver to add the server to sysservers."
The server shown above is the a local sql server instance that is running the stored procedure and therefore shouldn't need to be linked. Am I misunderstanding the linked server definition or is there another underlying issue with the stored procedure?


Software/Hardware used:
SQL Server 2005

Answer Wiki

Thanks. We'll let you know when a new response is added.

Sounds like the stored procedure is looking for a linked server as part of the code, but that linked server doesn’t exist. You’ll need to look at the source code of the stored procedure to be sure.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jabeam
    [...] Mrdenny got to the bottom of SQL Server error 7202: Could not find server. 6. Mrdenny has a quick suggestion for multipath [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following