ASP.NET Windows Authentication Problems

From: Phil Pragnell, IT Developer (philip.pragnell@electricity.gg)
Date: 10/08/02 

From: philip.pragnell@electricity.gg (Phil Pragnell, IT Developer)
Date: 8 Oct 2002 08:51:41 -0700

I wish to access a SQL Server database using Windows Authentication
from an ASP.NET application. I have the following settings in my
web.config file:

<authentication mode="Windows"></authentication>
<identity impersonate="false"></identity>

In an attempt to understand the problem I've used the following code
on the WebForm:

Dim wp As New System.Security.Principal.WindowsPrincipal(System.Security.Principal.WindowsIdentity.GetCurrent())
Dim username As String = wp.Identity.Name
Response.Write("wp identity is " & username)
Response.Write("<BR>User Identity is " & User.Identity.Name.ToString)

This code outputs the following on the page:

wp identity is myserver\ASPNET
User Identity is mydomain\myaccountname

In IIS on the development server I only have Integrated Windows
Authentication. Anonymous access it not set.

HOWEVER when I attempt to access the SQL database I get the following
error:

"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection."

I've had a look on Google Groups. A lot of people seem to
experiencing similar problems, but I've yet to find any solutions.

Any help would be greatly appreciated.

Thanks,

Relevant Pages

  • Re: ASP.NET Windows Authentication Problems
    ... I wish to access a SQL Server database using Windows Authentication ... User Identity is mydomain\myaccountname ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SQL server question
    ... Microsoft is deprecating it even for new development, ... An Access project is an Access file that provides a direct, ... You can connect an Access project to a remote SQL Server ... a local SQL Server database, or a local installation of the SQL Server ...
    (comp.databases.ms-access)
  • Exactly How to Use Disconnected Recordsets in VB / SQL Server Application
    ... Front-end is VB 6.0, back-end is SQL Server 2000 (actually, MSDE since ... underlying SQL Server database w/the assumption that the user *might* ... the local disconnected recordset on the user's machine would seem to ... time to update each and every record as each user scrolls through the ...
    (microsoft.public.vb.database)
  • Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
    ... if the way synchronization needs to be handled changes in the ... > data stored in an SQL Server database. ... > GetChanges() call, but I feel that this workaround is not my best choice. ...
    (microsoft.public.dotnet.framework.adonet)
  • VBA Microsoft Access and SQL Server
    ... I am currently working on a project with Power Point. ... into a Microsoft SQL Server database. ... information from the Microsoft SQL Server database and re-populate a Power ...
    (microsoft.public.office.developer.vba)
Quantcast