Can’t connect to a SQLEXPRESS Server whit the Servoy_server.bat –upgradeReository.
I don’t have any error or log entry.
How does the connection string have to look like whit the SQLJDBC driver on a 64bit system?
server.0.URL=jdbc:sqlserver://localhost;databasename=repository_servery;instanceName=SQLEXPRESS
server.0.catalog=
server.0.connectionValidationType=0
server.0.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.0.enabled=true
server.0.maxConnectionsActive=30
server.0.maxConnectionsIdle=10
server.0.maxPreparedStatementsIdle=100
server.0.password=xxxx
server.0.schema=
server.0.serverName=repository_server
server.0.skipSysTables=true
server.0.userName=sa
server.0.validationQuery=
I connect to an SQLEXPRESS instance like this:
jdbc:jtds:sqlserver://mymachinename:61775/mydatabasename;instanceName=SQLEXPRESS
Note that I had to explicitly define the port. And that uses the JDTS driver but it should be the same in terms of the parameters.
When I want to connect it hangs forever.
We are trying this on Windows 7 in Boot Camp on am Mac , has it something to do with that?
SQL 2008 Express is installed and TCP IP is enabled for the SQL Server and also the port is divined.
See attachment.
Well, back to basics - at the prompt (in Windows 7) can you access the SQL Server like this:
sqlcmd -E -S .\SQLEXPRESS
Do you have TCP/IP enabled in the SQL Server configuration ?
Is the port in question getting blocked by a firewall rule ?
