RE: SQLBrowser Error installing SQL2005 Failover Cluster -x64

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello, You need to check the cluster logs and the installation logs.

install logs are here
%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt

cluster logs are here.
C:\WINDOWS\Cluster\cluster.log

However see your installation setup my I suggest that you visit the SQL
server best practies site? as having all the data and logs on one drive is
really a bad idea not to mention having tempdb and your database data files
on the same drive. Any way here is the link you really need to think about
how the server is setup now so

here is how the ops guys at microsoft do things
http://www.microsoft.com/technet/itshowcase/content/dbopsmstsb.mspx

here are the storage best practices
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx

I hope this helps
John Vandervliet

"9146fan@xxxxxxxxx" wrote:

I am having trouble installing a brand new SQL2005 Cluster.

Servers: DL585's, AMD x64, Windows 2003 Enterprise X64 with SP2
SQL: SQL 2005 Enterprise x64 (attempting to install anyways)
Disks on each machine:
C: OS
D: Stuff
Shared Disks: (via EMC ICSCI)
M: (MSDTC Shared Disk)
Q: Cluster Quorum
X: SQL2005 Instance shared disk (for tempdb, master, etc..)

So, I have MSCS setup with only one active node.

CLUSTER GROUP

Cluster IP, Network Name (Keberos and DNS Regsitration) and Quorum
Disk

MSDTC GROUP

MSDTC IP
MSDTC Network Name (Keberos and DNS Registration)
MSDTC Log disk (M:)
MSDTC Service

STGDBVS1 (Staging Database VS1)

Shared Drive (X:) where the tempdb,master, msdb,etc... databases are
kept)


So, I run through the install.

1. I select Database Engine and Failover cluster
2. It takes me through the GUI in setting up (adding IP, chosing
resource group, etc..)
3. Near the end, it tries to start the SQLBrowser, which fails to
start

If I look in the Cluster Admin, I see the SQL IP and SQL Name but no
SQL Server Database Resource (or Agent) and none of them are started.

Can someone help? Seems like a "catch-22" as I don't even want to use
the SQL Browser (we will connect by name and port number).


.

Relevant Pages

  • Re: I Surrender.....Help?
    ... Name resolution is critical to cluster ... Verify the Edition of SQL you are installing. ... Install the SQL client tools only on your primary install node. ... account is a domain account with local admin rights on each node. ...
    (microsoft.public.sqlserver.clustering)
  • Re: sql 2005 cluster setup questions
    ... Thanks again, Geoff. ... Here is the official instructions on how to rip SQL 2005 out by the roots. ... to 2nd node to install work station component, ... want to take Microsoft recommended approach not to cluster SSIS but I ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... http://www.clusterhelp.com - Cluster Training ... actually do the install to catch that one. ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... Setup is supposed to install client tools on all nodes. ... Microsoft SQL Server MVP ... the first instance on the cluster. ...
    (microsoft.public.sqlserver.clustering)