ODBC Connection failure

  • Getting this error "Can't find SQL Server or

    Access was denied". when attempting to connect.

    The strange thing is that it works from Servers in Domain A to Domain B

    (where the SQl servers are[SQL servers are clustered])

    but doesn't work from servers in that are in Domain C to Domain B.

    Full trust to all Domains listed.

    The test connection works in the ODBS Administrator but getting the error

    when tried via asp scripting.

    Thanks

  • This was removed by the editor as SPAM

  • ASP should be running under the IWAM account by default. How is security setup on the server that is running ASP? How is your SQL server login setup, mixed? You will either need to login to the SQL Server using a SQL login or modify so that the specific server IWAM account has access.

    Joe Johnson

    NETDIO,LLC.


    Joe Johnson
    NETDIO,LLC.

  • Thanks for responding. From the server that has the DSN created.. what should the IWAM account have access to?

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply