Hello group,
today we tried to install a SQL 2k cluster very unsuccessfully. Would
need your support.
What we have:
2 Server (node 1, node 2) with external storage installed as a cluster
(MSCS). Partitions are C (for node 1 and 2), e and q (quorum db) - both
on the external storage.
OS is Windows 2003 Enterprise
We copied the installfiles to C:\temp on node1 and made a share. Node2
can access this share.
Antivirus was disabled.
We started the installation with a domainaccount that has local
administrative rights on both nodes and can be started as a service.
As installation target for the program we chosed C:... and the data
should be stored on e:...
Installation started - we gave the virtual server a different name than
the cluster and a free ip adress. Both nodes were seen during the next
steps and we gave an instancename like "DECGNWSSQL20007". Licensing was
choosen as 2CPU.
When the server should start the installation, it immediately stopped
with the message: Setup failed to perform required operations on the
cluster nodes.
We don=B4t have any clue how to continue. Could need your help.
Thanks in advance
Stefan
The error message "Setup failed to perform required operations on the cluster nodes." is a generic message. To understand where the setup failed, one has to review the sqlstp.log (search for this on the node
where you ran the setup). Based on this file, you will know where the error occurred and then accordingly you may need to review additional logs like sqlstpN.log (where N is an integer) on one/both nodes,
sqlclstr.log, cluster.log.
For detailed information on troubleshooting setup failures on cluster, please review
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
The above webcast may not give you the solution but will give you steps that you can use to troubleshoot and find the solution using Microsoft Knowledge Base articles.
Also, make sure that you have all the pre-reqs of installing SQL 2K on Win2K3. A list of pre-reqs and other related info can be found at
TechNet Support WebCast: How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
http://support.microsoft.com/default...b;en-us;888121
If you need more help, feel free to post your questions.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Hi,
what IU inbetween found out is that the installed Terminal Server caused
the problems. Now the installation starts fine, runs and finishes with
the message that the "Virtual server cannot go online". Then the
uninstall started automatically. Do you know more about this problem? Is
it why we try to install SP2 first and then to update to SP3?
Thanks in advance
Stefan
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||You cannot run a SQL Cluster and Terminal Server on the same system.
SQL Server 2000 cluster does not install on Windows Server 2003-based
computers where Terminal Services is installed
http://support.microsoft.com/default...b;en-us;301520
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Stefan Gsundbrunn" <info@.gsundbrunn.de> wrote in message
news:uPYXood7EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Hi,
> what IU inbetween found out is that the installed Terminal Server caused
> the problems. Now the installation starts fine, runs and finishes with
> the message that the "Virtual server cannot go online". Then the
> uninstall started automatically. Do you know more about this problem? Is
> it why we try to install SP2 first and then to update to SP3?
> Thanks in advance
> Stefan
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Hi,
> You cannot run a SQL Cluster and Terminal Server on the same system.
Yes, as mentioned I deinstalled Terminal Server and then the installation
started. But: At the end of the installation the message appeared like
"Virtual server cannot go online" and automatically the desintallation
starts. I don′t have any clue for the reason. Does anybody know how to fix?
Thanks in advance!
Stefan
> SQL Server 2000 cluster does not install on Windows Server 2003-based
> computers where Terminal Services is installed
> http://support.microsoft.com/default...b;en-us;301520
>
--
Stefan Gsundbrunn
Project Design - Software Design - Brain Design
http://www.gsundbrunn.de
Cell: +49.173.3426906
|||Stefan,
Looks like the unattended installation on all cluster nodes succeeded and failed during the virtual resources creation step. Ofcourse check sqlstp.log to find out where exactly the issue is. If indeed it failed during the
virtual server resources section then you will need to review sqlclstr.log and cluster.log to get to the root cause.
Additional Information
=====================
TechNet Support WebCast:
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
http://support.microsoft.com/default...b;en-us;888121
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment