Post reply

ODBC Connection failure

  • November 14, 2003 at 5:25 am

    #160913

    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

  • November 17, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • November 17, 2003 at 8:15 am

    #482229

    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.

  • November 17, 2003 at 10:24 am

    #482249

    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