Change Lincense Key

We currently have a SQL cluster which was built on pirated license keys.
This was a managerial mistake let me point out.~
Can we change the license key to legal copy without re-installing SQL? I
see that they license key is stored in the registry, but it appears that the
Product ID is generated randomly.
Any help is appreciated.Hi
You may want to try the rebuild registry option in the setup program or see
http://tinyurl.com/ad484
John
"Andrew" wrote:
> We currently have a SQL cluster which was built on pirated license keys.
> This was a managerial mistake let me point out.~
> Can we change the license key to legal copy without re-installing SQL? I
> see that they license key is stored in the registry, but it appears that the
> Product ID is generated randomly.
> Any help is appreciated.
>

Change Lincense Key

We currently have a SQL cluster which was built on pirated license keys.
This was a managerial mistake let me point out.~
Can we change the license key to legal copy without re-installing SQL? I
see that they license key is stored in the registry, but it appears that the
Product ID is generated randomly.
Any help is appreciated.
Hi
You may want to try the rebuild registry option in the setup program or see
http://tinyurl.com/ad484
John
"Andrew" wrote:

> We currently have a SQL cluster which was built on pirated license keys.
> This was a managerial mistake let me point out.~
> Can we change the license key to legal copy without re-installing SQL? I
> see that they license key is stored in the registry, but it appears that the
> Product ID is generated randomly.
> Any help is appreciated.
>

change license mode on SQL 2k cluster

I need to change the SQL server license mode on an installed SQL server
2000 cluster from processor license to per seat.
Does anyonw know?
http://support.microsoft.com/default...b;en-us;870617
http://www.tkdinesh.com/faq/ans/license.html
Simon

change license mode on SQL 2k cluster

I need to change the SQL server license mode on an installed SQL server
2000 cluster from processor license to per seat.

Does anyonw know?http://support.microsoft.com/defaul...kb;en-us;870617
http://www.tkdinesh.com/faq/ans/license.html

Simon

Change IP in SQL Cluster

Hi all,
We need to change the IP address of server SQL.
We use SQL 2000 Enterprise, Windows 2000 Advanced Server, Cluster Service
with two nodes.
What must we do?
Thanks a lot,
Ednaldo
Please check the following articles
Changing the IP Address of Network Adapters in Cluster Server
http://support.microsoft.com/default...b;en-us;230356
Changing the IP Address of a Cluster Adapter May Result in Failover
http://support.microsoft.com/kb/241828/EN-US/
How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/kb/244980
"Ednaldo" wrote:

> Hi all,
> We need to change the IP address of server SQL.
> We use SQL 2000 Enterprise, Windows 2000 Advanced Server, Cluster Service
> with two nodes.
> What must we do?
> Thanks a lot,
> Ednaldo

Change IP in SQL Cluster

Hi all,
We need to change the IP address of server SQL.
We use SQL 2000 Enterprise, Windows 2000 Advanced Server, Cluster Service
with two nodes.
What must we do?
Thanks a lot,
EdnaldoPlease check the following articles
Changing the IP Address of Network Adapters in Cluster Server
http://support.microsoft.com/defaul...kb;en-us;230356
Changing the IP Address of a Cluster Adapter May Result in Failover
http://support.microsoft.com/kb/241828/EN-US/
How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/kb/244980
"Ednaldo" wrote:

> Hi all,
> We need to change the IP address of server SQL.
> We use SQL 2000 Enterprise, Windows 2000 Advanced Server, Cluster Service
> with two nodes.
> What must we do?
> Thanks a lot,
> Ednaldo

Change IP in SQL Cluster

Hi all,
We need to change the IP address of server SQL.
We use SQL 2000 Enterprise, Windows 2000 Advanced Server, Cluster Service
with two nodes.
What must we do?
Thanks a lot,
EdnaldoPlease check the following articles
Changing the IP Address of Network Adapters in Cluster Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;230356
Changing the IP Address of a Cluster Adapter May Result in Failover
http://support.microsoft.com/kb/241828/EN-US/
How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/kb/244980
"Ednaldo" wrote:
> Hi all,
> We need to change the IP address of server SQL.
> We use SQL 2000 Enterprise, Windows 2000 Advanced Server, Cluster Service
> with two nodes.
> What must we do?
> Thanks a lot,
> Ednaldo

Change IP address and subnet of Cluster nodes

I have two node SQL 2005 Cluster on Windows 2003 SP1. Now, I have to change
both IP address and subnet Windows Cluster servers.
is it possible? or What can I do step-by-step?
thanks
"TUFAN ODUNCU" <TUFANODUNCU@.discussions.microsoft.com> wrote in message
news:AF919426-25AC-4D68-AE1D-214729F868EE@.microsoft.com...
>I have two node SQL 2005 Cluster on Windows 2003 SP1. Now, I have to change
> both IP address and subnet Windows Cluster servers.
> is it possible? or What can I do step-by-step?
> thanks
Per Ryan in the other cluster newsgroup...
Changing the IP address of network adapters in cluster server
http://support.microsoft.com/kb/230356
How to change the network IP addresses of SQL Server failover cluster
instances
http://support.microsoft.com/kb/244980
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
July 10-13 in Denver
July 16-19 in New York
Sep 3 - 6 in Copenhagen

Change from Active\Active to Active\Passive Cluster

I have a SQL Server 2000 Cluster with Windows 2000 Server.
The Cluster was set up as a Active\Active and I would like to change it to
Active\Passive.
What do I need to change go from Active\Active to Active\Passive?
Thanks,
Hi
Active/Active vs Active/Passive in SQL server tems is not correct.
Active/Active = 2 SQL Server instances, one running on each node.
Active/Passive = 1 SQL Server instance, running on a Node, with the other
node doing nothing but waiting for a failover.
Uninstall one SQL server instance and you have what you want. Any reason you
want to do this?
Regards
Mike
"Joe K." wrote:

> I have a SQL Server 2000 Cluster with Windows 2000 Server.
> The Cluster was set up as a Active\Active and I would like to change it to
> Active\Passive.
> What do I need to change go from Active\Active to Active\Passive?
> Thanks,
|||Mike - Are you recommending not to run an active/passive cluster config?
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Active/Active vs Active/Passive in SQL server tems is not correct.
> Active/Active = 2 SQL Server instances, one running on each node.
> Active/Passive = 1 SQL Server instance, running on a Node, with the other
> node doing nothing but waiting for a failover.
> Uninstall one SQL server instance and you have what you want. Any reason you
> want to do this?
> Regards
> Mike
> "Joe K." wrote:
|||Hi
No, but the decision must be based on business requirements.
If you need 2 instances of SQL Server, run them.
At work, we use put 4-6 instances per node on a SQL Cluster (= 8-12 per 2
node cluster). Our perspective is that having one machine do nothing is a
waste of space and energy.
Single Instance (Active/Passive), from a licensing perspective is cheaper,
you only need to license the single node as the other node is DR and is not
active.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Todd" <Todd@.discussions.microsoft.com> wrote in message
news:90355A4B-87CE-4B14-8C2C-AC0D909D1981@.microsoft.com...[vbcol=seagreen]
> Mike - Are you recommending not to run an active/passive cluster config?
> "Mike Epprecht (SQL MVP)" wrote:
other[vbcol=seagreen]
you[vbcol=seagreen]
it to[vbcol=seagreen]
|||I agree Mike. At work we use all active/passive clusters (4 total clusters
with 2 nodes in each) and run only a single instance on each active node. We
are doing a mass db consolidation project now and will likely go the path of
a multinode cluster as that will best suit our business needs.
Do you run different coalition settings on your 4-6 instances per node?
Thanks,
Todd
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> No, but the decision must be based on business requirements.
> If you need 2 instances of SQL Server, run them.
> At work, we use put 4-6 instances per node on a SQL Cluster (= 8-12 per 2
> node cluster). Our perspective is that having one machine do nothing is a
> waste of space and energy.
> Single Instance (Active/Passive), from a licensing perspective is cheaper,
> you only need to license the single node as the other node is DR and is not
> active.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Todd" <Todd@.discussions.microsoft.com> wrote in message
> news:90355A4B-87CE-4B14-8C2C-AC0D909D1981@.microsoft.com...
> other
> you
> it to
>
>
|||Hi
No, Same collation. For us, multi-instances are there for security (bank),
to keep everyone away from each other.
It also makes it easier to add more nodes if we need to, so we then move the
instances around.
Once you start to have more than 2 busy instances, you better have a decent
SAN (EMC, biiiig EMC's) that can sustain the throughput. Multi fiber cards,
multi paths etc.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Todd" <Todd@.discussions.microsoft.com> wrote in message
news:23520408-C115-496C-9D33-A5313C3424C2@.microsoft.com...
> I agree Mike. At work we use all active/passive clusters (4 total
clusters
> with 2 nodes in each) and run only a single instance on each active node.
We
> are doing a mass db consolidation project now and will likely go the path
of[vbcol=seagreen]
> a multinode cluster as that will best suit our business needs.
> Do you run different coalition settings on your 4-6 instances per node?
> Thanks,
> Todd
> "Mike Epprecht (SQL MVP)" wrote:
2[vbcol=seagreen]
a[vbcol=seagreen]
cheaper,[vbcol=seagreen]
not[vbcol=seagreen]
config?[vbcol=seagreen]
reason[vbcol=seagreen]
change[vbcol=seagreen]
|||I agree 100% with Mike. I run a large N-1 cluster (N Nodes, N-1 Instances)
so I have one stand-by node for three active instances. I have scripts to
change the cluster failover order depending on what maintenance is
happening. I also can change memory settings and collapse the cluster on a
single node during low activity times for host node maintenance. It takes a
few extra steps to manage a large, multi-instance cluster, but the same
principles apply.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:Ok8qLjeGFHA.3472@.TK2MSFTNGP09.phx.gbl...
> Hi
> No, Same collation. For us, multi-instances are there for security (bank),
> to keep everyone away from each other.
> It also makes it easier to add more nodes if we need to, so we then move
the
> instances around.
> Once you start to have more than 2 busy instances, you better have a
decent
> SAN (EMC, biiiig EMC's) that can sustain the throughput. Multi fiber
cards,[vbcol=seagreen]
> multi paths etc.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Todd" <Todd@.discussions.microsoft.com> wrote in message
> news:23520408-C115-496C-9D33-A5313C3424C2@.microsoft.com...
> clusters
node.[vbcol=seagreen]
> We
path[vbcol=seagreen]
> of
per[vbcol=seagreen]
> 2
is[vbcol=seagreen]
> a
> cheaper,
is[vbcol=seagreen]
> not
> config?
the[vbcol=seagreen]
> reason
> change
Active\Passive?
>
sql

Change Domains

I need to move a Win2k/SQL2k 2-node cluster to another Domain. I'm
considering two alternatives: (a) a node by node rebuild to a Win2k3/SQL2k
cluster in the new Domain, and (b) migrating MSCS to the new domain per
kb26196: "How to Move a Windows Cluster Server from one domain to another",
and then using SQL Server's Setup program, Cluster Administrator, and
regedt32 to migrate the instances to the new domain, per per kb319016: "How
To: Change Doamins for a SQL Server 2000 Failover Cluster". Any advice?
I had to do this recently. I start from scratch and then attached the
databases. Worked great.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Harvey Hall" <Harvey Hall@.discussions.microsoft.com> wrote in message
news:F21C09DF-36F2-4AF4-B50A-B71D9ACDDBDF@.microsoft.com...
>I need to move a Win2k/SQL2k 2-node cluster to another Domain. I'm
> considering two alternatives: (a) a node by node rebuild to a Win2k3/SQL2k
> cluster in the new Domain, and (b) migrating MSCS to the new domain per
> kb26196: "How to Move a Windows Cluster Server from one domain to
> another",
> and then using SQL Server's Setup program, Cluster Administrator, and
> regedt32 to migrate the instances to the new domain, per per kb319016:
> "How
> To: Change Doamins for a SQL Server 2000 Failover Cluster". Any advice?
|||Thanks for your response. Glad to hear that "from scratch" works well. Do you
have any thoughts about what I call plan (b) below, that is:
(b) migrating MSCS to the new domain per kb26196: "How to Move a Windows
Cluster Server from one domain to another", and then using SQL Server's Setup
program, Cluster Administrator, and regedt32 to migrate the instances to the
new domain, per kb319016: "How To: Change Domains for a SQL Server 2000
Failover Cluster"
Would you recommend one approach over another?
"Harvey Hall" wrote:
I need to move a Win2k/SQL2k 2-node cluster to another Domain. I'm
considering two alternatives: (a) a node by node rebuild to a Win2k3/SQL2k
cluster in the new Domain, and (b) migrating MSCS to the new domain per
kb26196: "How to Move a Windows Cluster Server from one domain to another",
and then using SQL Server's Setup program, Cluster Administrator, and
regedt32 to migrate the instances to the new domain, per per kb319016: "How
To: Change Doamins for a SQL Server 2000 Failover Cluster". Any advice?
|||Hello Harvey,
With regards to the options I would utilise the option of building from
scratch if this option is available to you as this will gurantee you that
setup is clean, whereas with the migration option using the KB artilces you
have specified you can run into issues which can be caused by objects not
being created during the migration, etc; service account issues, etc.
However the KB articles are tested and proven to work but as is with most
cases if you can start from scratch its always better, especially in a
cluster environment where you want to gurantee a clean environment for high
availability and ease of troubleshooting.
Regards,
Shashank Pawar
SQL Server Support Engineer, Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Change Domains
| thread-index: AcTZXDH2uVyKQNVbSwSq4yvHs8qoUw==
| X-WBNR-Posting-Host: 69.89.128.5
| From: "=?Utf-8?B?SGFydmV5IEhhbGw=?="
<HarveyHall@.discussions.microsoft.com>
| References: <F21C09DF-36F2-4AF4-B50A-B71D9ACDDBDF@.microsoft.com>
| Subject: RE: Change Domains
| Date: Fri, 3 Dec 2004 09:19:07 -0800
| Lines: 20
| Message-ID: <011FD8E0-BBF7-4040-B2BD-1A9098C71D6D@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.clustering
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFT NGXA01.phx.gbl!TK2MSFTNGXA
03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.clustering:15918
| X-Tomcat-NG: microsoft.public.sqlserver.clustering
|
| Thanks for your response. Glad to hear that "from scratch" works well. Do
you
| have any thoughts about what I call plan (b) below, that is:
|
| (b) migrating MSCS to the new domain per kb26196: "How to Move a Windows
| Cluster Server from one domain to another", and then using SQL Server's
Setup
| program, Cluster Administrator, and regedt32 to migrate the instances to
the
| new domain, per kb319016: "How To: Change Domains for a SQL Server 2000
| Failover Cluster"
|
| Would you recommend one approach over another?
|
| "Harvey Hall" wrote:
|
| I need to move a Win2k/SQL2k 2-node cluster to another Domain. I'm
| considering two alternatives: (a) a node by node rebuild to a
Win2k3/SQL2k
| cluster in the new Domain, and (b) migrating MSCS to the new domain per
| kb26196: "How to Move a Windows Cluster Server from one domain to
another",
| and then using SQL Server's Setup program, Cluster Administrator, and
| regedt32 to migrate the instances to the new domain, per per kb319016:
"How
| To: Change Doamins for a SQL Server 2000 Failover Cluster". Any advice?
|
sql

Change Cluster Disk Owner

I have an Active/Active cluster with Windows 2003 with SQL Server 2000. I
am trying to move the cluster disk T: owner to my other group.
I keep receiving the following error:
An error occurred attempting to change the group of the
Disk T: to 'Other Resource' Group. The cluster node is not the owner of the
group. Error ID:5016
I checked all cluster groups and they have both owners. I also checked and
there is no dependency on Disk T:
Please help me with moving Disk T: to the Other Resource Group.
Thanks,
You can only change ownership of a resource from the node that currently
both resource groups.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:BAFDEF6E-33BF-4C6B-9066-8CD9F5347325@.microsoft.com...
> I have an Active/Active cluster with Windows 2003 with SQL Server 2000. I
> am trying to move the cluster disk T: owner to my other group.
> I keep receiving the following error:
> An error occurred attempting to change the group of the
> Disk T: to 'Other Resource' Group. The cluster node is not the owner of
the
> group. Error ID:5016
> I checked all cluster groups and they have both owners. I also checked
and
> there is no dependency on Disk T:
> Please help me with moving Disk T: to the Other Resource Group.
>
> Thanks,
|||And the SOLUTION would be to create a new resource group ("FOO") with no resources in it. Move it to the same node as the group that owns the resource you want to move. Now you can move the resource into the FOO resource group.
Move the FOO resource group to the node that owns the group to which you'd like to move the resource. Now you can move the resource to its destination.
Remove the FOO group and you are done.
This, of course, is only necessary if you can't move both resources to the same node for some reason.
HTH
jg

Quote:

Originally posted by Geoff N. Hiten
You can only change ownership of a resource from the node that currently
both resource groups.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
> I have an Active/Active cluster with Windows 2003 with SQL Server 2000. I
> am trying to move the cluster disk T: owner to my other group.
> I keep receiving the following error:
> An error occurred attempting to change the group of the
> Disk T: to 'Other Resource' Group. The cluster node is not the owner of[/vbcol]
the
> group. Error ID:5016
> I checked all cluster groups and they have both owners. I also checked
and
> there is no dependency on Disk T:
> Please help me with moving Disk T: to the Other Resource Group.
>
> Thanks,

|||Joe,
Geoff is correct.
Make sure you both groups are on the same node.
Then from that node, move the T: drive into the other resource group.
You will of course need to make sure T: is not a dependency of any other
resources prior to moving it.
Hope that helps!
Donna Lambert
Microsoft PSS
SQL Server Support

Change

Currently have a 2 node windows 2000 cluster, active/passive, with sql 2000
running a data vault that's controlled by node a. Would like to upgrade to
windows 2003, but run active/active with sql running on node b. To do this,
do I have to reinstall sql server? I'm at a loss and all help and any white
papers would be appreciated.
Thanks in advance.
Hi
Don't think of "active/passive" or "active/active", rather think of it as 2
nodes, with either one or 2 (or 3 or 4 etc) virtual servers.
Currently, you have 2 nodes, with one virtual server and you want to have 2
nodes with 2 virtual servers. Between the 2 nodes, there is a shared quorum
drive.
The virtual server you currently have has a name, an IP address and disk
groups associated with it. If you want an additional virtual server, you
need the same again, another name, another IP address and another set of
disk groups.
Only one node can own a disk group at a time, so it you have allocated all
the space on the SAN to one disk group, you do not have space to make more
virtual disks for the other node. You might need to buy higher capacity
drives, add drives or add another SAN, or reduce the size allocated to the
disk group that currently exists.
I have a strict policy. No OS Upgrades to clusters. Re-Installs only.
Especially if you have to re-do the disk groups, it gives you a chance to
re-do the cluster.
So, backup your databases to a safe place, off the SAN, wipe it, setup your
disks and then re-do the whole cluster.
Get to know the content on
http://www.microsoft.com/windowsserv...g/default.mspx
On the pages, there is a step by step on how to setup a SQL cluster:
http://www.microsoft.com/technet/pro.../failclus.mspx
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:B2FC1873-54BB-40F8-B0BD-CA25597A35E9@.microsoft.com...
> Currently have a 2 node windows 2000 cluster, active/passive, with sql
2000
> running a data vault that's controlled by node a. Would like to upgrade
to
> windows 2003, but run active/active with sql running on node b. To do
this,
> do I have to reinstall sql server? I'm at a loss and all help and any
white
> papers would be appreciated.
> Thanks in advance.
|||I have a slightly different approach. I will allow an OS node upgrade,
mainly to find out compatibility issues, then I go back and rebuild each
node from scratch.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OIoWPIzLFHA.2492@.TK2MSFTNGP14.phx.gbl...
> Hi
> Don't think of "active/passive" or "active/active", rather think of it as
> 2
> nodes, with either one or 2 (or 3 or 4 etc) virtual servers.
> Currently, you have 2 nodes, with one virtual server and you want to have
> 2
> nodes with 2 virtual servers. Between the 2 nodes, there is a shared
> quorum
> drive.
> The virtual server you currently have has a name, an IP address and disk
> groups associated with it. If you want an additional virtual server, you
> need the same again, another name, another IP address and another set of
> disk groups.
> Only one node can own a disk group at a time, so it you have allocated all
> the space on the SAN to one disk group, you do not have space to make more
> virtual disks for the other node. You might need to buy higher capacity
> drives, add drives or add another SAN, or reduce the size allocated to the
> disk group that currently exists.
> I have a strict policy. No OS Upgrades to clusters. Re-Installs only.
> Especially if you have to re-do the disk groups, it gives you a chance to
> re-do the cluster.
> So, backup your databases to a safe place, off the SAN, wipe it, setup
> your
> disks and then re-do the whole cluster.
> Get to know the content on
> http://www.microsoft.com/windowsserv...g/default.mspx
> On the pages, there is a step by step on how to setup a SQL cluster:
> http://www.microsoft.com/technet/pro.../failclus.mspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Scott" <Scott@.discussions.microsoft.com> wrote in message
> news:B2FC1873-54BB-40F8-B0BD-CA25597A35E9@.microsoft.com...
> 2000
> to
> this,
> white
>
|||Thanks Mike and Geoff!!!!
It's pretty much what I figured, but was hoping not.
Again, THANKS!!!!
"Geoff N. Hiten" wrote:

> I have a slightly different approach. I will allow an OS node upgrade,
> mainly to find out compatibility issues, then I go back and rebuild each
> node from scratch.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:OIoWPIzLFHA.2492@.TK2MSFTNGP14.phx.gbl...
>
>

Catalog Population Fails on Cluster

I have an installation that move their database to a cluster server.
SQL2000 has SP3 applied.
We created a new FTS against a single table, single row.
The table has 500,000 rows of data.
When I select "Start Full Population" the task completes immediately and the
count is one.
The edited text from the Application Log follows:
Event Type: Information
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3019
Date: 12/14/2004
Time: 4:10:34 PM
User: N/A
Computer: NT-TWDB2
Description:
The crawl on project <SQLServer SQL0000500005> has started.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3035
Date: 12/14/2004
Time: 4:10:35 PM
User: N/A
Computer: NT-TWDB2
Description:
One or more warnings or errors for Gatherer project <SQLServer
SQL0000500005> were logged to file <S:\Program Files\Microsoft SQL
Server\MSSQL\FTData\SQLServer\GatherLogs\SQL000050 0005.1.gthr>. If you are
interested in these messages, please, look at the file using the gatherer
log query object (gthrlog.vbs, log viewer web page).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3036
Date: 12/14/2004
Time: 4:10:35 PM
User: N/A
Computer: NT-TWDB2
Description:
The crawl seed <MSSQL75://SQLServer/318258d2> in project <SQLServer
SQL0000500005> cannot be accessed. Error: 8007007f - The specified procedure
could not be found. .
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3024
Date: 12/14/2004
Time: 4:10:35 PM
User: N/A
Computer: NT-TWDB2
Description:
The crawl for project <SQLServer SQL0000500005> could not be started,
because no crawl seeds could be accessed. Fix the errors and try the crawl
again.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Information
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3018
Date: 12/14/2004
Time: 4:10:36 PM
User: N/A
Computer: NT-TWDB2
Description:
The end of crawl for project <SQLServer SQL0000500005> has been detected.
The Gatherer successfully processed 0 documents totaling 0K. It failed to
filter 1 documents. 0 URLs could not be reached or were denied access.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
I followed the recommendations of
http://support.microsoft.com/default...;en-us;817301,
PRB: Microsoft Search Full-Text Catalog Population Fails When You Upgrade
SQL Server 2000 Failover Cluster to SQL Server 2000 Service Pack 3
I registered every dll in the Bin folder.
This did not help.
Where do I go from here?
Binder,
First of all, thank you for providing the "Microsoft Search" source events
from your server's Application event log as this is very helpful info in
troubleshooting this SQL FTS issue in a clustered environment!
The key error here is "Error: 8007007f - The specified procedure could not
be found." and the two following KB articles may be appropriate to this
problem, but the error reference in KB article Q304282 - "80070002 - The
system cannot find the file specified" is close, but not exactly the same
error (8007007f ). Reviewing past postings in this newsgroup, I found one
with your error and a past poster suggested this can be resolved via
re-running the SearchStp.exe program from SP3 file. Another suggestion was
to change the (fulltext) dependency to the SQL Agent - in a clean install -
this stops all errors from occurring. Below are the KB articles:
Q304282 PRB: Full Text Resource Fails to Come Online on a Cluster with
"Event ID 1069 :
SQL Cluster Resource 'Full Text' failed" Error Message
http://support.microsoft.com/default...304282&sd=tech
812666 How to recover a failed full-text search resource on a clustered
instance of SQL Server 2000
http://support.microsoft.com/default.aspx?kbid=812666
Hope this helps!
John
"Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
news:uk6Hp734EHA.3908@.TK2MSFTNGP12.phx.gbl...
> I have an installation that move their database to a cluster server.
> SQL2000 has SP3 applied.
> We created a new FTS against a single table, single row.
> The table has 500,000 rows of data.
> When I select "Start Full Population" the task completes immediately and
the
> count is one.
> The edited text from the Application Log follows:
>
> Event Type: Information
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3019
> Date: 12/14/2004
> Time: 4:10:34 PM
> User: N/A
> Computer: NT-TWDB2
> Description:
> The crawl on project <SQLServer SQL0000500005> has started.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3035
> Date: 12/14/2004
> Time: 4:10:35 PM
> User: N/A
> Computer: NT-TWDB2
> Description:
> One or more warnings or errors for Gatherer project <SQLServer
> SQL0000500005> were logged to file <S:\Program Files\Microsoft SQL
> Server\MSSQL\FTData\SQLServer\GatherLogs\SQL000050 0005.1.gthr>. If you are
> interested in these messages, please, look at the file using the gatherer
> log query object (gthrlog.vbs, log viewer web page).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3036
> Date: 12/14/2004
> Time: 4:10:35 PM
> User: N/A
> Computer: NT-TWDB2
> Description:
> The crawl seed <MSSQL75://SQLServer/318258d2> in project <SQLServer
> SQL0000500005> cannot be accessed. Error: 8007007f - The specified
procedure
> could not be found. .
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3024
> Date: 12/14/2004
> Time: 4:10:35 PM
> User: N/A
> Computer: NT-TWDB2
> Description:
> The crawl for project <SQLServer SQL0000500005> could not be started,
> because no crawl seeds could be accessed. Fix the errors and try the crawl
> again.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Event Type: Information
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3018
> Date: 12/14/2004
> Time: 4:10:36 PM
> User: N/A
> Computer: NT-TWDB2
> Description:
> The end of crawl for project <SQLServer SQL0000500005> has been detected.
> The Gatherer successfully processed 0 documents totaling 0K. It failed to
> filter 1 documents. 0 URLs could not be reached or were denied access.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> I followed the recommendations of
> http://support.microsoft.com/default...;en-us;817301,
> PRB: Microsoft Search Full-Text Catalog Population Fails When You Upgrade
> SQL Server 2000 Failover Cluster to SQL Server 2000 Service Pack 3
> I registered every dll in the Bin folder.
> This did not help.
> Where do I go from here?
>
>
|||John,
If the original database was backed up from another server then restored to
this cluster machine, is the FTData directory
copied from the original machine also? Does a restore affect the FTData
directory?
I believe they installed SQL to the cluster with FTS, then did a restore
from the other machine's backup.
Wouldn't the FTData folder be created when FTS was installed with the
initial SQL setup?
If this is the case, would the issues you reference concerning the FTData
folder and its files be a possible source of the problem?
Rg
"John Kane" <jt-kane@.comcast.net> wrote in message
news:ehECYk44EHA.1976@.TK2MSFTNGP09.phx.gbl...
> Binder,
> First of all, thank you for providing the "Microsoft Search" source events
> from your server's Application event log as this is very helpful info in
> troubleshooting this SQL FTS issue in a clustered environment!
> The key error here is "Error: 8007007f - The specified procedure could not
> be found." and the two following KB articles may be appropriate to this
> problem, but the error reference in KB article Q304282 - "80070002 - The
> system cannot find the file specified" is close, but not exactly the same
> error (8007007f ). Reviewing past postings in this newsgroup, I found one
> with your error and a past poster suggested this can be resolved via
> re-running the SearchStp.exe program from SP3 file. Another suggestion was
> to change the (fulltext) dependency to the SQL Agent - in a clean
install -[vbcol=seagreen]
> this stops all errors from occurring. Below are the KB articles:
> Q304282 PRB: Full Text Resource Fails to Come Online on a Cluster with
> "Event ID 1069 :
> SQL Cluster Resource 'Full Text' failed" Error Message
> http://support.microsoft.com/default...304282&sd=tech
> 812666 How to recover a failed full-text search resource on a clustered
> instance of SQL Server 2000
> http://support.microsoft.com/default.aspx?kbid=812666
> Hope this helps!
> John
>
>
> "Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
> news:uk6Hp734EHA.3908@.TK2MSFTNGP12.phx.gbl...
> the
are[vbcol=seagreen]
gatherer[vbcol=seagreen]
> procedure
crawl[vbcol=seagreen]
detected.[vbcol=seagreen]
to[vbcol=seagreen]
Upgrade
>
|||Binder,
No, the FTData directory (and files under it) are not backed up with a
database backup for SQL Server 2000 and SQL Server 7.0, but this will be a
new feature in SQL Server 2005 (Yukon). However, the FTData directory is
installed by default by SQL 2000 Enterprise Edition, but not necessarily at
the same location as the original database, i.e.., different installation
paths.
If a restore was done to the same database, then an internal system table
(sysfulltextcatalogs) may not have the correct path (a value of null is
normal), as if the source server's location of the FT Catalog (may be
different from the FTData directory) is different from the destination
server's location of the FT Catalog then this may be the cause of the error.
Note, for clustered environments, the FT Catalog can only exist on the
shared drive and if the source server's drive letter for the FT Catalog is
different, then this can be correct in the sysfulltextcatalogs table. If
this is the problem, when you create a new FT Catalog in this database it
will fail with an error. Could you try this?
Thanks,
John
"Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
news:uuMVoF54EHA.2624@.TK2MSFTNGP11.phx.gbl...
> John,
> If the original database was backed up from another server then restored
to[vbcol=seagreen]
> this cluster machine, is the FTData directory
> copied from the original machine also? Does a restore affect the FTData
> directory?
> I believe they installed SQL to the cluster with FTS, then did a restore
> from the other machine's backup.
> Wouldn't the FTData folder be created when FTS was installed with the
> initial SQL setup?
> If this is the case, would the issues you reference concerning the FTData
> folder and its files be a possible source of the problem?
>
> Rg
>
>
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:ehECYk44EHA.1976@.TK2MSFTNGP09.phx.gbl...
events[vbcol=seagreen]
not[vbcol=seagreen]
same[vbcol=seagreen]
one[vbcol=seagreen]
was[vbcol=seagreen]
> install -
and
> are
> gatherer
> crawl
> detected.
> to
> Upgrade
>