Forum Discussion

anthonydedipowe's avatar
anthonydedipowe
Icon for Nimbostratus rankNimbostratus
Jul 01, 2009

SQL Error on install

Everytime I try and install the MP, I get an error in the log and the install fails, stating:

 

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

 

The RMS is SCOM2007 SP1, Windows Server 2003 x64

 

The DB Server is Windows 2008 x64 Enterprise, SQL Server 2008

 

I've tried this using both Windows Login (Logged in as Domain Administrator) and using SQL Authentication, but it gives the same error,

 

The DB server does authenticate correctly as this has been running the SCOM DB for over a year without any issues.

 

 

 

Help!!
management
microsoft
scom

2 Replies

  • joel_hendrickso's avatar
    joel_hendrickso
    Historic F5 Account
    Jul 01, 2009
    Anthony,

     

     

    The install is failing when it tries to query the master database to see if the F5 Management Pack database already exists. The NT account logged in as (or running the install as) must have basic permissions on the SQL server that you specifiy during install, specifically to be able to query the master database.

     

     

    Try the following to troubleshoot the permissions:

     

    - Open the SQL Management Studio while logged in as the same NT account.

     

    - Connect to the database engine that you are specifying during setup, using Windows Authentication

     

    - select the server you just connected to in the object explorer

     

    - Click the New Query button

     

    - switch to the master datbase using the database drop-down in the top left

     

    - run this query in the new query window:

     

     

    SELECT name FROM master.dbo.sysdatabases WHERE name = 'F5_ManagementPack'

     

     

    If you get a permissions error anywhere along the way, you'll know more precisely where the problem is. If there is no problem, we'll investigate further.

     

     

    Thanks for you interest in the product!

     

     

    Joel Hendrickson