May 26, 2015 at 12:18 pm
Hi friends,
I need to load a customer database onto our SQL 2008 server. I always use restore database option in the management studio and create a new database from device (customer database backup file), it used to work just fine. But when I do the same now, I get this below error:
CREATE DATABASE permission denied in database 'master'.
RESTORE HEADERONLY is terminating abnormally.(Microsoft SQL Server,Error: 262)
I also tried to create new database option in the management studio, but get the same error. I did run management studio as 'Run as admin'.
Server - Windows 2008 R2
SQL Server 2008 R2, SP1
Please help..
May 26, 2015 at 1:46 pm
Is this the same account you always did the restores on in the past? Who is the DBA for the instance? It seems like either the login is incorrect and permissions have been changed and your login no longer has permissions to create dbs on the instance.
Joie Andrew
"Since 1982"
May 27, 2015 at 6:22 am
Sounds like there must have been some security changes on your server. The login you're using doesn't have permission to run the RESTORE command.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 27, 2015 at 7:20 am
Try to login with system admin account and check the permissions of the account you are currently using
May 27, 2015 at 7:38 am
Thanks a lot everyone. It was indeed permissions issue, we got it fixed,
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply