When trying to run the ASP.NET Timesheets application I have been having a problem with logging onto the MSSQL server with my application. I assume that when I connect to the server I have to use the 'sa' logon to establish the connection to the server, and then the application will pass the logon and password for the application to gain access to the database. I keep getting "Login failed for user 'LAPTOP/ASPNET'. How do I allow the ASPNET profile access to MSSQL Server? (Assuming this is the problem)

Thanks

Did you have problems in Chapter 8? This chapter dealt with connecting to either SQL Server or Oracle. You should be using the same connection information now that you were using then. If this is not the problem, this please elborate further so I can assist you.

Thearon

Yes, I had some problems in Chapter 8 or 10, can't remember. But they had to do with using the password and login parameters in the connection string. I hadn't had problems with the Integrated Security part. So, I changed the string back to integrated security. It probably has to do with my lack of understanding and experience with SQL Server or MSDE administration. I'll work with my IS counterparts on bringing this knowledge up to speed. Thanks, I've really enjoyed the book!

I remember now... I had to change something in the ASP.NET config file to allow access as an admin.