SQL Connection string in VBscript

I am trying to create a SQL 2008 connection from VBscript using Windows Authentication and I am getting the error "login failed" for the below string. Any sort of help is much appreciated.

strConnection = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=username;Password=ntpassword;Initial Catalog=dbname;Data Source=servername;Integrated Security=SSPI"

0 answers