Active/Active to 2x Active/Passive?

I have a 2-node active/active cluster (SQL2KSP4 on Win2003sp1)
supporting 3 instances (2 on one node, 1 on the other). I've received
funding to upgrade the instances by adding new host nodes with
better/faster hardware (Yay!).
The end-result should be the 3 instances running active on the two new
hosts (2 on one, 1 on the other, just like before), with each new host
failing to an old host. Due to SQL licensing, I know I can't run active
on more than 2 hosts; the third instance has very little load/activity,
so I'm not concerned there.
The questions are many:
1) can I accomplish this while keeping everything within the one windows
cluster, or must I break it into two distinct clusters?
2) If I have to break it into two clusters, can I rename the existing
cluster so that the old and new clusters (and their nodes) can fit a
naming convention?
2a) Is possible to evict a node from a cluster, then bring it up as a
different cluster (1-node) without re-installing SQL2K for each instance?
3) Is there any way to pre-install SQL2K on the cluster node that's
being added to eliminate downtime?
Any pointers or tips would be greatly appreciated!
If I understand you correctly, you can accomplish it with a four-node cluster.
Linchi
"Jim Millard" wrote:

> I have a 2-node active/active cluster (SQL2KSP4 on Win2003sp1)
> supporting 3 instances (2 on one node, 1 on the other). I've received
> funding to upgrade the instances by adding new host nodes with
> better/faster hardware (Yay!).
> The end-result should be the 3 instances running active on the two new
> hosts (2 on one, 1 on the other, just like before), with each new host
> failing to an old host. Due to SQL licensing, I know I can't run active
> on more than 2 hosts; the third instance has very little load/activity,
> so I'm not concerned there.
> The questions are many:
> 1) can I accomplish this while keeping everything within the one windows
> cluster, or must I break it into two distinct clusters?
> 2) If I have to break it into two clusters, can I rename the existing
> cluster so that the old and new clusters (and their nodes) can fit a
> naming convention?
> 2a) Is possible to evict a node from a cluster, then bring it up as a
> different cluster (1-node) without re-installing SQL2K for each instance?
> 3) Is there any way to pre-install SQL2K on the cluster node that's
> being added to eliminate downtime?
> Any pointers or tips would be greatly appreciated!
>
sql

Active transaction counter does not add up

Hi,
I've just started having problems in a SQL 2000 database (W2K, dual cpu) where the database server just grinds to a virtual halt for 5 to 10 minutes then carries on. One thing I have noticed is the system's Total Active Transaction counter is kinda growin
g during the day at about 1 transaction every hour or so but, when I look at the Active Transacions at the individual database level, the Active Transactions are normally zero. The application's database registering 1 every so often (I have Performance Mo
nitor checking every 5 seconds) but all the other, eg tempdb are zero.
How can I find what the details are behind the total active transaction count?
Is there a reason why the total can be different from the individual database active transaction counts?
TIA - Peter
Peter
DBCC LOGINFO(database_id)
If you see tranasction status =2 at the end of the list that means you have
an active transaction (has not been written to the disk yet)
Also , I'd run Profiler to find out a long running queris/stored procedures
..
"Peter Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:72470C20-A20B-4750-8682-A4FCC46CEACB@.microsoft.com...
> Hi,
> I've just started having problems in a SQL 2000 database (W2K, dual cpu)
where the database server just grinds to a virtual halt for 5 to 10 minutes
then carries on. One thing I have noticed is the system's Total Active
Transaction counter is kinda growing during the day at about 1 transaction
every hour or so but, when I look at the Active Transacions at the
individual database level, the Active Transactions are normally zero. The
application's database registering 1 every so often (I have Performance
Monitor checking every 5 seconds) but all the other, eg tempdb are zero.
> How can I find what the details are behind the total active transaction
count?
> Is there a reason why the total can be different from the individual
database active transaction counts?
> TIA - Peter

Activating MSDE for remote Access

I'm finding that when I install MSDE, by default no protocols are enabled
for remote access. I've found that I can use the SQL Server Network Utility
to enable the TCP/IP protocol and then the MSDE instance is accessible from
remote workstations.
But how can I do this without having the SQL Server Client Tools installed?
Is there a command line or configuration option I can use?
Thanks for your help,
Joe Geretz
I think I found it. DISABLENETWORKPROTOCOLS=0.
- Joe Geretz -
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:uoPxQ8DYEHA.3300@.TK2MSFTNGP09.phx.gbl...
> I'm finding that when I install MSDE, by default no protocols are enabled
> for remote access. I've found that I can use the SQL Server Network
Utility
> to enable the TCP/IP protocol and then the MSDE instance is accessible
from
> remote workstations.
> But how can I do this without having the SQL Server Client Tools
installed?
> Is there a command line or configuration option I can use?
> Thanks for your help,
> Joe Geretz
>
|||But how would I do this after the instance is already installed? I can't
rely on SQL Server Client Tools because presumably, they won't exist locally
on the MSDE box.
Thanks for your help,
- Joe Geretz -
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:ucsgMAEYEHA.716@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> I think I found it. DISABLENETWORKPROTOCOLS=0.
> - Joe Geretz -
> "Joseph Geretz" <jgeretz@.nospam.com> wrote in message
> news:uoPxQ8DYEHA.3300@.TK2MSFTNGP09.phx.gbl...
enabled
> Utility
> from
> installed?
>
|||Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe
Enable tcp/ip and restart MSDE
David P. Lurie
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:e$2DuCEYEHA.3988@.tk2msftngp13.phx.gbl...
> But how would I do this after the instance is already installed? I can't
> rely on SQL Server Client Tools because presumably, they won't exist
locally
> on the MSDE box.
>
|||hi Joseph,
"Joseph Geretz" <jgeretz@.nospam.com> ha scritto nel messaggio
news:e$2DuCEYEHA.3988@.tk2msftngp13.phx.gbl...
> But how would I do this after the instance is already installed? I can't
> rely on SQL Server Client Tools because presumably, they won't exist
locally
> on the MSDE box.
on the box where MSDE has been installed, the Server Network Tools will be
alwayse available (as David already pointed out), and the Client Network
Tools (cliconfg.exe) too...
on all client, only the Client Network Tools will be available, installed by
MDAC...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank David and Andrea!
I hadn't noticed that these tools are actually installed with MSDE. This is
great, exactly what I'll need.
Thanks,
- Joe Geretz -
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2kladsF3m4fmU1@.uni-berlin.de...
> hi Joseph,
> "Joseph Geretz" <jgeretz@.nospam.com> ha scritto nel messaggio
> news:e$2DuCEYEHA.3988@.tk2msftngp13.phx.gbl...
> locally
> on the box where MSDE has been installed, the Server Network Tools will be
> alwayse available (as David already pointed out), and the Client Network
> Tools (cliconfg.exe) too...
> on all client, only the Client Network Tools will be available, installed
by
> MDAC...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Account problem when creating a new publication

I've got SQL Server Developer installed on my laptop. I'm trying to get
merge replication to work, but when I try to create a new publisher, when I
select the option to make SQL Server on my laptop its own distributor, I
then get an error msg. saying I've chosen a local system account, and
replication will not work. It then sends me to a publications properties
form to select a new account. I have no other accounts, this is just run
from my laptop. Can some kind soul help me and tell me what I need to do
to get this working?
My end result is to be able to get merge replication set up so I can sync.
with a handheld device using SQL Server 2000 CE.
Thanks in advance for any assistance.
The account that SQL Server and the Agent need to run in something other
than a Local account.
"DaveM" <nosebop@.yahoo.com> wrote in message
news:OFNJHikLFHA.2824@.TK2MSFTNGP10.phx.gbl...
> I've got SQL Server Developer installed on my laptop. I'm trying to get
> merge replication to work, but when I try to create a new publisher, when
I
> select the option to make SQL Server on my laptop its own distributor, I
> then get an error msg. saying I've chosen a local system account, and
> replication will not work. It then sends me to a publications properties
> form to select a new account. I have no other accounts, this is just
run
> from my laptop. Can some kind soul help me and tell me what I need to do
> to get this working?
> My end result is to be able to get merge replication set up so I can sync.
> with a handheld device using SQL Server 2000 CE.
> Thanks in advance for any assistance.
>
>

Accessing named instance remotely

I've got an instance of SQL server running on my website. I have port
1433 open and I can connect to it via enterprise manager across the
internet just by using the domain name in the server name box.
I recently installed SQL 2K5 beta 2 on the same box and gave it a
different name. I should be able to connect to it using
domainname\instancename correct? For some reason I can't connect to
it. I guess I don't know whether this is something particular to 2K5
or not, or do I need to do something specific for any named instance?
That should be enough, assuming you have TCP/IP enabled. If nothing in
http://www.aspfaq.com/sql2005/show.asp?id=3 helps, please post to the SQL
Server 2005 newsgroups. (See http://www.aspfaq.com/sql2005/show.asp?id=1)
http://www.aspfaq.com/
(Reverse address to reply.)
<erithtotl@.gmail.com> wrote in message
news:1106075082.815158.287290@.z14g2000cwz.googlegr oups.com...
> I've got an instance of SQL server running on my website. I have port
> 1433 open and I can connect to it via enterprise manager across the
> internet just by using the domain name in the server name box.
> I recently installed SQL 2K5 beta 2 on the same box and gave it a
> different name. I should be able to connect to it using
> domainname\instancename correct? For some reason I can't connect to
> it. I guess I don't know whether this is something particular to 2K5
> or not, or do I need to do something specific for any named instance?
>
|||You will have to specify a PORT NUMBER unless you also have UDP PORT 1434
opened on your firewall.
If you also have dynamic defined, which would not be recommended in your
configuration, you may have to open up several inbound ports to cover those
that SQL Server may use.
You would be better off blocking inbound UDP 1434, configuring your named
instance to use a specific port, say 1533, and then also open up inbound TCP
1533.
Out of curiosity, why would you expose a SQL Server installation to the
public network?
Sincerely,
Anthony Thomas

"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23AZc8EZ$EHA.2568@.TK2MSFTNGP10.phx.gbl...
That should be enough, assuming you have TCP/IP enabled. If nothing in
http://www.aspfaq.com/sql2005/show.asp?id=3 helps, please post to the SQL
Server 2005 newsgroups. (See http://www.aspfaq.com/sql2005/show.asp?id=1)
http://www.aspfaq.com/
(Reverse address to reply.)
<erithtotl@.gmail.com> wrote in message
news:1106075082.815158.287290@.z14g2000cwz.googlegr oups.com...
> I've got an instance of SQL server running on my website. I have port
> 1433 open and I can connect to it via enterprise manager across the
> internet just by using the domain name in the server name box.
> I recently installed SQL 2K5 beta 2 on the same box and gave it a
> different name. I should be able to connect to it using
> domainname\instancename correct? For some reason I can't connect to
> it. I guess I don't know whether this is something particular to 2K5
> or not, or do I need to do something specific for any named instance?
>