Adding 2nd node fails

hi all ,
I tried several times to install sql clustering on
two sql nodes but when it tries to configure the resources on virtual server
after configuring sql server resource.
then I tried to configure it with single node it succeeded.
but when I want to add the 2nd node again it cannot configure the sql agent
and search resources on the 2nd node. if I remove the agent and search
resources from the first node and then add the 2nd node to the cluster it
runs.
but is this the way. should n't sql agent and search resouces be running on
a cluster?
the account I use is the local administrator on both machines. I followd
everything just as it was said in the microsoft documentations. what else
should i do? does it have a trick or what?
any idea whould be greatly appreciated.
When you say that you're using the local admin, do you mean that you're
using it for your SQL Server and SQL Agent services? You really need a
domain account for this and it should be part of the local admin group on
each node.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Alireza G." <csspcman@.hotmail.com> wrote in message
news:OO5X1FyjEHA.592@.TK2MSFTNGP11.phx.gbl...
hi all ,
I tried several times to install sql clustering on
two sql nodes but when it tries to configure the resources on virtual server
after configuring sql server resource.
then I tried to configure it with single node it succeeded.
but when I want to add the 2nd node again it cannot configure the sql agent
and search resources on the 2nd node. if I remove the agent and search
resources from the first node and then add the 2nd node to the cluster it
runs.
but is this the way. should n't sql agent and search resouces be running on
a cluster?
the account I use is the local administrator on both machines. I followd
everything just as it was said in the microsoft documentations. what else
should i do? does it have a trick or what?
any idea whould be greatly appreciated.
|||The SQLSTP.log on the setup node and the SQLSTPn.log (where highest value
for n is the most recent setup) from each node will contain the details of
the virtual SQL Server setup. Also check the last few entries in the
SQLCLSTR.log.
You can also try setting up a virtual SQL Server on one node, then re-run
the setup in maintenance mode and add the second node. Sometimes this
helps get past the virtual SQL Server creation setup.
Chris Skorlinski
Microsoft SQL Server Support
Please reply directly to the thread with any updates.
This posting is provided "as is" with no warranties and confers no rights.

add subscriber in publication database`

Hi ...i am new to sql server replication, im using the sql server 2005.

I was configure the replication n publish a database , i wanna add a new subscription, but i am facing the follow error

You have selected the Publisher as a Subscriber and entered a subscription database that is the same as the publishing database. Select another subscription database.

How do i add another subscription database,since in my sql server has only 1 subscriber?

You have to manually pre-create the subscription database.|||THanks Greg , but how to muanually pre-create the subscription database?|||In SQL Server Books Online, look up topic "CREATE DATABASE".

Add a 3rd node to a 2 instance active/active cluster

If I add a 3rd node to an already existing 2 node active/active cluster, do
I have to take the other 2 instances offline as I configure the 3rd node?
I have never configured a cluster before, but I am under the assumption that
when you build a cluster, each nodes should be able to map to the shared
resource drives and due to that, I would have to take the other instances
offline.
Thanks
Not that it matters, but SQL2K or 2K5? I've just been doing this the
past couple of days and have some tips for you if 2K...
But to answer your question - you shouldn't have to take them offline.
On Feb 4, 12:24 pm, "Hassan" <has...@.hotmail.com> wrote:
> If I add a 3rd node to an already existing 2 node active/active cluster, do
> I have to take the other 2 instances offline as I configure the 3rd node?
> I have never configured a cluster before, but I am under the assumption that
> when you build a cluster, each nodes should be able to map to the shared
> resource drives and due to that, I would have to take the other instances
> offline.
> Thanks
|||Im all ears for tips.. so shoot away.. Can your tips not apply for 2K5 ?
<unc27932@.yahoo.com> wrote in message
news:1170779511.734049.110890@.s48g2000cws.googlegr oups.com...
> Not that it matters, but SQL2K or 2K5? I've just been doing this the
> past couple of days and have some tips for you if 2K...
> But to answer your question - you shouldn't have to take them offline.
> On Feb 4, 12:24 pm, "Hassan" <has...@.hotmail.com> wrote:
>
|||It will take the instances offline, although SS2K5 minimizes this much more.
A bigger issue is that before the new node will be able to host the
resources, you will need to patch it to the same build level as the other
two nodes.
The add a node step only lays out the RTM binaries.
Sincerely,
Anthony Thomas

"Hassan" <hassan@.hotmail.com> wrote in message
news:%23kRF9AmSHHA.1364@.TK2MSFTNGP06.phx.gbl...[vbcol=seagreen]
> Im all ears for tips.. so shoot away.. Can your tips not apply for 2K5 ?
> <unc27932@.yahoo.com> wrote in message
> news:1170779511.734049.110890@.s48g2000cws.googlegr oups.com...
cluster,[vbcol=seagreen]
node?[vbcol=seagreen]
shared[vbcol=seagreen]
instances
>