?
Solved

fail to create  database at SQLExpress

Posted on 2013-11-25
6
Medium Priority
?
240 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 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

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

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.

Question has a verified solution.

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

A bad practice commonly found during an account life cycle is to set its password to an initial, insecure password. The Password Reset Tool was developed to make the password reset process easier and more secure.
Wouldn't it be nice if objects in Active Directory automatically moved into the correct Organizational Units? This is what AutoAD aims to do and as a plus, it automatically creates Sites, Subnets, and Organizational Units.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

719 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