SQLServer Validate Login

[nievesj]

Originally posted by szlamany
Domain accounts do not use the same connection strings as SQL Authentication accounts. Something more like this...

sConStr = "Provider=SQLOLEDB.1;" & _
              "Integrated Security=SSPI;" & _
              "Server=YourSQLServer;" & _
              "Initial Catalog=YourDBName;"

BTW - Mixing authentication types - why?? MS recommends Win2K authentication - not SQL authentication. Why have you made your choice??

But there's no username and pass for that connection string?, it authenticates with the logged account?, thats not what I want.

BTW - Mixing authentication types - why?? MS recommends Win2K authentication - not SQL authentication. Why have you made your choice??

Dont know, this is the first time I wirk with SQL Server.