Home / server / Questions / 309562
Accepted
MacGyver
Asked: 2011-09-09 13:50:12 +0800 CST

CREATE DATABASE permission denied in database 'master' ... A database with the same name exists, or specified file

  • 772

Background:

I'm trying to get the Live Demos of Telerik's Rad Controls for ASP.NET AJAX working on my local machine in IIS 7. I'm getting an error when I view the ComboBox demo.

Error I get:

Server Error in '/' Application .... CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file C:\Users\MacGyver\MyDocuments\Visual Studio 2008\Projects\TelerikDemos\Telerik\RadControls for ASP.NET AJAX Q2 2011\Live Demos\App_Data\Northwind.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Same error is here:
(search for "THE SOLUTION IS HERE" .. half way down in huge font)

http://social.msdn.microsoft.com/forums/en-US/sqlexpress/thread/6dfdcc22-7a81-4e8f-a947-c1ce6982d4b3/

I'm on Windows 7.. slightly different clicks, but same problem I'm guessing. I get to the "Advanced Security Settings for App_Data" window, and I have two check boxes. Initially, the "Include inheritable permissions from this object's parent" (box 1) box is checked. But the "Replace all child object permissions with inheritable permissions from this object" (box 2) is unchecked. When I try checking box 2, and click "Apply", it doesn't stay checked. Why would this be?

===================================

9/9/2011 update @ 9:19am

Here are my connection strings:

<connectionStrings>
<add name="NorthwindConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Northwind.mdf;Integrated Security=True;User Instance=False" providerName="System.Data.SqlClient" />
    <add name="TelerikConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Telerik.mdf;Integrated Security=True;User Instance=False" providerName="System.Data.SqlClient" />
    <add name="NorthwindConnectionString35" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Northwind.mdf;Integrated Security=True;User Instance=False" providerName="System.Data.SqlClient" />
    <add name="TelerikConnectionString35" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Telerik.mdf;Integrated Security=True;User Instance=False" providerName="System.Data.SqlClient" />
    <add name="NorthwindEntities" connectionString="metadata=res://*;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Northwind.mdf;Integrated Security=True;User Instance=False;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
    <add name="TelerikEntities" connectionString="metadata=res://*;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Telerik.mdf;Integrated Security=True;User Instance=False;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
    <add name="QSFRatingsConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|QSFRatings.mdf;Integrated Security=True;User Instance=False" providerName="System.Data.SqlClient" />
    <add name="SelfReferencingDbConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|TelerikSelfReferencingDb.mdf;Integrated Security=True;User Instance=False" providerName="System.Data.SqlClient" />
</connectionStrings>

Here is a screen shot of the files in App_Data:

enter image description here

sql-server-2008 permissions database windows-7

2 Answers

  1. Best Answer

    Sounds like you already have a database on the instance called Northwind.

    See this link for more details on entire setup, issues and solution:

    https://stackoverflow.com/questions/7366295/sqlexpress-connection-fails-in-iis-7-w-user-instance-error-failed-to-generate

    • 1

  2. I prepended "Initial Catalog=uniquenamehere;" to the connection string, that solved it:

      <connectionStrings>
    <add name="Northwind" connectionString="metadata=res://*/Models.Northwind.csdl|res://*/Models.Northwind.ssdl|res://*/Models.Northwind.msl;provider=System.Data.SqlClient;provider connection string=&quot;Initial Catalog=uniquenamehere;data source=.\SQLEXPRESS;attachdbfilename=|DataDirectory|\Northwind.mdf;integrated security=True;user instance=True;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>
    • 0