JDBC connection string with instance name and domain
When specifying the location of the SQL Server instance, one normally provides serverName\instanceName
or serverName:portNumber
, not both. That is, either
jdbc:sqlserver://INNOWAVE-99\SQLEXPRESS01;databaseName=EDS
or
jdbc:sqlserver://localhost:1433;databaseName=EDS
(assuming that the SQLEXPRESS01 instance has been explicitly configured to listen on port 1433, which is not usually the case for a SQL Express instance).
As mentioned in the documentation for Building the Connection URL
If both a portNumber and instanceName are used, the portNumber will take precedence and the instanceName will be ignored.
There is no domain=
property defined for the connection URL for Microsoft's JDBC driver for SQL Server. Logging in to the SQL Server instance with Windows domain credentials is done implicitly using the integratedSecurity=true
connection property (and not explicitly providing a username and password); details here.