DCSIMG
Unable to connect to SQL Server when using ruby on rails - SQL SERVER DBAces And More

SQL SERVER DBAces And More

שרון כהן שכן טוב

Unable to connect to SQL Server when using ruby on rails

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

Comments

No Comments

Leave a Comment

(required) 

(required) 

(optional)

(required) 


Enter the numbers above: