Re: Web Server connecting to db server on different machines

http://msdn.microsoft.com/msdnmag/issues/05/09/SecurityBriefs/default.aspx

---------------------------------------
Dominick Baier - DevelopMentor
http://www.leastprivilege.com

Hello

Im creating an asp.net web app that will need to connect to a SQL
Server db on another machine. I have set this up using trusted
connections and impersonation in the web.config file but I am getting
a "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'" message. I
need this to work through domain accounts on both machines.

Currently, it will work if I am using the machine where the web app
resides (ie. http://localhost/webapp/page.aspx) but i get the above
message when using another remote machine.

Any help is appreciated.
Ben


.

Relevant Pages

  • Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... I'm replacing an older computer which is running Widows XP Pro and Sql 2000. ... We are accessing the current sql server via a web app. ... complain when it connects to the database using DSN. ...
    (microsoft.public.sqlserver.setup)
  • Re: where to put SQL Server ?
    ... The general consensus is to place a firewall between the Web server and SQL ... > i have a LAN and a WEB App ... > 1) in the LAN sub-net? ...
    (microsoft.public.windows.server.security)
  • URGENT: ConnectionString for SQLServer db
    ... I developed my ASP.NET 2.0 web app using SQL Express. ... On my web server I attached the SQL Express mdf database to a new SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Migrate content databases - moving from WSS2 to WSS3 on different WEB/SQL Servers
    ... So I'm trying to Migrate from WSS2 to WSS3 on to a new Web and SQL Servers. ... We currently have two independant WSS 2.0 Servers that are both storing Data ... new WSS 3.0 Server with Farm Potential. ... Do I just create a Web App and give it a name for the DB, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Connecting VS.NET 2003 to IIS6/WSS
    ... successful at creating a web app with the source tree on the web server. ... >> I'm posting this question here, rather than in the programming group, ... >> web apps, web parts, etc. wants to find an IIS installation (with Windows ...
    (microsoft.public.sharepoint.windowsservices)