Hi
I am using IIS 5.1 and im trying to host my web site on IIS.
But it generates error while opening database..im using MS SQL server 2005.

The error is :
"Cannot open database "EXAM" requested by the login. The login failed.
Login failed for user 'ABC-0C2DBCA594D\ASPNET'."

Please help in this.
-Amruta

you would need to create the user in sql server in order grant authentication on any data request

Hi
I am using IIS 5.1 and im trying to host my web site on IIS.
But it generates error while opening database..im using MS SQL server 2005.

The error is :
"Cannot open database "EXAM" requested by the login. The login failed.
Login failed for user 'ABC-0C2DBCA594D\ASPNET'."

Please help in this.
-Amruta

Will you pls elaborate how can I do this?!

Dear,
I have faced this problem & solved too, method as followed.

OPENN IIS - RIGHT CLICK ON APPLICAITON POOL - CREATE NEW APPLICATION POOL -
TYPE NAME OF NEW APP. POOL - CLICK OK - RIGHT CLICK ON NEWLY CREATED APP. POOL -
SELECT TAB IDENTITY - SELECT CONFIGURABLE - HERE YOU TO SELECT USER NAME WHO HAVE
RIGHTS TO CONNECT SQL DATA BASE - APPLY - OK.

SELECT WEB SITE - DEFAULT WEB SITE - SELECT YOUR VIRTUAL DIRECTORY - TAB VITURAL DIRECTORY - APPLICATION POOL - SELECT POOL NAME - APPLY - OK.

PLS. VERIFY EITHER YOUR APPLICATION POOL STOP OR START.