Authenticating SQL Users from VB.NET Application.

  • Thread starter Thread starter Manuel Canas
  • Start date Start date
M

Manuel Canas

Hi there,

I'm posting this message again cause my lat message was totally wrong.

What I'm looking for is how do I authenticate SQL users from a VB.NET
application using VB.NET language? I know there is a sp_addlogin stored
procedure in the master database, but do I call it from my application?

Thanks very much,

Manuel.
 
¤ Hi there,
¤
¤ I'm posting this message again cause my lat message was totally wrong.
¤
¤ What I'm looking for is how do I authenticate SQL users from a VB.NET
¤ application using VB.NET language? I know there is a sp_addlogin stored
¤ procedure in the master database, but do I call it from my application?
¤

No, sp_addlogin is used to add a new login for SQL Server authentication.

The following documents the two authentication modes for SQL Server:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp

Connection string examples for each SQL Server authentication method can be found at:

http://www.connectionstrings.com


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top