Hi,

SQL Server is listening on the cluster IP, not the SQL Server IP. Will this present a problem later down the line? I have no problem connecting, failing over, or creating a DSN from my webserver (using cluster IP of course).

Thanks!

If SQL is using cluster IP, I would change it to listen on SQL IP. If you
are using SQL Server 2000 then its very easy to do this. This article may
be helpful to you

HOWTO: Change the Network IP Addresses on a Virtual SQL Server
http://support.microsoft.com/?kbid=244980

HTH,

Uttam Parui
SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Thanks Uttam

I found that one of the problems by using the DSN to connect to the virtual cluster IP was that when the cluster failed over, the application and web servers lost thier connection. I updated the IP's and it works correctly now

That leaves me with a new question..
Whats the difference between the SQL IP and the Cluster IP

----- Uttam Parui[MS] wrote: ----

If SQL is using cluster IP, I would change it to listen on SQL IP. If you
are using SQL Server 2000 then its very easy to do this. This article may
be helpful to yo

HOWTO: Change the Network IP Addresses on a Virtual SQL Serve
http://support.microsoft.com/?kbid=24498

HTH

Uttam Paru
SQL Server Developer Support Engineer, MCDBA, MCSE, MC
Product Support Service
Microsoft Corporatio

This posting is provided "AS IS" with no warranties, and confers no rights

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security

They are different. The Windows server cluster is its own
virtual server, and SQL is its own virtual server that
runs within/on top of the Windows server cluster. It is a
hard requirement that the IP addresses you assign are
unique; SQL's cannot be the same as the underlying server
cluster.


cluster failed over, the application and web servers lost
thier connection. I updated the IP's and it works
correctly now.

Mike,



The difference will be more clear if you look at these from "virtual
servers" perspective. Please check out the sub-section named "Virtual
Servers" on pages 9 to 11 of the document
http://www.microsoft.com/windowsserv...chitecture.doc



To make things more simple, think of one virtual server (say VS1) which
allows you to store and retrieve data in database, another one (say VS2)
which allows you to send and receive emails. Now to access the functionality
provided by these virtual servers from other machines on the network you
need to know their IP addresses. So if VS1 is SQL and VS2 is Exchange, IP
address used by VS1 is SQL IP address and that used by VS2 is Exchange IP
address.



Finally, think of one virtual server (say VS0) whose major purpose is to
host other virtual servers. This virtual server allows you (apart from
providing other functionality) to query what virtual servers it is hosting
and if they are working fine or not. To query this virtual server from other
machines on the network you need to know its IP address and this is nothing
but the cluster IP address.



--
Regards,
Shon Shah
Software Test Engineer
Microsoft Cluster Server

This posting is provided "AS IS" with no warranties, and confers no rights.

"Mike" <anonymous (AT) discussions (DOT) microsoft.com> wrote

and web servers lost thier connection. I updated the IP's and it works
correctly now.

Cluster IP Address is the IP address that all external connections use to
reach the failover WINDOWS CLUSTER itself, not the SQL Server virtual
server.

SQL Server IP Address is the TCP/IP address that users and applications
will use to connect to SQL Server.

For additional information, please refer to

Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...overcluster.as
p

HTH,

Uttam Parui
SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Thanks guys!

----- Shon Shah [MSFT] wrote: ----

Mike



The difference will be more clear if you look at these from "virtua
servers" perspective. Please check out the sub-section named "Virtua
Servers" on pages 9 to 11 of the documen
http://www.microsoft.com/windowsserv...rchitecture.do



To make things more simple, think of one virtual server (say VS1) whic
allows you to store and retrieve data in database, another one (say VS2
which allows you to send and receive emails. Now to access the functionalit
provided by these virtual servers from other machines on the network yo
need to know their IP addresses. So if VS1 is SQL and VS2 is Exchange, I
address used by VS1 is SQL IP address and that used by VS2 is Exchange I
address



Finally, think of one virtual server (say VS0) whose major purpose is t
host other virtual servers. This virtual server allows you (apart fro
providing other functionality) to query what virtual servers it is hostin
and if they are working fine or not. To query this virtual server from othe
machines on the network you need to know its IP address and this is nothin
but the cluster IP address



--
Regards
Shon Sha
Software Test Enginee
Microsoft Cluster Serve

This posting is provided "AS IS" with no warranties, and confers no rights

"Mike" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:3CBFF58C-6CBA-4B0A-99E9-DDC8D6DAD91D (AT) microsoft (DOT) com..
and web servers lost thier connection. I updated the IP's and it work
correctly now