SQL2000 MP: SQL Server 2000 Block Analysis is unable to successfully connect to the SQL Server instance
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 … Continue reading SQL2000 MP: SQL Server 2000 Block Analysis is unable to successfully connect to the SQL Server instance