Post reply

Add a new database to an Already existing Linked Server

  • August 31, 2007 at 6:20 am

    #176369

    I have added a new database to our dev server and our production server.  I am trying to copy data from a table on the production server to a table on the dev server and I receive the following message.

    Msg 7314, Level 16, State 1, Line 1

    The OLE DB provider "SQLNCLI" for linked server "kopsql01" does not contain the table ""communityserver"."dbo"."cs_sitesettings"". The table either does not exist or the current user does not have permissions on that table. 

     

    I noticed the database does not exist in the catalog listing under the linked server and I cannot figure out how to add it.  I know it is probably something simple but I have searched everywhere and I can not find any information.  Any help would be appreciated.

     

  • August 31, 2007 at 7:02 am

    #730748

    The catalog will only list DB's for the user that is trying to query the linked server, so you may very well have a permissions issue. Make sure that the user who is trying to access the linked server has been given rights to the new table.

    Hope this helps.

  • August 31, 2007 at 7:05 am

    #730749

    I appreciate the reply but unfortunately I tried that and it still does not work.

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

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