dbTalk Databases Forums  

Accessing named instances

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Accessing named instances in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Brett F
 
Posts: n/a

Default Accessing named instances - 05-24-2005 , 04:43 PM






I am looking to see if anyone has had this problem or ideas of what I might
try. We have been running a Windows 2000 cluster connected to a powervault
for two years as a single instance with no problems.

I am in the process of setting of a Windows 2003 Active-Passive two node
cluster connected to a SAN. I have fourinstances/virtual servers installed
and I can access the "default instance" from any machine with enterprise
manager within our network. This behavior is as expected.

I can only access the named instances from machines within the cluster's
subnet, which is not expected. I have all the instances using port 1433; not
sure if that makes a difference.

Need some help pointing our network team in the right direction. They have
had me turn off the second node, and disable NIC teaming to get down to a
single server, single NIC environment, and I still don't have success.

Any ideas on whether this is a SQL setup problem or a network/firewall
configuration issue?

Respectfully,

Brett

Reply With Quote
  #2  
Old   
Pascal Damman
 
Posts: n/a

Default RE: Accessing named instances - 05-27-2005 , 12:00 PM






Hi Brett,

Some things to try:
Can the IP addresses of the named instances be resolved (DNS, hosts)?

Maybe you can try connecting to the instance using the IP address.
Or to test, add it in
C:\Windows\System32\drivers\etc\hosts

--
Chau chau,

Pascalos


"Brett F" wrote:

Quote:
I am looking to see if anyone has had this problem or ideas of what I might
try. We have been running a Windows 2000 cluster connected to a powervault
for two years as a single instance with no problems.

I am in the process of setting of a Windows 2003 Active-Passive two node
cluster connected to a SAN. I have fourinstances/virtual servers installed
and I can access the "default instance" from any machine with enterprise
manager within our network. This behavior is as expected.

I can only access the named instances from machines within the cluster's
subnet, which is not expected. I have all the instances using port 1433; not
sure if that makes a difference.

Need some help pointing our network team in the right direction. They have
had me turn off the second node, and disable NIC teaming to get down to a
single server, single NIC environment, and I still don't have success.

Any ideas on whether this is a SQL setup problem or a network/firewall
configuration issue?

Respectfully,

Brett

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.