Groups | Blog | Home
all groups > sql server connect > july 2006 >

sql server connect : An error 1059 - (The Service did not Start due to a logon failure)


rmcompute
7/27/2006 12:19:02 PM
I installed SQL Server on my PC and it has been running fine for a few
months. Now I cannot start it but get this message:

-------------------------------------------------------------------------------------------
An error 1059 - (The Service did not Start due to a logon failure) occurred
while performing this Service Operation on the MSSLQServer)
-------------------------------------------------------------------------------------------
I recently changed by network password; Is there something that has to be
Sue Hoegemeier
7/27/2006 4:14:52 PM
It sounds like the services are running under your windows
account. If that's the case, you need to change the password
for the service accounts if they are the same as yours.
Looks like this is SQL Server 2005 so you can use the SQL
Server Configuration Manager to change the password for the
services.

-Sue

On Thu, 27 Jul 2006 12:19:02 -0700, rmcompute
[quoted text, click to view]
rmcompute
7/27/2006 6:05:01 PM
It was definitely the password. I had Data Security switch my network
password back to the old password and it worked. The problem is that I am
forced to change my password monthly and can't keep having Data Security
reset it. I am using SQL Server 2000 Developer Edition and it does not have
the Server Configuration Manager. Is there any other way to change the
password in SQL Server ?

[quoted text, click to view]
Sue Hoegemeier
7/27/2006 7:23:03 PM
On 2000, you can change the password from the Services
applet in Administrative Tools. Select the properties for
the service mssqlserver and go to the Log On tab. You can
change the password there.
In Enterprise Manager, if you right click on a server and
select properties, you can change the login information on
the security tab.

-Sue

On Thu, 27 Jul 2006 18:05:01 -0700, rmcompute
[quoted text, click to view]
rmcompute
7/29/2006 6:57:01 AM
I found it on Enterprise Manager as per your instruction.

Thank you.

[quoted text, click to view]
Sue Hoegemeier
7/31/2006 10:05:51 AM
Your welcome...thanks for posting back.

-Sue

On Sat, 29 Jul 2006 06:57:01 -0700, rmcompute
[quoted text, click to view]
AddThis Social Bookmark Button