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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

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…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

752 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