Unable to connect to SQL Server 2005 worked before

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Unable to connect to SQL Server 2005 worked before

Author

Topic

o9z
Starting Member

23 Posts

Posted - 2007-03-06 : 13:06:26

I am developing an app in VB.Net 2005, and I installed SQL Server 2005 locally on my machine. My app access multiple databases on SQL and has worked like a charm in the past. Today, when I go to access my app, I receive an error when trying to connect to the SQL database.

"An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connection"

As I said before, this is a local install and worked fine until today. I checked the services running and Here is what I have:

SQL Server Integration Services - Running
SQL Server FullText Search - Stopped
SQL Server(SQLEXPRESS) - Running
SQL SERVER (MSSQLSERVER) - Stopped <---------- I tried restarting this and it times out
SQL Server Analysis Services (MSSQLSERVER) - Stopped
SQL Server Reporting Services (MSSQLSERVER) - Stopped
SQL Server Browser - Stopped
SQL Server Agent (MSSQLSERVER) - Stopped

I am unable to start any of these services... they all time out. Any help would be greatly appreciated!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-06 : 14:33:18

The problem is that SQL Server is not running. Check the Application Log and System Log in Event Viewer to see what error occurs when you try to start the SQL Server service. You can post the errors here if you need help deciphering them.

Tara Kizer

o9z
Starting Member

23 Posts

Posted - 2007-03-06 : 15:21:17

It appears since I am using Windows Authentication, that SQL is no longer recognizing my password. How would I go about reconfiguring this and for it to use my updated password?

Error in System Log:
"The MSSQLSERVER service was unable to log on as ISF\bmc with the currently configured password due to the following error:
Logon failure: unknown user name or bad password. "

I recently changed my network password.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-06 : 15:23:05

Just double click on the service to change the credentials or the password.

BTW, you shouldn't be using your own account for any services. Create a local account, grant it local admin, then use that instead. Make sure to set the option to never expire the password.

Tara Kizer

o9z
Starting Member

23 Posts

Posted - 2007-03-06 : 15:31:43

thanks for the tips. I will give it a shot!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources