I have been working as SQL server DBA on standalone
servers for about 3 years. I have been using SQL Server
2K Personal Ed. on my pc to do most development and to
register standalone test servers. I have never worked in
a Clustered environment. I have recently been put in a
SQL Server 2K Clustered environment, with little to no
help. I know how to register a standalone server from my
pc via SQL Server Personal Ed., but do not know how to
register or access a SQL Server in a clustered
environment. What must be done to access the Clustered
Server. I have been developing a database on my pc on
Personal Ed. and need to migrate the database to the
Cluster. Since MSCS runs only on Windows 2000 Advanced
and Datacenter OS, How do I, or, do I need access MSCS?

Thanks for all your help!

To be able to access a SQL Server via tools like Query analyzer or SQL
Enterprise Manager, one does not have to do anything different if SQL
Server is clustered. The only difference is that you will be using the
Virtual Server name instead of the computer name.
Look at the SQL Server errorlog (located on the shared drive) or the
cluster administrator to determine the Virtual Server Name. Then register
the server in ENterprise Manager using this Virtual Server Name. When
connecting via Query Analyzer, use this Virtual SQL Server name.

The following whitepaper may be useful to you.
SQL Server 2000 Whitepaper on Failover Clustering
http://www.microsoft.com/technet/tre...hnet/prodtechn
ol/sql/deploy/confeat/failclus.asp


Thanks
Deepali

This posting is provided "AS IS" with no warranties, and confers no rights

Same way as standalone server - difference is that you don't need to know on which node SQL is running..
You will register SQL through VirtualServerName for default instance and VirtualServerName\InstanceName for named instanc

rgd
Sinisa