ASP.NET and Windows Authentication for SQL Connection

[GornHorse]

Hi There,

 

This is really starting to give me to squirts. :eek:

 

I have two (2) programs, "REMS Windows App" (A windows application in VB.net), and "REMS Intranet Service" (An ASP.NET program in VB.net).

 

Both of these programs use the same class (clsBOTHERSConnection) to connect to a database on a server using Windows Authentication.

 

The windows authentication works perfectly for the windows application.

 

However, the windows authentication does not work for my ASP.NET program. Why on earth not?? I have set the IIS security settings for the ASP.NET program to be 'windows authentication' through the Internet Service Manager, so it shouldn't be that.

 

The connectionstring is within the clsBOTHERSConnection, and not in the applicationsettings section of the application.config or web.config files, as there is no need for this, because the connectionstring is within a referenced class.

 

What do i need to do to get my ASP.NET application to accept the windows authentication logins as well??

 

This is clsBothers:

Imports System.Data.SqlClient

 

Namespace Class_clsBOTHERSConnection

 

Public Class clsBOTHERSConnection

Public WithEvents BOTHERSConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection()

Sub BOTHERS_Connect()

BOTHERSConnection.ConnectionString = "data source=Universe;initial catalog=RecFindMerger;integrated security=SSPI"

 

Try

BOTHERSConnection.Open()

Catch ex As SqlClient.SqlException

Dim exstr As String

exstr = ex.Message

Finally

End Try

End Sub

 

Sub BOTHERS_Close()

BOTHERSConnection.Close()

End Sub

 

End Class

 

End Namespace

 

Please reply as soon as possible.

 

 

Regards,

Michelle

Edited August 4, 2003 by GornHorse

[Derek Stone]

Place the following in your Web application's configuration file (web.config):

<identity impersonate="true" />

[GornHorse]

Thanks!! That's excellent!!