Solved

fail to create  database at SQLExpress

Posted on 2013-11-25
6
231 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 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Disabling the Directory Sync Service Account in Office 365 will stop directory synchronization from working.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
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 …

810 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