Solved

Security issues of Windows 7 preventing  database creation in SQL server

Posted on 2010-09-08
7
580 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 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
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…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now