# Accessing SQL Server named instance

**URL:** <https://www.ruby-forum.com/t/accessing-sql-server-named-instance/118242>\
**Category:** Ruby\
**Created:** [October 25, 2007, 2:45am UTC](https://www.ruby-forum.com/t/accessing-sql-server-named-instance/118242 "2007-10-25T02:45:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gregarican](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/7feea3/32.png) [@gregarican](https://www.ruby-forum.com/u/gregarican)\
**Post date:** [October 25, 2007, 2:45am UTC](https://www.ruby-forum.com/t/accessing-sql-server-named-instance/118242/1 "2007-10-25T02:45:41Z")

</div>

I apologize in advance for posting a Rails question in the general  
Ruby news group, but here goes. Does anyone know of a way I can  
configure my Rails app to access a SQL Server named instance? My  
version of Rails is a couple of years old (ActiveRecord v1.10.0 if  
that means anything). I am using ADO and when I refer to the SQL  
Server named instance as SERVERNAME\INSTANCE the app errors out that  
it cannot connect. The app was previously hosted on anothe server that  
used the default instance. No problems then. I had googled a posting  
on another board where someone had similar issues. But no follow-up as  
to if it was fixable.

Anyone know?

---

<div class="post-metadata">

**Author:** ![gregarican](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/7feea3/32.png) [@gregarican](https://www.ruby-forum.com/u/gregarican)\
**Post date:** [October 25, 2007, 2:37pm UTC](https://www.ruby-forum.com/t/accessing-sql-server-named-instance/118242/2 "2007-10-25T14:37:23Z")

</div>

2007/10/25, gregarican [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid):

> Anyone know?

Unfortunately no Rails experience here, but: you did make sure the  
port on the DB server is reachable from your Rails machine?

Kind regards

robert