eqrojas
6 years agoNew Contributor
Database connection to MS SQL Server 2008 R2
Hi, I am trying to connect to SQL using my local maching through scripting. However, I always get "Server does not exist or access denied" error upon executing the script (please see below). I hope you can help me with this. Thank you.
I have already try setting the Persistent Security to TRUE, Setting the Data Source through instance name but still encountered the error.
--------
function MSSQLConnectTest()
{
var TestObj = ADO.CreateADOQuery();
TestObj.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=xxx;Password=xxx;Initial Catalog=xxx;Data Source=xxx";
try
{
TestObj.Open();
Log.Message("Success!!");
}
catch(e)
{
Log.Message(e.message);
}
}