Problems with Rights in MS SQL Server Management Studio Express

Hi all!

I'm a beginner in SQL server admin and have just set up SQL Server 2005 in a Vista environment. So far so good! What I've got a problem with now is to get rights set up properly in the MS SQL Server Management Studio Express sw. If I try to add another database or add a new login and such, the results is all the time insufficent priviledges.

CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) for instance.

SQL is SP2, all else is up to date too

Really would appreciate som help on this

Olof

hi Olof,

please verify the the account/SQL Server login you are using has enought permissions to create new databases, specifically "Create any database" permission..
log in as a member of system administrators server role or "sa" login, select the Security->Logins node... select the appropriate login, rx click->Properties.. in the "Securables" tab, press the [add] button, select the "the Server:your instance" radio.. in the "Explicit permissions for instance_name" grid, grant "Create any database" to the required login(s)..

regards

|||

Hi again!

I found the tabs u mentioned, came in where the explicit rights where and set create db on my user. Effectiv rights lists all the rights. Still I can't create a db as I don't have rights in the masterdb it says. If I go back to the explicit rights afterward, nothing is set on my user, even though it went well entering them earlier.....

This seems strange. My account is as system admin and login shows automatically login as SQLEXPRESS. If I use login with user my accound (as normal admin in the system) it says that it's not a trusted account: The user is not associated with a trusted SQL Server connection

I'm really lost here and will be thankful for any more hints.

Thanks in advance

Olof

|||

Hi Olof,

Windows Vista introduced a new security feature called User Account Control. Because of UAC, programs will no longer recognize your membership in Builtin\Administrators and will only see you as a normal user. Normal users do not have permission to create databases in SQL Server. You can use the provisioning tool described in this blog post to give yourself the appropriate permissions in SQL Express for use on Vista.

Mike