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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

735 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