Monday, March 19, 2012

Logon failure in sql server 2000

Hi every one
I have got a problem with my Ms SQL Server: I have defined a server and
in the server i am running a rainbow portal, however i cant get my
rainbow working because it says that SQL does not exist or access
denied. I checked me services for sql and it gives a message saying
the following "Could not start the MSSQL... Service on Local
Computer... Error 1069: The service did not start due to logon
failure." Aparently i am logged in as the administrator in the server,
so i don=B4t understand why this is happening. If anyone can give some
inputs on that i will highly appreciate.
Thanks in advance for any help
ErnestoEmesto,
What account MSSQL service run on the machine? You can check it from
the Services control panel. If it is not run as 'local system', which
is by default, then make sure that account is a member of local
administrator.
Mel|||In Services go to property of that server , go to logon tab and apply
new password for that account.
Make sure that account is not locked.
Make sure that account is member of administrator group
Regards
Amish Shah

No comments:

Post a Comment