Catalog missing from Linked Server
Question
Monday, March 4, 2019 6:24 PM
We recently configured Linked Servers (Sql Server 2016 Ent).Everything is working fine.
But today userdb missing from LinkedServer only default catalog are showing.
I logged in with SA user. How to add missing DB back to Catalog?
All replies (2)
Tuesday, March 5, 2019 1:10 PM âś…Answered
A quick way is to drop and recreate it by right-clicking the linked server in question --> script linked server as-->select DROP and CREATE TO. Make the desired changes (add @catalog parameter) to the exported script and run it to drop the existing one and create a new one.
Alternatively, a few options can be changed via sp_serveroption, but I don't think the catalog is one of them.
Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.
Tuesday, March 5, 2019 7:10 AM
Hi VijayK,
According to your description, you configured linked server to Sql Server 2016 and you can only view the system database. If anything is misunderstood, please tell me.
If you check the impersonate, you can use the sa account to connect to the server to check if the user database has been accidentally deleted.
If you use login mappings, please check whether the permissions of the remote user change or if you changed the remote user.
Best regards,
Dedmon Dai
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com