Error when attempting a JDBC connection using a Mid Server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
6 hours ago
Hello,
I need to load data into ServiceNow from an internal database. I already have a Mid Server setup that has allowed us to modify accounts in our Active Directory through flows in Flow Designer. I've successfully been able to telnet to this database from the Mid Server, however I can't make a connection from the Data Source Record in ServiceNow.
I have an account that I'm able to authenticate and view the database when using SQL Server Management Studio. I have this same accounts credentials stored on the data source record. I believe I uploaded the correct JAR file to the Mid server. If I try to test load records with this configuration, I receive an error stating "Encryption Key must be specified". Is this a problem with the database i'm trying to access? I haven't seen any documentation that describes this issue i'm seeing. Any tips would be much appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
5 hours ago
- This dba.stackexchange.com post suggests clicking the options button on your connection window above and adding TrustServerCertificate=True under Additional Connection Parameters. This is basically telling SSMS that yes, you know, just do it.
- If that doesn't work, this dba.stackexchange.com post suggests using runas in order to trick Windows. For example, runas /netonly /user:domain\username "C:\path_to\ssms.exe" I've never done this with SSMS but it's worth a try
