remote database connection issue is it possible to connect ASP website which is on web server to connect to SQL server 2008 database which is on another database machine? In my case the database machine has windows XP SP1 installed on it, so it is just like desktop machine on the network. Both machines are on the same domain.
If possible how can we setup the connection? What security settings are required on database side? what network settings are required? What code can we use on ASP file?
Is there any test that we can perform with the simple connection string code?

I had used this code 

Provider=SQLOLEDB.1;Data Source=myDbServer;Initial Catalog=myDatabase;Uid=myUsername; Pwd=myPassword;
I got this code from the .udl file where test connection works but it does not work when I put it on dataconn.inc file. Why? 
I have tried various connection strings but it does not work. I am confuse.

How can I debug the datconn.inc file? it is just the text file. Can I use any other asp file rather than using dataconn.inc? I am conecting to database to check my login credentials and then log into this website and I am getting http 500 error.
The simplest way to do this is give IUSR_[computer name] (where that is your web server machine) read/write access to the relevant database (use the datereader and datawriter builtin roles, DON'T use dbo).  

If you are using stored procedures, you will need to grant execute permissions to  IUSR_[computer name] as well.

In addition, eet you connection string to use a Trusted connection: 

"Data Source=myServer;Initial Catalog=myDataBase;Integrated Security=SSPI;"