sql advice

dom17

Hope im posting this in the right place.

My problem is i downloaded sql 2008 express edition and MS SSMS for a course im doing. I have my desktop set up with me as admin and me also as a user so as i can do work on the pc without being in admin user, (supposed to be safer i was told). This works fine for all my other programs, but with MS SSMS i cant create any new databases to work with. I went back into admin and allowed myself (well i thought i did) to be a user. When i open up a database in admin mode i can see myself as a user ,but when i go back as a normal user it wont allow me to create a new database. any help would be greatly appreciated.

uch

You need to give the general user permissions to create databases (dbcreator) through Management studio, standard users do not by default have permissions to create DB's

dom17

thanks uch

ok tell me if im wrong


open management suite in admin user
open security tab up
right click on users
click on new user
create myself as new user
there are then 2 sets of boxes
1 owned schema 2 role members
neither have db_creator

could it be datawriter and if so which one do i choose 1 owned schema 2 role members or both

or am i in the wrong area all-together

thanks

please forgive my ignorance but i am new to this


[Removed Image]

heroics

Read this

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/f12d6f58-afb1-4092-96ca-be0d9394adf8

dom17

thanks heroics
but as im new to this i don't really understand what they're saying, obviously the highlighted text is inserted somewhere but where im not sure
thanks again will try youtube

you know monkey see monkey do

heroics

No problem

Try this

Log into the server as the admin - Open SSMS and on the left hand window go to security - logins. right click on your username and select properties. Under server roles make sure you have dbcreator selected

Or in the top left corner select new query and paste in the script from the link above but replace the <login name> with your username.

dom17

you are aptly named heroics worked a treat thanks very much i owe you a pint/coffee
thanks again

heroics

No problem