I have installed sqlserver 2008 r2 in mixed mode now while going to login with sa and password with sql authetication i got the error

  • 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: Named Pipes Provider, error: 26 – error locating server/instance specified)(Microsoft SQL Server)

    some one who can help me please suggest...what to do now.

  • Well, verify if SQL Server is allowed to have remote connections.

    Check your firewall to see if it is blocking connection to SQL Server.

    Enable the TCP/IP and the Named Pipes providers in the Configuration Manager.

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

  • i have checked the remote connection, it is allowing to login but i found unable to login with my sql authentication login credentials..

    i installed the software again with mixed mode and tried to login but same issue is occuring..

  • So you can login with windows authentication, but you can't with SQL authentication?

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

  • Dumb question I am sure but have you checked that SQL services are running?

  • i have installed again its working now ..

    thanks ..

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

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