IIS Woes

Hi all,

I am attempting to host an asp.net 2.0 page on a server running windows server 2003 with IIS 6.0. I have been trying to get it working for almost 2 months now reading countless articles but nothing seems to help. I am trying to host a page that uses SQL server 2005 express for all of its data storage. After hours of errors I decided to make a simple page that has a single label that gets its text from the database. I was getting the exact same error which was: An attempt to attach an auto-named database for file C:\WebSites\Test_TimeTracker\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.

I continued to get this error for a long time, but unfortunately i am not the only one working on this so some unknown changes were made such that the first time you try to connect you get the above error and then any attempts after get this error: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - The system cannot open the file.)

After it not working for so long I reinstalled IIS. Now after adding a new website I got a configuration error saying that it didnt recognize the configuration section 'connectiongStrings' but that was just because I forgot to set the ASP.NET version to 2.0. So I change it to 2.0 and now it says: "The page cannot be found"........

Does anyone know what the problem is and can help me get this page up and running?

Did you configure IIS to allow sql server use?

I'm not sure if its configured. How do I do that?

I don't have IIS6 but I believe there is a setting somewhere in the IIS management console to enable sql server access by the web server.