These are chat archives for rails-sqlserver/activerecord-sqlserver-adapter

Nov 2016
Nov 30 2016 04:47
Hi everyone
Nov 30 2016 04:54

Wonder if anyone can help me with this setup that I have been trying to get to work for the last few days.

I’m on rails 4 and each time I try to run the following command to test the connection to the sql database: ”bgf\SQLEXPRESS”,  username:<my_username>,  password:<my_password>, database: <my_databasename>)

I'll get an error:

TinyTds::Error: Unable to connect: Adaptive Server is unavailable or does not exist (bgf-PC)

I’ve already enabled TCPIP on my microsoft sql server and checked that firewall is turned on for the port 1433

In microsoft sql server management studio, my database engine is named bgf-PC\SQLEXPRESS

Ken Collins
Nov 30 2016 12:50
Try using the host: ip option vs dataserver