Sunday, March 11, 2012

error 1069

I have been running my SQL under Local System a/c. I
wanted to change it to run under my NT a/c. I went to
control panel, services and tried changing the account to
this account and gave my NT credentials. It wouldn't start
and I get logon failure error 1069.
Am I missing anything here?
thanks,
balaYou can change it in Enterprise manager (Properties of the Server).
What rights does the new account have on the domain? You need log on locally
rights.
Is it your personal account or an account specific for SQL Server only? It
is best to use a dedicated account as SQL will stop working if your password
expires.
Look at http://support.microsoft.com/defaul...kb;en-us;283811
(HOW TO: Change the SQL Server or SQL Server Agent Service Account Without
Using SQL Enterprise Manager in SQL Server 2000)
Regards
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"bala" <balal@.microsoft.com> wrote in message
news:00ff01c3d613$d8533400$a401280a@.phx.gbl...
quote:

> I have been running my SQL under Local System a/c. I
> wanted to change it to run under my NT a/c. I went to
> control panel, services and tried changing the account to
> this account and gave my NT credentials. It wouldn't start
> and I get logon failure error 1069.
> Am I missing anything here?
> thanks,
> bala

No comments:

Post a Comment