System.Data error '80131904'

From: zeplynne (motleycrue_at_comcast.net)
Date: 11/14/05

  • Next message: Dan Guzman: "Re: ACL enforcement via SP or trigger" 
    Date: Mon, 14 Nov 2005 17:41:12 -0500

    Have a .net assembly, strong named, on an IIS box running Win 2000 Advanced
    Server (box is in DMZ). Web site connects to a Sql Server box (not in DMZ).
    The legacy asp app has no problem connecting to Sql Server, but when the dll
    is invoked in the asp app, and it attempts to connect to Sql Server, a
    System.Data error occurs. I have setup other similar environments in a
    different network, and I have no problems.
    Error:
    System.Data error '80131904'
    SQL Server does not exist or access denied.

    Haven't been able to find much on this error code. Any help or direction
    would be greatly appreciated.

  • Next message: Dan Guzman: "Re: ACL enforcement via SP or trigger"

    Relevant Pages

    • Re: Security in DMZ
      ... set up a DMZ zone. ... this windows account can be used directly as an anonymous user under IIS7 to ... communicate with the sql server). ... When get paid, I laugh all ...
      (microsoft.public.sqlserver.security)
    • Re: Integrated Security in the DMZ
      ... I created a local account on the DMZ ... where the SQL Server box is running. ... You would setup the same LOCAL user acct on the DMZ box as well. ...
      (microsoft.public.sqlserver.security)
    • Re: SQL2000 based website: DMZ or LAN placement
      ... It will be IIS on one box (in the ... DMZ) and SQL2000 on the other. ... be to put the SQL server in the DMZ, and allow no direct access to it ... since it is fully exposed to the compromised web server. ...
      (comp.security.firewalls)
    • Re: Merge replication security
      ... I know port 1433 needs to be open for OUTBOUND traffic, ... By having a separate SQL server in the DMZ I can use Windows ... > connect to your SQL Server which is on your internal network. ...
      (microsoft.public.sqlserver.replication)
    • System.Data error 80131904
      ... The legacy asp app has no problem connecting to Sql Server, but when the dll ...
      (microsoft.public.sqlserver.connect)