dbhatoa
asked on
Can't create a new user or database within 2008 database engine
Hi,
I've just installed sql server 2008. When running the management studio I get the option of connecting to the database engine or sql server compact edition.
When I go to connect to the database engine with a local or domain administrator account, I can't create a new database -
I get the error message
"create database permission denied in database "master"" error 262
When I go to security, create new login and try to give my user domain user access to dbcreator I get another permission denied error (15247).
I've tried logging on with the sa default username and password, but no luck.
In short, I can't create a database and can't give myself permissions to do so.
Please help.
tx
I've just installed sql server 2008. When running the management studio I get the option of connecting to the database engine or sql server compact edition.
When I go to connect to the database engine with a local or domain administrator account, I can't create a new database -
I get the error message
"create database permission denied in database "master"" error 262
When I go to security, create new login and try to give my user domain user access to dbcreator I get another permission denied error (15247).
I've tried logging on with the sa default username and password, but no luck.
In short, I can't create a database and can't give myself permissions to do so.
Please help.
tx
ASKER
I'm using Server 2003, unfortunately trying the steps didnt work
With my domain admin account I tried to give myself sysadmin permission only to be given SQL server error 15247
May have to re-install sql server 2008 :-(
With my domain admin account I tried to give myself sysadmin permission only to be given SQL server error 15247
May have to re-install sql server 2008 :-(
Kindly confirm under what account SQL Server service is running and check whether the user you try to connect have administrator privileges on that machine.
If not kindly use sa login to log in to the machine ( or ask your DB Admin instead) and add this user login and grant sysadmin privileges to your account.
If not kindly use sa login to log in to the machine ( or ask your DB Admin instead) and add this user login and grant sysadmin privileges to your account.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
rrjegan,
SQL server is logged on as NT authority service\network service as shown in services.msc.
I've tried to make that account a member of local admin group, but account not found in AD.
jagdish,
I'm using windows server 2003 for the OS (not Vista and hence no UAC), I'm using sql server 2008
tx
SQL server is logged on as NT authority service\network service as shown in services.msc.
I've tried to make that account a member of local admin group, but account not found in AD.
jagdish,
I'm using windows server 2003 for the OS (not Vista and hence no UAC), I'm using sql server 2008
tx
hi,
sorry i havn't checked that ... meanwhile why cant you try the 3rd step in previous post on windows 2003.
sorry i havn't checked that ... meanwhile why cant you try the 3rd step in previous post on windows 2003.
ASKER
Run as local administrator worked, which I thought I tried earlier.
Odd that domain admin doesn't have permission. All good, tx
Odd that domain admin doesn't have permission. All good, tx
Can you kindly post what exactly helped you to solve this issue so that it would be helpful for others visiting here later on..
ASKER
I managed to right click on the sql server management studio, then run as, run as the local administrator, (not domain), logged on via windows authentication to sql server contacting the local sql server
that account had permissions to create a db, I could also click within logins to set permissions for existing users (such as sysadmin), as well as create new logins.
that account had permissions to create a db, I could also click within logins to set permissions for existing users (such as sysadmin), as well as create new logins.
Isn't the same thing I mentioned in my first comment 24902801
Because in the above OS, Local administrators wont have access/ privilege to the database by default.
You have to elevate the Local administrator or other users to grant them privileges.
Kindly follow steps mentioned in "To add a Windows user that has the login "domainname \username" to the sysadmin fixed server role " topic in the link below
http://msdn.microsoft.com/en-us/library/bb326612.aspx
Once this is done, you would be able to create database and users.
Hope this helps