MSSQL Setup - TinyTds::Error: closed connection
Solved, see at the bottom.
I'm currently trying to setup a Redmine installation for our team. I can't seem to establish a connection to our MSSQL server from within rails.
$ RAILS_ENV=production bundle exec rake db:migrate
TinyTds::Error: closed connection
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
I installed sqlcmd to test the connection outside out rails, and I managed to login and create and drop a table as a test. I suspect it's my database.yml. I have to connect to an MS SQL Instance, and the server in running on a different port. Tried to tweak around with the settings a bit, but couldn't get it working.
As a sidenote, for sqlcmd I used "-S server\\instance,####" to establish the connection. Which I've surely tried in the database.yml too, but without any success.
I'd really appreciate any input from the experts, since we'd love to start using your tool beginning next week. I'm happy to provide any further information regarding the server configuration.
In case anyone stumbles upon this, leaving out the instance does the job.