sql server cluster resource failed to come online

#11

Addendum:

cluster log entry:

"connection string server does not exist"
The connection string contains the name of the
<physical server>\<sqlinstance>

The connection string should contain the name of the
<Virtual server>\<sqlinstance>

How can I fix this entry?

MJ

"mj" wrote:

Quote:

OS: Windows Server 2003
SQL Server: SQL Server 2000 Enterprise Edition
Environment: Development

Summary:
2 node Windows cluster has been (verified and active)
Successfully installed slq server 2005 - on node 1 and node 2
Uninstalled sql server 2005
Uninstall cluster
Successfully Install 2 node Windows cluster (verified)

Install sql server 2000 client utility
create pipe connection

Install sql server 2000 on node 1

Install does not complete.... error message: cluster resource fails
Note: DO NOT AKnowlage error message!!!!!!!! Aknowledging error message
rolls back the installation and removes sql error logs.

open cluster administrator
bring sql server on line - fails

Open sql server Error logs
SQL Server successfully installed on node 1
open MyComputer
mssqlserver start - login cluster account
mssqlagent - will not start

open
cluster logs
odbc error

Open administrative tools | odbc
create odbc connection (pipes) connection successful
create odbc connection (TCP) connection Failed

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

sql server cluster resource failed to come online

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

RE: sql server cluster resource failed to come online - 03-06-2008 , 08:16 AM