Post reply

Problem connecting to Linked server

  • May 15, 2006 at 7:25 am

    #168934

    Hi,

    I have installed SQL Server 2005 on 2 machines say machine1 and machine2. I want to add machine2’s named instance (viz., Instance1) as a liked server to machine1. This I achieve by executing the following procedure:

    sp_addlinkedServer @server='Machine2_Instance1',

    @srvproduct='',

    @provider='SQLNCLI',

    @datasrc='machine2\Instance1'

     

    I saw an example in BooksOnline and followed the same for my SQL 2005 Server. But I am not able to access machine2\Instance1’s database using my SQL Server Management studio. I am getting an error:

    An error has occurred while establishing a connection to the server. When connecting to the SQL server this failure may be caused by the fact that unser the default settings SQL Server does not allow remote connections.

    Also I am not able to execute the following query:

    SELECT * FROM [chnshl21514\Instance1].master.dbo.sysmessages from machine1.

    I am getting the following error:

    Could not find server 'chnshl21514\Instance3' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

    Is the syntax wrong? Please help.

    Thanks in Advance.

    Sandhya

  • May 15, 2006 at 10:04 am

    #637906

    Hope this link has the info to resolve your issue..

    http://www.datamasker.com/SSE2005_NetworkCfg.htm

    Thx..

    Prasad Bhogadi
    www.inforaise.com

  • May 16, 2006 at 1:14 am

    #638064

    Hi,

    Still I face the problem.

    Thanks,

    sandhya

  • May 16, 2006 at 9:43 am

    #638188

    is the second SQL Server in your SQL Server box hosts file?  If not add it

    Eric

Viewing 4 posts - 1 through 4 (of 4 total)

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