Discussion Locked

VB6 to SQL Server Connection ( Windows Authentication mode)

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to connect to SQLServer2000 from VB6 ,my SQLServer is using Windows Authentication mode , can any body tell me how to establish a connection

1 reply

by tony hopkinson

user and password in.

Put "Persist Security Info=False; Integrated Security = SSPI"
aLong with the usual "Data Source=MyServer; Initial Catalog=MyDatabase"

Course the account that is running the program has to have access to the data base.

You dio that from Enterprise Manaager by adding a Logon and mapping it to a database user in each database that the program requires access to.

This discussion is closed to new replies.