Connect to SQL Server 2000 using Windows Authentication

[AppSpecialist]

Does anyone have a piece of VB Script that demonstrates how to connect to SQL Server using VBScript and Windows authentication.

Also does anything specific need to be configured on SQL Server to allow this to work... other than adding the login.

Thanks

 

[AshleyRickards]

I need this too! ;-) Ashley L Rickards
SQL DBA

 

[tlbroadbent]

Just make sure you add the NT login(s) you'll be using. Add the Logins as users in the appropriate databases and Grant needed permissions. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[AshleyRickards]

Right. I know how to connect useing SQL auth. as seen below. But Windows?


Set cnn = New ADODB.Connection
cnn.ConnectionString = "driver={SQL Server};" & "server=MSSQL_F1;uid=user1;pwd=password;database=database1"
cnn.ConnectionTimeout = 30
cnn.Open Ashley L Rickards
SQL DBA

 

[AppSpecialist]

I answered it myself... but for Ashley's help try this...

Set Conn = CreateObject("ADODB.Connection&quot
Conn.ConnectionString = "Trusted_Connection=yes;Provider=SQLOLEDB.1;Intergrated Security=SSPI;Persist Security Info=TRUE;Initial Catalog=tempdb;Data Source=abcd"
Conn.open

 

[AshleyRickards]

Thanks. Would that string work for NT? Ashley L Rickards
SQL DBA