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.
| Author |
Topic |
|
gagani
Posting Yak Master
112 Posts |
 Posted - 2013-06-06 : 10:52:29
|
| when I tried a database on my local sqlexpress for the first time, I am getting the error asCREATE DATABASE permission denied in database 'master'I think only administrator has the option to do it. But when I tried to open sql management studio by right clicking on it and 'run as administrator'. Once the management studio is opened, when I run the query select _username(), it is resulting as 'guest' only. how to work around this and create a database |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-06-06 : 11:10:56
|
| When installing Sql Server you had an option to make the current (installing) user an admin on the (sql) server. You just need to add your account to the Sql Server's "Security | Server Roles | sysadmin" server role.EDIT:It should allow you to do that. But if not another installation option was to include an "sa" sql user. Hopefully you did that. Connect as sa then add your account to the sysadmin Server Role.Be One with the OptimizerTG |
 |
|
|
|
|
|
CREATE DATABASE permission denied in database 'mas