Wim-ms’s Opsmgr 2007 Weblog

A blog about opsmgr 2007

SQL cluster gotcha’s – part one

Posted by wim-ms on January 19, 2008

My first installation was an ‘everything-on-one-box’ one. Everything just worked fine, but not really scalable of course. So the powers that be decided to put every component on another server (still using only one management server though).

The Opsmgr OperationsManager database would be installed in a SQL cluster, so we used the Microsoft recommendation and copied dbcreatewizard.exe and a bunch of dll’s (from the SCOM directory!) over to the SQL server (very userfriendly there Microsoft).

Now the SQL server was running 64-bit windows .. and my Opsmgr server and dll’s were 32-bit. This didn’t seem to work very well on the SQL-server ๐Ÿ˜‰ So we had to install Opsmgr on the SQL-server to copy the dll’s to run the dbcreatewizard to create the OperationsManager database. (and people complain about unix ..)

We now had a working database (or so we thought) ….

More to come in part two


2 Responses to “SQL cluster gotcha’s – part one”

  1. juan said

    i was reading your blog and saw that in this set up you had the same as mine. But the problem is that my DBCreateWizard.exe is timing out! i don’t know why… i ran the SQL code that it uses to create the database and it works fine but it doesn’t work when i run it. it just hangs and throws an exception that either it timed out or the server could not be contacted. Have you heard anything like this?
    My setup is all 64-bit trying to install it in a single node cluster using the 64-bit dlls and all that stuff.
    i thought there was maybe a bug in the code not accounting for query timeouts but it looks like it worked for you : \
    I’d appreciate your help…

  2. wim-ms said

    Hi Juan,

    I also got some problems with dbcreatewizard causing exceptions, but closing and restarting it a few times fixed it (yes really ๐Ÿ™‚ on my server. What is the exception you’ve got ?
    PS: you can try posting your error in the microsoft.public.opsmgr.* groups on http://groups.google.com/groups/dir?sel=33656554 (or somewhere on the microsoft site ๐Ÿ™‚

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: