No more able to connect to my SQL Server 2005 database engine

Question

Hello,
I have installed SQL Server 2005 in my PC and during the installation I have created a predefined instance (I have used Windows autentication).
I could use correctly SQL Server till some days ago, when I changed the password of my PC login profile.
Now, when I open SQL Server, if I click on the "Connect" button, the following error message appears (I translate it from italian version)

Unable to connect to "CARLO"
Further information:
An error has occurred while you were trying to establish a connection to the server. When you connect to SQL Server 2005, this error can be generated because SQL Server doesn't allow remote connections under the predefined settings. (provider: Provider Named Pipes, error: 40 - Unable to open a connection to SQL Server) (Micorsoft SQL Server, error:2)

I'm sure that the error raises because I have changed my PC access password (the program worked correctly before), but in the "Connect to Server" window the user name and the password text boxes are disabled, so I can't insert the new password...
Can you suggest what have I to do?

Thank you very much

Answer 1

Go to SQL Server Configuration Manager and make sure that Named Pipes protocol is enabled for the edition you are working with on your machine (EXPRESS or MSSQLSERVER)

Then under services, make sure MSSQLSERVER, SQLEXPRESS and SQL Browser services are started.

Shyam

Answer 2

Hi Shyam, thank you for your answer.
I followed your suggestion, and opened SQL Server Connection Manager.
As I don't know the edition I'm working with (if EXPRESS or MSSQLSERVER), I have enabled the Named Pipes protocol of both (when I have installed SQL Server, I have created a predefined instance, and now, when I open SQL Server Management Studio, in "Server Name" field it is written the name of my PC... How can I understand the edition I'm using?
However, to be sure, I enabled Named Pipes protocol of both.
Then I controlled "Services", and I discovered that MSSQLSERVER service is stopped. I tried to start it, but after 30 seconds the following message appears: "Impossible to execute the request or the service hasn't answered in time. For further details, view the events log or other related errors logs".
Do you know where I can find this log file?

Thank you in advance

Answer 3

Ok, finally I solved.
To start MSSQLSERVER service correctly, I opened SQL Server Configuration Manager, selected SQL Server 2005 services, on the right list selected MSSQLSERVER service, double clicked and, on the "Access" Tab, selected "Predefined account". In this way it has started.
Thank you

Answer 4

I installed SQL server 2005 and I am a beginner. When i open the sql server management studio, it asks to connect to database engine. I do not know how to connect to... also i checked my sql services  and there is no service named mssqlserver service in the server configuration manager under the sql server 2005 services... Please help me in this problem....