Share via

Restore failed with Microsoft SQL Server Management Studio Express 2005

  • Article

Question

Wednesday, June 2, 2010 9:51 AM

Hi, I'm helping a friend of mine migrate their database from one computer to another, he created a backup from the original server and gave me a USB stick with the backup on. The plan was to use the restore database function from within Management Studio Express on the new computer to restore the database to it's new home.  However every time I run restore I get the following error:

TITLE: Microsoft SQL Server Management Studio Express

Restore failed for Server 'CURWOOD-PC\INVENIAS'.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: CREATE DATABASE permission denied in database 'master'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

BUTTONS:

OK

 

There is already another database server (CURWOOD-PC\INVENIAS) on the new computer, do I need to create another one for the restore? or can it be restored inside the existing server, as this server seems to be the one were permission is denied for database creation.

I much appreciate any help provided,

 

John

All replies (5)

Thursday, June 3, 2010 5:54 AM âś…Answered

sa user always creted by default when you install sql server.

If you create any new login and using that sql login or windows login to restore database you can veirfy the permission by following step.

expend security=>expend login=>right click on login and click on property=>check the server role (it should be sysadmin)

 

 

 

**Mark as answer if it solves your problem. Raj_79

Wednesday, June 2, 2010 10:14 AM

Error showing that user does not have permisssion to modify master database. Please confirm that login should have proper permission, even you can also use sa login to restore this database.

Raj

**Vote it if it is helpful. **Mark as answer if it solves your problem. Raj_79

Wednesday, June 2, 2010 7:01 PM

I thought I had permission to modify the database, I've set everything up on the new computer myself.

How can I tell what permissions I have?

If I don't have permission, what is sa login, and how can I use this to restore the database?

Thanks once again for your help.

 

John

 

Thursday, June 3, 2010 7:59 AM | 1 vote

Hi Raj,

 

Thanks very much for your help, going through the process in your latest response and seeing that everying was as you said it should be reminded me that I am now running Vista not XP and that I had to "Run Management Studio Express as Administratior".  Once I started Management Studio that way, I was able to restore the database no problems.

Thanks again,

John

Thursday, February 6, 2014 7:24 AM

This solution works.. thanks a lot..