Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASP application can not connect to sql2000 servder ?

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
0
0
Why I can not connect to sql2000 server from an ASP application if my logging account created with windows authentication but I can if it is created iwth sql authentication !!!

Any help
 
The account ASP is running in is the IUSR_<servername> == anonymous user. For that account the access is limited to the web's dictionary. Maybe You can grant access for the anonymous user, but then Your databases will be open to all internet users over the world!
If You restrict the access to the web (not allowing anynymous users) the SQL-access should be able too.
PFR
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top