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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.