Hi,
I hope someone can help me in solving this issue. I migrated to a new server and had to move the DB to this new machine. All seemed fine, I restored the DB and then used the administrator to open and create a new database. It found my DB and all seemed fine. However during the creation it asks me for the master password. I have the master password but if I type it in it is not accepted. To be sure I tried also the server login password the SQL SA password and several more. Nothing worked and I am out of ideas what can cause this to not accept the password that are valid. I still have the old server standing here and I can still access it there using the normal passwords. So something must be happening when this is moved. Any tips for this would be great.

Thanks,
thom

Thom,

If you've attached the database from the old server on the new SQL server you should simply be able to go into the Maximizer Administrator and click File>>New Address book, enter the SA password and then choose to Employ an Existing Database, select your moved database and then let it update.

If you've done that and it still doesn't work then there is likely to be a problem with the login links. Try this, open the Query Analyser and select the database you've moved over as its target, then type in the following:

sp_change_users_login 'AUTO_FIX', MASTER

and hit enter. This should relink the MASTER account.

See also instructions here:

Reference # 040510-000001

Moving Maximizer Enterprise SQL databases

http://support.maximizer.com/scripts/support.cfg/php.ex..._refno=040510-000001

.

Hi,

Thank you both very much for the tips. I found a knowledge base article that did solve the issue. http://support.maximizer.com/scripts/support.cfg/php.ex...gmcF9wYWdlPTE*&p_li= The Master user was not part of the securetyadmin ans sysadmin. I did go to the enterprise manager and added user master to the 2 groups in the securety tap it started to work. Thank you for the help.