These are chat archives for rails-sqlserver/activerecord-sqlserver-adapter
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:
TinyTds::Client.new(dataserver: ”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