[jdbc] Building the Connection URL

jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]


Example:

• jdbc:sqlserver://localhost;user=MyUserName;password=*****;
• jdbc:sqlserver://localhost;integratedSecurity=true;
• jdbc:sqlserver://localhost;databaseName=AdventureWorks;integratedSecurity=true;
• jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;integratedSecurity=true;
• jdbc:sqlserver://localhost;databaseName=AdventureWorks;integratedSecurity=true;applicationName=MyApp;
• jdbc:sqlserver://localhost:1433;integratedSecurity=true;<more properties as required>;
• jdbc:sqlserver://localhost;instanceName=instance1;integratedSecurity=true;<more properties as required>;