Sql Server Autentication

  • Thread starter Thread starter Marco Roberto
  • Start date Start date
M

Marco Roberto

Hi everyone,

is there any way to conect to SQL Server by using Windows Autentication,
but providing the
user and password? I mean, the user need to type the same windows user login
and password.
How could I write the connection string?

Regards,

Marco
 
Windows Authentication will generate the Security Context
automatically.

WA is all based on a Trust, which means it trusts you are
who you claim to be by virtue of your login.

If you want to use Username and Password then use Mixed
Mode Authentication.

Good Luck,

Bill
 
Marco,
There are different ways you can state the connection string. The strings
below are taken from the website;
http://www.connectionstrings.com

cheers!
Steve

Standard Security:
"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
- or -
"Server=Aron1;Database=pubs;User
ID=sa;Password=asdasd;Trusted_Connection=False"
(booth connection strings produces the same result)



a.. Trusted Connection:
"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
- or -
"Server=Aron1;Database=pubs;Trusted_Connection=True;"
(booth connection strings produces the same result)

(use serverName\instanceName as Data Source to use an specifik SQLServer
instance, only SQLServer2000)
a.. Connect via an IP address:
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial
Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is
the port to use (1433 is the default))
a.. Declare the SqlConnection:

C#:
using System.Data.SqlClient;
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="my connectionstring";
oSQLConn.Open();

VB.NET:
Imports System.Data.SqlClient
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString="my connectionstring"
oSQLConn.Open()
--------------------------------------------------------cut
here------------------------------------------------------------------------
-----------------------------------
Hi everyone,

is there any way to conect to SQL Server by using Windows Autentication,
but providing the
user and password? I mean, the user need to type the same windows user login
and password.
How could I write the connection string?

Regards,

Marco
 
Back
Top