ASP.Net en SQL2000 authorisation

From: Edward (e.tollenaar@otsgroup.nl)
Date: 10/28/02 

From: "Edward" <e.tollenaar@otsgroup.nl>
Date: Mon, 28 Oct 2002 06:05:46 -0800

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

Relevant Pages

  • Transactional Bi-Directional Replication failing.
    ... Replication as per: http://support.microsoft.com/kb/820675, and I ... Publisher Server A - Subscriber Server B ... update "mytest" set ...
    (microsoft.public.sqlserver.replication)
  • Re: Update cube statement
    ... If Anonymous access is turned on, then that is probably what it is using. ... > I thought using ConnectTo is a good practice and took it from the AdoMd ... >>> and IIS server is the same server in a DMZ. ... >>> error information transformed through a xslt to generate html. ...
    (microsoft.public.data.xmlanalysis)
  • Re: Fax Alerts
    ... Server" and choose Properties. ... Click the Authentication button. ... Anonymous access ... Granted SBS Server External IP Address ...
    (microsoft.public.windows.server.sbs)
  • Re: Accessing a web application anonymously
    ... If you need to configure anonymous access, first make sure that IUSR account ... If your IIS server is member of domain then you will need the following ... to the SQL server, the application server for ASP pages etc.. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Logon Prompts for any user
    ... I doubt if there is anything you can do on the server to "make this work". ... you could make the WSS server anonymous access so it wouldn't need to ... > = Automatic Logon with current name and password) and this fixed the ... >>> Main site requires no login, and allows anonymous access. ...
    (microsoft.public.sharepoint.windowsservices)