If you're using Windows Authentication, the UserID option in the connection string is ignored. The app is going to try to connect to the SQL Server using your CBCINC\username login. You'll have to create a trust between the two domains.

-Mike

>Hi,
>
>I do have 2 domains, CBCINC (2000 server) and CBCDOMAIN (2003 server).
>
>I have SQL 2000 sp3 install on domain CBCDOMAIN with IIS6.0.
>
>I do my development in VS.NET 2002 on a PC on domain CBCINC .
>
>In my ASP site, in the web.config appSettings, I do have ,
>
>"Integrated Security=SSPI;User ID=cbcdomain\administrator;Initial Catalog=DBC;Data Source=CBC;"
>
>I also have identity impersonate = "true"
>
>The only thing I want is to be able to connect from my ASP apps running on my PC to the SQL server in CBCDOMAIN. I prefer to use a fix user instead of anonymous to access the SQL server.
>
>But everything I try, give me the error,
>Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
>
>The only reason why I do not want to create user ID's, is this table in SQL is use to capture how many times the ASP application pages or function is called. This site is open to every one.
>
>Any Idea on the best way of doing this?.
>
>Carl,
>
>
>