Can’t connect to a SQLEXPRESS

[ttmgybta]

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=<none>
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=<none>
server.0.serverName=repository_server
server.0.skipSysTables=true
server.0.userName=sa
server.0.validationQuery=

[AlanBourke]

I connect to an SQLEXPRESS instance like this:

Code: Select all

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.

[ttmgybta]

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.

[AlanBourke]

Well, back to basics - at the prompt (in Windows 7) can you access the SQL Server like this:

Code: Select all

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 ?