Export (0) Print
Expand All

Using SQL Server Tools with Failover Clustering (64-bit)

SQL Server 2000

  This topic applies only to SQL Server 2000 (64-bit).

You can use Microsoft® SQL Server™ 2000 (64-bit) failover clustering with a variety of SQL Server tools and services. However, to get some of the SQL Server 2000 tools and services, you must install them on a 32-bit computer and administer them remotely. Review the following usage considerations.

Full-Text Queries: Available on SQL Server 2000 (64-bit)

To use the Microsoft Search service to perform full-text queries with failover clustering, consider the following:

  • An instance of SQL Server 2000 (64-bit) must run on the same system account on all failover cluster nodes in order for full-text queries to work on failover clusters. Note that this is a general requirement of failover clustering, and is not specific to Microsoft Search service.

  • You must change the start-up account for SQL Server 2000 (64-bit) in the failover cluster using SQL Server Enterprise Manager. If you use Control Panel or the Services Application in the 64-bit versions of the Windows® Server 2003 family, you will break the full-text configuration for SQL Server.
SQL Server Enterprise Manager: Only Available on SQL Server 2000 (32-bit)

To use SQL Server Enterprise Manager with failover clustering, consider the following:

  • You must change the start-up account for SQL Server 2000 (64-bit) in the failover cluster by using SQL Server Enterprise Manager. If you use Control Panel or the Services Application in the 64-bit versions of the Windows Server 2003 family, you could break your server configuration.

  • When creating or altering databases, you will only be able to view the cluster disks for the local virtual server.

  • If you are browsing a table through SQL Server Enterprise Manager and lose the connection to SQL Server during a failover, you will see the error message, "Communication Link Failure." You must press the ESCAPE key and undo the changes to exit out of the SQL Server Enterprise Manager window. You cannot click Run Query, save any changes, or edit the grid.

  • If you use SQL Server Enterprise Manager to reset the properties of the SQL Server service account, you will be prompted to restart SQL Server. When SQL Server is running in a failover cluster configuration, this will bring the full text and SQL Agent resources offline, as well as SQL Server. However, when SQL Server is restarted, it will not bring the full text or SQL Agent resources back online. You must start those resources manually using the Windows Cluster Administrator utility.
Service Control Manager: Available on SQL Server 2000 (64-bit)

Use the Service Control Manager to start or stop a clustered instance of SQL Server. You cannot pause a clustered instance of SQL Server.

SQL Profiler: Only Available on SQL Server 2000 (32-bit)

You can use SQL Profiler with failover clustering. However, if you experience a failover on a server where you are running a SQL Profiler trace, you must restart the trace when the server is back online to continue tracing.

SQL Query Analyzer: Only Available on SQL Server 2000 (32-bit)

You can use SQL Query Analyzer with failover clustering. However, if you experience a failover on a server where you are executing a query, you must restart the query when the server is back online to continue execution.

SQL Mail: Not Available on SQL Server 2000 (64-bit)

You cannot use SQL Mail with SQL Server 2000 (64-bit). However, SQL Agent Mail in SQL Server 2000 (64-bit) can be configured remotely by Enterprise Manager, if your client remotely connects using SQL Server 2000 Service Pack 3.0 or later. For more information, see Differences Between 64-bit and 32-bit Releases (64-bit).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft