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 ;

"sid" <an*******@discussions.microsoft.com> wrote in message
news:41****************************@phx.gbl...

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!

[Jos]

sid wrote:

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.

--

Jos

[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!

-----Original Message-----
Sid,
I think it should be Integrated Security=SSPI not TrueJared

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=Tru e;

"sid" <an*******@discussions.microsoft.com> wrote in messagenews:41****************************@phx.gbl...

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!

.

[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?

"sid" <an*******@discussions.microsoft.com> wrote in message news:41****************************@phx.gbl...

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!

[Nick]

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

"Raterus" <ra*****@spam.org> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
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?

"sid" <an*******@discussions.microsoft.com> wrote in message
news:41****************************@phx.gbl...

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!