Active/Passive Multi-Intance

Hi,
How many instances of SQL server I need to install in 2 - node server
cluster for Active/Active and for Active/Passive mode 'on each node' ?
Pankaj
SQL does not use the term Active or Passive. It's all about instances. With
Server 2003, you can run 16 instances within the cluster. Any node will be
albe to support as many as that node can hold
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
news:3360D54D-0676-4AD0-84DE-26D61D6761D9@.microsoft.com...
> Hi,
> How many instances of SQL server I need to install in 2 - node server
> cluster for Active/Active and for Active/Passive mode 'on each node' ?
> Pankaj
|||Pankaj,
Rod is correct.
I think you might want to review the following whitepaper:
http://www.microsoft.com/technet/pro.../failclus.mspx
and the following topics in BOL;
SQL Server 2000 Failover Clusters
Failover Clustering FAQ
Failover Clustering
Hope that helps!
Thanks
Donna Lambert
Microsoft SQL Server Product Support

Active/Active ClusterInstall

How do you install SQL server in Active/Active cluster?
We want have an instance of SQL running on each of two
nodes. What different when installing it like this
versus Active/Passive?
Thank.
Read BOL. Active-active is really multi-instance clustered. You simply
install a second instance on its own disks, IP address, and network names.
Each instance has its own preferred nodes and failover path that you will
have to check. Make sure that both instances can live on the same node at
the same time. Do not overcommit memory to either instance.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"John Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:369701c42951$200c3fe0$a101280a@.phx.gbl...
> How do you install SQL server in Active/Active cluster?
> We want have an instance of SQL running on each of two
> nodes. What different when installing it like this
> versus Active/Passive?
> Thank.
sql

Active/Active Cluster Installation Failed

Hi All,
I am trying to install active/active two nodes cluster (Windows Server
2003/SQL Server 2000 â' sp3). I had successfully install the first instance.
But the name instance failed. â'Error: The cluster resource failed to come
online.â'
Also, I did not see any option to choose log file location (only able to
choose data file location). Would you please give me some hints?
For the first instance, I named the first virtual server as SQLVR1 and the
first instance as default.
For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can I
give the virtual server and the name instance same name or they have to be
different?
Thanks,
AlimI didn't think SQL Server's clustering was Active/Active capable - only
Active/Passive.
--
TheSQLGuru
President
Indicium Resources, Inc.
"alim" <alim@.discussions.microsoft.com> wrote in message
news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
> Hi All,
> I am trying to install active/active two nodes cluster (Windows Server
> 2003/SQL Server 2000 - sp3). I had successfully install the first
> instance.
> But the name instance failed. "Error: The cluster resource failed to come
> online."
> Also, I did not see any option to choose log file location (only able to
> choose data file location). Would you please give me some hints?
> For the first instance, I named the first virtual server as SQLVR1 and the
> first instance as default.
> For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can
> I
> give the virtual server and the name instance same name or they have to be
> different?
> Thanks,
> Alim
>|||First, use the term "multi-instance" instead of "Active/Active". It is much
less confusing to everyone.
The Application Event log should tell you you why the cluster resource did
not come on line. My guess is this is the problem:
Installation of a named instance of SQL Server 2000 virtual server on a
Windows Server 2003-based cluster fails
http://support.microsoft.com/kb/815431/en-us
You can change the log file location after the system is up and running.
You can only specify one file location during the install.
And yes, the virtual server name and the SQL instance name must be the same.
I usually use only named instances on a cluster to keep from having to
explain why the names look different.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"alim" <alim@.discussions.microsoft.com> wrote in message
news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
> Hi All,
> I am trying to install active/active two nodes cluster (Windows Server
> 2003/SQL Server 2000 â' sp3). I had successfully install the first
> instance.
> But the name instance failed. â'Error: The cluster resource failed to come
> online.â'
> Also, I did not see any option to choose log file location (only able to
> choose data file location). Would you please give me some hints?
> For the first instance, I named the first virtual server as SQLVR1 and the
> first instance as default.
> For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can
> I
> give the virtual server and the name instance same name or they have to be
> different?
> Thanks,
> Alim
>|||> And yes, the virtual server name and the SQL instance name must be the same.
Hmmm... They can be the same or different. We typically just name the
instances SQL1, SQL2, etc. so that we can easily tell/communicate which
instance it is.
Linchi
"Geoff N. Hiten" wrote:
> First, use the term "multi-instance" instead of "Active/Active". It is much
> less confusing to everyone.
> The Application Event log should tell you you why the cluster resource did
> not come on line. My guess is this is the problem:
> Installation of a named instance of SQL Server 2000 virtual server on a
> Windows Server 2003-based cluster fails
> http://support.microsoft.com/kb/815431/en-us
> You can change the log file location after the system is up and running.
> You can only specify one file location during the install.
> And yes, the virtual server name and the SQL instance name must be the same.
> I usually use only named instances on a cluster to keep from having to
> explain why the names look different.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "alim" <alim@.discussions.microsoft.com> wrote in message
> news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
> > Hi All,
> > I am trying to install active/active two nodes cluster (Windows Server
> > 2003/SQL Server 2000 â' sp3). I had successfully install the first
> > instance.
> > But the name instance failed. â'Error: The cluster resource failed to come
> > online.â'
> > Also, I did not see any option to choose log file location (only able to
> > choose data file location). Would you please give me some hints?
> > For the first instance, I named the first virtual server as SQLVR1 and the
> > first instance as default.
> > For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can
> > I
> > give the virtual server and the name instance same name or they have to be
> > different?
> >
> > Thanks,
> > Alim
> >
>|||Thanks all for the comments. I think I will go with active/passive
configuration which is much easier.
Thanks!
"Linchi Shea" wrote:
> > And yes, the virtual server name and the SQL instance name must be the same.
> Hmmm... They can be the same or different. We typically just name the
> instances SQL1, SQL2, etc. so that we can easily tell/communicate which
> instance it is.
> Linchi
> "Geoff N. Hiten" wrote:
> > First, use the term "multi-instance" instead of "Active/Active". It is much
> > less confusing to everyone.
> >
> > The Application Event log should tell you you why the cluster resource did
> > not come on line. My guess is this is the problem:
> >
> > Installation of a named instance of SQL Server 2000 virtual server on a
> > Windows Server 2003-based cluster fails
> > http://support.microsoft.com/kb/815431/en-us
> >
> > You can change the log file location after the system is up and running.
> > You can only specify one file location during the install.
> >
> > And yes, the virtual server name and the SQL instance name must be the same.
> > I usually use only named instances on a cluster to keep from having to
> > explain why the names look different.
> >
> > --
> > Geoff N. Hiten
> > Senior Database Administrator
> > Microsoft SQL Server MVP
> >
> >
> >
> >
> > "alim" <alim@.discussions.microsoft.com> wrote in message
> > news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
> > > Hi All,
> > > I am trying to install active/active two nodes cluster (Windows Server
> > > 2003/SQL Server 2000 â' sp3). I had successfully install the first
> > > instance.
> > > But the name instance failed. â'Error: The cluster resource failed to come
> > > online.â'
> > > Also, I did not see any option to choose log file location (only able to
> > > choose data file location). Would you please give me some hints?
> > > For the first instance, I named the first virtual server as SQLVR1 and the
> > > first instance as default.
> > > For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can
> > > I
> > > give the virtual server and the name instance same name or they have to be
> > > different?
> > >
> > > Thanks,
> > > Alim
> > >
> >
> >

Active/Active Cluster Installation Failed

Hi All,
I am trying to install active/active two nodes cluster (Windows Server
2003/SQL Server 2000 – sp3). I had successfully install the first instance.
But the name instance failed. “Error: The cluster resource failed to come
online.”
Also, I did not see any option to choose log file location (only able to
choose data file location). Would you please give me some hints?
For the first instance, I named the first virtual server as SQLVR1 and the
first instance as default.
For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can I
give the virtual server and the name instance same name or they have to be
different?
Thanks,
Alim
I didn't think SQL Server's clustering was Active/Active capable - only
Active/Passive.
TheSQLGuru
President
Indicium Resources, Inc.
"alim" <alim@.discussions.microsoft.com> wrote in message
news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
> Hi All,
> I am trying to install active/active two nodes cluster (Windows Server
> 2003/SQL Server 2000 - sp3). I had successfully install the first
> instance.
> But the name instance failed. "Error: The cluster resource failed to come
> online."
> Also, I did not see any option to choose log file location (only able to
> choose data file location). Would you please give me some hints?
> For the first instance, I named the first virtual server as SQLVR1 and the
> first instance as default.
> For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can
> I
> give the virtual server and the name instance same name or they have to be
> different?
> Thanks,
> Alim
>
|||First, use the term "multi-instance" instead of "Active/Active". It is much
less confusing to everyone.
The Application Event log should tell you you why the cluster resource did
not come on line. My guess is this is the problem:
Installation of a named instance of SQL Server 2000 virtual server on a
Windows Server 2003-based cluster fails
http://support.microsoft.com/kb/815431/en-us
You can change the log file location after the system is up and running.
You can only specify one file location during the install.
And yes, the virtual server name and the SQL instance name must be the same.
I usually use only named instances on a cluster to keep from having to
explain why the names look different.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"alim" <alim@.discussions.microsoft.com> wrote in message
news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
> Hi All,
> I am trying to install active/active two nodes cluster (Windows Server
> 2003/SQL Server 2000 – sp3). I had successfully install the first
> instance.
> But the name instance failed. “Error: The cluster resource failed to come
> online.”
> Also, I did not see any option to choose log file location (only able to
> choose data file location). Would you please give me some hints?
> For the first instance, I named the first virtual server as SQLVR1 and the
> first instance as default.
> For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can
> I
> give the virtual server and the name instance same name or they have to be
> different?
> Thanks,
> Alim
>
|||> And yes, the virtual server name and the SQL instance name must be the same.
Hmmm... They can be the same or different. We typically just name the
instances SQL1, SQL2, etc. so that we can easily tell/communicate which
instance it is.
Linchi
"Geoff N. Hiten" wrote:

> First, use the term "multi-instance" instead of "Active/Active". It is much
> less confusing to everyone.
> The Application Event log should tell you you why the cluster resource did
> not come on line. My guess is this is the problem:
> Installation of a named instance of SQL Server 2000 virtual server on a
> Windows Server 2003-based cluster fails
> http://support.microsoft.com/kb/815431/en-us
> You can change the log file location after the system is up and running.
> You can only specify one file location during the install.
> And yes, the virtual server name and the SQL instance name must be the same.
> I usually use only named instances on a cluster to keep from having to
> explain why the names look different.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "alim" <alim@.discussions.microsoft.com> wrote in message
> news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
>
|||Thanks all for the comments. I think I will go with active/passive
configuration which is much easier.
Thanks!
"Linchi Shea" wrote:
[vbcol=seagreen]
> Hmmm... They can be the same or different. We typically just name the
> instances SQL1, SQL2, etc. so that we can easily tell/communicate which
> instance it is.
> Linchi
> "Geoff N. Hiten" wrote:

Active/Active Cluster Installation Failed

Hi All,
I am trying to install active/active two nodes cluster (Windows Server
2003/SQL Server 2000 – sp3). I had successfully install the first instanc
e.
But the name instance failed. “Error: The cluster resource failed to come
online.”
Also, I did not see any option to choose log file location (only able to
choose data file location). Would you please give me some hints?
For the first instance, I named the first virtual server as SQLVR1 and the
first instance as default.
For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can I
give the virtual server and the name instance same name or they have to be
different?
Thanks,
AlimI didn't think SQL Server's clustering was Active/Active capable - only
Active/Passive.
TheSQLGuru
President
Indicium Resources, Inc.
"alim" <alim@.discussions.microsoft.com> wrote in message
news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
> Hi All,
> I am trying to install active/active two nodes cluster (Windows Server
> 2003/SQL Server 2000 - sp3). I had successfully install the first
> instance.
> But the name instance failed. "Error: The cluster resource failed to come
> online."
> Also, I did not see any option to choose log file location (only able to
> choose data file location). Would you please give me some hints?
> For the first instance, I named the first virtual server as SQLVR1 and the
> first instance as default.
> For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can
> I
> give the virtual server and the name instance same name or they have to be
> different?
> Thanks,
> Alim
>|||First, use the term "multi-instance" instead of "Active/Active". It is much
less confusing to everyone.
The Application Event log should tell you you why the cluster resource did
not come on line. My guess is this is the problem:
Installation of a named instance of SQL Server 2000 virtual server on a
Windows Server 2003-based cluster fails
http://support.microsoft.com/kb/815431/en-us
You can change the log file location after the system is up and running.
You can only specify one file location during the install.
And yes, the virtual server name and the SQL instance name must be the same.
I usually use only named instances on a cluster to keep from having to
explain why the names look different.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"alim" <alim@.discussions.microsoft.com> wrote in message
news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
> Hi All,
> I am trying to install active/active two nodes cluster (Windows Server
> 2003/SQL Server 2000 – sp3). I had successfully install the first
> instance.
> But the name instance failed. “Error: The cluster resource failed to co
me
> online.”
> Also, I did not see any option to choose log file location (only able to
> choose data file location). Would you please give me some hints?
> For the first instance, I named the first virtual server as SQLVR1 and the
> first instance as default.
> For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can
> I
> give the virtual server and the name instance same name or they have to be
> different?
> Thanks,
> Alim
>|||> And yes, the virtual server name and the SQL instance name must be the sam
e.
Hmmm... They can be the same or different. We typically just name the
instances SQL1, SQL2, etc. so that we can easily tell/communicate which
instance it is.
Linchi
"Geoff N. Hiten" wrote:

> First, use the term "multi-instance" instead of "Active/Active". It is mu
ch
> less confusing to everyone.
> The Application Event log should tell you you why the cluster resource did
> not come on line. My guess is this is the problem:
> Installation of a named instance of SQL Server 2000 virtual server on a
> Windows Server 2003-based cluster fails
> http://support.microsoft.com/kb/815431/en-us
> You can change the log file location after the system is up and running.
> You can only specify one file location during the install.
> And yes, the virtual server name and the SQL instance name must be the sam
e.
> I usually use only named instances on a cluster to keep from having to
> explain why the names look different.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "alim" <alim@.discussions.microsoft.com> wrote in message
> news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
>|||Thanks all for the comments. I think I will go with active/passive
configuration which is much easier.
Thanks!
"Linchi Shea" wrote:
[vbcol=seagreen]
> Hmmm... They can be the same or different. We typically just name the
> instances SQL1, SQL2, etc. so that we can easily tell/communicate which
> instance it is.
> Linchi
> "Geoff N. Hiten" wrote:
>sql

Active/Active Cluster

I am trying to install an Active/Active cluster of SQL2000 on a Win2003 machine. I installed the default instance and a named instance. When both instances are on the same machine, they come up correctly. However, if I fail the named instance over to the
other node, it will not come up. If I then fail the default instance over to the other node the named instances starts. The error messages are as follows:
[sqsrvres] ODBC sqldriverconnect failed
[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
[sqsrvres] ODBC sqldriverconnect failed
[sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 35; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Is the default Instance and the named instance running in the same domain account context? Also, most people that use clustering would just use named instances...
|||Are the service account passwords the same on both machines? What are the
steps you took to install both virtual servers?
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Active Directory Helper service aborting upon startup

On a fairly new install of SQL 2005 64-bit, upon bootup the Active Directory Helper Serivice is aborting with the error 3221225572 (0XC0000064). When an attempt is made to start the service manually the following error appears: "Windows could not start teh SQL Server Active Directory Helper on Local Computer. For more infromation, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to the service-specific error code - 1073741724."

The service is strating up under the network services account, which I am suspicous may be a problem. Currently the SQL server is running under SQL 2005 SP2 with no post service pack hotfixes. Do you have any advice on how to get the service to launch without errors?

I would guess the service may be set to automatic. The MSSQLServerADHelper service should be set to manual. SQL Server will start and stop the service itself when needed. It's not something you need to start yourself - just let SQL Server manage it.

-Sue

Active Active Clustering

I am planning to install Multiple Instance SQL Server 2000 cluster (two instances) on Windows 2000 Advanced servers (two nodes). All the examples I have seen deal with Single Instance SQL Servers. What I have read that in case of a Multiple Instance ins
tallation you merely run the SQL Server setup program another time after the installation of the first virtual server is completed. I have also read that during the install you chose one of the nodes (one of the two Windows boxes) as the owner of one virt
ual SQL Server instance. Then when you run the SQL Server setup program a second time, you specify the other node as the owner of the other SQL Server virtual instance.
My question is this: where do I specify a node as the owner of a particular SQL Server instance? On the SQL Server 2000 Failover Clustering white paper, Appendix B, http://www.microsoft.com/technet/pro...x?pf=true#XSLT
section133121120120 step 10 shows a dialog box where you specify the configured nodes. Do I specify only one node as the Configured Node? Is that how I identify the node that owns the particular SQL Server instance? Or do I we identify it some other way
? Thanks.
I am sorry that I used the old terminology from SQL Server 7.0. Thanks in advance for your help.
|||You have a preferred owners list on the properties page of the resource
group. The host nodes are listed in preferred order. The actual ownership
can be changed by moving the group to a particular host. During setup, you
install SQL from the node that owns the disk resource where you intend to
put SQL. The dialog box you refer to selects the nodes that SQL is allowed
to run on. Once SQL is installed, the instance can be moved to any allowed
node.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"EY" <shafaqrahim@.hotmail.com> wrote in message
news:69BBB5B8-E23A-451F-B8FE-EAADD88A8E56@.microsoft.com...
> I am planning to install Multiple Instance SQL Server 2000 cluster (two
instances) on Windows 2000 Advanced servers (two nodes). All the examples I
have seen deal with Single Instance SQL Servers. What I have read that in
case of a Multiple Instance installation you merely run the SQL Server setup
program another time after the installation of the first virtual server is
completed. I have also read that during the install you chose one of the
nodes (one of the two Windows boxes) as the owner of one virtual SQL Server
instance. Then when you run the SQL Server setup program a second time, you
specify the other node as the owner of the other SQL Server virtual
instance.
> My question is this: where do I specify a node as the owner of a
particular SQL Server instance? On the SQL Server 2000 Failover Clustering
white paper, Appendix B,
http://www.microsoft.com/technet/pro...on133121120120
step 10 shows a dialog box where you specify the configured nodes. Do I
specify only one node as the Configured Node? Is that how I identify the
node that owns the particular SQL Server instance? Or do I we identify it
some other way? Thanks.
>
|||Thanks Mr. Hitten for answering my question so promptly.

Active - Active clustering -Second instance

Trying to install a second named instance of SQL Server 2005 on a
Windows Server 2003 Enterprise two node cluster. I am installing on the
node which the cluster group is currently on. The first named instance I
installed went in like a champ - I have a Cluster Resource group, a SQL
Server(Instance) Group (contains disks, services, ip address, net name, etc)
and a SQL Server (NewInstance) resource group which contains only the shared
disks for the second instance.
Run through setup - everything goes as planned, until the actual
installation is to take place, and then it fails on the 'Remote' server,
because the Scheduled task can't be run - I get this in the Scheduled Task
log file:
"SQL Server Remote Setup .job" (setup.exe) 10/4/2006 3:27:10 PM ** ERROR **
Unable to start task.
The specific error is:
0x80070005: Access is denied.
Try using the Task page Browse button to locate the application.
This seems to indicate that the remote machine cannot access the install
files on the local machine - Has anyone experienced this, and how did you
solve it ?
thanks !
RJ wrote:
> Trying to install a second named instance of SQL Server 2005 on a
> Windows Server 2003 Enterprise two node cluster. I am installing on the
> node which the cluster group is currently on. The first named instance I
> installed went in like a champ - I have a Cluster Resource group, a SQL
> Server(Instance) Group (contains disks, services, ip address, net name, etc)
> and a SQL Server (NewInstance) resource group which contains only the shared
> disks for the second instance.
> Run through setup - everything goes as planned, until the actual
> installation is to take place, and then it fails on the 'Remote' server,
> because the Scheduled task can't be run - I get this in the Scheduled Task
> log file:
> "SQL Server Remote Setup .job" (setup.exe) 10/4/2006 3:27:10 PM ** ERROR **
> Unable to start task.
> The specific error is:
> 0x80070005: Access is denied.
> Try using the Task page Browse button to locate the application.
> This seems to indicate that the remote machine cannot access the install
> files on the local machine - Has anyone experienced this, and how did you
> solve it ?
> thanks !
I am not sure about this specific problem, however from my experience
it is quite easier to first install SQL Server on both machines, then
create the cluster.
Other suggestions while you are in the setup stage:
-Make sure you have different ports and names for your instances if you
want to have them both running on the same server in a failover
scenario.
-If possible, try using the default instance on one of your servers.
Some software can't connect to named instances, like Microsoft CRM.
-Be careful about SSIS, which can be painful in an active-active
cluster. The easier way to go it is to use Filesystem packages, and
store the packages on a cluster resource.
Regards,
lucm
|||Actually, this was mysteriously resolved -
I started looking through the installation log files, and decided I wanted a
'clean' set of files for analysis. I deleted ALL the files in the c:\program
files\Microsoft SQL Server\90\Setup Bootstrap\LOG folder, and proceeded to
try another doomed installation. To my complete amazement, it succeeded.
So - I don't know that I learned anything here... but it got me working.
"lucm@.iqato.com" wrote:

> RJ wrote:
> I am not sure about this specific problem, however from my experience
> it is quite easier to first install SQL Server on both machines, then
> create the cluster.
> Other suggestions while you are in the setup stage:
> -Make sure you have different ports and names for your instances if you
> want to have them both running on the same server in a failover
> scenario.
> -If possible, try using the default instance on one of your servers.
> Some software can't connect to named instances, like Microsoft CRM.
> -Be careful about SSIS, which can be painful in an active-active
> cluster. The easier way to go it is to use Filesystem packages, and
> store the packages on a cluster resource.
> Regards,
> lucm
>
|||Take a look at this KB article see whether it's relevant:
http://support.microsoft.com/?id=910851
Linchi
"RJ" wrote:

> Trying to install a second named instance of SQL Server 2005 on a
> Windows Server 2003 Enterprise two node cluster. I am installing on the
> node which the cluster group is currently on. The first named instance I
> installed went in like a champ - I have a Cluster Resource group, a SQL
> Server(Instance) Group (contains disks, services, ip address, net name, etc)
> and a SQL Server (NewInstance) resource group which contains only the shared
> disks for the second instance.
> Run through setup - everything goes as planned, until the actual
> installation is to take place, and then it fails on the 'Remote' server,
> because the Scheduled task can't be run - I get this in the Scheduled Task
> log file:
> "SQL Server Remote Setup .job" (setup.exe) 10/4/2006 3:27:10 PM ** ERROR **
> Unable to start task.
> The specific error is:
> 0x80070005: Access is denied.
> Try using the Task page Browse button to locate the application.
> This seems to indicate that the remote machine cannot access the install
> files on the local machine - Has anyone experienced this, and how did you
> solve it ?
> thanks !

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
>

ACT7 instance of Microsoft SQL server 2000

Alright; here is my problem. I recently bought ACT 2006 and tried to install. I had no such luck. I keep getting an error message that says need to unistall an ACT7 instance of Microsoft SQL server 2000. Now, I looked at downloading a service pack for the server, but I don't know what server I have. I would guess the 2000 edition. I am running Windows XP office edition and it is on a fairly new laptop. Can anybody help me. If I knew what server I have I could get the updates for it and from what I have read on other forums, that should fix the problem.Hi tyler9953 and welcome to TSDN,

If you go start -> control panel and select add / remove programs, you should find Microsoft SQL server in the list, you sould be able to discern which version you have installed.

If you want to install a service pack for server 2000, you can get service pack 4 here.

Hope this helps

Kind Regards

Purple

Account for SQL Server services

Hi,
When I install cluster SQL Server in two nodes (active-passive), I used
valid administrator account for all nodes. After install, I changed SQL Agent
service account for replicate database. SA asked me to change the SQL Server
service account to not using currently administrator account under the
domain. If I changed what happy after stop and restart SQL, the cluster will
work or not? I mean the failover or fail back.
Regards!
-Chen
Use Enterprise Manager to change the SQL Server or SQL Agent service account
information. EM is cluster-aware and will make all necessary changes for
you.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:51ED33DF-3880-46AB-879C-E00DE0E0670F@.microsoft.com...
> Hi,
> When I install cluster SQL Server in two nodes (active-passive), I used
> valid administrator account for all nodes. After install, I changed SQL
> Agent
> service account for replicate database. SA asked me to change the SQL
> Server
> service account to not using currently administrator account under the
> domain. If I changed what happy after stop and restart SQL, the cluster
> will
> work or not? I mean the failover or fail back.
> Regards!
> -Chen

Accessing Reporting Services from a machine which is not the server

Hello,

I plan to install MS SQL Reporting Services 2000 (later probably 2005) on the same server as where the MS SQL Server 2000 database is stored.

However, the developers (people designing the reports) will not have physical access to this server (it is stored in a different office). Remote Desktop is possible though, if no other solution exists.

Are the developers able to use the Report Builder on every machine or is a single license needed for each developer workstation? Or, in other words, what needs to be installed on a computer in order to create different type of reports?

Any comment on what is best or a link is appreciated. Thank you in advance!

Best regards,

Michael Fuchs

You do not need a license for client machines using Report Builder, only for the server itself. You can find out more information here:

http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx

Accessing MSDE 2000

I have downloaded msde 2000. I have edited and saved the setup.ini file for
a sa password.
[Options]
SAPWD="cfm56z"
Setup appears to run and install msde. However when I try to access it with
DbatMGR, I get
SQL Server does not exist or access is denied
Any suggestions would be helpful.
Thanks,
Fred Herring
hi Fred,
Fred Herring wrote:
> Setup appears to run and install msde. However when I try to access
> it with DbatMGR, I get
> SQL Server does not exist or access is denied
>
this kind of error is a general exception raised by MDAC... please check
http://support.microsoft.com/default...06&Product=sql
for more info on how to troubleshoot it
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply