August 20, 2012 at 10:55 pm
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
August 21, 2012 at 2:17 pm
what value did you provide for the network name?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2012 at 11:38 pm
Hi,
Same i mention as host name "Heartbeat" but i want to connect through IP...
Thanks
Satish
August 23, 2012 at 2:08 am
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" 😉
August 23, 2012 at 2:17 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply