Hello, i'm trying to connect to a SQL server with VBScripting. I am using the below noted code to open the connection. Problem is, I keep getting "Login Failed for user "test". Reason:Not associated with a trusted sql server connection"
The server authentication is set to windows only. I cannot change it due to the environment it's in. I've created a test account and put it in 2 group. The admin group and application group. Neither has helped. I am open for suggestions on what to do. I need to get this going so I can run some procedures. :) Thank you in advance.
set conn = CreateObject("ADODB.Connection")
conn.ConnectionString = "Provider=SQLOLEDB;" & _
"Initial Catalog=DBName;" & _
"Server=ServerName;" & _