I am testing the login feature in ASP.NET 2.0. I have a Login.aspx page with a login control and a Default.aspx page just with a simple word "Hello" on it. I have added 1 user which i have added to administrators role and have denied all annonymous users. I run the site on my local PC and it works perfectly, i login it authenticates me and i see "HELLO"
The problem i have is when i deploy this simple site to our intranet webserver the login fails and gives me a SQL error. The web server does not have sql server or even sql express installed on it. My sites normally access the database server via a connection string in the webconfig.
Why is my authentication failing. I think it has something to do with my site trying to access the ASPNETDB.mdf, but it cant.