ActiveRecord::LostConnection (TinyTds::Error: DBPROCESS is dead or not enabled

[eklipse2k8]

It looks like Azure SQL is dropping the connection after about 60 seconds at which point this exception is thrown on the website. Shouldn't the driver attempt to retry the connection before dying?

stack trace:

ActiveRecord::LostConnection (TinyTds::Error: DBPROCESS is dead or not enabled: EXEC sp_executesql N'SELECT TOP (1) [sessions].* FROM [sessions] WHERE [sessions].[session_id] = N''50224f43221cb4c3afb4f89129595668'''):
  /var/www/artcator.com/www/shared/bundle/ruby/2.0.0/bundler/gems/activerecord-sqlserver-adapter-c21f97f378fd/lib/active_record/connection_adapters/sqlserver/database_statements.rb:416:in `each'
  /var/www/artcator.com/www/shared/bundle/ruby/2.0.0/bundler/gems/activerecord-sqlserver-adapter-c21f97f378fd/lib/active_record/connection_adapters/sqlserver/database_statements.rb:416:in `handle_to_names_and_values_dblib'
  /var/www/artcator.com/www/shared/bundle/ruby/2.0.0/bundler/gems/activerecord-sqlserver-adapter-c21f97f378fd/lib/active_record/connection_adapters/sqlserver/database_statements.rb:405:in `handle_to_names_and_values'
  /var/www/artcator.com/www/shared/bundle/ruby/2.0.0/bundler/gems/activerecord-sqlserver-adapter-c21f97f378fd/lib/active_record/connection_adapters/sqlserver/database_statements.rb:377:in `_raw_select'
  /var/www/artcator.com/www/shared/bundle/ruby/2.0.0/bundler/gems/activerecord-sqlserver-adapter-c21f97f378fd/lib/active_record/connection_adapters/sqlserver/database_statements.rb:371:in `block in raw_select'

[scaryguy]

I get same error with SQL SERVER 2005. It's really weired. When I reload the page, connection works without any error.

Is this issue new or did exist since a while?

[mchambers]

seeing this as well, on Azure and TinyTds.

[metaskills]

Closing, this issue duplicates rails-sqlserver/tiny_tds#79