Error message when you try to import an object schema that references a linked server in Visual Studio 2005 Team Edition for Database Professionals: "Could not find server 'ServerName' in sysservers. Execute sp_addlinkedserver to add the server to sysserv

Article translations Article translations
Article ID: 928964 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you try to import an object schema that references a linked server in Microsoft Visual Studio 2005 Team Edition for Database Professionals, you may receive an error message that resembles the following:
Could not find server 'ServerName' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

WORKAROUND

To work around this problem, create a linked server on the design database. The design database is a local instance of Microsoft SQL Server that is used to perform design-time validation of the database project. To create a linked server, run the following command:
exec sp_addlinkedserver '<ServerName>', 'sql server'
After you run this command, you do not receive this error message. However, the warning remains because the linked server is not supported in Visual Studio 2005 Team Edition for Database Professionals. You can still build, validate, and deploy the rest of the project.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 928964 - Last Review: December 13, 2006 - Revision: 1.0
APPLIES TO
  • Microsoft Visual Studio 2005 Team Edition for Database Professionals
Keywords: 
kbtshoot kbprb KB928964

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com