Unable to connect to SQL Server when using ruby on rails

23 בMay 2012

no comments

Getting error when Executing rake db:migrate 

rake aborted!

Unable to connect: Adaptive Server is unavailable or does not exist

to solve this issue check your database configuration on config\database.yml (remove unnecessary property)

development:   adapter: sqlserver

  host: sharon

  database: SharonBlog_development

  username: Usersharon

  password: fill in the password


verify that TCP/IP port is Enabled (restart the MSSQLSERVER service):

open SQL Server configuration Tools – > SQL Server configuration manager-> SQL Server Network configuration

Add comment
facebook linkedin twitter email

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>