SQL Server and ASPNET account problem

G

Guest

My web form accesses a sql server database but I get an error message that I
cannot login to the database with the ASPNET limited account.

Is there a way to either configure the ASPNET account so that I can login or
change the login details?
 
E

Eliyahu Goldin

You have a number of options:

1. Add a windows login for your ASPNET account to the sql server.

2. Use sql server suthentication to access the database.

3. Change the ASPNET account in machine.config file

4. Impersonate another account in web.config file.

Eliyahu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is the login control with sql server express a known bug 7
Loading SQLserver database with ASPNET user ID 2
Cannot open user default database. Login failed. Login failed for user 'HEMPC\ASPNET' 3
How can ASPNET access the Northwind database 1
Error while trying to connect to SQL 2005 from ASP.Net 2
ASPNET User 6
newbie SQL Server 2005 connection question 1
Restoring ASPNET Machine Account in Windows XP 0

Top