Unsolved
This post is more than 5 years old
2 Intern
•
272 Posts
0
510798
March 9th, 2012 13:00
OpenManage Essentials Database re-target process
This is the process for re-targeting a Database in the OpenManage Essentials management console.
1. Backup Database – OMEssentials DB(where OME was installed)
2. Copy the DB to another server
3. Restore DB (this can be performed only by a sysadmin)
4. Create a new user with “db_owner” , “sysadmin” and “public” privileges
5. On the system where OME is installed, enter following commands
- sqlcmd /E -Q "select name from sys.syslogins"
- sqlcmd /E -Q "ALTER LOGIN [OMEService] WITH PASSWORD='DummyPassword'"
6. Launch OME
7. Database login error displayed. Click OK
.
8. DB Connection error window is displayed.
9. Enter server name where OME DB was restored. Also enter username and password of the new user(that was created in step 4)
10. Launch OME
11. Reset IIS
12. Restart OME services (or restart server)
13. Change the user privileges from sysadmin to dbowner. (This is done on the server where was DB was restored).
Note: You may delete the DB where OME was installed after the retarget is complete
DELL-Rob C
4 Apprentice
•
2.8K Posts
0
April 10th, 2015 13:00
Ok, so...disclaimer, feel free to open a ticket at 800-945-3355 to review the case with a support person...
That said...
Disable the SQL Server account that OME used when OME was first installed.
Do not disable the “domain admin account” that has access to SQL Server.
If they are the same account
- Create a new sysadmin account in SQL Server
- Login to SQL Server using the new sysadmin account
- Disable the account OME used when it was installed.
- Retarget OME by opening it.
- Re-enable the SQL Server account that was disabled.
Thanks,
Rob
e-JP
1 Rookie
•
90 Posts
0
May 13th, 2015 11:00
Hi,
I'm trying to move the DB to another server. However I can't get OME to retarget even if the OMEService is disabled ("Permission to connect to database engine = Deny", "Login = Disabled"). I restarted the server but OME seems to find a way to access the DB. Any clue?
DELL-Rob C
4 Apprentice
•
2.8K Posts
0
May 13th, 2015 14:00
Hi and thanks for the question.
If OME is opening up and accessing SQL Server then it has credentials to login.
This would be credentials the customer supplied for custom install or the OMEService SQL Server login account.
OME does nothing special for accessing SQL Server other than user name and password.
The user must disable the account that OME is using to access SQL Server.
BE VERY CAREFUL
Do not disable all sysadmin accounts or you will have to reinstall SQL Server and data loss may occur.
If you need to, please open a support ticket at 800-945-3355.
Thanks,
Rob
delltechcenter.com/ome
e-JP
1 Rookie
•
90 Posts
0
May 13th, 2015 14:00
Hi,
I don't remember doing any kind of custom install.
The question is how to find the account used by OME? I can only see OMEService with a user mapping for OMEssentials DB. OME must store, somewhere, the SQL account : I tried registry and a file scan without any luck.
DELL-Rob C
4 Apprentice
•
2.8K Posts
0
May 14th, 2015 08:00
Ok....
OME encrypts the credentials it is using. So it would not be useful to see those credentials.
You want to avoid deleting them since it would cause OME to stop working.
One thing you might try is to find out what the user name is by running this command in SQL Server
execute sp_who
either by using SQL Server Management Studio or by using sqlcml.exe
Thanks!
Rob
e-JP
1 Rookie
•
90 Posts
0
May 14th, 2015 12:00
Hi,
OK, I did the command. What are you looking for? I don't want to copy/paste all the output as I don't want some info to be available worldwide. I don't see OMService listed but I see my login name associated on a bunch of line like this one:
spid ecid status loginame hostname blk dbname cmd
51 0 sleeping MyDomain\MyLoginNamet Hostname 0 OMEssentials AWAITING COMMAND
JP
e-JP
1 Rookie
•
90 Posts
0
May 15th, 2015 09:00
Ok, I managed to find the account and to re-target the DB. I need to finish my tests but so far everything is working fine. Thx for the help
FrenchITops
1 Message
0
May 22nd, 2015 07:00
Hi all,
thanks for explanation.
We were not able to change password of SQL user because it's a service account use on many Databases.
We use another solution which is more faster and doesn't required SQL user or password :).
-stop DSM services on your OME server (Server Manager)
-stop "OpenManage Essentials" Website on OME server (IIS).
-backup DB on source and "Take offline" it (Mangement Studio)
-copy DB to destination server and restore it (Mangement Studio)
-create a new SQL user on destination and give him DBOWER privileges on DB.
-start "OpenManage Essentials" Website on OME server (IIS).
-open OME webpage
-->you will get an error message: click on OK to specify Server\Instance on which you have restored
the DB and write credentials of the user you have just created.
OME will take some time to load and start services (2 minutes for me).
That's all, good luck :).
Brice