Need help : connecting to MSDE with Integrated security

[TF]

hello,
I use the MSDE 2000, I can't connect only with the SQL security;
I hope connect with Windows security, How can I do it ?

Thanks

 

[Douglas J. Steele]

The connection strings for MSDE are the same as for SQL Server. Check what
Carl Prothman has at http://www.able-consulting.com/ado_conn.htm

 

[TF]

The problem comes from the MSDE :
With the SqlDemo object I try two connections type :

With NT AUTHENTIFICATION :
SQLServer.LoginSecure = True
SQLServer.Connect "Srv01"
Connection Error like : Srv01\guest user connection failed

But with SQL Server security :
SQLServer.LoginSecure = False
SQLServer.Connect "Srv01", "sa", ""
The Connection is OK

The LoginMode subkeyin the Registry = 2