Click here to Skip to main content
15,895,606 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a PC with me with SQL Server installed i had worked with sql server for one year of 2013
but now from recent days it was not connecting to open with my user credentials it was displaying an error-40 ie

Cannot connect to <my system name>

additional information:

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:40-could not open a connection to SQL Server)(Microsoft SQL Server,Erroe:2)  



and generally what i do for this is i go for
C#
mycomputer-->R.Click-->Manage-->services and applications-->MSSQLSERVER-->R.Click-->Start.


with this my mssqlserver was going to start and as usual i start's to work with this..
of creation of tables and...so on..

but now when i start the service as above it was throwing another Error which seems like below

Windows could not start the SQL Server (MSSQLSERVER)on local computer.For more information,review the system Event Log.If this is a non-Microsoft service,contact the service vendor,and refer to service-specific error code 17051.


I don't Know How to overcome this problem...
Could any one giude me towards solving this problem so that i can work as usual...
Posted

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900