Connection Failed.

Hi everyone, I need help.

I am using Windows Server 2003, VS.NET 2003 and SQL 2000&sp3 on same PC. I was try to run the samples from Framework DSK v1.0 and v1.1, both failed on SQL connection. No matter sa or ASPNET userID, can't make it works.
I can run these samples on Windows 2000, VS.NET 2002 and SQL 2000&sp3 without problem, also runs on Windows XP, VS.NET 2002, SQL 2000&sp3 with WC service on my notebook.

Any particular section I should scope it for troubleshooting?

Thanks for any suggestion on this issue.You have to help us a little. EXACTLY what is the error message.|||The error message is:

Login Failed for user 'NT Authority\Network Service'.

Lin 4: sqlDataAdapter1.Fill(dSet) is in Red.

Thank you for helping me.|||I imagine you are using integrated security to try and connect to SQL Server.

This might help
You need to add the Network Service user into SQL Server, or use a username and password, if your SQL Server will allow it.|||Actually, I try the Integrated Security and Trusted_Connection both ways, neither of these works. I was thinking the IIS 6.0 security features on Windows server 2003 may block connection to SQL server. While, I will try to add the password to sa and hope get succeed at this time.

Thank you very much.|||Hi Douglas,

It works right now. In my case, Windows server 2003, IIS 6.0, .Net 2003 and SQL 2000server are configuring correctly but one thing I forget (Usually I do, but not this time) that is the ODBC configuration for default user ID. Well, thanks again for your helpful opinion.

Have a nice day.