Solved

Security issues of Windows 7 preventing  database creation in SQL server

Posted on 2010-09-08
7
587 Views
Last Modified: 2012-05-10
Hi,

I have downloaded and installed SQL server express 2005 with SQL management Studio. They are running on Windows 7 Home edition.

When trying to create or attach a database I fail and get the following Error:

Create failed for Databse "databseName" (Microsoft SQLServer.Express.Smo)
Additonal information.
An exception occured while executing a Transact-SQL statement or batch.
(Micrsoft SqlServer.Express ConnectionInfo)
Create database permission denied in database 'master'. (Microsoft SQL Server, Error 262)
My guess is that this is Winows 7 Security issue, but I don't know how to deal with it.
Can any one help.
Thanks
0
Comment
Question by:adamtrask
[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
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 8

Accepted Solution

by:
Mohit Vijay earned 250 total points
ID: 33633309
Have you loged in SQL server using Admin rights? generally this problem occur whenever your SQL user dont have permission for such orations.

Please check if your windows authenticated user has all rights in SQL Server Security/login, if not give permission there.

Its not really Windows 7 security related issue.
0
 
LVL 7

Expert Comment

by:Inteqam
ID: 33633348
it might be, try to give rights for network services to the folder you want the database to be stored in.

0
 

Author Comment

by:adamtrask
ID: 33633408
The installation is very new, I am the owner/administrator and the only person logging in.

And I haven't used a network yet, I am logging in from the machine that has Sql server. The machine is not  attached to any network. So far this is a purely solo beginning.

Thanks
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 8

Expert Comment

by:Mohit Vijay
ID: 33633416
We understand. But your login on SQL server has all rights? is it belongs to sysadmin/owner etc..?
0
 
LVL 7

Assisted Solution

by:Inteqam
Inteqam earned 250 total points
ID: 33633419
well, i'll tell you my experience.

I have had the same environment you have, except that i had windows 7 Ultimate, and i wasn't trying to create a database, but Attaching one. every time i attached a database i got it read-only and couldn't change it.

the solution was to give the network services user the proper access privilege to the folder of the database file, since that is the user the SQL service is running under.

0
 

Author Closing Comment

by:adamtrask
ID: 33636792
Thank you guys, all I had to do was  right-click on Sql server Management Studio, go to properties and select run as administrator.

It was a Windows 7 security problem after all.


Thanks again.

0
 

Expert Comment

by:geoff_austin
ID: 34944307
adamtrask -

Just had the same problem on Windows 7 / SQL 2005 Express.  Running SQL Server Management Studio as administrator did the trick.  Thank you for posting.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Assume you have an outside contractor who comes in seasonally or once a week to do some work in your office, but you only want to give him access to the programs and files he needs and keep all other documents and programs private. Can you do this o…
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.

627 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