locked
Catalog missing from Linked Server RRS feed

  • Question

  • 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?


    • Edited by VijayKSQL Monday, March 4, 2019 6:24 PM Add
    Monday, March 4, 2019 6:24 PM

Answers

  • 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 1:10 PM

All replies

  • 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

    Tuesday, March 5, 2019 7:10 AM
  • 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 1:10 PM