Solved

fail to create  database at SQLExpress

Posted on 2013-11-25
6
234 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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

This article demonstrates probably the easiest way to configure domain-wide tier isolation within Active Directory. If you do not know tier isolation read https://technet.microsoft.com/en-us/windows-server-docs/security/securing-privileged-access/s…
Group policies can be applied selectively to specific devices with the help of groups. Utilising this, it is possible to phase-in group policies, over a period of time, by randomly adding non-members user or computers at a set interval, to a group f…
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…
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 …

617 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