Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How do i connect cluster instance?? Expand / Collapse
Author
Message
Posted Monday, August 20, 2012 10:55 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
Hi All,
I am configured SQL Cluster 2008 in Win server 2008, below are the details..

NODE1 IP :- 192.168.10.51
NODE2 IP :- 192.168.10.52
SQL N/W IP :- 92.168.10.53
SQL N/W Instance Name:- Heartbeat

Issue:- When i logged in NODE1 & open SSMS connecting through HEARTBEAT instance name, connecting fine but when i tried to connect through IP not able to connecting and i tried all IP's let me advice what shall I do to connect through IP.

Thanks in advance........

Satish
Post #1347566
Posted Tuesday, August 21, 2012 2:17 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, August 29, 2014 9:57 AM
Points: 6,304, Visits: 13,601
what value did you provide for the network name?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1348081
Posted Wednesday, August 22, 2012 11:38 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
Hi,
Same i mention as host name "Heartbeat" but i want to connect through IP...

Thanks
Satish
Post #1348862
Posted Thursday, August 23, 2012 2:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, August 29, 2014 9:57 AM
Points: 6,304, Visits: 13,601
Above you specify instance name as heartbeat!

Is this a default or named instance of SQL server?
Confirm the SQL server config manager settings and post them back


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1348917
Posted Thursday, August 23, 2012 2:17 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, August 28, 2014 3:20 AM
Points: 880, Visits: 4,093

When i logged in NODE1 & open SSMS connecting through HEARTBEAT instance name, connecting fine but when i tried to connect through IP not able to connecting and i tried all IP's let me advice what shall I do to connect through IP.


Try with ip,portnumber. It should work and if TCP/IP protocol is enabled on your sql server


----------
Ashish
Post #1348922
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse