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

AD MP: An error occurred while executing AD Remote Topology Discovery Failed to CreateObject OOMADs (0x1AD)

DESCRIPTION   An error occurred while executing ‘AD Remote Topology Discovery’ Failed to CreateObject ‘OOMADs’. The error returned was: ‘ActiveX component can’t create object’ (0x1AD) 0x1AD.   CAUSE   This occurs when domain controllers do not have the OOMADS.DLL registered which is required for Active Directory Management Pack. As soon as the rules associated with this computer group are deployed, a script automatically runs to install and register this DLL and if you dont have ACTIVE DIRECTORY HELPER OBJECT installed, you will see such error.   WORKAROUND   Install oomads.msi (Active Directory Helper Object) from MOM Support Tools.    

How to Identify MOM2005 Service Pack Level?

If you are wondering How to Identify MOM2005 Service Pack Level in MOM2005, then you can use this tip; Right click Microsoft Operations Manager (Your-MOM-Server) and click About Microsoft Operations Manager and check the first line; For MOM2005 you should see, 5.0.2749.0 For MOM2005 Service Pack1, you should see, 5.0.2911.0

Installing MOM 2005 on SQL 2000 SP4

Hello everyone and after a long time, I am back to the community. I have changed my employer and I am now working for Atos Origin Middle East.   So, today I started to play with MOM2005 in my test-bed and encountered with couple of issues which I really wanted to share;   ENVIRONMENT Windows Server 2003 SP1 with all the latest updates. SQL 2000 SP4. Ok, fair enough and I installed SQL 2000 SP4 without any glitches. One thing to remember here is the MSSQLSERVER SERVICE will not start automatically and you have to start it manually.  Now, I ran the … Continue reading Installing MOM 2005 on SQL 2000 SP4