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 |
|
LuisC
Starting Member
6 Posts |
 Posted - 2008-01-09 : 15:32:50
|
| Where I work the novel network ask the users to change the password every 6 month.I have noticed that every time I change the novel password I can notconnect to the Personal SQL server 2000 I have in my PC. The database does not show in the enterprise manager group. Since I am new to SQL the only alternative I find to correct the problem is to uninstall and install the SQL server every time the novel password needs to be changed. Is there any way to prevent the above from happening? Is there a way to reconnect to the server once the Novel password has changed?Thanks |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-09 : 16:15:49
|
| is the sql server running under the localsystem account or is it running as your user account? look in the services control panel to find that.i suspect that the sql server is running under your actual user account. each time your novell pass changes, novell also changes your windows password at the same time. This doesn't update the stored login info in the services control panel, which would explain why you don't see the db (instance actually) in EM. Because the stored pass doesn't match the new pass, sql server refuses to start properly.You can verify this by looking at the sql error logs when this problem occurs.-ec |
 |
|
|
LuisC
Starting Member
6 Posts |
Posted - 2008-01-11 : 10:01:19
|
| Thank you very much for your advice. Indeed it was what you suspected. I did what you suggested and it fixed the problem. Thank you again eyechart. |
|
|
|
|
|
|
Not able to connect to server