Cannot find server in sys.servers

Answered

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

 

0
1 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.

0

Please sign in to leave a comment.