on my desktop. I think that I may have used the wrong
method of authentication as I have to change my password
on the network every 90 dys and now the SQL server
service will not start and I get a password error. When I
try to view the properties I get an error saying the
password is incorrect.You can also change the Windows service account password for the SQL Server
service under Windows 2000/XP as follows.
Right-click on My Computer and select Manage
Select 'Service and Applications' and then Services
Double-click on 'MSSQLSERVER' (or 'MSSQL$YourInstanceName') from the
services list and clock the 'Log On' tab
Once you've successfully started the SQL Server service, you can change the
service account to the system account via Enterprise Manager so that you
don't need to bother with periodically changing the service password.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike" <mrestall@.superbolt.com> wrote in message
news:965e01c3eb21$359cc320$a101280a@.phx.gbl...
quote:
> I am relatively new to SQL and have the developer edition
> on my desktop. I think that I may have used the wrong
> method of authentication as I have to change my password
> on the network every 90 dys and now the SQL server
> service will not start and I get a password error. When I
> try to view the properties I get an error saying the
> password is incorrect.
No comments:
Post a Comment