cluster installation.

Hi ,
I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
active/passive configuration .
for that configuration for my understanding i need named instanced let say
SQLPROD and my vitual server name
is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
clear but i do not know
which ip address to specifiy in installation of the sql server when he ask
for ip for virtual sql server.
SQLPROD has an ip address
The IP addr will be what you assign it. You can't use an existing IP, don't
try using the Cluster's IP addr, the install won't let you. The IP addr you
assign must also be in the public address subnet for the cluster.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"w2system5" <none@.none.com> wrote in message
news:cpgtcb$cbg$1@.news2.netvision.net.il...
> Hi ,
> I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
> active/passive configuration .
> for that configuration for my understanding i need named instanced let say
> SQLPROD and my vitual server name
> is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
> clear but i do not know
> which ip address to specifiy in installation of the sql server when he ask
> for ip for virtual sql server.
> SQLPROD has an ip address
>
|||It's asking for a new IP Address to use for SQL Server. In total you will
need four:
- Physical node A
- Physical node B
- Virtual Cluster
- Virtual SQL
"w2system5" <none@.none.com> wrote in message
news:cpgtcb$cbg$1@.news2.netvision.net.il...
> Hi ,
> I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
> active/passive configuration .
> for that configuration for my understanding i need named instanced let say
> SQLPROD and my vitual server name
> is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
> clear but i do not know
> which ip address to specifiy in installation of the sql server when he ask
> for ip for virtual sql server.
> SQLPROD has an ip address
>
|||You will also need a heartbeat IP for each node. This IP can be
whatever you want.
For example:
192.168.1.1 - Node 1 Heartbeat
192.168.1.2 - Node 2 Heartbeat
Thanks,
Peter
On Thu, 13 Jan 2005 11:40:19 -0000, "Christian Bolton [MSFT]"
<christian.online@.microsoft.com> wrote:

>It's asking for a new IP Address to use for SQL Server. In total you will
>need four:
>- Physical node A
>- Physical node B
>- Virtual Cluster
>- Virtual SQL
>"w2system5" <none@.none.com> wrote in message
>news:cpgtcb$cbg$1@.news2.netvision.net.il...
>

Cluster Addresses

Hi,
I am a newbie to Clustering so please bear with me.
We have a db environment set up with Win 2003 and SQL 2000 connecting to a
single disk array.
The question I have is, what is the difference between the Cluster IP
Address and the SQL IP address.
What I really want to know is what is the purpose for the two different
addresses?
Thanks for any help.
JD
When you create a cluster, you start working with Virtual Servers. The
cluster itself becomes a Virtual server, as does each SQL instance you
install. Each virtual server consists of a minimum of a physical disk
resource, an IP address, and a network name. Of course, each virtual server
has other resources to make it actually do something useful. So, the
Cluster IP address is used to connect to Cluster control resources and the
SQL IP address is used to connect to SQL service resources. These addresses
are in addition to the IP addresses of the host nodes.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"jimmy" <jimmy@.discussions.microsoft.com> wrote in message
news:DC5A7EF8-C516-411B-823D-BA36A6E24A85@.microsoft.com...
> Hi,
> I am a newbie to Clustering so please bear with me.
> We have a db environment set up with Win 2003 and SQL 2000 connecting to a
> single disk array.
> The question I have is, what is the difference between the Cluster IP
> Address and the SQL IP address.
> What I really want to know is what is the purpose for the two different
> addresses?
> Thanks for any help.
> JD
|||Hi Geoff,
Thanks for the explanation. We have a single application that points at the
database, so should we use the SQL IP Address to point the application at the
db server?
So from your explanaition if a file share was one of the Cluster resources
and you wanted to acces it. This is when you would use the Cluster address
to access the file share. Like so:
\\ClusterIP\FileShare
Thanks Again
JD
"Geoff N. Hiten" wrote:

> When you create a cluster, you start working with Virtual Servers. The
> cluster itself becomes a Virtual server, as does each SQL instance you
> install. Each virtual server consists of a minimum of a physical disk
> resource, an IP address, and a network name. Of course, each virtual server
> has other resources to make it actually do something useful. So, the
> Cluster IP address is used to connect to Cluster control resources and the
> SQL IP address is used to connect to SQL service resources. These addresses
> are in addition to the IP addresses of the host nodes.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "jimmy" <jimmy@.discussions.microsoft.com> wrote in message
> news:DC5A7EF8-C516-411B-823D-BA36A6E24A85@.microsoft.com...
>
>
|||Yes, you use the SQL vurtial server IP address as the connection target.
Personally, I prefer to use the network name. That way, I can play with
Aliases and DNS records during disasters.
You shouldn't use the cluster resource group and quorum disk for anything
extra. You should create another virtual server and add the file service to
that resource group. \\FileShareVirtualServerName\ShareName
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"jimmy" <jimmy@.discussions.microsoft.com> wrote in message
news:641B055A-4878-4E12-AE77-DE4BFDEF3718@.microsoft.com...
> Hi Geoff,
> Thanks for the explanation. We have a single application that points at
the
> database, so should we use the SQL IP Address to point the application at
the
> db server?
> So from your explanaition if a file share was one of the Cluster resources
> and you wanted to acces it. This is when you would use the Cluster
address[vbcol=seagreen]
> to access the file share. Like so:
> \\ClusterIP\FileShare
> Thanks Again
> JD
> "Geoff N. Hiten" wrote:
server[vbcol=seagreen]
the[vbcol=seagreen]
addresses[vbcol=seagreen]
to a[vbcol=seagreen]
different[vbcol=seagreen]
|||Hi Geoff,
Thats great.
Thanks
Jamie.
"Geoff N. Hiten" wrote:

> Yes, you use the SQL vurtial server IP address as the connection target.
> Personally, I prefer to use the network name. That way, I can play with
> Aliases and DNS records during disasters.
> You shouldn't use the cluster resource group and quorum disk for anything
> extra. You should create another virtual server and add the file service to
> that resource group. \\FileShareVirtualServerName\ShareName
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "jimmy" <jimmy@.discussions.microsoft.com> wrote in message
> news:641B055A-4878-4E12-AE77-DE4BFDEF3718@.microsoft.com...
> the
> the
> address
> server
> the
> addresses
> to a
> different
>
>
|||So...
Are there any restrictions on the Cluster IP and SQL IP?
If I have an internal and external NIC, should one go on each? Can they have neighboring IPs?
The reason I ask is that I set up a new cluster with the Cluster IP on the external NIC and the SQL IP on the internal NIC. At this point everything worked fine. However the requirements changed and I changed the SQL IP from the internal NIC to the external one - with an IP contigious to the Cluster IP. Ever since, I can not get my application to connect over TCP. Sometimes the sql services will not come online either until I change the IPs back to the original settings.
I have changed the IPs both in Cluster Admin and using the SQL installer as indicated in this KB article: http://support.microsoft.com/kb/244980.
Any thoughts?

Client user timeout

Hi,
Used Mssql 5 exp. On win 2003 server
my problem,
client user time out 15 minute by sql server,
Client user inside my program, connection closed,
logout program and relogin program work again,
no network problem, no closed network connection
How can i do,There are several reasons depending upon how the connection process is set
up. For a brief review see: http://vyaskn.tripod.com/watch_your_timeouts.htm
Anith