Re: IIS and SQL server 7

From: Uttam Parui[MS] (uttamkp@online.microsoft.com)
Date: 10/26/02 

From: uttamkp@online.microsoft.com (Uttam Parui[MS])
Date: Sat, 26 Oct 2002 13:38:35 GMT

JJ,

Review the foll. Microsoft Knowledge base articles. They may be helpful.

INFO: Accessing SQL Server with Integrated Security from ASP
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q176377

INF: Authentication Methods for Connections to SQL Server in Active Server
Pages
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q247931

HOWTO: IIS and SQL Server on Separate Machines with Trusted Connection
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q176379

HOWTO: SQL Server with Integrated Security, IIS on Same Machine
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q176378

Hope this helps.

Regards,

Uttam Kumar Parui
SQL Server Support Engineer, MCDBA, MCSE, MCT
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Relevant Pages

  • Please explain loss of token between web server box and sql box
    ... relating to Integrated Security with Asp.Net IIS 5 and Sql Server 2k. ... The problem arises when endeavouring to use Integrated Security at all ... grant the group Sql Server access and rights to the relevant database. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Connecting to a sql server database
    ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ... sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ...
    (microsoft.public.dotnet.general)
  • Re: Active Directory and SQL Server Connection
    ... when you say that you intend to use integrated security, ... creating a WindowsIdentity and calling Impersonate on that. ... > Thanks Sahil, ... so they have access to the sql server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Please explain loss of token between web server box and sql box
    ... The client user principal is a W2K AD domain member, the users accounts must be set up as "delegatable" in the AD. ... The IIS server's "machine account" is trusted for delegation in the AD. ... The SQL server SPN must be registered in the AD, or must run under "localsystem" identity. ... > relating to Integrated Security with Asp.Net IIS 5 and Sql Server 2k. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Call a stored proc. from a Smart Device.
    ... If you want to use Integrated Security you must explicitly set User ID ... also you may try use SQL Server Authentication: ... > Thanks for advising me on right clicking and adding the reference. ... > I'm pretty sure the connection is good, I wrote a Window Form app and cut ...
    (microsoft.public.dotnet.framework.compactframework)