I am trying connecting Mssql server with Nifi but getting below error. Configuration: Host: 210c:a022:205:541d::1:87 , it is not considering entire IP.
Asked
Active
Viewed 272 times
-1
-
try specifiying properties like this `jdbc:sqlserver://192.168.1.201:1433;databaseName=[your database]` `com.microsoft.sqlserver.jdbc.SQLServerDriver` – Vikramsinh Shinde Mar 03 '21 at 14:14
-
refer this one - https://stackoverflow.com/questions/41489816/connect-sql-to-apache-nifi – Vikramsinh Shinde Mar 03 '21 at 14:14
1 Answers
0
I have not tried IPv6 addresses with MSSQL & NiFi, but according to MS docs, your connection string should look like:
jdbc:sqlserver://;serverName=3ffe:8311:eeee:f70f:0:5eae:10.203.31.9\\instance1;integratedSecurity=true;
Reccommend starting by looking at documentation.
The JDBC driver supports the use of IPv6 addresses with the connection properties collection, and with the serverName connection string property. The initial serverName value, such as jdbc:sqlserver://serverName, is not supported for IPv6 addresses in connection strings. Using a name for serverName instead of a raw IPv6 address will work in every case in the connection. The following examples provide more information.
To use the serverName property
jdbc:sqlserver://;serverName=3ffe:8311:eeee:f70f:0:5eae:10.203.31.9\instance1;integratedSecurity=true;
Sdairs
- 1,912
- 1
- 13
- 13