Solved

Restore SQL.bak file from Maximizer 11 to Maximizer 12

Posted on 2013-02-06
5
1,415 Views
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.
0
Comment
Question by:Lounger-Master
  • 3
  • 2
5 Comments
 
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 ?
0
 

Accepted Solution

by:
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
0
 
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.
0
 

Author Comment

by:Lounger-Master
ID: 38864642
Well said!, ,Thank You again and have a great day :)
0
 

Author Closing Comment

by:Lounger-Master
ID: 38879454
I managed to figure it out myself
0

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.

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

760 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now