Servoy Forum

Resolved: the name of the server is the name of the database, 'repository_server'
Working the problem at too late a level in the instructions. duh.

Failing at install of a 7.4.11 on a Windows Server 2012R2.
Haven't found the secret sauce to get this running.

Server 2012 R2
Servoy 7.4.11
MS SQL Server 2014, driver sqljdbc_7.2.2.0_enu.exe
Java 32-bit (due to connecting to a 3rd party)
Port is 1433. Error log shows unable to locate 'repository_server'
'could not find repository_server'

URL: jdbc:sqlserver://localhost:1433;DatabaseName=repository_server
class: com.microsoft.sqlserver.jdbc.SQLServerDriver
and user/password entries

TCP/IP is enabled and active with other databases.

Tried these iterations and others:
jdbc:sqlserver://;DatabaseName=repository_server;SelectMethod=cursor
jdbc:sqlserver://localhost:1433;DatabaseName=repository_server;SelectMethod=cursor;autoReconnect=true
jdbc:sqlserver://10.0.0.10:1433;DatabaseName=repository_server;SelectMethod=cursor;autoReconnect=true

Any suggestions?
Is there a conflicting driver in the drivers directory that might interfere with the new driver? (I did attempt install without a new driver as well.)

Thanks,
--Joe.

Hi Joe,

the connection name for repository server should be 'repository_server'
the actual name of the database may be different and is used in the connection string.

This might look like this:
jdbc:sqlserver://localhost:1433;instance=<INSTANCE NAME>;databaseName= repository_server

Marc,

Does that mean I should be using an instance name?

--Joe.

joe26 wrote:Does that mean I should be using an instance name?

This depends on your SQL Server configuration, but this might be the case.

Is there any place where you were able to successfully connect to a database on this SQL Server?
It all depends on SQL Server configuration, version and driver (version) so it's a bit hard to tell what this should be.

Aside from the instance name, nothing is different from my original post.

It does not appear that this sqlserver installation is using instances, though.

Was not able to get into the customer machine today, so will have to check tomorrow.

--Joe.