account Administrator can't create Database

Question

Hi everyone, i'm programming with Microsoft SQL Management Studio and recently, i have activated the admin account for some reason (on windows 7). Now i'm trying to create a Database in the master, it doesn't worked, so i've read on the forum that i needed to give authorisation to the user "Administrator", and i've done it..... i still can't create a database...... does someone can help me?

Answer 1

On which level did you gave you yourselve "Admin" role permissions, on Windows?

You need SysAdmin rights in SQL Server, not on Windows/OS level.

 

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

ok i'll try to give permission to SA and tell you if it worked after.

Answer 3

The "SA" Sql Server account do already have all permisson on SQL Server.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 4

it doesn't allow me to give permission to SA, i think i do something wrong here.... what i've done is in the security folder, i've added the account "name of computer"/Administrator, all the same right that the user i used to install the software, but it still doesn't work, something strange too is that in the DB master, in security, i've added the account admin, and when i log into the admin account, go to the security folder, my account is not here.

Answer 5

Then you don't have the permission to change the permissions.
During installation of SQL Server have you added your account to the "System Administrator" role of SQL Server?

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 6

i can't remember, it's been a year since i've installed it.

Answer 7

During that time, have you ever trying to do some administration task like adding a new database, new login etc.?

Which version of SQL Server are you using?

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 8

on my account where i installer SQL Management studio, i created DB, table, insert, everything of this, but i needed to activate my admin account for some reason, and on that account, even if i gived the authorisation in the security folder under Master and in master, i still can't create DB, i have SQL Server Express. (The one free with visual studio 2010 ultimate)

Answer 9

on my account where i installer SQL Management studio, i created DB, table, insert, everything of this, but i needed to activate my admin account for some reason

Start SSMS with your account, which seems to work, open node "Securtity" => "Logins" and add the Windows Account + add this account to the "SysAdmin" server role to ensure it has enough permissions.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 10

here's what's given as right right now

Answer 11

Hello,

As soon as you are sysadmin ( you have this server role according the screenshot ), you are allowed to create a database.

SQL Server Express is free ( you are true ) but the Developer Edition is the same as at least the Entreprise Edition ( but you can use it only to learn or test not for production aims ) and it is really costly : around 50 to 70 € in France , surely the same price 50tro 70 $ in USA. I don't know how you got your VS 010 Ultimate, but it is much dearer than a SQL Server Developer 2008/2008/ R2/2012 ( at list 30 times more ) or it is a school version.

I have not understood "in master, i still can't create DB". Master is the master database. You can create a database as soon as you are using the same Windows login than this which was used to install SQL Server.

I have noted that you have masked partly the name of the administrator ( ComputerName\Administrateur ) . Administrateur is the french translation of Administrator. Have you a french operating system  and an Engligh (en-US) SQL Server?

The version of your SQL Server 2008 Express is 10.02531. If my memorty is good, it is a RTM release ( i have a Developer SQL Server 2008 10.0.5500. You should ( at least ) install the SP2.

Have a nice day

PS : Papy Normand because i am from Normandy (Haute Normandie ).Iit is why i am interested by the language of your SQL  Server/ operating system

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 12

because i'm a student, i got some free software from microsoft (like windows 7, visual studio 2010 ultimate), from msdnaa. Second, i'm canadian, not french.  can you tell me where can i get the SP2 please?

Thirs here's the code i write:

USE master;

IF EXISTS (SELECT * FROM sys.databases WHERE name = 'CENCORED')
    DROP DATABASE CENCORED;
GO

CREATE DATABASE CENCORED;

and it says i can't write in master, because i don't have the authorisation(...)

Answer 13

Hello,

I am sorry not to have "tilted" on your name (Iqebecois) which would be an explanation of your french SQL Server

For SP2 : http://www.microsoft.com/en-us/download/details.aspx?id=20610

For SP3 : http://www.microsoft.com/en-us/download/details.aspx?id=27597

be careful , you have 3 possibilities of download depending whether you have a 32-bit or 64-bit operating system

You will find explanations about the 3 available downloads (SP3 but partly related to SP2 ) in

http://social.technet.microsoft.com/wiki/contents/articles/4937.microsoft-sql-server-2008-sp3-release-notes.aspx

To create a new database, i would suggest to use the SQL Server Management Studio Express ( SSMSE ). Expand the nodes of your instance.Right-click on the 1st node (Databases) and , in the conceptual menu, click on the New Database item. You will open a new form which will permit you to create a new database through a graphical form ( more simple and quicker ).

If the Windows account you are using is sysadmin, you should have the right to create a new database ( you need to have the "dbcreator" server role permission which is included in sysadmin ).

Don't hesitate to post again for more help or explanations.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 14

i don't know if it'll work, i'm installing SP1, SP2 and SP3 X64 right now. but something i found strange is that i got the feeling there's two master database (1 per account) and that the master of "administrator" is a double, because i can't see my other database in the list

Answer 15

here what i say i got the feeling that the master is in double, look at what i got in the account admin

Answer 16

Hello,

What for a "double" do you mean? Sorry, it's really difficult to see anything in your screenshots. To much content in a to small size.

In the former screenshots there have the the settings for the "machine\Administrator", who seems to have SysAdmin server role permission. But you use Windows 7 and here you newer are the Administrator, even if you are in the local admin group, you always work with restricted permissions on the level of a normal user.

You have to add your Windows Account to the security + SysAdmin server role to get it working.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 17

juste compare the newest screenshot (this is my view as the user administrator" and the old screenshot (this is the view as my everyday user) and see the diference, i think the problem is here. what i mean is, there's a lot more account in my "everyday user" than the one in the administrator account. so it mean something is wrong right here, i don't access the master of "my everyday account" as an admin, instead i access the master of the Administrator account, that what i mean.

Answer 18

I am sorry, but I really don't understand what you mean, especially with "yesterday user".

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 19

not yesterday, everyday by "the user i use everyday" i don't want to write the real name for security issue.