Need help : connecting to MSDE with Integrated security

  • Thread starter Thread starter TF
  • Start date Start date
T

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
 
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
 
Back
Top