connection problem

[Ivan]

recently i tried to do a simple web site with server with visual
studio 2003, the other a sql server 2000.

when i try to run aspx pages i 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.

help?

 

[Guest]

The ASP.Net worker process runs under as a user with limited permissions. You can either add the user and appropriate permissions to SQL server, or an easier solution (just for development mode), would be to change the user that the asp_net process runs under in your machine.config file. To do that go to:

C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\CONFIG\machine.config

and change the userName attribute of the processModel element to 'SYSTEM';

That should do the trick,

~harris