Cannot find server in sys.servers
In my project i have some SP's which fetch data from Linked servers. In build setting temporary database server is set to SQL LocalDB. I have checked in sys.servers those server entry is already there. but when building the project i get error "Cannot find server in sys.servers". When i am trying to add server using sp_addlinkedserver it gives error that server already exist. Below is error log
[00:29:12]Error: Synchronization of 'Scripts.state' and
[00:29:12]'np:\\.\pipe\LOCALDB#B4ED959F\tsql\query.sqlCI_e36e7b19-facf-413a-a678-9e24e71d7
[00:29:12]3ce' failed: Could not find server 'SQLSRV11' in sys.servers. Verify that the
[00:29:12]correct server name was specified. If necessary, execute the stored procedure
[00:29:12]sp_addlinkedserver to add the server to sys.servers. Error executing the
[00:29:12]following SQL: CREATE PROCEDURE
[00:29:12][dbo].[rep_Check_Purchase_Positions] @StartDate DATE, @EndDate
Please help
Please sign in to leave a comment.
Hello,
It looks like environment issue or misconfiguration. Please investigate the issue using the guidelines. Please provide more details, if the reason is not clear.