Post reply

Linking Additional Catalogs to a Linked Server

  • January 26, 2010 at 8:51 am

    #137608

    Hi

    I have 2 SQL2005 servers linked with a number of databases on the first server executing queries from the second server. The database names on the second server are all set up as Catalogs under the Linked Server entry on the first server. We have added a new pair of datbases and I cannot see a simple way of adding the new database to the list of database catalogs on the first server...or am I missing something obvious?

    Thanks

    David

  • January 26, 2010 at 9:05 am

    #1108747

    If you have refreshed the list and are still not seeing them, it may be just permissions on the new databases, make sure that the account used in the linked server has access to the newly created databases on the second server (also, be sure they have database-level connect granted). Also, something to watch out for is if you are using the login’s current security context it actually might be authenticating as NT AUTHORITY/ANONYMOUS if you have any SSPI/ authentication issues.

  • January 26, 2010 at 11:39 am

    #1108854

    Thank you David, you were absolutely right, it was a permissions issue

    Regards

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply