Windows-only authentication not working

[sid]

I am trying to connect to SQL serevr using 'Windows only
Authentication'. Below is my code.
Dim strConn As String = _
"data source=localhost; " & _
"initial catalog=northwind; " & _
"integrated security=true;"
Dim conn As New SqlConnection(strConn)


Where as If I change the code to use 'Mixedmode
authentication', it is working.
Dim strConn As String = _
"data source=localhost; " & _
"initial catalog=northwind; " & _
"user id=sa;password=;"
Dim conn As New SqlConnection(strConn)
This one is working.


Do I need to change any further options in SQL server to
work in windows-only authentication?

Please help!

Thanks!

 

[Jared]

Sid,
I think it should be Integrated Security=SSPI not True
Jared

www.connectionstrings.com has the following examples for SQL Server -
SqlConnection (.NET)

Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;
- or -
Server=Aron1;Database=pubs;Trusted_Connection=True;

 

[Jos]

I am trying to connect to SQL serevr using 'Windows only
Authentication'. Below is my code.
Dim strConn As String = _
"data source=localhost; " & _
"initial catalog=northwind; " & _
"integrated security=true;"
Dim conn As New SqlConnection(strConn)


Where as If I change the code to use 'Mixedmode
authentication', it is working.
Dim strConn As String = _
"data source=localhost; " & _
"initial catalog=northwind; " & _
"user id=sa;password=;"
Dim conn As New SqlConnection(strConn)
This one is working.


Do I need to change any further options in SQL server to
work in windows-only authentication?

Either you need to set Impersonation=True, or
you need SQL Server to allow access to the ASPNET user account.

 

[sid]

Thanks for the reply and link Jared.
I tried with all the options in the connectionstrings.com
site. I replaced 'true' with 'SSPI'. Still I am getting
the same login error.

Thanks!

 

[Raterus]

Could be 1001 different things depending on your setup/needs

Are you trying to access the sql server using the credentials of the authenticated client?
Sql Server on a computer other than your webserver?

 

[Nick]

This works for me:
Dim strConn As String = "server=" & Global.ServerName & ";database=" &
Global.DatabaseName & ";integrated security=true"


Nick

Could be 1001 different things depending on your setup/needs

Are you trying to access the sql server using the credentials of the
authenticated client?
Sql Server on a computer other than your webserver?