Friday, March 9, 2012

Password Problem

i have Win 2000 server and I hv installed SQL Server 200 on it. I have
changed my win 2000 Administration server password. Now SQL Server doesn't
Run. What Should I do.?
I must keep Administration password.
Pl. helpIt sounds like you've changed the password for the account under which
the SQL Server service runs. It isn't a good idea to use a domain admin
account for this anyway because doing so may be a potential security
vulnerability.
I suggest you create an account specifically for the SQL Server
service. You can find the service listed as MSSQLSERVER under the
Services node in the server MMC Management Console. Right-click, select
Properties, then select the Log On pane. Do the same for the other SQL
services that you may use: DTC, Search, Agent, etc.
--
David Portas
SQL Server MVP
--

No comments:

Post a Comment