Using SQLServer driver
Does anyone have experience setting up a SQLServer JDBC driver in RM 5.1?
Here's what I've already done:
-installed SQLServer JDBC drivers
-installed new driver in RM (Tools->Manage Database Drivers)
-setup a DB connection (Tools->Manage Database Connections)
I'm running SQLServer Express. My connection details looks like this:
Database system : SQLServer (my driver that I'd previously installed)
Host: localhost/sqlexpress
Port: 1433
Database schema:
User: <username>
Password: <password>
URL shows up on the UI as : jdbc:sqlserver://localhost/sqlexpress:1433
When I hit the 'Test' button, I get the following (partial) message:
The TCP/IP connection to the host localhost/sqlexpress, port 1433 has failed. Error: "null. Verify t...
The rest of the message is not visible in the UI. SQLServer browser service is up. TCP is enabled.
Any help is appreciated! Thanks!
Here's what I've already done:
-installed SQLServer JDBC drivers
-installed new driver in RM (Tools->Manage Database Drivers)
-setup a DB connection (Tools->Manage Database Connections)
I'm running SQLServer Express. My connection details looks like this:
Database system : SQLServer (my driver that I'd previously installed)
Host: localhost/sqlexpress
Port: 1433
Database schema:
User: <username>
Password: <password>
URL shows up on the UI as : jdbc:sqlserver://localhost/sqlexpress:1433
When I hit the 'Test' button, I get the following (partial) message:
The TCP/IP connection to the host localhost/sqlexpress, port 1433 has failed. Error: "null. Verify t...
The rest of the message is not visible in the UI. SQLServer browser service is up. TCP is enabled.
Any help is appreciated! Thanks!