How to find the SQL Server used for OpsMgr installation

When looking in the OpsMgr console, you cannot see which SQL Server is used for the OperationsManager and OperationsManagerDW database. There are however a few ways to find this server. I will explain them in this blogpost.

1) Install the SQL Server management pack and wait till the SQL Servers are discovered. Expand the Databases tree and type 'OperationsManager' into the look for field. Select the database and in path name you will see the server (and instance) hosting the database. (Or look at the databases immediately)

2) You can determine the SQL database by reviewing the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Setup\DatabaseServerName. On this location the server (and instance) hosting the database is found.

3) Go to Monitoring, Discovered Inventory and run the 'Change Target Type' task. Select 'Operations Manager Operational Database Watcher' and choose OK. You will only see one instance.  Scroll to the right until you see the 'Operational Database Server Name' and 'Operational Database Name' columns.

Hope you find this as useful as I did.

Moving the SCUP database after installation

After installing System Center Updates Publisher (SCUP) 2011 configuration must be done. SCUP can be connected to a WSUS or SCCM/ConfigMgr 2007 and/or 2012 installation. Just use Update Server or ConfigMgr Server for that. Something else that must be done is moving the SCUP database. This because the database is placed in the active user profile. Oops! In this blogpost I will explain (in a few steps) what must be done.
 

 

By default the SCUPDB.SDF is placed in the [C:\Users\<username>\AppData\Local\Microsoft\System Center Updates Publisher 2011\5.00.1727.0000] folder. This can be checked at Advanced options. To move the database just close the SCUP console. Open the Scup2011.exe.config file, which can be found in the SCUP installation folder.
 

For example: Beneath <Scup.Properties.Settings> and <setting name="SSCEDataFile" serializeAs="String"> add the following line:

<value>D:\SCUP2011\5.00.1727.0000\scupdb.sdf</value>



This way the database is expected on another location. Just move the SCUPDB.SDF file to the same location configured in the Config file. After configuring both steps start the SCUP console again. Have a look at Advanced options again, and see above results. The database is moved to a better place now!