DESCRIPTION
The SQL Server management pack script “SQL Server 2000 Block Analysis” is unable to successfully connect to the SQL Server instance “MSSQLSERVER”. The error message returned is “Login failed for user.”
CAUSE
This might be due to login failure or lack of Windows user rights for the SQL Service Account to Log on as a service (SeServiceLogonRight).
WORKAROUND
Use Lockoutstatus.exe from Windows 2003 Resource Kit Tools which gives a statistics of Bad PWD Count and if the account is locked. If everything is clear, make sure SQL Service Account is having the prvillege to Log on as a service from the Group Policy.
MORE INFORMATION