Permissions for restoring a database.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Permissions for restoring a database.

Author

Topic

baitg
Starting Member

5 Posts

Posted - 2009-01-28 : 16:32:15

Hi,

When i try to restore a database it wont let me because I dont have administrator rights. The end of the error message that appears is "System.Data.SQLClient.SQLError' CREATE DATABASE permission denied in database 'master'". If anyone could provide a quick run through of the steps needed to fix this it would be greatly appreciated.

Thanks
Mark

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-28 : 18:15:13

As error says: You need Create Database Permission.

baitg
Starting Member

5 Posts

Posted - 2009-01-28 : 18:23:41

Hi,

How do you do that?

Thanks
Mark

quote:
Originally posted by sodeep

As error says: You need Create Database Permission.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-28 : 18:31:55

[code]GRANT CREATE DATABASE TO user[/code]

baitg
Starting Member

5 Posts

Posted - 2009-01-28 : 18:37:32

Hi,

How do I change the permissions? I am restoring the database for myself. I just need to know how to grant myself the required access permissio.

Thanks
Mark

quote:
Originally posted by sodeep

GRANT CREATE DATABASE TO user

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-28 : 18:44:28

It is highly unlikely that you can grant the permission to yourself if you are getting that error. Your account must not have sufficient privileges to begin with. Is this on a hosted server or on a server where a DBA administers it?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-28 : 18:45:12

Well DBA does this task.

baitg
Starting Member

5 Posts

Posted - 2009-01-28 : 18:58:13

Hi,

Its just on my laptop. There are no other users. I am creating a prototype of the system and I need to connect it to the database.

Mark

quote:
Originally posted by tkizer

It is highly unlikely that you can grant the permission to yourself if you are getting that error. Your account must not have sufficient privileges to begin with. Is this on a hosted server or on a server where a DBA administers it?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-28 : 19:04:03

Do you have local admin on it? What operating system are you using?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

baitg
Starting Member

5 Posts

Posted - 2009-01-28 : 19:15:59

Windows Vista. Its just a personal laptop.

quote:
Originally posted by tkizer

Do you have local admin on it? What operating system are you using?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-28 : 19:20:26

You may be impacted by this then: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=118627

See Wylbur's last reply on page 2.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources