SQL Server - Problems with sql 2k8 on windows 2k8 install
Asked By Mark Broadbent
18-Nov-09 07:29 AM
Installed the first node and it appeared that the installation only
installed to the first physical node?! dont remember seeing a physical node
selection (as per sql2k5 clustering) so have uninstalled (via remove node)
and then add/remove programs to try again. uninstall fine but now when
attempting to install, cluster still thinks the network name is already in
use -as I type I think this might be old entries in DNS perhaps.
However should I resolve that issue, am I missing the node selection screen?
Is there a simple doc I could reference for sql 2k8 -Im pretty much an
expert in sql 2k5/w2k3..
cheers.
SQL Server
(1)
Hiten
(1)
Windows
(1)
Sql2k5
(1)
RTFM
(1)
Days
(1)
DNS
(1)
Geoff N. Hiten replied to Mark Broadbent
The installer for SQL 2008 clustering is very different than the previous
versions. Short version is the installer only installs one node at a time.
There are installer options to create the failover cluster instance and to
add a node to a failover cluster instance. The remote install that created
the other nodes is not in SQL 2008.
BOL goes over this in pretty decent detail.
--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP
Mark Broadbent replied to Geoff N. Hiten
Geoff thanks. I guess it was a case of RTFM, but unfortunately everyone else
had overrun the project which left me a couple of days to get this all
sorted.
I arrived at your conclusion unfortunately after blowing away the first node
install but its finally all going after running into a few other issues.
SQL Server 2008 cluster- Missing SQL Agent Cluster Resource SQL Server We built a SQL Server 2008 two node failover cluster (Operating System: Windows Server 2008). The SQL Server Resource is working but the SQL Server Agent-cluster resource is
SQL Server and File Server SQL Server Hi, Can someone give me an opinion with installing SQL Server 2005 with clustering and use those servers for file servers at the same time. Thanks Jacques SQL Server Clustering Discussions SQL Server 2005 (1) SQL Server (1) Windows Server (1) SharePoint (1
SQL Cluster Tool installation SQL Server Environment: SQL Server Editions: SQL Server 2000, SP 4 SQL Server 2005, SP 2 with Cummulations Hotfix (kb918222) O.S. Windows 2003 Server R2, SP
Moving SQL Server 2000 to a new Virtual Server SQL Server Hi, I am moving the default instance of a SQL Server 2000 to a ESX Server running on VMWare. Below are the specifications: Current Server: SQL Server 2000 Enterprise Edition Version
Moving DB's to a new server SQL Server SQL Server 2000. As I move databases from the old QA server, to the new one, I'm wondering if there are going to be any "Gotcha s". I've restored the databases and am copying the SQL agent jobs from the old server. I have a vague recolection about user accounts being a issue sometimes, but I don