VBScript, SQL, Authentication

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.

SQL2000
VBScripting
set conn = CreateObject("ADODB.Connection")
 
    conn.ConnectionString = "Provider=SQLOLEDB;" & _
	"Initial Catalog=DBName;" & _
	"Server=ServerName;" & _
	"UID=test;PWD=test;"
 
conn.Open

Open in new window

mmitchell57Asked:
Who is Participating?
 
exx1976Connect With a Mentor Commented:
All of my scripts use SQL authentication, so I don't know the answer off the top of my head, but take a look here.  It also depends on the version of SQL..

http://www.connectionstrings.com/


HTH,
exx
0
 
mmitchell57Author Commented:
Thank you for the link it's working quite well now. :)  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.