?
Solved

fail to create  database at SQLExpress

Posted on 2013-11-25
6
Medium Priority
?
247 Views
Last Modified: 2013-11-26
I cannot create database on SQLexpress on my Machine
error massage: "create database permissions are denied in  database master"
I use Windows Authentication account

On my machine I am a member of administrative group.
it means : when I go to  
My Computer-> Manage -LocalUsers and Group  -group - Administrators -member Of
-I see my User ID
But I do not see my User ID when I go
My Computer-> Manage -LocalUsers and Group  -Users
0
Comment
Question by:Yampolka
  • 3
  • 3
6 Comments
 
LVL 3

Accepted Solution

by:
Jerry_Justice earned 2000 total points
ID: 39675951
It doesn't matter if you are an administrator on your local computer oir even on the domain.

Your login specifically needs to be assigned admin access in SQL Server.

The problem, of course, is that since you do not have admin access to create a database, you also do not have admin-level rights to change the rights on your computer.

You will have to talk to the person who installed SQL Server.  If SQL was installed with "mixed-mode" security, then there is an administrator login called "sa" (as well as other possible admin logins).  Logging in to SQL Server with that login will give you rights to both create a database and/or add your windows login to the list of administrators.

Alternateively, if SQL was set up with Windows authentication only, the person who set up SQL Server will need to log in to a machine to give you admin rights.

You will need a copy of SQL Server Management studio to make changes to logins.
0
 

Author Comment

by:Yampolka
ID: 39676064
I downloaded and install SQLExpress myself. unfortunately I did not paid attention while installation.
Sql  Server Management  studio was installed already  . It connects to SQl Servers 2008 engine on Production Machine where i have SQL Server account.
I downloaded  SQLExpress for testing purposes , and when downloaded figured out  that
I do not have nejther Server Nor windows permission.
I would satisfied with any  just to have the full accsess to create databease.
What do you suggest? To re-install SQLExpress? How?


What best I can do n
0
 
LVL 3

Expert Comment

by:Jerry_Justice
ID: 39676078
Well, when you install SQL Express, it usually defaults to adding your current login to the admin list.  Were you using the same login when you installed SQL Express as you are trying to use now?
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 

Author Comment

by:Yampolka
ID: 39676182
I uninstalled SQLExpress components  from Control panel now(all components including Shared)
I downloaded   SQLExpress 2008
But now I have different issue
When I trying to install it I have an error during installation
 " Could not load file or assemby  ' System version 4.0.0.0 PublickeyToken b77a5c561934e089 or one of the dependensies
0
 

Author Comment

by:Yampolka
ID: 39677904
When I  have been installing  sqlExpress second time I  wast more attentive.
When I was going tru process I added "current user" as admin"
I selected just in case  both " Server Authentication" and Windows Authentication mode
Now It's working fine
0
 
LVL 3

Expert Comment

by:Jerry_Justice
ID: 39677915
Great!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office 365 is a subscriptions based service which includes services like Exchange Online and Skype for business Online. These services integrate with Microsoft's online version of Active Directory called Azure Active Directory.
The article explains the process to deploy a Self-Service password reset portal I developed a few years ago. Hopefully, it will prove useful to someone.  Any comments, bug reports etc. are welcome...
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question