Help
We changed the Administrator Password, and now I cannot start Sqlserver on one of my systems.
And no password I try will apparently bring it back online
What can I do to reset password etc.
What error are you getting? Is that the account used by the SQL Service? If
so, you'll have to update the password in the Services applet, for
MSSQLServer service.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"sqlstopper" <sqlstopper@.discussions.microsoft.com> wrote in message
news:756D0E5C-4E50-4098-8D26-9DD5ABF1490F@.microsoft.com...
> Help
> We changed the Administrator Password, and now I cannot start Sqlserver on
one of my systems.
> And no password I try will apparently bring it back online
> What can I do to reset password etc.
|||The error I get is: Did not start due to logon failure.
Just where do I change the password?
regards
"Narayana Vyas Kondreddi" wrote:
> What error are you getting? Is that the account used by the SQL Service? If
> so, you'll have to update the password in the Services applet, for
> MSSQLServer service.
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "sqlstopper" <sqlstopper@.discussions.microsoft.com> wrote in message
> news:756D0E5C-4E50-4098-8D26-9DD5ABF1490F@.microsoft.com...
> one of my systems.
>
>
|||OK that did the trick!!!!
thank you very much
I just love you 'MVP (SQL Server)'-guys
Wonderfull Job
thx
"Narayana Vyas Kondreddi" wrote:
> What error are you getting? Is that the account used by the SQL Service? If
> so, you'll have to update the password in the Services applet, for
> MSSQLServer service.
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "sqlstopper" <sqlstopper@.discussions.microsoft.com> wrote in message
> news:756D0E5C-4E50-4098-8D26-9DD5ABF1490F@.microsoft.com...
> one of my systems.
>
>
|||You could change the password through Enterprise manager under Security >>
Logins, right click the logins and go into Properties and change, for SQL
Logins.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||Is this the sa password? Can you try logging on using a Windows NT account
taht has admin rights?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment