Groups | Blog | Home
all groups > sql server clustering > march 2004 >

sql server clustering : Windows/SQLvirtual name


Hassan
3/26/2004 11:22:19 PM
Setting up sql 2K cluster (single instance) on win2003

I already have win2003 cluster service setup. I have a
virtual server name and a virtual IP..

Now when I install SQL , what do I enter when i select
virtual server ? Do I put in the same name as the Win2003
virtual server name I entered ..Also what IP address
would I need to enter in the SQL installation ? Would it
be the same Windows virtual IP I have used. Im just a lil
confused here.. Im thinking I need to use the same
virtual name and IP address that i used while setting up
the windows cluster during the sql installation..

Hassan
3/27/2004 4:02:49 PM
Why is that ? Why would I need seperate virtual names/IP ? What would happen
if during the sql installation I use the same Windows cluster virtual name
and IP ?

[quoted text, click to view]

Geoff N. Hiten
3/27/2004 6:52:27 PM
You need one virtual name and IP for the cluster itself and one virtual name
and IP for each clustered sql instance.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

[quoted text, click to view]

Geoff N. Hiten
3/28/2004 9:52:18 AM
The install would fail.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

[quoted text, click to view]

rboyd NO[at]SPAM onlinemicrosoft.com
3/29/2004 4:25:28 PM
Unlike a standalone installation of SQL Server, a virtual SQL Server does
not rely on the name and ip address of the cluster. It needs it own virtual
network name and ip address in order to function properly.

Rand
This posting is provided "as is" with no warranties and confers no rights.
AddThis Social Bookmark Button