all groups > sql server clustering > august 2007 >
You're in the

sql server clustering

group:

Join SQL cluster process always jump out of the screen


RE: Join SQL cluster process always jump out of the screen (JR) Jorge Rivera
8/23/2007 9:56:04 AM
sql server clustering:
Hi

The account used to install the SQL have the next permissions, is local
admin in both nodes, logon as service, act as a part of S.O., lock pages in
memory
Are you installing using domain controllers as nodes or installing trought
temrinal ??
The first installation is stand alone (in one node) o the service for sql
server appers in cluster admin ??
Is a named instance ??
the sqlstp.log, is giving you errors ??


[quoted text, click to view]
Re: Join SQL cluster process always jump out of the screen Rodney R. Fournier [MVP]
8/23/2007 12:58:06 PM
NEVER CLUSTER A DC!!!! Buy more machines to be DCs and leave that role of
the clusters!!!

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


[quoted text, click to view]

Re: Join SQL cluster process always jump out of the screen (JR) Jorge Rivera
8/23/2007 2:30:01 PM
What said Rodney is true, be can be done the installation.. if have more
server move the DC role to it servers and try again the SQL Cluster setup
http://support.microsoft.com/kb/281662

Ok, what i means " trought terminal", i means, if you are installing the
sql instance using temrinal server session, that is not supported.. if you
have terminal service in aplication mode in DC's, sql cluster installation is
not supported
Read the next document and try the installation again
http://support.microsoft.com/kb/815431/

About the permission, check the permission listed in the last post, check
your DNS configuration in each network card in each cluster node, try to
connect from (from both nodes) one node to another node at c$ or d$ using the
account to perform the installation..

[quoted text, click to view]
Join SQL cluster process always jump out of the screen cccchris
8/23/2007 10:08:00 PM
Hi,

I had installed an SQL 2000 Cluster on one of the two nodes server that
running Windows 2003 Ent version, but the other node server cannot join the
SQL cluster and the setup process always jump out of the screen that need to
input Admin username, password and domain name with no errors. Is this issue
related to the Administrator right problem?

Pls advice
Chris

Re: Join SQL cluster process always jump out of the screen cccchris
8/24/2007 12:00:00 AM
Thank for your guys reply! And I will try the suggestion 1st.

Regards
Chris

"(JR) Jorge Rivera" <JRJorgeRivera@discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:AEDFFDF1-FF86-4361-87D4-AE74816B7A8F@microsoft.com...
[quoted text, click to view]

Re: Join SQL cluster process always jump out of the screen cccchris
8/24/2007 12:00:00 AM
Thank for your guys reply! And I will try the suggestions 1st.

Regards
Chris

"(JR) Jorge Rivera" <JRJorgeRivera@discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:AEDFFDF1-FF86-4361-87D4-AE74816B7A8F@microsoft.com...
[quoted text, click to view]

Re: Join SQL cluster process always jump out of the screen cccchris
8/24/2007 1:44:59 AM
Thanks for reply!

As you have guess right of it, the SQL cluster are using a pair of DCs (main
and additional) as nodes, but what is trought terminal? Can you describe
more abt this?
At the first installation, those SQL services (SQL cluster IP and Network
name, SQL Server, SQL Agent......)can be seen and online with node 1
holding, the name of SQL instance was using the default. For the sqlstp log,
I will list out for you later for checkout.

Regards
Chris

"cccchris" <cccchris@founder.com.hk> ¼¶¼g©ó¶l¥ó·s»D:%23RTMA8Y5HHA.1484@TK2MSFTNGP06.phx.gbl...
[quoted text, click to view]

Re: Join SQL cluster process always jump out of the screen cccchris
8/24/2007 1:45:24 AM
Thanks for reply!

As you have guess right of it, the SQL cluster are using a pair of DCs (main
and additional) as nodes, but what is trought terminal? Can you describe
more abt this?
At the first installation, those SQL services (SQL cluster IP and Network
name, SQL Server, SQL Agent......)can be seen and online with node 1
holding, the name of SQL instance was using the default. For the sqlstp log,
I will list out for you later for checkout.

Regards
Chris

"cccchris" <cccchris@founder.com.hk> ¼¶¼g©ó¶l¥ó·s»D:%23RTMA8Y5HHA.1484@TK2MSFTNGP06.phx.gbl...
[quoted text, click to view]

Re: Join SQL cluster process always jump out of the screen cccchris
8/24/2007 2:07:51 AM
But I try before and success. Is that some of the DCs' services will
interrupt the cluster/ SQL cluster?

Regards
Chris

"Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> ¼¶¼g©ó¶l¥ó·s»D:eX3Sp8a5HHA.5984@TK2MSFTNGP04.phx.gbl...
[quoted text, click to view]

Re: Join SQL cluster process always jump out of the screen cccchris
8/24/2007 2:10:27 AM
Why? I try before and success install cluster on DC, is that any services
will interrupt when running SQL cluster?

Regards
Chris

"Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> ¼¶¼g©ó¶l¥ó·s»D:eX3Sp8a5HHA.5984@TK2MSFTNGP04.phx.gbl...
[quoted text, click to view]

Re: Join SQL cluster process always jump out of the screen cccchris
8/24/2007 10:40:35 PM
Hi, I'm back!

I try you guys suggestions but fail. At last I gave up to setup the DC for
SQL cluster and join the DC as the member servers. Now one thing I check
that if the DCs cannot be found ,the SQL cluster will go offline
immediately. Can the SQL cluster still online even DCs disappear on the
network?

Regards
Chris

"cccchris" <cccchris@founder.com.hk> ¼¶¼g©ó¶l¥ó·s»D:eDkBAue5HHA.3940@TK2MSFTNGP05.phx.gbl...
[quoted text, click to view]

AddThis Social Bookmark Button