dbTalk Databases Forums  

Failed SQL Cluster install on HP/COMPAQ using EMC SAN.

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Failed SQL Cluster install on HP/COMPAQ using EMC SAN. in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Darin Seng
 
Posts: n/a

Default Failed SQL Cluster install on HP/COMPAQ using EMC SAN. - 05-24-2004 , 04:00 PM






Few questions and problems.

My config:
2x HP DL380 Servers with local c: and d:
EMC SAN providing 3 disks to me (100gig, 150gig, 4gig)
4 gig is configured a the quarum drive.
4 gigs of ram

My Goal:
Active/Active configuration of SQL Server
1st node running SQL Server Ent Ed. (2 gigs assigned ram)
2nd node running SQL Server Ent Ed. (1 gig assigned ram)

Backround info:
Installation of cluster services went smooth and without error.
Failover of cluster drives and cluster IP works well through Custer
Administrator. This is the first time I have done a installation
using EMC storage. All past implementations I have done were with
compaq fiber storage arrays.

Problems:
1.) I can failover drives, however, they can only be accessed by unc
and not by drive letter?
2.) SQL Server Ent Ed. fails (displays something like: Error during
instal. Installation Failed). I am not sure if this problem is
related to 1.) ?

Any help or tips for my config would be greatly appreciated.

Thanks
Darin Seng
dseng (AT) talk (DOT) com

Reply With Quote
  #2  
Old   
Rand Boyd [MSFT]
 
Posts: n/a

Default RE: Failed SQL Cluster install on HP/COMPAQ using EMC SAN. - 05-25-2004 , 08:10 AM






If the drives can only be accessed by UNCs and not the drive letters on the
node that owns the drives then there is a fundamental problem with the
cluster. I would get this resolved before even attempting to install SQL
Server on this cluster.

Rand
This posting is provided "as is" with no warranties and confers no rights.


Reply With Quote
  #3  
Old   
Darin Seng
 
Posts: n/a

Default Re: Failed SQL Cluster install on HP/COMPAQ using EMC SAN. - 05-26-2004 , 04:33 PM



rboyd (AT) onlinemicrosoft (DOT) com (Rand Boyd [MSFT]) wrote in message news:<mi0x4mlQEHA.752 (AT) cpmsftngxa10 (DOT) phx.gbl>...
Quote:
If the drives can only be accessed by UNCs and not the drive letters on the
node that owns the drives then there is a fundamental problem with the
cluster. I would get this resolved before even attempting to install SQL
Server on this cluster.

Rand
This posting is provided "as is" with no warranties and confers no rights.
Problem resolved.

Fist off, Cluster drive failover when connected via Terminal Services
is a bit messed up. The Terminal Service Client never recieves the
PNP trigger that makes the drives appear when you move a group/disk
over.

Second issue (my bad), When doing the install I mapped a to the SQL
ENT ED cd that I had in my notebook PC. This required me to issue a
login username. All apears fine during the installation until SQL
starts to get installed on the other node(s). The other node is
unable to authenticate the mapping to the CD and thus fails.

Live and learn I guess. Anyhow it works and I am happy.

Darin Seng


Reply With Quote
  #4  
Old   
Darin Seng
 
Posts: n/a

Default Re: Failed SQL Cluster install on HP/COMPAQ using EMC SAN. - 05-26-2004 , 07:25 PM



rboyd (AT) onlinemicrosoft (DOT) com (Rand Boyd [MSFT]) wrote in message news:<mi0x4mlQEHA.752 (AT) cpmsftngxa10 (DOT) phx.gbl>...
Quote:
If the drives can only be accessed by UNCs and not the drive letters on the
node that owns the drives then there is a fundamental problem with the
cluster. I would get this resolved before even attempting to install SQL
Server on this cluster.

Rand
This posting is provided "as is" with no warranties and confers no rights.
Problem resolved.

Fist off, Cluster drive failover when connected via Terminal Services
is a bit messed up. The Terminal Service Client never recieves the
PNP trigger that makes the drives appear when you move a group/disk
over.

Second issue (my bad), When doing the install I mapped a to the SQL
ENT ED cd that I had in my notebook PC. This required me to issue a
login username. All apears fine during the installation until SQL
starts to get installed on the other node(s). The other node is
unable to authenticate the mapping to the CD and thus fails.

Live and learn I guess. Anyhow it works and I am happy.

Darin Seng


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.