Adding a resource (Generic Script) to the SQL Cluster

I would like to add a VB Script to the SQL Cluster so that
in the event of a failover the script will execute on the
new active node. The script goes out and checks for the
existance of some key files once a day.
I am running Windows 2003 SQL 2000 in an Active / Passive
configuration.
I have the VBS running every morning through task Mgr, but
I would like to get it configured to run as a clustered
resource and failover to the active node.
Thanks,
In 2003, there is a "Generic Script" resource type that support VBS and Perl
scripts. Check out the following for more details:
http://msdn.microsoft.com/library/de...ric_script.asp
Regards,
John
"Rodney" <anonymous@.discussions.microsoft.com> wrote in message
news:441301c47333$a3be4aa0$a601280a@.phx.gbl...
> I would like to add a VB Script to the SQL Cluster so that
> in the event of a failover the script will execute on the
> new active node. The script goes out and checks for the
> existance of some key files once a day.
> I am running Windows 2003 SQL 2000 in an Active / Passive
> configuration.
> I have the VBS running every morning through task Mgr, but
> I would like to get it configured to run as a clustered
> resource and failover to the active node.
> Thanks,

add Reporting Services to an existing cluster

We have set up SQL Server 2005 failover cluster with 2 nodes, on Windows 2003. I'm now trying to add Reporting Services. I don't see any documentation for how to do this. Is it similar to adding Analysis Services? If I use this command I'm not sure what to put in several paramaters:

start /wait c:\<path-to-setup>\setup.exe /qn VS=<my-virtual-server-name> INSTALL=RS_Server INSTANCENAME=MSSQLSERVER ADDLOCAL=RS_Server ADDNODE=n GROUP="Cluster Group" IP="111.11.11.11,<my-virtual-server-name" ADMINPASSWORD=xxxx SAPWD=xxxx INSTALLSQLDIR=c INSTALLSQLDATADIR=c RSACCOUNT=mmm\xxxxx RSPASSWORD=<domain-user-psswd> SQLBROWSERACCOUNT=<mmm\xxxxx> SQLBROWSERPASSWORD=<domain-user-psswd> SQLREPORTING=1

My question are for:

IP: do i just put the virtual ip and name here, or every ip in the node?

INSTALLSQLDIR: is c drive correct here, or what is this?

INSTALLSQLDATADIR: is c drive correct here, or what is this?

RSACCOUNT: is this correct, not in the example in document ms144259 and what should go here?

RSPASSWORD: same as above

SQLBROWSERACCOUNT: what goes here?

SQLBROWSERPASSWORD: same as above

Thanks so much for any help.

I have a erlated question. Would I add Reporting Services like they way you add Integration Services? Using Add/Remove programs? If so, When I try that the choice of Reporting Services is blanked out, not available as a choice to install. How could I get that? Thanks!|||

Reporting Service cannot be installed as a virtual service, i.e., it is not a cluster-component. It can be only installed as a standalone instance. You can add it to an installed instance if that instance does not include Reporting Service. Or you can install it in another new instance. So the command line should be like

start /wait setup.exe /qb ADDLOCAL=RS_Server,RS_Web_Interface INSTANCENAME="xxxxx" RSACCOUNT="<domain\account>" RSPASSWORD="<strong password>" SQLBROWSERACCOUNT="<doemain\account>" SQLBROWSERPASSWORD="<strong password>" RSAUTOSTART=1 SQLBROWSERAUTOSTART=1

See BOL for more information related to command line or template.ini file for more sample command lines.

add Reporting Services to an existing cluster

We have set up SQL Server 2005 failover cluster with 2 nodes, on Windows 2003. I'm now trying to add Reporting Services. I don't see any documentation for how to do this. Is it similar to adding Analysis Services? If I use this command I'm not sure what to put in several paramaters:

start /wait c:\<path-to-setup>\setup.exe /qn VS=<my-virtual-server-name> INSTALL=RS_Server INSTANCENAME=MSSQLSERVER ADDLOCAL=RS_Server ADDNODE=n GROUP="Cluster Group" IP="111.11.11.11,<my-virtual-server-name" ADMINPASSWORD=xxxx SAPWD=xxxx INSTALLSQLDIR=c INSTALLSQLDATADIR=c RSACCOUNT=mmm\xxxxx RSPASSWORD=<domain-user-psswd> SQLBROWSERACCOUNT=<mmm\xxxxx> SQLBROWSERPASSWORD=<domain-user-psswd> SQLREPORTING=1

My question are for:

IP: do i just put the virtual ip and name here, or every ip in the node?

INSTALLSQLDIR: is c drive correct here, or what is this?

INSTALLSQLDATADIR: is c drive correct here, or what is this?

RSACCOUNT: is this correct, not in the example in document ms144259 and what should go here?

RSPASSWORD: same as above

SQLBROWSERACCOUNT: what goes here?

SQLBROWSERPASSWORD: same as above

Thanks so much for any help.

I have a erlated question. Would I add Reporting Services like they way you add Integration Services? Using Add/Remove programs? If so, When I try that the choice of Reporting Services is blanked out, not available as a choice to install. How could I get that? Thanks!|||

Reporting Service cannot be installed as a virtual service, i.e., it is not a cluster-component. It can be only installed as a standalone instance. You can add it to an installed instance if that instance does not include Reporting Service. Or you can install it in another new instance. So the command line should be like

start /wait setup.exe /qb ADDLOCAL=RS_Server,RS_Web_Interface INSTANCENAME="xxxxx" RSACCOUNT="<domain\account>" RSPASSWORD="<strong password>" SQLBROWSERACCOUNT="<doemain\account>" SQLBROWSERPASSWORD="<strong password>" RSAUTOSTART=1 SQLBROWSERAUTOSTART=1

See BOL for more information related to command line or template.ini file for more sample command lines.

add column to updateable subscription

sql2k sp3
Ive got a Publication with a Subscription that is
Immediate Updating with Queued for Failover. I tried to
run sp_repladdcolumn and got:
Server: Msg 21381, Level 16, State 1, Procedure
sp_repldropcolumn, Line 277
Cannot add (drop) column to table 'transdtl' because the
table belongs to publication(s) with an active updatable
subscription. Set @.force_reinit_subscription to 1 to force
reinitialization.
Server: Msg 21284, Level 16, State 1, Procedure
sp_repldropcolumn, Line 637
Failed to drop column 'test' from table 'transdtl'.
So how do you gurus add a column in this scenario? Do I
actually need to re snapshot the table? The only other
option I can think of would be:
Add them to the tables without sp_repladdcolumn. Add them
as an Article. Generate the Procs and Triggers for them.
Hmmm. That would suck.
TIA, Chris
I take it you are dropping a column. Your post is a little unclear to me.
do a sp_repdropcolumn with @.force_invaldiate_snapshot=1,
@.force_reinit_subscription=1
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:76ea01c47679$327475b0$a601280a@.phx.gbl...
> sql2k sp3
> Ive got a Publication with a Subscription that is
> Immediate Updating with Queued for Failover. I tried to
> run sp_repladdcolumn and got:
> Server: Msg 21381, Level 16, State 1, Procedure
> sp_repldropcolumn, Line 277
> Cannot add (drop) column to table 'transdtl' because the
> table belongs to publication(s) with an active updatable
> subscription. Set @.force_reinit_subscription to 1 to force
> reinitialization.
> Server: Msg 21284, Level 16, State 1, Procedure
> sp_repldropcolumn, Line 637
> Failed to drop column 'test' from table 'transdtl'.
>
> So how do you gurus add a column in this scenario? Do I
> actually need to re snapshot the table? The only other
> option I can think of would be:
> Add them to the tables without sp_repladdcolumn. Add them
> as an Article. Generate the Procs and Triggers for them.
> Hmmm. That would suck.
>
> TIA, Chris