Re: ASP.Net en SQL2000 authorisation
From: Cowboy \(Gregory A. Beamer\) (N0SpamMPleezEgbworld@comcast.netN0SpamMPleezE)
Date: 10/28/02
- Next message: Cowboy \(Gregory A. Beamer\): "Re: password protect subdirectory and files within"
- Previous message: Cowboy \(Gregory A. Beamer\): "Re: logout"
- In reply to: Edward: "ASP.Net en SQL2000 authorisation"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Cowboy \(Gregory A. Beamer\)" <N0SpamMPleezEgbworld@comcast.netN0SpamMPleezE> Date: Mon, 28 Oct 2002 12:45:00 -0600
You have a couple of choices.
1. Give the ASPNET account on the web server access to the SQL Server. This
can be tricky if they are on two machines as you have to take control.
2. Get rid of anonymous access on this website and only allow users who can
be mapped to SQL Server the ability to hit it.
3. Create a data access object with the proper account to hit the database.
This is probably the best option, but requires a bit different architecture
(n-tier).
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA Author: ADO.NET and XML: ASP.NET on the Edge **************************************************************************** **** Think outside the box! **************************************************************************** **** "Edward" <e.tollenaar@otsgroup.nl> wrote in message news:9c2001c27e8b$1c5a9e90$39ef2ecf@TKMSFTNGXA08... > Our sql2000-server (say the name is mySRV) is using > windows authentication. I've put mine asp.net application > on a server called myTest. In ISM I've > unchecked "anonymous access". Mine web.config file has the > following statements: > <authentication mode="Windows"/> > <identity impersonate="true" /> > > and defines a sql-connectionstring as: > <add key="myConnectionString" value="data > source=mySRV;initial catalog=myDB;integrated > security=SSPI;persist security info=False"/> > > When I start IE on the server and goes to my page > (//localhost/myWeb/Customer?id=1), everything is working > fine. Data is retrieved from SQL-server. > > When I'm using IE on my own pc and uses the > url //myTest/myWeb/Customer?id=1 I get the following error > message: > System.Data.SqlClient.SqlException: Login failed for > user 'NT AUTHORITY\ANONYMOUS LOGON'. > > Mine applition is used in a intranet and the users are > authorized for the server. > > What must I do or configure to run the application from my > own pc? > > Thanks in advance. > Edward
- Next message: Cowboy \(Gregory A. Beamer\): "Re: password protect subdirectory and files within"
- Previous message: Cowboy \(Gregory A. Beamer\): "Re: logout"
- In reply to: Edward: "ASP.Net en SQL2000 authorisation"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
