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

30th
Nov 2016
shaomingtan
@shaomingtan
Nov 30 2016 04:47
Hi everyone
shaomingtan
@shaomingtan
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:

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

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