Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Linki to other server using sp_addlinkedserver

Locked Linki to other server using sp_addlinkedserver

  • Wednesday, October 28, 2009 8:26 AM
     
     
    Sign In to Vote
    0
    Dear All,

                   i'm new to linked server... i just got some sample and tryed this.. but i get below error message, all the credital information are correct..

    EXEC sp_addlinkedserver
       @server = 'sampledb951',
       @srvproduct = '',
       @provider = 'SQLNCLI',
       @provstr = 'DRIVER={SQL Server};SERVER=192.168.0.95;UID=sa;PWD=admin123;',
       @catalog = 'sampledb'

    the above executes fine... but error comes when i execute the below line

    SELECT * FROM sampledb951...fo_rsrvtn_hdr

    fo_rsrvtn_hdr is the table inside sampledb database...

    can any one say where a'm i going wrong

    Narayanan Dayalan - Zeetaa Business Solutions
       

    All Replies

    • Wednesday, October 28, 2009 10:36 AM
       
       
      Sign In to Vote
      0
      oops i forgot to post what the error is, here is the error i get

      Msg 7313, Level 16, State 1, Line 1
      An invalid schema or catalog was specified for the provider "SQLNCLI" for linked server "sampledb951".

      Narayanan Dayalan - Zeetaa Business Solutions
         
      • Tuesday, November 03, 2009 8:24 AM
        Moderator
         
         Answered
        Sign In to Vote
        0
        Hi
        Does your issue related with the SQL development, you can publish your issue on below forum
        http://social.technet.microsoft.com/Forums/en-US/category/sqlserver

        Regards!