Post reply

error to connect remote named instance in sqlserver 2005 developer edition

  • May 25, 2009 at 3:23 am

    #134373

    Hi Experts,

    when i try to connect named instance remotly to sqlserver dev edition

    iam getting following error

    error - --When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote

    connections. (provider: SQL Network Interfaces, error: 26 - Error )

    can you please give your valuble solution to solve this issue

    Thanks in advance

  • May 25, 2009 at 4:09 am

    #999609

    Is it set to allow remote connections?

    Try sp_configure or surface area config.


    Cursors never.
    DTS - only when needed and never to control.

  • May 25, 2009 at 5:49 am

    #999627

    Also ensure the appropriate protocols are enabled. You can check these using the SQL Server configuration Manager under SQL Server 2005 Network Configuration.....Protocols for MSSQLSERVER.

  • May 25, 2009 at 8:04 am

    #999666

    ....Also make sure that SQL Server service is started..

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

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