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.