Hi everyone,
I am having a problem exporting the Photo Album application to my web / sql server.
On my domain, I have an IIS \ SQL 2k5 express server running on a single W2K3 Svr. I am accessing the site thru VWD Express 2k8 from a remote machine.
On my webserver, I've copied the files from the modification folder to the "PhotoGallery" subdirectory, set up the application, and enabled frontpage extensions.
After that, I attached to the given databases to my SQL Server and given the appropriate permissions to the ASPNET AND NETWORK SERVICE ACCOUNTS (Since I get conflicting errors about users not being able to access the secure portion of the website).
Here's the problem. The basic website works fine, but when I attempt to log in I cannot, and I get the following error:
Unable to open the physical file "d:\inetpub\wwwroot\PhotoGallery\App_Data\aspnetdb _log.ldf". Operating system error 5: "5(Access is denied.)".
Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
File activation failure. The physical file name "d:\inetpub\wwwroot\PhotoGallery\App_Data\aspnetdb _log.ldf" may be incorrect.
This is my connection string:
<connectionStrings>
<add name="SqlServerConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=PhotoDB;Integrated Security=SSPI;" providerName="System.Data.SqlClient" />
</connectionStrings>
I've done everything I can think of and checked everything that I could read online, but I'm going nuts trying to figure this out.
Please help.
It's not the size of the dog in the fight, it's the size of the fight in the dog!
Porting a web app to SQL 2005 Express
