|now I am trying to make virtual directory for asp.net 2.0 web application.
I know how to make virtual directory.
in my web project, App_Data contains database (.mdf) file.
then, I change web.config connection strings like that:
"Data Source=(local);AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True" providerName="System.Data.SqlClient"
I used auto attach connection.
But now,when I browse this application from browser, It shows error like below.
CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\WebHelpDesk\App_Data\Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I don't know how to slove.
pls share me , giving idea how to solve.
I also checked in SQL server 2005 management.
I detached my database file in SQL server.
but it shows error like above.