Using Integrated Security for Accessing SQL on Remote Server

From: eRic (anonymous_at_discussions.microsoft.com)
Date: 02/29/04 

Date: Sat, 28 Feb 2004 16:31:05 -0800

Hello,

I am currently trying to use integrated security to access the SQL database for the ASP.NET application (deployed on an intranet).

I am following this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskaccessingsqlserverwithexplicitcredentials.asp

So far I have
1. Set the Web.config file to impersonate a specific domain user
 <identity impersonate="true" userName = "myDomain\myUserName" password="password"/>
2. Created the login in the SQL server and given it appropriate permissions
3. Used Integrated Security = SSPI in the connection string
4. IIS does not allow anonymous access on the site and is using Windows Integrated Security

So far it's a no go.

I've also gone as far as to set the same user (that maps to the SQL login) as the user for the processModel and still nothing.
(do you need to reboot the box before changes in machine.config take place?)

I read a previous thread that said you need to enable Kerberos delegation for any identity to be passed acrossed machines. Is that the case? If so I really don't understand how the article that I mentioned above could work.

Thanks
 - e

Relevant Pages

  • using Integrated Security SSPI with User ID
    ... I'm trying to use integrated security with a User Id and password to ... The SQL Server administrators insist that I ... use the intergrated security option in the connection string, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Login failed for user (null). Reason: Not associated with a trusted SQL Server connection from A
    ... Originally the app was set up to use sql security and not windows ... the IUSR account be able to access the SQL server if that user was created ... > sql server using integrated security. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: IIS not passing logon info consistently
    ... clients accessing the site are automatically logged into sql using ... > browser onto SQL server, ... You will have problems using Integrated Security with SQL on a different ... http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS ...
    (microsoft.public.inetserver.iis.security)
  • IIS not passing logon info consistently
    ... An asp application is configured to use integrated security ... clients accessing the site are automatically logged into sql using ... I have checked the advanced settings in IE, ... browser onto SQL server, ...
    (microsoft.public.inetserver.iis.security)
  • Re: Builtin Administrators Group and SQL Agent Jobs
    ... has the service acct which sqlagent and sqlserver run been given the ... > All jobs are owned by SA and the problem remains. ... >>> On my SQL 2k Server I added a SQL Login for a Domain> group ...
    (microsoft.public.sqlserver.security)