Saturday, February 25, 2012

Password change

Some one has changed all the passwords on the machine (NT4) that runs our
SQL Server 2000 demo. Now the SQL Server service wont start.
I tried changing the password to the new one through Serives in control
panel but get the following error:
Could not start MSSQLServer Service on \\myserver
Error 2140: An internal Windows NT error occured
I have also tried to select Log On With System Account with the same effect.
I have also tried doing all of this thorugh the SQL Server Enterprise
Manager (edit registration properties) but I just get the following message:
Aconnection could not be established to OURSERVER
Reason SQL serevr does not exist or access denied.
Can any one help?
--
Cheers,
elzikoAnything in the SQL Server errorlog?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"elziko" <elziko@.NOTSPAMMINGyahoo.co.uk> wrote in message
news:%23DxXRCogDHA.2400@.TK2MSFTNGP11.phx.gbl...
> Some one has changed all the passwords on the machine (NT4) that runs our
> SQL Server 2000 demo. Now the SQL Server service wont start.
> I tried changing the password to the new one through Serives in control
> panel but get the following error:
> Could not start MSSQLServer Service on \\myserver
> Error 2140: An internal Windows NT error occured
> I have also tried to select Log On With System Account with the same effect.
> I have also tried doing all of this thorugh the SQL Server Enterprise
> Manager (edit registration properties) but I just get the following message:
> Aconnection could not be established to OURSERVER
> Reason SQL serevr does not exist or access denied.
> Can any one help?
> --
> Cheers,
> elziko
>|||Mmm, I dont know which log you are talkign about but I have found a log
folder with several errorlog file inside. And they do happen to say:
"SQL Server evaluation perios has expired."
OK, so my evaluation is up (should have thought of that)! But is this really
my problem? Surely I would get a message to that effect if the service could
even start or is this sort of message normal for an end of eval?
--
Cheers,
elziko|||All I remember when en eval is out is that you can't start the service. I had to go looking in the
eventlog for just such a message before I realized what the problem was.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"elziko" <elziko@.NOTSPAMMINGyahoo.co.uk> wrote in message
news:ewWGadogDHA.2408@.TK2MSFTNGP09.phx.gbl...
> Mmm, I dont know which log you are talkign about but I have found a log
> folder with several errorlog file inside. And they do happen to say:
> "SQL Server evaluation perios has expired."
> OK, so my evaluation is up (should have thought of that)! But is this really
> my problem? Surely I would get a message to that effect if the service could
> even start or is this sort of message normal for an end of eval?
> --
> Cheers,
> elziko
>

No comments:

Post a Comment