Dear all I've installed SQL Server 2005 on a cluster. But I can't see the management studio (enterprise mangaer) Where do I need to look? Note: Workstation components/BOL/Dev Tools didn't install correctly - I think due to Notification services didn't install (failed - no transaction manager). Do I need to install SQL Server on the other node (physical machine) as well? Thanks
If you install SQL2005 on a cluster, you need to install the client-components on both nodes ! (at least one node requieres the extra client install (=workstationcomponents)) Investigate why the NS-install failed, as well as why the workstationcomponents install failed. The logfiles can be found in Crogram FilesMicrosoft SQL Server90Setup BootstrapLOG.
That Notification Services is dependant on settings on the server such as that should be allowded the all ICMP option from advance option. >>Administrative Tools>>Component Services>> Computers>> Right Click>> Prpoerties. 1 Allow inbound 2 allow outbound 3 allow remote clients 4 Allow remote administration 5 Enable TIP transactions. 6 Enable XA transaction
I have installed SQL Server 2005 on one node. I don't need notification services. 1) I then installed workstation components but can't register the SQL cluster. How do I register the cluster?? 2) Do I need to install the same SQL Server cluster on the other node or just the workstation components?
http://technet.microsoft.com/en-us/library/ms143219.aspx http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx http://www.sql-server-performance.c...talling_sql_clustering_virtual_server_p1.aspx - fyi in case need to use virtual server. Check the above links for process & procedure.
- Check out the refs Satya posted [H] ! - on the other node you only need to install the workstation components (=client)
Thanks everyone - Thanks to alzdba too. I will install the workstation clients on the other node (physical machine). I'll let you know if I can get it to failover etc.
See http://www.sql-server-performance.com/articles/clustering/test_sql_2000_cluster_p1.aspx that is still applicable to 2005 in this case.
I get erro when trying to create maintenance plans!! It says I should install SQL Server 2005 Management Tools - Any idea on how to do this?? Thanks
It means the client tools are not installed properly or not upto date with service packs, check it out.
I've been asked to install SQL Server 2005 service pack 1 - The SQL Cluster is version 9.00.2047. Should I install later version - or doesn't it matter for service pack 1? I've rebooted both nodes (physical machines) and still get the same problem. What else can I check?
SP2 has more fixes towards maintenance plans, so better test and depoly them. FYi http://sqlserver-qa.net/blogs/tools...ate-4-for-sql-server-2005-service-pack-2.aspx on the service pack builds.
If you can, go for SP2 (bugfixes + changes to gui !! + performance dashboard (add-on) ) + cumulative update 2 or 3 (KB939537) It runs fine overhere.