Security issues of Windows 7 preventing database creation in SQL server
Posted on 2010-09-08
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)
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.