eqrojas
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
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); } }1.4KViews0likes3Comments