Re: ASP.NET windows authentication

From: SriSamp (ssampath@sct.co.in)
Date: 03/20/03


From: "SriSamp" <ssampath@sct.co.in>
Date: Thu, 20 Mar 2003 11:58:24 +0530


If your ASP.NET application is not doing anything based on the loggod-on
user (like changing the display for each user and so on), you can configure
your virtual folder for the ASP.NET application to use anonymous logon and
then configure an account for the same. This account can be made available
to SQL Server. In case this does not work out for you, try using the
"Application Roles" concept of SQL Server.

SriSamp

"rick" <rickpreddie@yahoo.com> wrote in message
news:041d01c2e7ec$07f378d0$2f01280a@phx.gbl...
> I would like to create a single login account for all of
> our intranet users to be able to browse and query an
> ASP.NET application residing on a SQL Server 2000 that
> uses windows authentication. How would I setup a scenario
> such as this?
>
> Thx!!
>
> Rick



Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Re: Does anyone know how to fix this??
    ... > Inside the Active Directory Users and Computers in the folder of SYSTEM I ... Give the site's SMS Service account full control rights to the ... MP encountered an error when connecting to SQL Server. ...
    (microsoft.public.sms.setup)

Quantcast