Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

best practice for remotely connecting to Cluster with Clie..

  
   Database Forums (Home) -> Clustering RSS
Next:  downgrade MDAC version  
Author Message
geek-y-guy

External


Since: Aug 29, 2006
Posts: 11



(Msg. 1) Posted: Fri Jan 04, 2008 5:30 pm
Post subject: best practice for remotely connecting to Cluster with Client GUI?
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
Hi All: I have an active/passive SQL 2005 Cluster set up on a subnet that
with a local Active Directory domain. Any computers in the domain can
connect to it using "SQLCluster" SQL Mgmt Studio and connect with Windows
Authentication.

This subnet is connected to a remote location with a point-2-point VPN. All
protocols are allowed through the VPN. The remote location has an SBS2003
server acting as the domain controller for the computers there.

If a user in the remote domain wants to connect to the server using Mgmt
Studio, they can't connect "SQLCluster" and they can't connect with
"SQLCluster.[clusterdomain].local" because the SBS server doesn't know how
to find it obviously.

Question is, what is the appropriate way to connect? Using the IP address I
believe is not recommended because the connection will break if the Cluster
fails over to the second server.

What is the best practice for giving them access?

--

 >> Stay informed about: best practice for remotely connecting to Cluster with Clie.. 
Back to top
Login to vote
geek-y-guy

External


Since: Aug 29, 2006
Posts: 11



(Msg. 2) Posted: Fri Jan 04, 2008 6:12 pm
Post subject: Re: best practice for remotely connecting to Cluster with Client GUI? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
> Hi All: I have an active/passive SQL 2005 Cluster set up on a subnet that
> with a local Active Directory domain. Any computers in the domain can
> connect to it using "SQLCluster" SQL Mgmt Studio and connect with Windows
> Authentication.
>
> This subnet is connected to a remote location with a point-2-point VPN.
> All protocols are allowed through the VPN. The remote location has an
> SBS2003 server acting as the domain controller for the computers there.
>
> If a user in the remote domain wants to connect to the server using Mgmt
> Studio, they can't connect "SQLCluster" and they can't connect with
> "SQLCluster.[clusterdomain].local" because the SBS server doesn't know how
> to find it obviously.
>
> Question is, what is the appropriate way to connect? Using the IP address
> I believe is not recommended because the connection will break if the
> Cluster fails over to the second server.
>
> What is the best practice for giving them access?
>

Sorry, I realize now that the cluster IP will work for remote
connections...but is this the correct way to connect, or is there a "better
practice"?

 >> Stay informed about: best practice for remotely connecting to Cluster with Clie.. 
Back to top
Login to vote
Manoj Raheja

External


Since: Dec 29, 2007
Posts: 6



(Msg. 3) Posted: Sun Jan 06, 2008 8:30 pm
Post subject: Re: best practice for remotely connecting to Cluster with Client G [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You can use either of these two options

Option 1
----------
Create an alias on client machine

1. Open SQL Server Configuration Manager
2. Expand SQL Native Client Configuration
3. Right click Aliases--> New Alias
4. Alias Name: <Name of the Cluster>
4. Port No:1433
5. Protocol: TCP/IP
6. Server: <IP Address>

Option 2
----------
Add entey for IP mapping in the hosts file located on client machine
C:\WINDOWS\system32\drivers\etc\hosts


--
Regards,
Manoj Raheja
MCDBA, MCITP


"geek-y-guy" wrote:

> > Hi All: I have an active/passive SQL 2005 Cluster set up on a subnet that
> > with a local Active Directory domain. Any computers in the domain can
> > connect to it using "SQLCluster" SQL Mgmt Studio and connect with Windows
> > Authentication.
> >
> > This subnet is connected to a remote location with a point-2-point VPN.
> > All protocols are allowed through the VPN. The remote location has an
> > SBS2003 server acting as the domain controller for the computers there.
> >
> > If a user in the remote domain wants to connect to the server using Mgmt
> > Studio, they can't connect "SQLCluster" and they can't connect with
> > "SQLCluster.[clusterdomain].local" because the SBS server doesn't know how
> > to find it obviously.
> >
> > Question is, what is the appropriate way to connect? Using the IP address
> > I believe is not recommended because the connection will break if the
> > Cluster fails over to the second server.
> >
> > What is the best practice for giving them access?
> >
>
> Sorry, I realize now that the cluster IP will work for remote
> connections...but is this the correct way to connect, or is there a "better
> practice"?
>
>
>
 >> Stay informed about: best practice for remotely connecting to Cluster with Clie.. 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 4) Posted: Mon Jan 07, 2008 8:18 am
Post subject: Re: best practice for remotely connecting to Cluster with Client G [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Option 3. Manually create a DNS entry on your SBS Server

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Manoj Raheja" wrote in message

> You can use either of these two options
>
> Option 1
> ----------
> Create an alias on client machine
>
> 1. Open SQL Server Configuration Manager
> 2. Expand SQL Native Client Configuration
> 3. Right click Aliases--> New Alias
> 4. Alias Name: <Name of the Cluster>
> 4. Port No:1433
> 5. Protocol: TCP/IP
> 6. Server: <IP Address>
>
> Option 2
> ----------
> Add entey for IP mapping in the hosts file located on client machine
> C:\WINDOWS\system32\drivers\etc\hosts
>
>
> --
> Regards,
> Manoj Raheja
> MCDBA, MCITP
>
>
> "geek-y-guy" wrote:
>
>> > Hi All: I have an active/passive SQL 2005 Cluster set up on a subnet
>> > that
>> > with a local Active Directory domain. Any computers in the domain can
>> > connect to it using "SQLCluster" SQL Mgmt Studio and connect with
>> > Windows
>> > Authentication.
>> >
>> > This subnet is connected to a remote location with a point-2-point VPN.
>> > All protocols are allowed through the VPN. The remote location has an
>> > SBS2003 server acting as the domain controller for the computers there.
>> >
>> > If a user in the remote domain wants to connect to the server using
>> > Mgmt
>> > Studio, they can't connect "SQLCluster" and they can't connect with
>> > "SQLCluster.[clusterdomain].local" because the SBS server doesn't know
>> > how
>> > to find it obviously.
>> >
>> > Question is, what is the appropriate way to connect? Using the IP
>> > address
>> > I believe is not recommended because the connection will break if the
>> > Cluster fails over to the second server.
>> >
>> > What is the best practice for giving them access?
>> >
>>
>> Sorry, I realize now that the cluster IP will work for remote
>> connections...but is this the correct way to connect, or is there a
>> "better
>> practice"?
>>
>>
>>
 >> Stay informed about: best practice for remotely connecting to Cluster with Clie.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Connecting to an instance in a cluster - Hello, I just setup a few instances on a cluster. But somehow I cannot conntect to the instances remotely using SQL Server Management Studio. I can connect to them locally. I can also connect to the default instance fine. Any idea? Thanks!

best practice - patching clusters - Hi, We have 2 2-node SQL clusters. We patch & update these servers monthly and there's different techniques my colleagues use when we patch the servers. Whats the best way to patch a 2 node cluster? (working on the passive node (B) natually) scene...

How SQL2005 cluster can be installed on windows cluster? - I am new on both SQL and windows cluster. Our company is trying to deploy a HA SQL system, which I need to install SQL2005 to windows cluster. My question is: Since windows cluster will share one back end storage chassis, where should I put SQL2005 on...

Connecting VIA IP Address - When I try to connect via IP to a newly created Active Active cluster I have to add the port to the IP for it to work. An example is if my IP is 10.0.0.1 and I try to connect it times out. if I try 10.0.0.1,1433 then it works fine. Am I missing a..

Access Denied when connecting - I am having a problem connecting to my SQL 2005 named instance on a clustered server in another domaim. If I am within the domain everything works fine. If I am in a different domain, I cannot register it through SQL Management Studio or create an ODB...
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]