i'm trying to do simple database access between two win2k3 boxes. one is an app server with visual studio 2003, the other a database server with sql server 2000.

when i try to run aspx pages which used to work on a local instance of sql server, i now get:

SQL Server does not exist or access denied.

I'm not sure what steps to take to authorize asp.net to connect to my sql server. The app server has no problem connecting to the database in non-aspx situations, like enterprise manager, and other C# applications using the same connection string.

help?

many forums on the site discuss you question ???
hope every one use this site to search before ask ??
any way...
to enable all web applications "by default" to connect the sqlserver machine
search the file machine.config in the winnt folder
"\WINNT\Microsoft.NET\Framework\v1.1.4322\CONFIG"Â  
and modify the identity tag as following
<identity impersonate="true" />



Ahmed Ali
Software Developer