1

I'm trying to update a target server using the Schema Compare feature in Visual Studio 2019. Upon checking the sys.servers table, I can see the linked server and confirmed that I can run queries against it without any issues. However, I'm unable to update the target server in my DacPac and this is the error I'm getting.

Could not find server 'servername' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

I've tried adding a database reference to the database it's expecting and building the project solution without any success. I would appreciate any suggestions on how to fix this. Thanks!

Improve this question
Related questions
1370
Difference between Build Solution, Rebuild Solution, and Clean Solution in Visual Studio?
968
How do you count the lines of code in a Visual Studio solution?
1322
.gitignore for Visual Studio Projects and Solutions
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.