Post reply

Linked Servers 2005->2005 and 2005->2008R2 Express - Guidance

  • May 22, 2012 at 6:05 am

    #258516

    Hi,

    I have 3 servers in my configuration ;

    [1]SQL 2005 Standard

    [2]SQL 2005 Standard

    [3]SQL 2008R2 Express ( Named Instance )

    on Server [1] I have created a Linked Server reference to Server [2] - and polling the data through queries using the 4 node statement.

    when I try and create the Linked Server from [1] to [3] I am getting a connection refused error - Named Pipes Provider: Could not open a connection to SQL Server [5], Error 5.

    My question is of 2 parts;

    [1]Can you link to a SQL 2008R2 Express Edition ?

    (I do have the media for R2 Standard, so could upgrade if neccessary)

    [2]Do you have to link to the "Server" or to the "Named Instance" - ( I am guessing the Server name, with the named instance being listed under the catalogs! )

    Any help would be appreciated.

    Steve

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.

  • May 22, 2012 at 6:14 am

    #1491012

    By default, remote connections are disabled in SQL Server. Express edition is generally installed as a named instance, so you'll need to:

    1) Enabled Named Pipes and/or TCP/IP in SQL Server Configuration Manager on the Express server

    2) Enable and start the SQL Browser service, so it can locate the service - alternatively, you'll have to fix the port that the Express server runs from and create an alias on the other server.

    This article explains this quite well:

    http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx

  • May 22, 2012 at 7:44 am

    #1491086

    Thanks for your help -

    I have set this up from the express sql - and works fine, so this is a problem with going to the express server from standard.

    I am now setting up the ports and resolving those issues so can "pull" from express on the standard box.

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.

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

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