UNSOLVED

Cusker

updated

12 years ago

C

Cusker

11 Posts

0

6782

June 17th, 2014 15:00

OME db instance case-sensitive; but it's not

Server 2012 R2 trying to do a fresh install of OME 1.3.

Server has pre-existing install of a case-INsensitive named instance of 32 bit SQL Express 2012 SP1.

I installed another 32 bit instance named SQLEXPRESSOME and selected remote db during OME install.  But when I get to Database Server part of the install it won't let me continue because it says my selected instance is case sensitive.

I know it's not because when I installed the new instance I selected Collation as case-INsensitive.  And when I look at the properties of the SQLEXPRESSOME instance it shows Collation as SQL_Latin1_General_CP1_CI_AS.

I also re-verified the pre-existing instance is also case-INsensitive.

So why won't the install let me continue?

  • 701

    0

    Posted June 18th, 2014 05:00

    Hi Cusker,

    Thanks for writing to Dell.

    This error can happen if OME pre-req checker is not able to read certain values from the Database instance. Even though 32bit version of SQL is supported, we recommend to use 64 bit version.

    Can you please try creating SQLEXPRESSOME instance with SQL Express 64 bit edition & try installing OME ? Hope that should solve your problem.

    Thanks,

    Arun

  • Cusker

    11 Posts

    701

    0

    Posted June 18th, 2014 09:00

    Ugh, don't get me started on the pre-req checker.  That thing is awful.  I've done test installs of 1.1 & 1.2 in the past and it has never worked properly.  I had high hopes for 1.3 but the "gui" portion never reports anything.  It just twirls around indefinitely saying "Loading prerequisite information. Please wait."  But it never loads anything.  What I ultimately had to do was run "RunPreReqChecks.exe /s" then go open the omprereq.htm document for the results.

    Anyway, I went ahead and let the installer do it's thing and install the required local (64 bit) db instance and everything installed fine and OME started up.

    So I didn't actually test your suggestion of manually installing a 64 bit instance but having the installer do it worked fine.  The kicker is the installer installed 64 bit instance has the exact same Collation as my manually installed 32 bit instance.  So as you suggested the pre-req checker is likely the problem.

    Based on my experience I would say that 32 bit SQL is NOT supported if the pre-req checker can't properly identify Collation and ultimately prevents OME from installing.