Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Security issues of Windows 7 preventing  database creation in SQL server

Posted on 2010-09-08
7
Medium Priority
?
594 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
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 8

Accepted Solution

by:
Mohit Vijay earned 750 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
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 750 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

916 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