Hi, I'm trying to connect/create to an instance of a SQL database but not able to do it. Can anyone help with url settings? I can connect if I use e.g. URL = localhost:1433 and then db name as <whatever>, but if I want to set it as localhost\devinstance:1433, cannot get through and create the database. Help!
For a succesful connection to SQL Server, you have to enable TCP/IP connections (can be set using the SQL Server Configuration Manager). If dynamic TCP connections are enabled (and they are by default), you have to remove the port number from the JDBC connection URL and have the SQL Server Browser service running.
A valid connection URL could be: jdbc:sqlserver://dbserver\SQLEXPRESS;databaseName=mydb