Post reply

Network related or instance-specific error occurred while establishing

  • January 10, 2011 at 5:43 pm

    #388595

    Hi All,

    Really anxious to resolve this problem occurring on my local machine..

    Error: Cannot connect to <instance name>

    Additional Info: A network related or instance-specific error occurred while establishing a connection to sql server. the server was not found or was not accessible. verify that the instance name is correct and that sql server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error locating Server/Instance Specified) (Microsoft SQL Server)

    i have SQl Server 2008 Enterprize Edition on Windows Xp 2002 SP-3..

    regards:

    Farhan.

  • January 11, 2011 at 3:39 am

    #1271779

    Is the server running on your local machine?

    How are you trying to connect?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 11, 2011 at 10:25 am

    #1271971

    yes its running on my local machine..

    am trying to connect using SSMS to my instance with my domain login and password..

    i have tried couple of things related to named pipes, TCP/IP, running services using local or my domain user name, also i reinstall the SQL Server couple of times but unable to connect the default instance and start the SQL Server default instance services...

    i have only one default instance installed on my machine..

    any help will be highly appreciated..

    Regards,

    Farhan.

  • January 11, 2011 at 11:18 am

    #1272001

    1. Check if the Windows Server or the SQL Server you are trying to connect is down

    2. Check if the SQL Server has been configured to use static port, if so try to specify the port number like SQLServerNAME,PORTNO when you conect to the SQL Server.

    Thank You,

    Best Regards,

    SQLBuddy

  • January 11, 2011 at 11:48 pm

    #1272198

    Have you set-up windows authentication?

    Is it a named instance?

    Did you give yourself administrator permission?

    Try logging in with . as the servername. (the dot represents localhost)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 12, 2011 at 10:20 am

    #1272480

    Have you set-up windows authentication?

    Is it a named instance?

    Did you give yourself administrator permission?

    Try logging in with . as the servername. (the dot represents localhost)

    These are the things i have checked way back in 90's 🙂

    just installed a named instance but the services are not starting up for named and default instances..

    Regards,

    Farhan.

Viewing 6 posts - 1 through 5 (of 5 total)

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