• State Verified Answer
  • Replies replies
    3
  • Subscribers subscribers
    17
  • Views views
    380
  • Users 0 members are here

Issues setting up application source with sql server.

Chase Hedelius

while trying to setup my sql server application i ran into the error:

Unable to connect to your server: DaaS connector returned error (486): Target connection failure: SQLException Errorjava.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

after reading a bit more from other people, the recommendation was to change the logging level of daas, so that we could get more info. I modified the xml file in tomcat/conf for daas logging and set it to debug. Then I restarted tomcat. no change occurred. I then read further and the other recommendation was to change it in UI. I changed it, no change occurred.

I've confirmed that this is not a firewall issue because I was able to connect to the server via command line. Also it should be noted that I have an old server running IG that does have the connection setup. However it is so outdated i cant import the application source. 

  • Verified Answer

    +1  

    Hello,

    1) I gather by your write-up, that you are not utilizing MS SQL as the database for which Identity Governance is installed with.  What database are you using?

    2) Did you add the MS SQL Type 4 JDBC Driver jar to the tomcat/lib directory and restart tomcat as outlined in the documentation?

    3) What account owns the MS SQL Type 4 JDBC Driver jar in the tomcat/lib directory?


    Sincerely,
    Steven Williams
    Principal Enterprise Architect
    OpenText Cybersecurity

  • 0 in reply to   

    Yeah that was the issue just was missing the driver. I had skipped that portion of the documentation when installing because we were going to use postgres and figured it wouldnt matter. 

  • 0   in reply to 

    Just a heads up, MS SQL Server support will be deprecated in future versions per the release notes of 4.2.   It should work great for now, and will support a POC of course, but if you are planning for long term, you may want to avoid a migration in the future.

    --Jim

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.