0

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

3
Contributors
3
Replies
4
Views
6 Years
Discussion Span
Last Post by ImranShafiq
0

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

0

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?!

Edited by amrutap27: n/a

0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.