Unsolved
This post is more than 5 years old
3 Posts
0
13510
November 1st, 2012 12:00
OME 1.1 and SQL account level
I will be installing OME 1.1 on a new system and need to know what level my userID that I use to install the application has to have to be able to create the DB. I will be using SQL 2005 sp4.
DELL-Rob C
3 Apprentice
•
2.8K Posts
0
November 1st, 2012 12:00
Hi,
You should have sysadmin db privileges for OME 1.1. (OME 1.0.1 needed dbowner).
Thanks for trying OME 1.1 and keep us posted.
(BTW, we also include SQL Express 2008 on the installer if that is useful).
Rob
DELL-Rob C
3 Apprentice
•
2.8K Posts
0
November 1st, 2012 12:00
Thanks Raj,
My mistake. :)
Rob
westyaz
3 Posts
0
November 1st, 2012 12:00
Thanks! I will keep you posted.
DELL-Raj S
327 Posts
0
November 1st, 2012 12:00
Correction:
For OME 1.1, if you chose "custom" installation, then only db_owner rights is required. Custom installation in OME 1.0.1 required sysadmin rights.
However if you chose "typical" installation in OME 1.0.1/1.1, you still need sysadmin rights.
Refer to this section "Minimum Login Roles for Microsoft SQL Server" in OME 1.1 user guide:
support.dell.com/.../index.htm
Thanks,
Raj Shresta