Hello, I'm trying to access sql2000 from IIS6, but no matter what I try, i keep getting denied. When I run the code from webmatrix, it works perfectly, despite the fact, that I'm accessing sqlserver across two domains, but when I publish the app on IIS6, they run from the same domain, but different servers.

The error:
system.Data.SqlClient.SqlException: Login failed for user 'intranet'.

The connectionstring:
Dim connectionString As String = "Data Source=srv221;database=intranet;uid=intranet;pwd=p assword;"

And I tried different combinations of:
trusted_connection=;
integrated_security=;
any suggestions?