The F5 Monitoring Service Data Source Singleton Error

OK. Have now checked the SQL server to see if that reveals anything.

 

 

Based on a previous thread by tomtux named "Unsuccessful Installation" (http://devcentral.f5.com/Community/GroupDetails/tabid/1082223/asg/54/afv/topic/aft/1171608/aff/59/showtab/groupforums/Default.aspx) I have checked checked the following items as per the reply by Joel Hendrickson:

 

 

1. Verify that the F5 service has the correct connection information for the database:

 

 

a) Open the F5 service configuration file (C:\Program Files\F5 Networks\Management Pack\f5mpsvc.exe.config)

 

b) The value specified for "SQLHostName" should match your SQL Server host name

 

Checked. The correct SQL server hostname is listed in thf5mpsvc.exe.config file.

 

 

c) The value specified for "DatabaseName" should match a database in the above SQL Server instance

 

Checked. The database name in both the f5mpsvc.exe.config file and on the SQL Server databases view match "F5_ManagementPack".

 

 

2. Open the database specified in the config file and verify that the "DynamicData.Entity" table exists:

 

 

a) Open SQL Server Management Studio

 

b) Connect to your SQL Server instance

 

c) Expand the list on the left to Databases => F5_ManagementPack => Tables

 

d) Verify that there is a table named "DynamicData.Entity"

 

Checked. The F5_ManagementPack contains this table.

 

 

If the database and/or table is missing, something probably went wrong in the installation process and we can diagnose further.

 

 

The only thing that I can see that is amiss is the the designated F5 Monitoring Service account that is constantly stopping on the Management Server does not appear listed in either the Security folder immediately below the F%_ManagementPack database or within the Sql Server Security > Logins view which leads me to suspect that the issue is simply one of the service account not having access to the database.

 

 

I have verified that the service account is a member of the local admins group on the SQL Server but I do not see it listed in any of the obvious security/authorization views within SQL Server Management Studio. That said I am not a DBA and I was advised by the DBAs that adding the service account to the Local Admins group gives the service account the necessary system admin access to SQL Server that the F5 MP guide indicates is required. I suspect this is not the case.

 

 

That said, there is a Logins for the BUILTIN/Administrators group of (which as noted above the F5 service account is a member on the SQL Server) which has "public" and "sysadmin" Server Roles but no actual database is ticked in the User Mappings property for this group so I suspect that even if the service account is a member of the BUILTIN/Administrator Security > Login group it is not actually granted any practical pivileges to any databases.

 

 

In order to be granular and not ask my DBAs to do something that would break there preferred security model I would appreciate if you could clarify the correct way to grant the service account the access it needs within SQL Management Studio so that it can write to the F5_ManagementPack database?

 

 

Not being a DBA I would be grateful if you could provide screenshots in a word document -which would be useful to have in the Install Guide too- so that even an SQL dummy such as me would be able to step through creating the necessary access for the account. This would also help me in convincing the DBAs that what I want to do is not going to break there preferred security model if they can see exactly what privileges are being granted.

 

 

Kind Regards,

 

 

Michael