OME installation on an empty remote DB

Hi Augustin and thanks for the post.

On install I’m pretty sure you can’t specify the name of the database.

The existing database must be called OMEssentials

It will work with an empty database.

Hope this helps.

Rob

delltechcenter.com/ome

Hi Rob,

I'll try this trick tomorrow :)

I would not have imagined to use the name "OMEssentials" for the DB!

Is this trick somewhere documented, indicated?

Thanks a lot! :)

Hi Rob,

I renamed the dbase to OMEssentials and I finished the installation.

But surprise, after the installation the dbase was deleted!

I did the installation twice, the same result, i.e dbase deleted.

So, what is to be done in this case?

Thanks in advance,

Augustin

Hi Augustin,

Thanks for the query and the detailed information you provided on the issue.

Just trying to reiterate the steps and find if something is missing in your setup:

1. Create empty database named "OMEssentials".

2. Add user mapping of database roles db_owner and public.

3. The login user should have dbcreator and public server roles.

4. From OME's custom install screen, target this remotely created database using following format:

\

for example: Server - myServer and instance - myInstance. Then myServer\myInstance.

Note: Database name is not required to be provided.

Please see if this information helps!

Hi Shivendra,

This time it has worked, so the installation was done.

Thanks and best regards,

Augustin

Thanks for letting us know, Augustin!