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
Jump to Postyou would need to create the user in sql server in order grant authentication on any data request
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.