Help with IIS and SQL "Trusted Connect" for first time user

[DellaCroce]

I am trying, for the first time, to set up a small development system at
home. I have two computer C1 and C2. C2 has SQL Server 2000 and IIS
running on. C1 has VS.Net 2003 running on it. All under WinXP

I am missing something, because I can not get VS to connect to the SQL
Server because "Not associated with Trust SQL Server connection" Where is
this set up?? The user name, Dev1, has user profile and permissions on C2
in SQL Server.

The other problem is the IIS connection. It is running on C2, but how do I
get VS.Net to see it from C1??

TIA to any and all that are willing to help me.

Greg

[Dan Brussee]

>I am trying, for the first time, to set up a small development system at

home. I have two computer C1 and C2. C2 has SQL Server 2000 and IIS
running on. C1 has VS.Net 2003 running on it. All under WinXP

I am missing something, because I can not get VS to connect to the SQL
Server because "Not associated with Trust SQL Server connection" Where is
this set up?? The user name, Dev1, has user profile and permissions on C2
in SQL Server.

The other problem is the IIS connection. It is running on C2, but how do I
get VS.Net to see it from C1??

When running a .NET application, it runs under the user account for
ASPNET_WP. This is the default. You can tell the system to use another
account if you wish by setting that in the IIS virtual folder
properties and then using the web.config setting for impersonation. I
wont go into any details... remember... google is your friend :)