[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1062
  • Last Modified:

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

0
mmitchell57
Asked:
mmitchell57
1 Solution
 
exx1976Commented:
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now