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=""> <strike> <strong>