Solved

fail to create  database at SQLExpress

Posted on 2013-11-25
6
233 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 3

Accepted Solution

by:
Jerry_Justice earned 500 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Suggested Solutions

This article shows the method of using the Resultant Set of Policy Tool to locate Group Policy that applies a particular setting.
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

710 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