search

rails-sqlserver / activerecord-sqlserver-adapter

SQL Server Adapter For Rails
MIT License
972 stars 557 forks source link

Named Instance Issue #128

Closed drobazko closed 12 years ago

drobazko commented 12 years ago

Hi, again Another one problem: I have named Instance of MSSQL Server (server name - ELLA, instance name - ELLA_2005). So full instance name: ELLA\ELLA_2005 My database.yml:

development:
  adapter: sqlserver
  host: ELLA\ELLA_2005
  database: earchive
  username: lesha
  password: lesha
  encoding: utf8

But when I try to execute any query I get this error message: TinyTds::Error: Server name not found in configuration files

Thanks for help

metaskills commented 12 years ago

From the wiki page linked from the adapter wiki page: https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/wiki/Using-TinyTds

If you are using named instances, you must use the :dataserver option. In some cases too, that will not work and you should just punt and use :host/:port for that named instance.

drobazko commented 12 years ago

You hate me I think )) Sorry for stupid question

metaskills commented 12 years ago

Brief terse RTM's are not hate :) just quickly helpful. Cheers.