Home TinyTds::Error: Login faild for user 'sa'
Reply: 1

TinyTds::Error: Login faild for user 'sa'

Santosh Kumbhar
1#
Santosh Kumbhar Published in 2017-11-30 09:22:48Z

I am try to connect sql-server through rails console.

ActiveRecord::Base.establish_connection(:adapter=> "sqlserver",:encoding=> "utf8",:host => "10.10.10.62",:database => "cosec", :username => "sa", :password => "****")

But i got error..

TinyTds::Error: Login faild for user 'sa'

Gabbar
2#
Gabbar Reply to 2017-11-30 09:35:43Z

it should be something like this: -

development:
  # <<: *default
  adapter: sqlserver
  mode: dblib
  host: 10.10.10.62
  port: 1433
  database: cosec
  username: sa
  password: *****
  timeout: 50000000

or

   adapter: sqlserver
   encoding: utf8
   database: cosec
   username: sa
   password: *****
   host: 127.0.0.1
   port: 1433
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.320891 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO