Post reply

SSMS Connecting Error

  • November 4, 2015 at 11:11 am

    #399278

    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.

  • November 4, 2015 at 1:02 pm

    #1837790

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

    Gerald Britton, Pluralsight courses

  • November 4, 2015 at 9:36 pm

    #1837856

    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

  • November 4, 2015 at 10:24 pm

    #1837857

    Hi,

    Please check the attached screenshots (Both).

    The Aliases are blank totally.

  • November 4, 2015 at 10:26 pm

    #1837858

    How to check that ?

  • November 4, 2015 at 11:12 pm

    #1837865

    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.

  • November 4, 2015 at 11:20 pm

    #1837868

    SQL Server Browser service is disabled .

  • November 4, 2015 at 11:30 pm

    #1837870

    then start it

  • November 4, 2015 at 11:30 pm

    #1837871

    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.

  • November 4, 2015 at 11:43 pm

    #1837873

    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.

  • November 5, 2015 at 12:41 am

    #1837877

    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.

  • November 5, 2015 at 2:36 am

    #1837891

    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.

  • November 5, 2015 at 5:34 am

    #1837921

    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]

  • November 5, 2015 at 10:35 pm

    #1838142

    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 13 (of 13 total)

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