If you are installing MOM 2005 on a new install of SQL server you must have the server set to use Windows only authentication rather than SQL Server And Windows authentication.
SQL Server And Windows authentication is misleading in that some folks believe this setting will allow both SQL and Windows authentication and this is true however MOM 2005 expects only Windows authentication.
If you already have the SQL server set to use SQL Server And Windows authentication you can easily change the authentication mode without the need to reinstall SQL.
Follow the steps below to change the authentication from SQL Server And Windows to Windows Only
1. Connect to the MOM SQL Database Server.
2. Select the SQL Server Name
3. Right mouse click on it and select “Properties” From the context menu.
4. Select the “Security” tab and change the “Authentication” from SQL Server And Windows to Windows Only
5. Click “OK” to make the change.
6. Finally select “OK” once again to restart the SQL server services.
No Comments