468,483 Members | 2,393 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,483 developers. It's quick & easy.

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

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

Nov 18 '05 #1
1 1441
>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 :)
Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Hunter | last post: by
6 posts views Thread by swartzbill2000 | last post: by
12 posts views Thread by Jonathan Wood | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by kmladenovski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.