Install 7.4.11 'could not find repository_server'

Questions and answers regarding general SQL and backend databases

Install 7.4.11 'could not find repository_server'

Postby joe26 » Tue Jul 23, 2019 10:57 pm

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.
Last edited by joe26 on Mon Aug 05, 2019 7:11 am, edited 1 time in total.
joe26
 
Posts: 172
Joined: Wed Jun 19, 2013 10:30 pm

Re: Install 7.4.11 'could not find repository_server'

Postby mboegem » Wed Jul 24, 2019 1:16 am

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 Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance SAN Developer

Image
User avatar
mboegem
 
Posts: 1573
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Install 7.4.11 'could not find repository_server'

Postby joe26 » Wed Jul 24, 2019 3:31 pm

Marc,

Does that mean I should be using an instance name?

--Joe.
joe26
 
Posts: 172
Joined: Wed Jun 19, 2013 10:30 pm

Re: Install 7.4.11 'could not find repository_server'

Postby mboegem » Wed Jul 24, 2019 4:24 pm

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.
_____________________
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance SAN Developer

Image
User avatar
mboegem
 
Posts: 1573
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Install 7.4.11 'could not find repository_server'

Postby joe26 » Thu Jul 25, 2019 1:15 am

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.
joe26
 
Posts: 172
Joined: Wed Jun 19, 2013 10:30 pm


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 1 guest

cron