Skip to main content

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
Original Post

Replies sorted oldest to newest

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.

Add Reply

Post
LEGAL INFO
CONTACT US
Copyright 2007-2018 Advoco Solutions Ltd. All Rights Reserved.
×
×
×
×
Link copied to your clipboard.
×