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.
| Author |
Topic |
|
Breen
Starting Member
3 Posts |
 Posted - 2005-09-30 : 09:26:01
|
| Hi,Everytime I change my Windows password, the change does not seem to be replicated to the SQL server (MS SQL Server 2000). For this reason, I configured the last setup so I could access it via windows or sa password. However, now that I've changed my password again, I cannot access with either. I get the following message when trying to connect!"An error 1069 - (The service did not start due to a login failure) occurred while performing this service operation on MSSQLServer service"I can't start the MSSQLServer service because I get a message that there was a login failure. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-09-30 : 13:22:25
|
| The sql server service needs to log on to access resources. Sounds like you have installed it to use your user name and password so every time yo uchange the password it will get a logon failure and fail to start until you reset it's password.Have a look at ms sql server under services.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-09-30 : 14:47:27
|
| this is also a good way to lock out your accounts. Too many login failures will lock everything out.Have a service account created that is used only be the SQL Server. Do not set the password to expire. Manually change the password at some interval if your security policies dictate that.-ec |
|
|
|
Breen
Starting Member
3 Posts |
Posted - 2005-10-03 : 05:32:10
|
| Txs - I assumed the password change locked me out alright. I did however, set access to the server with the 'sa' account too, but the SQL server will not autenticate this either. Is there anyway of modifying the account so I can connect again without having to remove SQL?P.S. I cannot start the MSSGL Server service as I get an error message "Could not start the MSSQLSERVER" service on Local Computer. Error 1069: The service did not start due to a logon failure" |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-03 : 22:46:23
|
| sure thing...just change the password of the mssqlserver service to the new password and don't forget to restart the service --------------------keeping it simple... |
|
|
|
Breen
Starting Member
3 Posts |
Posted - 2005-10-04 : 05:10:02
|
| Phew - that seems to have worked :o) Thanks all. |
|
|
|
|
|
|
Access Denied to SQL Srv after password change