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 |
|
NewToASP
Starting Member
7 Posts |
 Posted - 2012-01-21 : 19:19:53
|
| I scoured the web trying to find a guide for this and suprisingly I couldn't even find one straightforward guide.I need to run aspnet_resql to build an aspnet db but when I run the application it says that create database permissions are denied in db master.I tried going into the properties on my db server and setting it there but it doesn't stick. How can I set the permissions to create any database on the master db? Preferably through the SQL management tool gui if possible.Thanks. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-01-22 : 01:29:30
|
| What permissions do you have on the SQL Server? Are they sufficient enough to issue the CREATE DATABASE,CREATE ANY DATABASE or ALTER ANY DATABASE permissions.If not , you may need to speak to the DBA. Even so, normally the create database permissions are limited to a few logonsJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
NewToASP
Starting Member
7 Posts |
Posted - 2012-01-22 : 07:57:14
|
quote:
Originally posted by jackv
What permissions do you have on the SQL Server? Are they sufficient enough to issue the CREATE DATABASE,CREATE ANY DATABASE or ALTER ANY DATABASE permissions.If not , you may need to speak to the DBA. Even so, normally the create database permissions are limited to a few logonsJack Vamvas--------------------http://www.sqlserver-dba.com
Well the thing is that it's my own personal winhost server that is hosting the database and I only have one login that use and it's with SQL validation.When I click on the properties for my database server it brings up the permissions options but the only one checked is "logon the SQL". When I click on the permission of create any database and click apply it seems to allow it but when I go back in it's as if the change never happened.How can I give myself all the permissions?P.S- I have a copy of the aspnet db so I would just simply attach if I could but I get that stupid cannot show requested dialog error when I click attach. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-01-23 : 11:53:27
|
| As Jack said, what permission do you have on this server? |
|
|
|
|
|
|
How can I set Create Any Database permissions?