Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CREATE DATABASE problem 1

Status
Not open for further replies.

k108

Programmer
Jul 20, 2005
230
US
Hi,

I am trying to run a CREATE DATABASE command from Query Analyzer.

I am getting the following error:

" Create database permission denied in database 'master' "

Yes, I am trying to run it from the master database. Not sure where else I would run this command...

any ideas??

Thanks
 
The user trying create the DB is part of sysadmin, and have access to the drives that the mdf and ldf get created?
If you syntax is correct, try to login as sa and execute.

Dr.Sql
Good Luck.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top