Info about Active/Active SQL 2000 Cluster

Hi all,
i need configure a active/active SQL2000 cluster but i don't have experience
in this scenario
The hardware and installation of MSCS di the same for the active/passive
configuration ?
In active/active configuration i must install more SQL virtual server (two)
on the same node ?
Thanks.http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_clustering_81ma.asp
>--Original Message--
>Hi all,
>i need configure a active/active SQL2000 cluster but i
don't have experience
>in this scenario
>The hardware and installation of MSCS di the same for the
active/passive
>configuration ?
>In active/active configuration i must install more SQL
virtual server (two)
>on the same node ?
>Thanks.
>
>.
>|||Thanks,
but a last questions :
if i configure a active/active SQL Cluster may my web application may point
to virtual istance and the modified a date and a view the same data on the
both virtual SQL server ?
This mean active/active SQç cluster ?
bye
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:11f5401c4423b$b8eadd40$a101280a@.phx.gbl...
> http://msdn.microsoft.com/library/default.asp?
> url=/library/en-us/adminsql/ad_clustering_81ma.asp
>
> >--Original Message--
> >Hi all,
> >
> >i need configure a active/active SQL2000 cluster but i
> don't have experience
> >in this scenario
> >
> >The hardware and installation of MSCS di the same for the
> active/passive
> >configuration ?
> >
> >In active/active configuration i must install more SQL
> virtual server (two)
> >on the same node ?
> >
> >Thanks.
> >
> >
> >.
> >|||Not unless you replicate the data between the 2 virtual servers...
An active/active cluster has a virtual server on EACH of the physical
servers... Each virtual server is alive and doing a piece of work ( like
one might be HR and the other the SHOPFloor server)... Each virtual server
can fail over to the other physical server... But they are otherwise NOT
related to one another... (unless YOU do something to move data between the
two)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<io.com> wrote in message news:%23ayW5OkQEHA.1620@.TK2MSFTNGP12.phx.gbl...
> Thanks,
> but a last questions :
> if i configure a active/active SQL Cluster may my web application may
point
> to virtual istance and the modified a date and a view the same data on the
> both virtual SQL server ?
> This mean active/active SQç cluster ?
> bye
>
> "Julie" <anonymous@.discussions.microsoft.com> wrote in message
> news:11f5401c4423b$b8eadd40$a101280a@.phx.gbl...
> > http://msdn.microsoft.com/library/default.asp?
> > url=/library/en-us/adminsql/ad_clustering_81ma.asp
> >
> >
> > >--Original Message--
> > >Hi all,
> > >
> > >i need configure a active/active SQL2000 cluster but i
> > don't have experience
> > >in this scenario
> > >
> > >The hardware and installation of MSCS di the same for the
> > active/passive
> > >configuration ?
> > >
> > >In active/active configuration i must install more SQL
> > virtual server (two)
> > >on the same node ?
> > >
> > >Thanks.
> > >
> > >
> > >.
> > >
>

Info about A/A SQL 2000 cluster

Hi i need to configure 2 sql2000 server (S1 e S2) in a/a mode with two
database on the first node and other two database on the second node.
I have 3 Logical Unit SCSI on external diskarray
- q: quorum into "cluser group" with owner S1 Server
- r: dati1 into "Group 0" with owner S1 Server
- s: dati2 into "Group 1" with owner S1 Server
I now should install a SQL Virtual Server with SQL 2000 CD-ROM but how i
install virtual server for a/a mode ?
I read that i install first VS on the S1 Server and second VS on the S2
Server but how i can do it if all resource is locked is locked form S1
Server ?!?!?
How i set a datafile for VS on S1 to save to r: and datafile for VS on S2 to
save to s: if s: is locekd always from S1 server ?!?!?
Thanks in advance.
For every Active SQL you need another instance. In your case two instances
and two installs
Cheers,
Rod
<io.com> wrote in message news:%23qDH%23XlUEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Hi i need to configure 2 sql2000 server (S1 e S2) in a/a mode with two
> database on the first node and other two database on the second node.
> I have 3 Logical Unit SCSI on external diskarray
> - q: quorum into "cluser group" with owner S1 Server
> - r: dati1 into "Group 0" with owner S1 Server
> - s: dati2 into "Group 1" with owner S1 Server
> I now should install a SQL Virtual Server with SQL 2000 CD-ROM but how i
> install virtual server for a/a mode ?
> I read that i install first VS on the S1 Server and second VS on the S2
> Server but how i can do it if all resource is locked is locked form S1
> Server ?!?!?
> How i set a datafile for VS on S1 to save to r: and datafile for VS on S2
to
> save to s: if s: is locekd always from S1 server ?!?!?
> Thanks in advance.
>
|||> For every Active SQL you need another instance. In your case two instances
> and two installs
Thanks but wjat do you think about this ?
I read that i install first VS on the S1 Server and second VS on the S2
Server but how i can do it if all resource is locked is locked form S1
Server ?!?!?
How i set a datafile for VS on S1 to save to r: and datafile for VS on S2
to save to s: if s: is locekd always from S1 server ?!?!?
Thanks in advance.
|||You run active/active with the Microsoft shared nothing model, each
instance/node will control its own group/disk drive. If you would like to
write to one database or the other, use T-SQL.
Cheers,
Rod
<io.com> wrote in message news:%23EjN8yqUEHA.3200@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
instances
> Thanks but wjat do you think about this ?
> I read that i install first VS on the S1 Server and second VS on the S2
> Server but how i can do it if all resource is locked is locked form S1
> Server ?!?!?
> How i set a datafile for VS on S1 to save to r: and datafile for VS on S2
> to save to s: if s: is locekd always from S1 server ?!?!?
> Thanks in advance.
>
|||Thanks Rodney,
but a last question :
How i do configure the cluster in "shared nothing model" !?!
From Cluster Administration / Cluster administration Wizard or during a SQL
installation ?
Thanks!
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:uHLonHtUEHA.3664@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> You run active/active with the Microsoft shared nothing model, each
> instance/node will control its own group/disk drive. If you would like to
> write to one database or the other, use T-SQL.
> Cheers,
> Rod
> <io.com> wrote in message news:%23EjN8yqUEHA.3200@.TK2MSFTNGP10.phx.gbl...
> instances
S2
>
|||The shared nothing model is just the way things are. When you setup
Clustering and then SQL, both us this model.
Cheers,
Rod
<io.com> wrote in message news:OvXo5ytUEHA.2408@.tk2msftngp13.phx.gbl...
> Thanks Rodney,
> but a last question :
> How i do configure the cluster in "shared nothing model" !?!
> From Cluster Administration / Cluster administration Wizard or during a
SQL[vbcol=seagreen]
> installation ?
> Thanks!
>
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:uHLonHtUEHA.3664@.TK2MSFTNGP12.phx.gbl...
to[vbcol=seagreen]
news:%23EjN8yqUEHA.3200@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
S2
> S2
>

Indirect Configuration in SSIS

Hi,

I need to configure my package using SSIS Configurations. When I opened SSIS Configuration wizard, press ADD and selected Xml Configuration, I found two options.

One being : Specify configurations directly.

next : config location is stored in env variable.

How to use the second option?[ env variable]. Say I want to configure my connection string for my destination database [ OLEDB Destination Component]. How to do that using second option.

Thanks

Kishan

You first need to create your configuration file so go for option 1.

Once you've created it, create an environment variable whose value is the path and filename of the config file.

Go back into your configuration and edit it to use the environment variable rather than the config file.

And that's it!

In case it helps: SSIS: Indirect configurations ROCK!

-Jamie

|||this link might also help: http://dotnetjunkies.com/WebLog/appeng/archive/2006/05/30/indirectconfigpackagessis.aspx