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.