Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / Other Technologies / Clustering / February 2006

Tip: Looking for answers? Try searching our database.

SQL Server Install of Named Instance on 2003 fails

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chris - 23 Feb 2006 16:15 GMT
I am installing an SQL Server 2000 Active Active cluster on a Windows
2003 cluster.  I am unable to install the Virtual SQL Server as a Named
Instance.  I can succefully install SQL Server as a local or default
named instance.  I have added the client config utility to both nodes
and created a named pipes entry for the virtual server as described in
the KB article http://support.microssoft.com/?id=815431.  This does not
seem to help.  However the errors I am seeing seem to point me to this
article.  The following is the sqlclstr.log.  If anyone has any
thoughts of something I could try I would be very thankful.  Also a
sample of the event log is as follows...

thanks
Chris

Eventlog:
[sqsrvres] ODBC sqldriverconnect failed
[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11;
message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does
not exist or access denied.

SQLClstr.log:
calling ClusterGetComputerNames
ClusterGetComputerNames: m_LocalComputerName=[]
ClusterGetComputerNames: calling GetComputerName
ClusterGetComputerNames: m_LocalComputerName=[PHIF05]
ClusterGetComputerNames: calling ClusterOpenEnum
ClusterGetComputerNames: calling ClusterEnum[0]
ClusterGetComputerNames: calling ClusterEnum[1]
called  ClusterGetComputerNames, status=0x0
CreateSQLResourceTypes: calling ClusterEnum(0)
ClusterEnum(0): enter
ClusterEnum(0): [IP Address]
CreateSQLResourceTypes: called ClusterEnum(0), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(1)
ClusterEnum(1): enter
ClusterEnum(1): [Network Name]
CreateSQLResourceTypes: called ClusterEnum(1), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(2)
ClusterEnum(2): enter
ClusterEnum(2): [Physical Disk]
CreateSQLResourceTypes: called ClusterEnum(2), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(3)
ClusterEnum(3): enter
ClusterEnum(3): [DHCP Service]
CreateSQLResourceTypes: called ClusterEnum(3), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(4)
ClusterEnum(4): enter
ClusterEnum(4): [Distributed Transaction Coordinator]
CreateSQLResourceTypes: called ClusterEnum(4), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(5)
ClusterEnum(5): enter
ClusterEnum(5): [File Share]
CreateSQLResourceTypes: called ClusterEnum(5), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(6)
ClusterEnum(6): enter
ClusterEnum(6): [Generic Application]
CreateSQLResourceTypes: called ClusterEnum(6), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(7)
ClusterEnum(7): enter
ClusterEnum(7): [Generic Script]
CreateSQLResourceTypes: called ClusterEnum(7), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(8)
ClusterEnum(8): enter
ClusterEnum(8): [Generic Service]
CreateSQLResourceTypes: called ClusterEnum(8), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(9)
ClusterEnum(9): enter
ClusterEnum(9): [Local Quorum]
CreateSQLResourceTypes: called ClusterEnum(9), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(10)
ClusterEnum(10): enter
ClusterEnum(10): [Majority Node Set]
CreateSQLResourceTypes: called ClusterEnum(10), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(11)
ClusterEnum(11): enter
ClusterEnum(11): [Microsoft Search Service Instance]
CreateSQLResourceTypes: called ClusterEnum(11), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(12)
ClusterEnum(12): enter
ClusterEnum(12): [MSMQ]
CreateSQLResourceTypes: called ClusterEnum(12), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(13)
ClusterEnum(13): enter
ClusterEnum(13): [Print Spooler]
CreateSQLResourceTypes: called ClusterEnum(13), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(14)
ClusterEnum(14): enter
ClusterEnum(14): [SQL Server]
CreateSQLResourceTypes: called ClusterEnum(14), status=0x0
CreateSQLResourceTypes: calling ClusterEnum(15)
ClusterEnum(15): enter
ClusterEnum(15): [SQL Server Agent]
CreateSQLResourceTypes: called ClusterEnum(15), status=0x0
ClusterGetClusterDiskInfo: i=0
ClusterEnum(0): enter
ClusterEnum(0): [Disk Q:]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: ClusterResourcePhysDiskGetDevNames
ccNodeName=1024 ccGroupName=1024
szNodeName=[PHIF05] szGroupName=[Cluster Group]
csNodeName=[PHIF05] csGroupName=[Cluster Group]
csNodeName=[PHIF05].csGroupName=[Cluster Group]
ClusterGetClusterDiskInfo: i=1
ClusterEnum(1): enter
ClusterEnum(1): [I:\ LogFiles]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: ClusterResourcePhysDiskGetDevNames
ccNodeName=1024 ccGroupName=1024
szNodeName=[PHIF04] szGroupName=[PHIF04_SQLSERVER1]
csNodeName=[PHIF04] csGroupName=[PHIF04_SQLSERVER1]
csNodeName=[PHIF04].csGroupName=[PHIF04_SQLSERVER1]
ClusterGetClusterDiskInfo: i=2
ClusterEnum(2): enter
ClusterEnum(2): [H:\ Data Files]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: ClusterResourcePhysDiskGetDevNames
ccNodeName=1024 ccGroupName=1024
szNodeName=[PHIF04] szGroupName=[PHIF04_SQLSERVER1]
csNodeName=[PHIF04] csGroupName=[PHIF04_SQLSERVER1]
csNodeName=[PHIF04].csGroupName=[PHIF04_SQLSERVER1]
ClusterGetClusterDiskInfo: i=3
ClusterEnum(3): enter
ClusterEnum(3): [K:\ Backups]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: ClusterResourcePhysDiskGetDevNames
ccNodeName=1024 ccGroupName=1024
szNodeName=[PHIF04] szGroupName=[PHIF04_SQLSERVER1]
csNodeName=[PHIF04] csGroupName=[PHIF04_SQLSERVER1]
csNodeName=[PHIF04].csGroupName=[PHIF04_SQLSERVER1]
ClusterGetClusterDiskInfo: i=4
ClusterEnum(4): enter
ClusterEnum(4): [J:\ MSDTC_LogFiles]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: ClusterResourcePhysDiskGetDevNames
ccNodeName=1024 ccGroupName=1024
szNodeName=[PHIF04] szGroupName=[PHIF04_SQLSERVER1]
csNodeName=[PHIF04] csGroupName=[PHIF04_SQLSERVER1]
csNodeName=[PHIF04].csGroupName=[PHIF04_SQLSERVER1]
ClusterGetClusterDiskInfo: i=5
ClusterEnum(5): enter
ClusterEnum(5): [SQL IP Address1(IFORCE01)]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: not a disk
ClusterGetClusterDiskInfo: i=6
ClusterEnum(6): enter
ClusterEnum(6): [SQL Network Name(IFORCE01)]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: not a disk
ClusterGetClusterDiskInfo: i=7
ClusterEnum(7): enter
ClusterEnum(7): [SQL Server]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: not a disk
ClusterGetClusterDiskInfo: i=8
ClusterEnum(8): enter
ClusterEnum(8): [SQL Server Agent]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: not a disk
ClusterGetClusterDiskInfo: i=9
ClusterEnum(9): enter
ClusterEnum(9): [SQL Server Fulltext]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: not a disk
ClusterGetClusterDiskInfo: i=10
ClusterEnum(10): enter
ClusterEnum(10): [Cluster IP Address]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: not a disk
ClusterGetClusterDiskInfo: i=11
ClusterEnum(11): enter
ClusterEnum(11): [Cluster Name]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: not a disk
ClusterGetClusterDiskInfo: i=12
ClusterEnum(12): enter
ClusterEnum(12): [R:\ DataFiles]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo: ClusterResourcePhysDiskGetDevNames
ccNodeName=1024 ccGroupName=1024
szNodeName=[PHIF05] szGroupName=[PHIF05_SQLSERVER2]
csNodeName=[PHIF05] csGroupName=[PHIF05_SQLSERVER2]
csNodeName=[PHIF05].csGroupName=[PHIF05_SQLSERVER2]
ClusterCreateVirtualSQLSvrGroup1: vs->hresNet=0x0
CreateClusterVirtualSQLSvrGroup2: 1381
cConnectString="ODBC;DSN='';DRIVER={SQL
Server};SERVER=PHIF05\IFORCESQL02;DATABASE=master;Trusted_Connection=yes"
ExecuteQuery(command:<declare @srv varchar(255);select @srv =srvname
from master.dbo.sysservers where srvid = 0;exec sp_dropserver @server
=@srv>)
ExecuteQuery(command:<sp_dropserver N'PHIF05\IFORCESQL02'>)
The server 'PHIF05\IFORCESQL02' does not exist. Use sp_helpserver to
show available servers.

ExecuteQuery(command:<sp_dropserver N'PHIF05V\IFORCESQL02'>)
The server 'PHIF05V\IFORCESQL02' does not exist. Use sp_helpserver to
show available servers.

ExecuteQuery(command:<sp_addserver N'PHIF05V\IFORCESQL02', local>)
AddRegistryCheckpointing: enter
AddRegistryCheckpointing: path=0x2f44db8 cb=128
AddRegistryCheckpointing: path=[SOFTWARE\Microsoft\Microsoft SQL
Server\IFORCESQL02\Replication] cb=128
AddRegistryCheckpointing: exit
AddRegistryCheckpointing: enter
AddRegistryCheckpointing: path=0x2f46ea8 cb=134
AddRegistryCheckpointing: path=[SOFTWARE\Microsoft\Microsoft SQL
Server\IFORCESQL02\SQLserverAgent] cb=134
AddRegistryCheckpointing: exit
AddRegistryCheckpointing: enter
AddRegistryCheckpointing: path=0x2f44d28 cb=120
AddRegistryCheckpointing: path=[SOFTWARE\Microsoft\Microsoft SQL
Server\IFORCESQL02\Cluster] cb=120
AddRegistryCheckpointing: exit
AddRegistryCheckpointing: enter
AddRegistryCheckpointing: path=0x2f44c98 cb=128
AddRegistryCheckpointing: path=[SOFTWARE\Microsoft\Microsoft SQL
Server\IFORCESQL02\MSSQLSERVER] cb=128
AddRegistryCheckpointing: exit
AddRegistryCheckpointing: enter
AddRegistryCheckpointing: path=0x2f44a58 cb=124
AddRegistryCheckpointing: path=[SOFTWARE\Microsoft\Microsoft SQL
Server\IFORCESQL02\PROVIDERS] cb=124
AddRegistryCheckpointing: exit
ClusterGroupEnum(0): enter
ClusterGroupEnum(0): [R:\ DataFiles]
ClusterGroupEnum(1): enter
ClusterGroupEnum(1): [T:\ LogFiles2]
ClusterGroupEnum(2): enter
ClusterGroupEnum(2): [U:\ Backups]
ClusterGroupEnum(3): enter
ClusterGroupEnum(3): [S:\ LogFiles]
ClusterGroupEnum(4): enter
ClusterGroupEnum(4): [SQL IP Address1(PHIF05V)]
ClusterGroupEnum(5): enter
ClusterGroupEnum(5): [SQL Network Name(PHIF05V)]
ClusterGroupEnum(6): enter
ClusterGroupEnum(6): [SQL Server (IFORCESQL02)]
ClusterGroupEnum(7): enter
ClusterGroupEnum(7): [SQL Server Agent (IFORCESQL02)]
ClusterGroupEnum(8): enter
ClusterGroupEnum(8): [SQL Server Fulltext (IFORCESQL02)]
ClusterGroupEnum(9): enter
[clushelp.cpp:150] : 259 (0x103): No more data is available.

ClusterGroupEnum(0): enter
ClusterGroupEnum(0): [R:\ DataFiles]
~~~ XXX OnlineClusterResource starts for R:\ DataFiles
~~~ ClusterResourceStart... tick=0, state=2
ClusterGroupEnum(1): enter
ClusterGroupEnum(1): [T:\ LogFiles2]
~~~ XXX OnlineClusterResource starts for T:\ LogFiles2
~~~ ClusterResourceStart... tick=0, state=2
ClusterGroupEnum(2): enter
ClusterGroupEnum(2): [U:\ Backups]
~~~ XXX OnlineClusterResource starts for U:\ Backups
~~~ ClusterResourceStart... tick=0, state=2
ClusterGroupEnum(3): enter
ClusterGroupEnum(3): [S:\ LogFiles]
~~~ XXX OnlineClusterResource starts for S:\ LogFiles
~~~ ClusterResourceStart... tick=0, state=2
ClusterGroupEnum(4): enter
ClusterGroupEnum(4): [SQL IP Address1(PHIF05V)]
~~~ XXX OnlineClusterResource starts for SQL IP Address1(PHIF05V)
~~~ ClusterResourceStart... tick=0, state=129
~~~ ClusterResourceStart... tick=1, state=129
~~~ ClusterResourceStart... tick=2, state=129
~~~ ClusterResourceStart... tick=3, state=2
ClusterGroupEnum(5): enter
ClusterGroupEnum(5): [SQL Network Name(PHIF05V)]
~~~ XXX OnlineClusterResource starts for SQL Network Name(PHIF05V)
~~~ ClusterResourceStart... tick=0, state=129
~~~ ClusterResourceStart... tick=1, state=129
~~~ ClusterResourceStart... tick=2, state=129
~~~ ClusterResourceStart... tick=3, state=129
~~~ ClusterResourceStart... tick=4, state=129
~~~ ClusterResourceStart... tick=5, state=129
~~~ ClusterResourceStart... tick=6, state=129
~~~ ClusterResourceStart... tick=7, state=2
ClusterGroupEnum(6): enter
ClusterGroupEnum(6): [SQL Server (IFORCESQL02)]
~~~ XXX OnlineClusterResource starts for SQL Server (IFORCESQL02)
~~~ ClusterResourceStart... tick=0, state=129
~~~ ClusterResourceStart... tick=1, state=129
~~~ ClusterResourceStart... tick=2, state=129
~~~ ClusterResourceStart... tick=3, state=129
~~~ ClusterResourceStart... tick=4, state=129
~~~ ClusterResourceStart... tick=5, state=129
~~~ ClusterResourceStart... tick=6, state=129
~~~ ClusterResourceStart... tick=7, state=129
~~~ ClusterResourceStart... tick=8, state=129
~~~ ClusterResourceStart... tick=9, state=129
~~~ ClusterResourceStart... tick=10, state=129
~~~ ClusterResourceStart... tick=11, state=129
~~~ ClusterResourceStart... tick=12, state=129
~~~ ClusterResourceStart... tick=13, state=129
~~~ ClusterResourceStart... tick=14, state=129
~~~ ClusterResourceStart... tick=15, state=129
~~~ ClusterResourceStart... tick=16, state=129
~~~ ClusterResourceStart... tick=17, state=129
~~~ ClusterResourceStart... tick=18, state=129
~~~ ClusterResourceStart... tick=19, state=129
~~~ ClusterResourceStart... tick=20, state=129
~~~ ClusterResourceStart... tick=21, state=129
~~~ ClusterResourceStart... tick=22, state=129
~~~ ClusterResourceStart... tick=23, state=129
~~~ ClusterResourceStart... tick=24, state=129
~~~ ClusterResourceStart... tick=25, state=129
~~~ ClusterResourceStart... tick=26, state=129
~~~ ClusterResourceStart... tick=27, state=129
~~~ ClusterResourceStart... tick=28, state=129
~~~ ClusterResourceStart... tick=29, state=129
~~~ ClusterResourceStart... tick=30, state=129
~~~ ClusterResourceStart... tick=31, state=129
~~~ ClusterResourceStart... tick=32, state=129
~~~ ClusterResourceStart... tick=33, state=129
~~~ ClusterResourceStart... tick=34, state=129
~~~ ClusterResourceStart... tick=35, state=129
~~~ ClusterResourceStart... tick=36, state=129
~~~ ClusterResourceStart... tick=37, state=129
~~~ ClusterResourceStart... tick=38, state=129
~~~ ClusterResourceStart... tick=39, state=129
~~~ ClusterResourceStart... tick=40, state=129
~~~ ClusterResourceStart... tick=41, state=129
~~~ ClusterResourceStart... tick=42, state=129
~~~ ClusterResourceStart... tick=43, state=129
~~~ ClusterResourceStart... tick=44, state=129
~~~ ClusterResourceStart... tick=45, state=129
~~~ ClusterResourceStart... tick=46, state=129
~~~ ClusterResourceStart... tick=47, state=129
~~~ ClusterResourceStart... tick=48, state=129
~~~ ClusterResourceStart... tick=49, state=129
~~~ ClusterResourceStart... tick=50, state=129
~~~ ClusterResourceStart... tick=51, state=129
~~~ ClusterResourceStart... tick=52, state=129
~~~ ClusterResourceStart... tick=53, state=129
~~~ ClusterResourceStart... tick=54, state=129
~~~ ClusterResourceStart... tick=55, state=129
~~~ ClusterResourceStart... tick=56, state=129
~~~ ClusterResourceStart... tick=57, state=129
~~~ ClusterResourceStart... tick=58, state=129
~~~ ClusterResourceStart... tick=59, state=129
~~~ ClusterResourceStart... tick=60, state=129
~~~ ClusterResourceStart... tick=61, state=129
~~~ ClusterResourceStart... tick=62, state=129
~~~ ClusterResourceStart... tick=63, state=129
~~~ ClusterResourceStart... tick=64, state=129
~~~ ClusterResourceStart... tick=65, state=129
~~~ ClusterResourceStart... tick=66, state=129
~~~ ClusterResourceStart... tick=67, state=129
~~~ ClusterResourceStart... tick=68, state=129
~~~ ClusterResourceStart... tick=69, state=129
~~~ ClusterResourceStart... tick=70, state=129
~~~ ClusterResourceStart... tick=71, state=129
~~~ ClusterResourceStart... tick=72, state=129
~~~ ClusterResourceStart... tick=73, state=129
~~~ ClusterResourceStart... tick=74, state=129
~~~ ClusterResourceStart... tick=75, state=129
~~~ ClusterResourceStart... tick=76, state=129
~~~ ClusterResourceStart... tick=77, state=129
~~~ ClusterResourceStart... tick=78, state=129
~~~ ClusterResourceStart... tick=79, state=129
~~~ ClusterResourceStart... tick=80, state=129
~~~ ClusterResourceStart... tick=81, state=129
~~~ ClusterResourceStart... tick=82, state=129
~~~ ClusterResourceStart... tick=83, state=129
~~~ ClusterResourceStart... tick=84, state=129
~~~ ClusterResourceStart... tick=85, state=129
~~~ ClusterResourceStart... tick=86, state=129
~~~ ClusterResourceStart... tick=87, state=129
~~~ ClusterResourceStart... tick=88, state=129
~~~ ClusterResourceStart... tick=89, state=129
~~~ ClusterResourceStart... tick=90, state=129
~~~ ClusterResourceStart... tick=91, state=129
~~~ ClusterResourceStart... tick=92, state=129
~~~ ClusterResourceStart... tick=93, state=129
~~~ ClusterResourceStart... tick=94, state=129
~~~ ClusterResourceStart... tick=95, state=129
~~~ ClusterResourceStart... tick=96, state=129
~~~ ClusterResourceStart... tick=97, state=129
~~~ ClusterResourceStart... tick=98, state=129
~~~ ClusterResourceStart... tick=99, state=129
~~~ ClusterResourceStart... tick=100, state=129
~~~ ClusterResourceStart... tick=101, state=129
~~~ ClusterResourceStart... tick=102, state=129
~~~ ClusterResourceStart... tick=103, state=129
~~~ ClusterResourceStart... tick=104, state=129
~~~ ClusterResourceStart... tick=105, state=129
~~~ ClusterResourceStart... tick=106, state=129
~~~ ClusterResourceStart... tick=107, state=129
~~~ ClusterResourceStart... tick=108, state=129
~~~ ClusterResourceStart... tick=109, state=129
~~~ ClusterResourceStart... tick=110, state=129
~~~ ClusterResourceStart... tick=111, state=129
~~~ ClusterResourceStart... tick=112, state=129
~~~ ClusterResourceStart... tick=113, state=129
~~~ ClusterResourceStart... tick=114, state=129
~~~ ClusterResourceStart... tick=115, state=129
~~~ ClusterResourceStart... tick=116, state=129
~~~ ClusterResourceStart... tick=117, state=129
~~~ ClusterResourceStart... tick=118, state=129
~~~ ClusterResourceStart... tick=119, state=129
~~~ ClusterResourceStart... tick=120, state=129
~~~ ClusterResourceStart... tick=121, state=129
~~~ ClusterResourceStart... tick=122, state=129
~~~ ClusterResourceStart... tick=123, state=129
~~~ ClusterResourceStart... tick=124, state=129
~~~ ClusterResourceStart... tick=125, state=129
~~~ ClusterResourceStart... tick=126, state=129
~~~ ClusterResourceStart... tick=127, state=129
~~~ ClusterResourceStart... tick=128, state=129
~~~ ClusterResourceStart... tick=129, state=129
~~~ ClusterResourceStart... tick=130, state=129
~~~ ClusterResourceStart... tick=131, state=129
~~~ ClusterResourceStart... tick=132, state=129
~~~ ClusterResourceStart... tick=133, state=129
~~~ ClusterResourceStart... tick=134, state=129
~~~ ClusterResourceStart... tick=135, state=129
~~~ ClusterResourceStart... tick=136, state=129
~~~ ClusterResourceStart... tick=137, state=129
~~~ ClusterResourceStart... tick=138, state=129
~~~ ClusterResourceStart... tick=139, state=129
~~~ ClusterResourceStart... tick=140, state=129
~~~ ClusterResourceStart... tick=141, state=129
~~~ ClusterResourceStart... tick=142, state=129
~~~ ClusterResourceStart... tick=143, state=129
~~~ ClusterResourceStart... tick=144, state=129
~~~ ClusterResourceStart... tick=145, state=129
~~~ ClusterResourceStart... tick=146, state=129
~~~ ClusterResourceStart... tick=147, state=129
~~~ ClusterResourceStart... tick=148, state=129
~~~ ClusterResourceStart... tick=149, state=129
~~~ ClusterResourceStart... tick=150, state=129
~~~ ClusterResourceStart... tick=151, state=129
~~~ ClusterResourceStart... tick=152, state=129
~~~ ClusterResourceStart... tick=153, state=129
~~~ ClusterResourceStart... tick=154, state=129
~~~ ClusterResourceStart... tick=155, state=129
~~~ ClusterResourceStart... tick=156, state=129
~~~ ClusterResourceStart... tick=157, state=129
~~~ ClusterResourceStart... tick=158, state=129
~~~ ClusterResourceStart... tick=159, state=129
~~~ ClusterResourceStart... tick=160, state=129
~~~ ClusterResourceStart... tick=161, state=129
~~~ ClusterResourceStart... tick=162, state=129
~~~ ClusterResourceStart... tick=163, state=129
~~~ ClusterResourceStart... tick=164, state=129
~~~ ClusterResourceStart... tick=165, state=129
~~~ ClusterResourceStart... tick=166, state=129
~~~ ClusterResourceStart... tick=167, state=129
~~~ ClusterResourceStart... tick=168, state=129
~~~ ClusterResourceStart... tick=169, state=129
~~~ ClusterResourceStart... tick=170, state=129
~~~ ClusterResourceStart... tick=171, state=129
~~~ ClusterResourceStart... tick=172, state=129
~~~ ClusterResourceStart... tick=173, state=129
~~~ ClusterResourceStart... tick=174, state=129
~~~ ClusterResourceStart... tick=175, state=129
~~~ ClusterResourceStart... tick=176, state=129
~~~ ClusterResourceStart... tick=177, state=129
~~~ ClusterResourceStart... tick=178, state=129
~~~ ClusterResourceStart... tick=179, state=129
~~~ ClusterResourceStart... tick=180, state=129
~~~ ClusterResourceStart... tick=181, state=4
~~~ XXX OnlineClusterResource failed
[sqlclusterSetup.cpp:1785] : 0xffffffff (-1): <<<FormatMessage failed:
317>>>
[sqlclusterSetup.cpp:1478] : 50049 (0xc381): <<<FormatMessage failed:
317>>>
~~~  DoClusterSetupWork
about to open cluster
calling ClusterGetComputerNames
ClusterGetComputerNames: m_LocalComputerName=[]
ClusterGetComputerNames: calling GetComputerName
ClusterGetComputerNames: m_LocalComputerName=[PHIF05]
ClusterGetComputerNames: calling ClusterOpenEnum
ClusterGetComputerNames: calling ClusterEnum[0]
ClusterGetComputerNames: calling ClusterEnum[1]
called  ClusterGetComputerNames, status=0x0
ccNodeName=1024 ccGroupName=1024
szNodeName=[PHIF05] szGroupName=[PHIF05_SQLSERVER2]
csNodeName=[PHIF05] csGroupName=[PHIF05_SQLSERVER2]
csNodeName=[PHIF05].csGroupName=[PHIF05_SQLSERVER2]
RemoveRegistryCheckpointing: enter
RemoveRegistryCheckpointing: path=0x2f44ed8 cb=128
RemoveRegistryCheckpointing: path=[SOFTWARE\Microsoft\Microsoft SQL
Server\IFORCESQL02\Replication] cb=128
RemoveRegistryCheckpointing: exit
RemoveRegistryCheckpointing: enter
RemoveRegistryCheckpointing: path=0x2f47090 cb=134
RemoveRegistryCheckpointing: path=[SOFTWARE\Microsoft\Microsoft SQL
Server\IFORCESQL02\SQLserverAgent] cb=134
RemoveRegistryCheckpointing: exit
RemoveRegistryCheckpointing: enter
RemoveRegistryCheckpointing: path=0x2f44e48 cb=120
RemoveRegistryCheckpointing: path=[SOFTWARE\Microsoft\Microsoft SQL
Server\IFORCESQL02\Cluster] cb=120
RemoveRegistryCheckpointing: exit
RemoveRegistryCheckpointing: enter
RemoveRegistryCheckpointing: path=0x2f44db8 cb=128
RemoveRegistryCheckpointing: path=[SOFTWARE\Microsoft\Microsoft SQL
Server\IFORCESQL02\MSSQLSERVER] cb=128
RemoveRegistryCheckpointing: exit
RemoveRegistryCheckpointing: enter
RemoveRegistryCheckpointing: path=0x2f44d28 cb=124
RemoveRegistryCheckpointing: path=[SOFTWARE\Microsoft\Microsoft SQL
Server\IFORCESQL02\PROVIDERS] cb=124
RemoveRegistryCheckpointing: exit
---------------------
DoesGroupContainVSSQL(PHIF05_SQLSERVER2): enter
ClusterGroupEnum(0): enter
ClusterGroupEnum(0): [R:\ DataFiles]
IslastinstanceRemoved enter: ClusterResourceGetType
ClusterGetClusterDiskInfo: -- GetType returns status=0x0
ClusterGroupEnum(1): enter
ClusterGroupEnum(1): [T:\ LogFiles2]
IslastinstanceRemoved enter: ClusterResourceGetType
ClusterGetClusterDiskInfo: -- GetType returns status=0x0
ClusterGroupEnum(2): enter
ClusterGroupEnum(2): [U:\ Backups]
IslastinstanceRemoved enter: ClusterResourceGetType
ClusterGetClusterDiskInfo: -- GetType returns status=0x0
ClusterGroupEnum(3): enter
ClusterGroupEnum(3): [S:\ LogFiles]
IslastinstanceRemoved enter: ClusterResourceGetType
ClusterGetClusterDiskInfo: -- GetType returns status=0x0
ClusterGroupEnum(4): enter
ClusterGroupEnum(4): [SQL IP Address1(PHIF05V)]
IslastinstanceRemoved enter: ClusterResourceGetType
ClusterGetClusterDiskInfo: -- GetType returns status=0x0
ClusterGroupEnum(5): enter
ClusterGroupEnum(5): [SQL Network Name(PHIF05V)]
IslastinstanceRemoved enter: ClusterResourceGetType
ClusterGetClusterDiskInfo: -- GetType returns status=0x0
ClusterGroupEnum(6): enter
[clushelp.cpp:150] : 259 (0x103): No more data is available.

Enum resources completed successfullyCloseEnum successfulCloseGroup
successfulIs Last instance exit successfullyRemove resources completed
successfully
Reply to this Message
Geoff N. Hiten - 23 Feb 2006 16:46 GMT
I have had some problems with cluster installs depending on the version of
SQL 2000 used.  Check your i386 folder creation date on the SQL 2000 CD.  If
it is in the year 2000, you need to obtain new media.  If it is in 2003, we
will need to keep looking for the problem.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

>I am installing an SQL Server 2000 Active Active cluster on a Windows
> 2003 cluster.  I am unable to install the Virtual SQL Server as a Named
[quoted text clipped - 535 lines]
> successfulIs Last instance exit successfullyRemove resources completed
> successfully
Reply to this Message
Chris - 23 Feb 2006 16:54 GMT
It was in the year 2000 so I will try to find a newer version.  If this
fixes it I would have never found this one thanks alot.  I'll keep you
updated.

Chris
Reply to this Message
Geoff N. Hiten - 23 Feb 2006 17:46 GMT
FYI, the fixed version is sometimes called SQL 2000a.  All currently shipped
media is the updated version.  The only change is that the slammer worm
vulnerability has been removed by replacing a single dll.  Windows 2003
looks for the fix and won't allow SQL to activate its network libraries
unless it is patched, hence the need for the named pipes alias during setup.
Sometimes Windows 2003 can be over-eager and not allow installs at all from
the older media.  And yes, this was a real hard one to track down.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> It was in the year 2000 so I will try to find a newer version.  If this
> fixes it I would have never found this one thanks alot.  I'll keep you
> updated.
>
> Chris
Reply to this Message
Chris - 23 Feb 2006 18:24 GMT
Thanks for the update I am coping the 2003 version to the server right
now.  It's a remote server so it's taking awile.  I'll update you when
I finish.  Thanks Again....
Chris
Reply to this Message
Chris - 23 Feb 2006 20:20 GMT
Geoff,

It worked....I can't tell you how happy I am right now.  thanks again
for your help.  I don't now how I would have found that one.

Chris
Reply to this Message
Geoff N. Hiten - 23 Feb 2006 20:37 GMT
You are welcome.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Geoff,
>
> It worked....I can't tell you how happy I am right now.  thanks again
> for your help.  I don't now how I would have found that one.
>
> Chris
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.