I'm trying to set up another local testing machine for my ASP.net web site.
I can display the page that doesn't have data connections.
However, I get following error message when I try to access database.
Unable to open the physical file "C:\Inetpub\wwwroot\htdocs\App_Data\ASPNETDB.MDF". Operating system error 5: "5(Access is denied.)".
An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\htdocs\App_Data\ASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Connection String is as below
Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Inetpub\wwwroot\htdocs\App_Data\ASPNETDB.MDF;Integrated Security=True;User Instance=True
I checked all the security setting that I think of, but I can't get it work.
I installed Visual Web Developer just to see if it establishes connections SQL server.
In Visual Web Developer 2010 Express edition, I can open the database and if I press "test Connection" button in "modify connection" pop up window, I get message say "Test connection succeeded"
What am I missing??
Thank you for your help