Connection string without username and password, asp.net

Question

I have a website built in asp.net connecting to sql 2000 db. in my web.config file I have a connection string referring to DSN. in order for my db connection to work, I have to specify the username and password in the line. for security reasons, is there any way to connect to my db without displaying the username and password. perhaps a method of encrypting information? the trusted connection string method did not work for me.

current method

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

trusted method (does not work in my server environment)

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Answer 1

web.config.

. MSDN.