Now you see it, Now you don't (Connection Problems)

[scostell]

This is a strange problem...or maybe I'm just stupid.

I'm creating an ASP.Net web application that interfaces with SQL Server 2000. Everything works fine on my development machine. I'm able to view the webpage through the IDE as well as if I open up IE and type in the address (http://C1156/css-training).

But when I try and look at the webpage by way of another computer I get a login error (Login failed for user '\'.).


My Connection string is as follows:

Dim MyConnection as New SqlConnection("Server=c1156\sql2000;Integrated Security=true;database=css_training;User ID=IUSR_C1103;Password=scott")

I've got Impersonation set to True in my webconfig file. Anybody have a clue as to my error? it has to be in the connection string.

Thanks