I ran into this problem and it now makes sense why I had an issue. My external name used would not resolve on the local server (internal). Once I added the external dns name being used to the local dns list, the dashboard started to work correctly.

Great information. Thanks

I found I had to change the connection string with an instance to the following:

jdbc.url=jdbc:log4jdbc:jtds:sqlserver://:/;instance=

After that it came up with an error the first time I loaded the dashboard after an iisreset but after that it was fine.

That's a good tip!

I saw that error when I changed the server name. The error on the screen was: The Dashboard has experienced a problem. Please contact your System Administrator. The error in the scrmsql log file was org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

Changing this line:

jdbc.url=jdbc:log4jdbc:sqlserver://;databaseName=

in jdbc.properties to point to the correct server and doing an iisreset got it working again.

We have tried the options mention in the article but it does not seem to work.