StevensNet.com

...Because someone's gotta tell the story...

Blogs

To return to the main Blog List, click Full Blog Listing.

Tags

Error
SCOM
SQL
Technical
Troubleshoot

Operations Manager and SQL 2008 R2

Tuesday, July 27, 2010 in Technical Articles (Views: 3294)
I am working on Operations Manager, and trying to stay current on server technologies. It sounds good, sounds like it makes sense, but then receive an error when installing the Operations Manager 2007 R2 database, that I don't have SQL installed.

In all fairness to Microsoft, SQL 2008 R2 came out after OpsMgr 2007 R2, but it would make more sense to throw an error, more like this (paraphrased):

- I see you have SQL Server installed, but it is a newer version than we're sure we support.

Anyway, there is a way I found around this, and OpsMgr works fine.

On your SQL server, run the database creation wizard, it's in the \SupportTools\i386 folder of the DVD. The binary name is dbcreatewizard.exe. This will not do a version check, rather enumerate your versions of SQL installed and then create the database.

This is at least how I was able to install it in my lab, without issues. The other option would be to stand up a new SQL box (or load it on the OpsMgr server).

 

Related Blogs You May Be Interested In:


To leave a comment, please log in and/or register.