We moved a internal web application to a new server and now cannot connect (I think) to the SQL Server. We are using .Net 3.5 and SQL Server 2008R2. Is there a way to get something back that tells me more about what is happening? I am validating users
against a table in the database and I know the sql command works when I run it in SSMS. Thanks.
Some new detail on this. I was able to connect to the SQL Server from other pages. The problem occurs after the login page and the authentication function and the home page has code below which is always redirecting.
If Not Page.User.Identity.IsAuthenticated Then
Response.Redirect("~/BodyShopLogin.aspx")
End If
...
Go to the complete details ...