I have the database on windows 2003 system and the webserver on windows 2000. I am getting an error while trying to establish a db connection. Error is as follows:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."

my connection string is:
DbConn.ConnectionString = "Persist Security Info=False;User ID=test;PWD=test123;Connect Timeout=35;Initial Catalog=testdb;Trusted_Connection=yes; Data Source=tstSer

I have included the parameter Trusted_Connection=yes recently but it also doesn't seem to work. It gives the same error when this parameter is removed.
pls help me with a solution for this

As of now, I need to have both the db and the web server on the same 2003 system or use 2000 for both servers

Hi,
    In server security in enterprise manager, can you make sure Windows and Sql authentication is checked.

Are both the servers on the same domain? If not do you know if they have trust relationship establised? You might need to check with your Admin.

Regards

Do you know if it works for sa?

Sql authentication is checked.
I am not sure if they have trust relationship establised. I will check this out. Thanks