# SQL Loader Connector Error - HTTPS on Windows Server **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** identity-security-cloud\ **Created:** [June 24, 2024, 10:07pm UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369 "2024-06-24T22:07:30Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![SauravSaraffLSEG](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@SauravSaraffLSEG](https://developer.sailpoint.com/discuss/u/SauravSaraffLSEG)\ **Post date:** [June 24, 2024, 10:07pm UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/1 "2024-06-24T22:07:30Z")
Hello, I am trying to fetch data from remote windows server using SQL Loader Connector. Server Name: sv-12345.devsrv.rem.local File Location: D:\Path1\test.csv In SQL Loader Connector, details added are: Datafile URL: jdbc:csv:[https://sv-12345.devsrv.rem.com/Path1](https://sv-12345.devsrv.rem.com/Path1) Test Connection SQL Query: SELECT first(‘EmpId’) FROM Test IIS was not configured in the server, hence I configured the IIS on the server and opened the https on port 9443. Also, I installed the server certificate on IIS. However, when I try to do a test connection, I get the error: We have detected an error from the managed system. Error Received: [ConnectionFailedException] [Possible suggestions] Verify that Connection User and Password are correct. [Error details] Error occurred while establishing the connection with Data File during test configuration operation. Failed to load table Test: java.io.IOException: https://\*:\*@vsv-12345.devsrv.rem.com/Test.csv I have tried combinations for URL including replacing the server with IP address, but still get the same error: Can someone please help here? ---
**Author:** ![Abhinov7](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/abhinov7/32/13253_2.png) [@Abhinov7](https://developer.sailpoint.com/discuss/u/Abhinov7)\ **Post date:** [June 25, 2024, 2:02am UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/2 "2024-06-25T02:02:36Z")
Hi, couple of points here. 1. Where is the VA located? Can you check if VA can access the local server? 2. Can you access the file directly from the web browser with URL? 3. Ensure the path is added correctly. -Abhinov ---
**Author:** ![ashutosh08](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/ashutosh08/32/11459_2.png) [@ashutosh08](https://developer.sailpoint.com/discuss/u/ashutosh08)\ **Post date:** [June 25, 2024, 4:21am UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/3 "2024-06-25T04:21:12Z")
Hi @SauravSaraffLSEG, Hope you went through below link. If still things do not workout, then please try increasing the logging level and share the same. > **[Supported Features](https://documentation.sailpoint.com/connectors/sql_loader/help/integrating_sql_loader/supported_features.html)** > > SailPoint Connectors Documentation Thanks ---
**Author:** ![agutschow](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/agutschow/32/8543_2.png) [@agutschow](https://developer.sailpoint.com/discuss/u/agutschow)\ **Post date:** [June 25, 2024, 11:29am UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/4 "2024-06-25T11:29:53Z")
> [@SauravSaraffLSEG](#): > > from remote windows server using SQL Loader Connector. > > Server Name: sv-12345.devsrv.rem.local > File Location: D:\Path1\test.csv > > In SQL Loader Connector, details added are > Datafile URL: jdbc:csv:[https://sv-12345.devsrv.rem.com/Path1](https://sv-12345.devsrv.rem.com/Path1) > Test Connection SQL Query: SELECT first(‘EmpId’) FROM Test For this URL to work, you would have to have D:\ set as the wwwroot folder for your IIS server. Normally, the folder is something like C:\inetpub. Try moving your file test.csv to that folder. Alicia ---
**Author:** ![SauravSaraffLSEG](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@SauravSaraffLSEG](https://developer.sailpoint.com/discuss/u/SauravSaraffLSEG)\ **Post date:** [June 25, 2024, 12:19pm UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/6 "2024-06-25T12:19:07Z")
Hi Alicia, I read your response to another question on SQL Loader connecter, moved the test.csv file to the location C:\inetpub, continue to get the same error. I am not familiar with IIS configurations required to access the file, do you have any thoughts on weather this looks correct: ![image](https://global.discourse-cdn.com/sailpoint/original/2X/b/b73fffdda7ed87889f67160673e264b11986e411.png) ---
**Author:** ![agutschow](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/agutschow/32/8543_2.png) [@agutschow](https://developer.sailpoint.com/discuss/u/agutschow)\ **Post date:** [June 25, 2024, 3:13pm UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/7 "2024-06-25T15:13:35Z")
From your screenshot, as long as the folder D:\Path1 matches the configuration of your IIS sqlloadfiles path that you crossed out. If your test.csv is in the D:\Path1 folder, then your URL in the SQLLoader configuration would be [https://sv-12345.devsrv.rem.com/](https://sv-12345.devsrv.rem.com/) I do notice is that your urls are different. For the server name, you say: sv-12345.devsrv.rem.local But for the sql loader url, you say: sv-12345.devsrv.rem.local Two things to try: 1. Go to the VA, use the command nslookup to verify which of these values will translate to an IP address. ```auto nslookup sv-12345.devsrv.rem.local ``` 1. Use the curl command from the VA to make sure that you can access the file ```auto curl https://sv-12345.devsrv.rem.local/ ``` The other thing I noticed from your screenshot on IIS is that your Default IIS configuration is showing that you are running on port 9443. Are you running on 9443 for your sqloadfiles as well? If so, you would need to add it to the url like [https://sv-12345.devsrv.rem.local:9443/](https://sv-12345.devsrv.rem.local:9443/) Let us know how your testing goes. Alicia ---
**Author:** ![SauravSaraffLSEG](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@SauravSaraffLSEG](https://developer.sailpoint.com/discuss/u/SauravSaraffLSEG)\ **Post date:** [June 27, 2024, 10:35am UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/8 "2024-06-27T10:35:00Z")
Hello Alicia, URL in SQLLoader Configuration: [https://sv-12345.devsrv.rem.com/](https://sv-12345.devsrv.rem.com/) Path in IIS: D:\Path1 File Location: D:\Path1\test.csv 1. I have tested nslookup from my VA and it works fine. I am able to run “nslookup sv-12345.devsrv.rem.local” and retrieve the IP address of server 2. curl [https://sv-12345.devsrv.rem.local/](https://sv-12345.devsrv.rem.local/) =\> This gives error “curl: (56) CONNECT tunnel failed, response 504”. 3. curl sv-12345.devsrv.rem.local --output ss.csv =\> Upon reading the ss.csv file, I see the below text: “ **Description: Unable to locate the server named “_sv-12345.devsrv.rem.local_” — the server does not have a DNS entry. Perhaps there is a misspelling in the server name, or the server no longer exists. Double-check the name and try again** ” I am able to see the files mapped via IIS in local browser and download it. However, the error remains same during test connection, below is what I see in VA logs. ![image](https://global.discourse-cdn.com/sailpoint/original/2X/a/a98fc53062f2888eae12aff46065ee7209937045.jpeg) ---
**Author:** ![SauravSaraffLSEG](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@SauravSaraffLSEG](https://developer.sailpoint.com/discuss/u/SauravSaraffLSEG)\ **Post date:** [June 27, 2024, 1:06pm UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/9 "2024-06-27T13:06:48Z")
Hello @agutschow, Thanks for the pointer, the issue with CURL command has been resolved. However I still face issue with connectivity and error is still same in IDN. Anything else that might be blocking? ---
**Author:** ![KiranSeehra](https://avatars.discourse-cdn.com/v4/letter/k/73ab20/32.png) [@KiranSeehra](https://developer.sailpoint.com/discuss/u/KiranSeehra)\ **Post date:** [June 27, 2024, 3:52pm UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/10 "2024-06-27T15:52:12Z")
Have you tried ensuring the VA is up to date? From the VA logs it looks like it’s either a credential error or an invalid CCG version ---
**Author:** ![SauravSaraffLSEG](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@SauravSaraffLSEG](https://developer.sailpoint.com/discuss/u/SauravSaraffLSEG)\ **Post date:** [June 28, 2024, 2:29pm UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/11 "2024-06-28T14:29:51Z")
Hi Kiran, As VA is managed and maintained by Sailpoint, and as VA has always been connected, I assume it is updated. Is there something specifically suspicious that hints at invalid CCG Version? ---
**Author:** ![agutschow](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/agutschow/32/8543_2.png) [@agutschow](https://developer.sailpoint.com/discuss/u/agutschow)\ **Post date:** [June 28, 2024, 2:45pm UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/12 "2024-06-28T14:45:21Z")
What happens if you put in the IP address instead of the server name in the jdbc URL in the source? Alicia ---
**Author:** ![SauravSaraffLSEG](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@SauravSaraffLSEG](https://developer.sailpoint.com/discuss/u/SauravSaraffLSEG)\ **Post date:** [June 28, 2024, 3:05pm UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/13 "2024-06-28T15:05:24Z")
Same error, no impact with IP address. ---
**Author:** ![KiranSeehra](https://avatars.discourse-cdn.com/v4/letter/k/73ab20/32.png) [@KiranSeehra](https://developer.sailpoint.com/discuss/u/KiranSeehra)\ **Post date:** [July 1, 2024, 10:21am UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/14 "2024-07-01T10:21:57Z")
JDBC had a connection error recently, and was rectified by a CCG update, the errors you’re facing are similar to the ones experienced with an outdated CCG. In order to test this it would be best to try and create a simple JDBC connector in Java and test you can access the database from there. If you are able to with the same credentials then it will most likely just be a connector error. ---
**Author:** ![KiranSeehra](https://avatars.discourse-cdn.com/v4/letter/k/73ab20/32.png) [@KiranSeehra](https://developer.sailpoint.com/discuss/u/KiranSeehra)\ **Post date:** [July 9, 2024, 2:29pm UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/15 "2024-07-09T14:29:20Z")
Hi Saurav, After some further research, it could be that the user account you are using does not have read access to the “Path1” folder, which would explain the username and password error even though you are using correct details. Could you please check this by right clicking the folder, clicking security and adding read permissions on the user. ---
**Author:** ![SauravSaraffLSEG](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@SauravSaraffLSEG](https://developer.sailpoint.com/discuss/u/SauravSaraffLSEG)\ **Post date:** [July 29, 2024, 7:39am UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/16 "2024-07-29T07:39:40Z")
It took some time to figure out the issue, but could finally resolve it. The VA is configured with Proxy. So, even after opening the firewall and ports, the requests were flowing via the Proxy server instead of the VA. As a resolution, I added the Proxy server IP in the proxy.yaml file, and aggregation started working like charm! 🙂 Thanks to all the community members for help and inputs. In case you have additional questions on this issue, ping me. ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [September 27, 2024, 7:39am UTC](https://developer.sailpoint.com/discuss/t/sql-loader-connector-error-https-on-windows-server/68369/17 "2024-09-27T07:39:47Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.