Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Restore SQL.bak file from Maximizer 11 to Maximizer 12

Posted on 2013-02-06
Medium Priority
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
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.

704 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