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 |
|
mayoorsubbu
Yak Posting Veteran
95 Posts |
 Posted - 2008-03-02 : 02:38:25
|
| Dear friends,I have a problem on hand. I installed SQL Server 2000 on Windows Server 2003 os. I chose windows authentication and assigned a pwd to the admnistrator account at the time of installation. So far so good.The pwd that I assigned was weak and therefore sometime later I decided to change the adm pwd. But when I shutdown the machine and logged in with the new pwd, I found that SQL Server failed to start. So I restored the old pwd and started up once again. This time SQL was up and running. Can someone explain the problem and suggest a fix.Thanx |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-02 : 14:41:37
|
Change password for the sql server service too.This is the reason for never using an user account to start a service.Always use dedicated accounts for starting services.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
mayoorsubbu
Yak Posting Veteran
95 Posts |
Posted - 2008-03-03 : 09:10:45
|
| Peso,I appreciate your reply. Is it done by assigning a Startup service account in the SQL Server properties Security tab? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-03 : 09:13:57
|
That obviously already is done.Change the associated password to the new password.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
mayoorsubbu
Yak Posting Veteran
95 Posts |
Posted - 2008-03-03 : 10:19:25
|
| Peso,Let me explain again. I probably haven't been able put across the problem properly. (A) I have two servers, both Windows 2003, one running SQL Sever and the other just the failover services. In other words I have a cluster. At the time of installing windows for the first time, I assigned a pwd to the windows administrator account. I later installed SQL. SQL is set to start automatically. After starting up I changed the windows adm pwd. This is where the problem began. As long as I did not shut down the server SQL continued to run but the moment I restarted, SQL failed to start but did so once I changed the pwd to the old one and restarted the server. May be I haven't been able to understand your solution. Be a little explicit.Thanx |
|
|
|
MuadDBA
628 Posts |
Posted - 2008-03-03 : 13:24:35
|
| You need to go into control panel, services, and adjust the password associated with the SQL Server service there to match your new password. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-03 : 23:04:17
|
| You should start sql services with dedicated service account, like peso said above. You can change sql service account in control panel -> services applet or in sql server properties. |
|
|
|
mayoorsubbu
Yak Posting Veteran
95 Posts |
Posted - 2008-03-04 : 05:13:34
|
| Thank you guys |
|
|
|
|
|
|
|
|
SQL Server does not start when windows pwd changed