SQL Instance won't come online -- sql server clustering

Squerb
10/19/2004 3:43:02 PM

Hi there,

I have a two node cluster Win 2k with SP4 and SQL 2k with SP3. There are
two instances of SQL. The primary instance comes up just fine. The
secondary does not come up all of the disk, IP, and name resources load, but
the SQL Server resource will not. I have been able to get it to load by
opening the SQL Server Client Network Utility and putting in a Named Pipes
Alias for the instance. When I do this the clusetered instance comes online,
but I cannot access it from any clients.

Mike Epprecht (SQL MVP)
10/19/2004 10:39:03 PM

Hi

Run "svrnetcn.exe" on the secondary instance and make sure that both TCP/IP
and Named Pipes are enabled.

On the Secondary, whan she starts, are there any errors in the SQL Log?

Regards
Mike

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : SQL Instance won't come online