Re: connection sql server with asp.net

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: zalizan (anonymous_at_discussions.microsoft.com)
Date: 04/24/04

  • Next message: Paul Ibison: "Re: connection sql server with asp.net" 
    Date: Fri, 23 Apr 2004 20:00:43 -0700

    for your information sir, i'm new with Sql Server, and i
    think i have added IIS anonymous user at SQL in Web
    server. so can you give me a better way to add login to
    user. And how i want to know that if i use anonymous
    access or not

    >-----Original Message-----
    >Zalizan,
    >are you impersonating the user, and / or using anonymous
    access?
    >If you are using impersonation and anonymous, then the
    IIS anonymous user
    >from the new box will need adding as a login to SQL
    Server.
    >If you aren't using impersonation and have anonymous,
    then the
    >IISComputer/ASPNET login will need adding.
    >Alternatively you could use SQL Server logins, especially
    if you are on
    >different domains.
    >HTH,
    >Paul Ibison
    >
    >
    >.
    >

  • Next message: Paul Ibison: "Re: connection sql server with asp.net"

    Relevant Pages

    • Re: connection sql server with asp.net
      ... If you are using impersonation and anonymous, then the IIS anonymous user ... IISComputer/ASPNET login will need adding. ... Alternatively you could use SQL Server logins, ...
      (microsoft.public.sqlserver.connect)
    • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
      ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
      (microsoft.public.sqlserver.connect)
    • Re: cannot acees two databases as owner
      ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
      (microsoft.public.sqlserver.setup)
    • Re: Database security design with ASP.net and form-based authentication
      ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
      (microsoft.public.sqlserver.security)
    • Re: Credentials not being passed with remote access
      ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
      (microsoft.public.sqlserver.security)