Hi All,
I'm trying to install SQL 2000 (with SP3A) on a Windows 2003 Clustered
environment (AMD64). This is a two node cluster, and SQL is being
installed as a named instance. I've checked the following:
* Using a domain account that is part of the Local Administrators group
* Changed all Cluster Resources, as per the Microsoft article
http://support.microsoft.com/kb/302491/en-us
* Unregistered / Registered gathercl.dll files
* Created an alias, as per Microsoft Article 815431
* Checked to ensure I have the "Impersonate a Client
AfterAuthentication" User Right".
I am using SQL 2000, which does not appear to be the 2000a version.
I'm trying to get a hold of that version to see if that makes a
difference.
I'm getting the message "The Cluster resource failed to come online. If
extended error information was reported by the clustering service it
can be obtained from the event log."
The following is a snipit from the sqlcstr.log file:
~~~ 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=2
ClusterGroupEnum(4): enter
ClusterGroupEnum(4): [SQL Server (DEV)]
~~~ XXX OnlineClusterResource starts for SQL Server (DEV)
~~~ 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
.....etc, etc...
~~~ ClusterResourceStart... tick=177, state=129
~~~ ClusterResourceStart... tick=178, state=129
~~~ ClusterResourceStart... tick=179, state=129
~~~ ClusterResourceStart... tick=180, 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
And from the sqlstp.log a snipit from the log where the error occurs:
22:40:40 Begin Action : CreateVirtualServerResources
22:44:53 End Action : CreateVirtualServerResources
22:45:04 The cluster resource failed to come online.If extended error
information was reported by the clustering service it can be obtained
from the event log.
22:45:17 DoUnClusterInstance returned: 0
22:45:17 Begin Action : ClusterErrorCleanup
If anyone has come across the same problem or has any further
suggestions, it would be greatly appreciated.
Thanks!
This definitely looks like a lack of SQL 2000a. You are on the right track
for a solution.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"sqlclusterhelp" <misty.pratt@.gmail.com> wrote in message
news:1141903642.020512.35280@.u72g2000cwu.googlegro ups.com...
> Hi All,
> I'm trying to install SQL 2000 (with SP3A) on a Windows 2003 Clustered
> environment (AMD64). This is a two node cluster, and SQL is being
> installed as a named instance. I've checked the following:
> * Using a domain account that is part of the Local Administrators group
> * Changed all Cluster Resources, as per the Microsoft article
> http://support.microsoft.com/kb/302491/en-us
> * Unregistered / Registered gathercl.dll files
> * Created an alias, as per Microsoft Article 815431
> * Checked to ensure I have the "Impersonate a Client
> AfterAuthentication" User Right".
> I am using SQL 2000, which does not appear to be the 2000a version.
> I'm trying to get a hold of that version to see if that makes a
> difference.
> I'm getting the message "The Cluster resource failed to come online. If
> extended error information was reported by the clustering service it
> can be obtained from the event log."
> The following is a snipit from the sqlcstr.log file:
> ----
> ~~~ 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=2
> ClusterGroupEnum(4): enter
> ClusterGroupEnum(4): [SQL Server (DEV)]
> ~~~ XXX OnlineClusterResource starts for SQL Server (DEV)
> ~~~ 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
> ....etc, etc...
> ~~~ ClusterResourceStart... tick=177, state=129
> ~~~ ClusterResourceStart... tick=178, state=129
> ~~~ ClusterResourceStart... tick=179, state=129
> ~~~ ClusterResourceStart... tick=180, 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
> ----
> And from the sqlstp.log a snipit from the log where the error occurs:
> ----
> 22:40:40 Begin Action : CreateVirtualServerResources
> 22:44:53 End Action : CreateVirtualServerResources
> 22:45:04 The cluster resource failed to come online.If extended error
> information was reported by the clustering service it can be obtained
> from the event log.
> 22:45:17 DoUnClusterInstance returned: 0
> 22:45:17 Begin Action : ClusterErrorCleanup
> ----
>
> If anyone has come across the same problem or has any further
> suggestions, it would be greatly appreciated.
>
> Thanks!
>
|||Great thanks.
I've heard that the ssnetlib.dll is the main file that differs between
SQL 2000 and SQL 2000a - do you happen to know if there is anyway to
convert a copy of SQL 2000 to SQL 2000a, so to speak? When I have a
look at my copy of SQL 2000 the dates for this dll file are all 2000
under the x86 install directory. Whereas the ssnetlib.dll file under
SP3a and SP4 are all post 2000. I'm guessing its not possible to
replace the appropriate files from the SP3a directory into the base SQL
2000 directory to perform the base installation!? The only reason I
ask, is because my copy of SQL is actually being provided by a third
party company wherein their application uses Microsoft SQL. The only
version of SQL 2000 they provide is the non-SQL 2000a copy.
Thanks!
|||Actually, the SQL2000a CD is exactly the same as the SQL 2000 CD with that
one file changed. You can copy the file to a folder on your hard disk,
replace that one DLL file, and you are good to go.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"sqlclusterhelp" <misty.pratt@.gmail.com> wrote in message
news:1141996748.942787.222080@.e56g2000cwe.googlegr oups.com...
> Great thanks.
> I've heard that the ssnetlib.dll is the main file that differs between
> SQL 2000 and SQL 2000a - do you happen to know if there is anyway to
> convert a copy of SQL 2000 to SQL 2000a, so to speak? When I have a
> look at my copy of SQL 2000 the dates for this dll file are all 2000
> under the x86 install directory. Whereas the ssnetlib.dll file under
> SP3a and SP4 are all post 2000. I'm guessing its not possible to
> replace the appropriate files from the SP3a directory into the base SQL
> 2000 directory to perform the base installation!? The only reason I
> ask, is because my copy of SQL is actually being provided by a third
> party company wherein their application uses Microsoft SQL. The only
> version of SQL 2000 they provide is the non-SQL 2000a copy.
> Thanks!
>
|||Hmmm... as far as I recall, SQL2000 RTM has always worked for me. You just
have to remember to apply the service pack as soon as you have done the
SQL2000 RTM install. I have not used SQL2000a in any of the enviornment.
Linchi
"sqlclusterhelp" wrote:
> Hi All,
> I'm trying to install SQL 2000 (with SP3A) on a Windows 2003 Clustered
> environment (AMD64). This is a two node cluster, and SQL is being
> installed as a named instance. I've checked the following:
> * Using a domain account that is part of the Local Administrators group
> * Changed all Cluster Resources, as per the Microsoft article
> http://support.microsoft.com/kb/302491/en-us
> * Unregistered / Registered gathercl.dll files
> * Created an alias, as per Microsoft Article 815431
> * Checked to ensure I have the "Impersonate a Client
> AfterAuthentication" User Right".
> I am using SQL 2000, which does not appear to be the 2000a version.
> I'm trying to get a hold of that version to see if that makes a
> difference.
> I'm getting the message "The Cluster resource failed to come online. If
> extended error information was reported by the clustering service it
> can be obtained from the event log."
> The following is a snipit from the sqlcstr.log file:
> ----
> ~~~ 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=2
> ClusterGroupEnum(4): enter
> ClusterGroupEnum(4): [SQL Server (DEV)]
> ~~~ XXX OnlineClusterResource starts for SQL Server (DEV)
> ~~~ 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
> .....etc, etc...
> ~~~ ClusterResourceStart... tick=177, state=129
> ~~~ ClusterResourceStart... tick=178, state=129
> ~~~ ClusterResourceStart... tick=179, state=129
> ~~~ ClusterResourceStart... tick=180, 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
> ----
> And from the sqlstp.log a snipit from the log where the error occurs:
> ----
> 22:40:40 Begin Action : CreateVirtualServerResources
> 22:44:53 End Action : CreateVirtualServerResources
> 22:45:04 The cluster resource failed to come online.If extended error
> information was reported by the clustering service it can be obtained
> from the event log.
> 22:45:17 DoUnClusterInstance returned: 0
> 22:45:17 Begin Action : ClusterErrorCleanup
> ----
>
> If anyone has come across the same problem or has any further
> suggestions, it would be greatly appreciated.
>
> Thanks!
>
|||I have had some issues where SQL 2000 RTM doesn't install well on Windows
Server 2003. Moving to SQL 2000a always has solved the issue. I make it a
point to search all media when I arrive at a place and discard any SQL 2000
RTM disks and replace them with SQL 2000a CDs.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:4DEB7B17-172F-4EE3-8F12-4BCBF1E7C9E6@.microsoft.com...[vbcol=seagreen]
> Hmmm... as far as I recall, SQL2000 RTM has always worked for me. You just
> have to remember to apply the service pack as soon as you have done the
> SQL2000 RTM install. I have not used SQL2000a in any of the enviornment.
> Linchi
> "sqlclusterhelp" wrote:
|||I replaced the ssnetlib.dll in the base 2000 installation path, with
the one that was in the SP4 path. I tried the installation again, it
sat there for about 30 minutes and then displayed "Setup failed to
perform required operations on the cluster nodes." From the SQLSTP
file on Node A i'm getting:
1.sqlsetup=Y
1.copyexe=cnvsvc2.exe
13:10:06 Setup is performing required operations on cluster nodes.
This may take a few minutes...
13:10:06 C:\TEMP\SqlSetup\Bin\remsetup.exe C:\WINDOWS\remsetup.ini
13:41:49 Process Exit Code: (1460) This operation returned because the
timeout period expired.
13:41:49 Begin Action : GetRemsetupRetCode
13:41:49 Installation return status on RYOSAP01 : -1
13:41:49 Installation return status on RYOSAP02 : 0
13:41:49 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 03/11/06 13:10:06 ####
(just taken from the part that seems to be causing the problem).
I've had a look around other posted messages to get a feel for what the
problem might be. I am using an account that is part of the Local
Administrators, i've logged into both machines with this account, i've
changed all TMP and TEMP variables to C:\TEMP (which exists) on both
servers. I've tried pinging the cluster and get a fast response (so
doesn't look like name resolution problems). Trying to look at the
sqlstp7.log file, i'm getting the message "The process cannot access
the file because it is being used by another process". This time it
seems that a MSSQL$DEV service has been created, but all resources in
the cluster have been cleaned up.
I've noticed some other suggestions, ie. add the virtual server to the
HOSTS file (but I don't think I have a name resolution problem), which
I haven't tried yet. I'm using RDP to connect to the servers, do you
think this could cause issues?
I specified I drive for my data files, and under I:\Program Files
(x86)\Microsoft SQL Server\MSSQL$DEV\LOG looking at the ERRORLOG file I
find:
2006-03-11 13:10:49.71 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2006-03-11 13:10:49.79 server Attempting to initialize Distributed
Transaction Coordinator.
2006-03-11 13:11:03.41 spid2 Warning ******************
2006-03-11 13:11:03.41 spid2 SQL Server started in single user
mode. Updates allowed to system catalogs.
2006-03-11 13:11:03.42 spid2 Starting up database 'master'.
2006-03-11 13:11:03.44 server Error: 17822, Severity: 16, State: 1
2006-03-11 13:11:03.44 server Could not load Net-Library
'SSNETLIB'..
2006-03-11 13:11:03.44 server Error: 17059, Severity: 18, State: 0
2006-03-11 13:11:03.44 server Operating system error 126: The
specified module could not be found...
2006-03-11 13:11:03.44 server Unable to load any NETLIBs. Server
shutting down.
... and then the installation uninstalls everything...
Do you happen to have any suggestions? I will continue to have a good
look through all the logs, its just that when I saw this errorlog I
presume the install might have failed because I replaced the dll file
(mind you it seemed to get a lot further then it was before).
Thanks!
|||RDP can cause install failures if you don't use the /console option to get
to the physical console.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"sqlclusterhelp" <misty.pratt@.gmail.com> wrote in message
news:1142050472.049607.51360@.u72g2000cwu.googlegro ups.com...
>I replaced the ssnetlib.dll in the base 2000 installation path, with
> the one that was in the SP4 path. I tried the installation again, it
> sat there for about 30 minutes and then displayed "Setup failed to
> perform required operations on the cluster nodes." From the SQLSTP
> file on Node A i'm getting:
> 1.sqlsetup=Y
> 1.copyexe=cnvsvc2.exe
> 13:10:06 Setup is performing required operations on cluster nodes.
> This may take a few minutes...
> 13:10:06 C:\TEMP\SqlSetup\Bin\remsetup.exe C:\WINDOWS\remsetup.ini
> 13:41:49 Process Exit Code: (1460) This operation returned because the
> timeout period expired.
> 13:41:49 Begin Action : GetRemsetupRetCode
> 13:41:49 Installation return status on RYOSAP01 : -1
> 13:41:49 Installation return status on RYOSAP02 : 0
> 13:41:49 End Action : GetRemsetupRetCode
> #### SQL Server Remote Setup - Start Time 03/11/06 13:10:06 ####
>
> (just taken from the part that seems to be causing the problem).
> I've had a look around other posted messages to get a feel for what the
> problem might be. I am using an account that is part of the Local
> Administrators, i've logged into both machines with this account, i've
> changed all TMP and TEMP variables to C:\TEMP (which exists) on both
> servers. I've tried pinging the cluster and get a fast response (so
> doesn't look like name resolution problems). Trying to look at the
> sqlstp7.log file, i'm getting the message "The process cannot access
> the file because it is being used by another process". This time it
> seems that a MSSQL$DEV service has been created, but all resources in
> the cluster have been cleaned up.
> I've noticed some other suggestions, ie. add the virtual server to the
> HOSTS file (but I don't think I have a name resolution problem), which
> I haven't tried yet. I'm using RDP to connect to the servers, do you
> think this could cause issues?
> I specified I drive for my data files, and under I:\Program Files
> (x86)\Microsoft SQL Server\MSSQL$DEV\LOG looking at the ERRORLOG file I
> find:
> 2006-03-11 13:10:49.71 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2006-03-11 13:10:49.79 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2006-03-11 13:11:03.41 spid2 Warning ******************
> 2006-03-11 13:11:03.41 spid2 SQL Server started in single user
> mode. Updates allowed to system catalogs.
> 2006-03-11 13:11:03.42 spid2 Starting up database 'master'.
> 2006-03-11 13:11:03.44 server Error: 17822, Severity: 16, State: 1
> 2006-03-11 13:11:03.44 server Could not load Net-Library
> 'SSNETLIB'..
> 2006-03-11 13:11:03.44 server Error: 17059, Severity: 18, State: 0
> 2006-03-11 13:11:03.44 server Operating system error 126: The
> specified module could not be found...
> 2006-03-11 13:11:03.44 server Unable to load any NETLIBs. Server
> shutting down.
> ... and then the installation uninstalls everything...
> Do you happen to have any suggestions? I will continue to have a good
> look through all the logs, its just that when I saw this errorlog I
> presume the install might have failed because I replaced the dll file
> (mind you it seemed to get a lot further then it was before).
> Thanks!
>
|||I have been using the /console option for all of the installs, so I
guess that shouldn't be the reason. I'm thinking that perhaps using
the ssnetlib.dll file from the SP4 directory could of caused the
problem. Do you happen to know if Microsoft provides a copy of the
updated ssnetlib.dll file that should be used (ie. the 2000a version -
from the standard x86 install parth, not the SP3a or SP4 versions) to
save having to find a whole new copy of SQL?
I might try and perform an install on one node and then apply SP3a then
install on the second node... its worth a shot! Failing that i'm
thinking of cutting my loses and installing SQL 2005 instead. :-)
|||The other option might be to install the SQL Client on both machines
and then install the SP3a or SP4. Reboot the cluster make sure that
both nodes have the correct alias's setup then try to install the SQL
Server 2000 again. By the way all of the attempts that you have tried
did you do a uninstall or cleanup of the registry? At this point you
might want to think about reinstalling the OS to cleanup the Registry
there may be something messed up there causing the problem.
Chris
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment