ISA 2004 Logging to SQL not asking for ODBC

Posted on 2006-06-06
Last Modified: 2010-04-09
I'm trying to set up my ISA 2004 Enterprise server to log to my SQL 2000 server. When I click on SQL then options (In ISA) It asks for server, database and table, then log in info. No matter what I put for log in info I get an error that the database in unavailable or access is denied. What am I missing. All the walkthroughs say to enter ODBC information but it's not even asking for that. I tried getting extreme and using my sa account, but still no luck. I know the server is working becaue I run everything else off of it. Any ideas? The tables are all set up and everything..
Question by:t1clausen
    LVL 51

    Accepted Solution

    LVL 2

    Author Comment

    Yeah and this line "Type the DSN in the ODBC data source (DSN) box." Doesn't show up on my version of ISA It asks for Server Name, port, database, table. Then login info. Nothing I enter in here seems to work. Is there something I need to do on the ISA box to open it up? I know the SQL box works and allows remote connections because I'm doing that with other programs.
    LVL 2

    Author Comment

    All I need to do was restart the ISA server, then I had to uncheck the force encryption check box. Then blank out the log in info and use windows authentication.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Title # Comments Views Activity
    Cisco ASA 5505 NAT question 8 66
    SRX http test cookie 7 93
    iptables nat port range centos 6.x 21 71
    Firewall vs WYSIWYG editor 5 72
    Do you have a windows based Checkpoint SmartCenter for centralized Checkpoint management?  Have you ever backed up the firewall policy residing on the SmartCenter?  If you have then you know the hassles of connecting to the server, doing an upgrade_…
    This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now