Restore SQL.bak file from Maximizer 11 to Maximizer 12

Posted on 2013-02-06
Last Modified: 2013-02-12
I am trying to restore a Maximizer CRM 11 database to a Maximizer CRM 12 system.  I have the file backed up properly through the Administrator of Maximizer in version 11 but have great difficulty restoring it in Maximizer 12.  I've tried to restore the file using the SQL Management Studio but then the MASTER password does not allow me to log in after a successful restore.  I've also tried to restore the database using the Maximizer Administrator program and here I get the message "The user MASTER does not have sufficient rights on this machine to perform the requested action.  You may choose to grant this user the neccessary rights to perform the restore directly within SQL Server Management Studio.  For full details please see the Maximizer CRM 11Administrator's Guide or Maximizer Software knowledgebase.  I've search for hours but I cant find the answer.  I hope someone can help me.
Question by:Lounger-Master
  • 3
  • 2
LVL 51

Expert Comment

by:Mark Wills
ID: 38861857
Sounds like they are using a mixed mode authentication and have a privileged user "master"

So, in SSMS have a look at the user "master" in your CRM 11 instance, and then again in your CRM 12 instance. Chances are you need to "reconnect" the "master" in the database and the "master" in sql server users.

If using Windows authentication, then double check the AD groups.

Now, when you restore a database, it has the user SID's in there and they might not match in your new server (the names might but those SID's give access to security and are unique).

Are you moving the database to another machine ?

Is this an upgrade in place ?

Are you able to restore OK from a technical perspective (ie SQL Server does have the database and sql doesnt report errors as such).

Could you maybe describe the steps you have taken so far ?

Accepted Solution

Lounger-Master earned 0 total points
ID: 38862642
This ended up being much simpler than anticipated.  All I needed to do from the old version is to highlight all contacts, select address book transfer, and then on the new system , double click on the generated file and it asked if I want to import the data and upgrade it in the process and it was done.  No need to use SQL or the Administrator function at all.  My aplogies to waste your time.  Thank You
LVL 51

Expert Comment

by:Mark Wills
ID: 38863321
No problems, and isnt a waste of time.

The only waste of time is hesitating to raise the hand :)

Very happy to hear that you were able to solve the problem.

You should accept your comment as the answer so others can see your solution.

Author Comment

ID: 38864642
Well said!, ,Thank You again and have a great day :)

Author Closing Comment

ID: 38879454
I managed to figure it out myself

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question