SSMS Connecting Error

  • Krishh

    SSC Eights!

    Points: 929

    Hi Guys,

    Getting an error while connecting to SQL Server Management Studio (SSMS) i.e connecting via Database Engine.

    Please check the first Screenshot for error. (1)

    I tried to start SQL Server Manually through Services.msc but got an error.

    Please check the Screenshot for that. (1)

    Please help me on this guys.

  • g.britton

    SSChampion

    Points: 13689

    How is the service configured for Log on (check the Services applet)

    Gerald Britton, MCSE-DP, MVPToronto PASS Chapter[/url]

  • johnwalker10

    SSCrazy Eights

    Points: 9074

    reddychaitanyakrishna (11/4/2015)


    Getting an error while connecting to SQL Server Management Studio (SSMS) i.e connecting via Database Engine.

    Go to Control Panel -> Administrative Tools -> Computer Management

    Expand Services And Application-> SQL Server Configuration Manager->SQL Native Client Configuration

    Check Aliases Option

    If you find any aliases for the SQL Server that you are getting problem, then delete it

  • Krishh

    SSC Eights!

    Points: 929

    Hi,

    Please check the attached screenshots (Both).

    The Aliases are blank totally.

  • Krishh

    SSC Eights!

    Points: 929

    How to check that ?

  • johnwalker10

    SSCrazy Eights

    Points: 9074

    If Aliases are totally blank, then check SQL Server Browser service is running and is kept in automatic Start mode.

    From start -> click on run- > type services.msc -> click on ok button -> check for SQL Server browser service, and start if it is not running.

  • Krishh

    SSC Eights!

    Points: 929

    SQL Server Browser service is disabled .

  • johnwalker10

    SSCrazy Eights

    Points: 9074

    then start it

  • Krishh

    SSC Eights!

    Points: 929

    I Started SQL Server Browser Manually.It got started, but trying to connect to SSMS once again and still getting the same error .

    I'm able to connect to Integration and Reporting Services, but Database engine is not getting connected.

    Please check the attached error screenshot once again.

    Thanks.

  • johnwalker10

    SSCrazy Eights

    Points: 9074

    Enable TCP/Ip, Piped Protocol

    From Computer Management ->SQL and Services, ensure the Service is On. Enable the port on the Firewall. Try to login through Command Prompt -> as Admin; last the User Name should be (local)\SQLEXPRESS. Hope this helps.

  • Krishh

    SSC Eights!

    Points: 929

    TCP/IP and Piped Protocol are already enabled.

    All Services are ON , except SQL Server and SQL Server Agent.

    How to enable the port on firewall ?

    How to check through Command Prompt ?

    and about last username too.

    Please guide me once with navigation.

    Thanks.

  • Krishh

    SSC Eights!

    Points: 929

    TCP/IP and Piped Protocol is already enabled.

    All the Services are ON except SQL Server and SQL Server Agent.

    I'm able to connect to Integration and Reporting Services, but cannot connect to Database Engine.

    How to Enable the Port on the Firewall ?

    How to login through command prompt ?

    Which username you are telling me ?

    Please help me on the Navigation.

    Thanks.

  • johnwalker10

    SSCrazy Eights

    Points: 9074

    I have found one article on the same error, maybe this will help you out, see form here: http://www.sqlserverlogexplorer.com/fix-error-message-40/[/url]

  • Krishh

    SSC Eights!

    Points: 929

    I had done doing that by manually starting SQL Server from SQL Server Configuration Manager, but it didn't work for me.

    Please check the Screenshot.

    Help me on this.

    I'm facing lots of problem.

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

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