How to remove the sqlcachedependancy ?

I had sqlcachedependancy installed. But now I cannot uninstall it?

1. I unregistered:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -E -S localhost
-d DNN1 -dd

2. I remove the Dependencry.Start() from my application_start

' System.Data.SqlClient.SqlDependency.Start(ConfigurationManager.ConnectionStrings("SiteSqlServer").ConnectionString)

3. I removed the cache section from my web.config

4. I removed the outputcache statements from my aspx pages.

<!--<%@. OutputCache Duration="1" VaryByParam="*" SqlDependency="CommandNotification" %>-->

However, I still get the next error:

FileError When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance.

What to do?

Any help or advice is appreciated.

Jelle

Have you done a search through all of your application's files, looking for a rogue SqlDependency instance?|||

Thank you for your reply. I looked mainly in the default.aspx and forgot that for Dotnetnuke I also modified the install.aspx file. So in the end I copy-past all the next files over my files:

default.aspx + codebehind

install.aspx + codebehind

global.ascx

assembly + global file in app_code directory

That solved the solution.

Main reason I wanted to uninstall is that in case the webserver does stop a connection, the database server starts logging errors that the connectio n with the remote webserver is lost...and then the database server hangs. Would be nicer of MS SQL2005 to stop the logging in case the webserver does not request any info anymore.

How to remove a previous Installed instance

I uninstall the complete SQL Server 2005, and then when I reinstall it,
Reporting Services don't want to install because a previous installed
instance is detected.Hi Robert,
Welcome to MSDN newsgroup.
From your description, you've uninstalled the existing SQL Server 2005 on
your server. However, when you try reinstalling it later, you get
error(during Reporting Service installation) indicate that there is a
previous installed instance, correct?
Based on my experience, when installing the SQL Server, setup program will
try detecting existing SQL Server instances through the windows registry.
So you can have a look in the registry to see whether the Reporting Service
entry is still there. For SQL 2005, it uses the MSSQL.X like naming
convention, e.g
on my test server, the SQL 2005 Reporting Service is associated with the
below key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.4
In addition, before we performing registry editing, I suggest you still
have a look at the following SQL Server setup document and try the
commandline uninstallation (for specific named instance...) to see whether
it can help clearly remove the Reporting service instance.
#How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)
http://msdn2.microsoft.com/en-us/library/ms143412.aspx
Hope helps. Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Roberto Hernández" <robertohh@.newsgroups.nospam>
| Subject: How to remove a previous Installed instance
| Date: Tue, 24 Jan 2006 12:30:59 -0600
| Lines: 5
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <e1y#uoRIGHA.3036@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 201.201.36.70
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67408
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I uninstall the complete SQL Server 2005, and then when I reinstall it,
| Reporting Services don't want to install because a previous installed
| instance is detected.
|
|
||||Thanks,
solved deleting the regedit key
And then I reinstall it and all works ok.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> escribió en el mensaje
news:VOdn65WIGHA.3944@.TK2MSFTNGXA02.phx.gbl...
> Hi Robert,
> Welcome to MSDN newsgroup.
> From your description, you've uninstalled the existing SQL Server 2005 on
> your server. However, when you try reinstalling it later, you get
> error(during Reporting Service installation) indicate that there is a
> previous installed instance, correct?
> Based on my experience, when installing the SQL Server, setup program will
> try detecting existing SQL Server instances through the windows registry.
> So you can have a look in the registry to see whether the Reporting
> Service
> entry is still there. For SQL 2005, it uses the MSSQL.X like naming
> convention, e.g
> on my test server, the SQL 2005 Reporting Service is associated with the
> below key:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.4
> In addition, before we performing registry editing, I suggest you still
> have a look at the following SQL Server setup document and try the
> commandline uninstallation (for specific named instance...) to see whether
> it can help clearly remove the Reporting service instance.
> #How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)
> http://msdn2.microsoft.com/en-us/library/ms143412.aspx
> Hope helps. Thanks,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Roberto Hernández" <robertohh@.newsgroups.nospam>
> | Subject: How to remove a previous Installed instance
> | Date: Tue, 24 Jan 2006 12:30:59 -0600
> | Lines: 5
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | Message-ID: <e1y#uoRIGHA.3036@.tk2msftngp13.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 201.201.36.70
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:67408
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I uninstall the complete SQL Server 2005, and then when I reinstall it,
> | Reporting Services don't want to install because a previous installed
> | instance is detected.
> |
> |
> |
>|||Thanks for your response Roberto,
Glad that we've resolved the problem.
Have a good day!
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--
| From: "Roberto Hernández" <robertohh@.newsgroups.nospam>
| References: <e1y#uoRIGHA.3036@.tk2msftngp13.phx.gbl>
<VOdn65WIGHA.3944@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: How to remove a previous Installed instance
| Date: Wed, 25 Jan 2006 14:32:42 -0600
| Lines: 72
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <uk3xA6eIGHA.984@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 201.201.36.70
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67515
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Thanks,
| solved deleting the regedit key
| And then I reinstall it and all works ok.
|
|
| "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> escribi?en el mensaje
| news:VOdn65WIGHA.3944@.TK2MSFTNGXA02.phx.gbl...
| > Hi Robert,
| >
| > Welcome to MSDN newsgroup.
| > From your description, you've uninstalled the existing SQL Server 2005
on
| > your server. However, when you try reinstalling it later, you get
| > error(during Reporting Service installation) indicate that there is a
| > previous installed instance, correct?
| >
| > Based on my experience, when installing the SQL Server, setup program
will
| > try detecting existing SQL Server instances through the windows
registry.
| > So you can have a look in the registry to see whether the Reporting
| > Service
| > entry is still there. For SQL 2005, it uses the MSSQL.X like naming
| > convention, e.g
| >
| > on my test server, the SQL 2005 Reporting Service is associated with the
| > below key:
| >
| > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.4
| >
| > In addition, before we performing registry editing, I suggest you still
| > have a look at the following SQL Server setup document and try the
| > commandline uninstallation (for specific named instance...) to see
whether
| > it can help clearly remove the Reporting service instance.
| >
| > #How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)
| > http://msdn2.microsoft.com/en-us/library/ms143412.aspx
| >
| > Hope helps. Thanks,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| > --
| > | From: "Roberto Hernández" <robertohh@.newsgroups.nospam>
| > | Subject: How to remove a previous Installed instance
| > | Date: Tue, 24 Jan 2006 12:30:59 -0600
| > | Lines: 5
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | Message-ID: <e1y#uoRIGHA.3036@.tk2msftngp13.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: 201.201.36.70
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:67408
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | I uninstall the complete SQL Server 2005, and then when I reinstall
it,
| > | Reporting Services don't want to install because a previous installed
| > | instance is detected.
| > |
| > |
| > |
| >
|
|
|

How to remove (uninstall ) cluster sql server manually?

Hi All,
Environment:windows2003 sp1
SQl server 2000, sp2, and It is clustered(2 nodes)
I need to uninstall SQL server2000 . When i tried to uninstall from setup,
i have got error and so i have deleted manually so sql binaries and registry
key(services\mssqlserver and sqlagent).
Now i am not able to uninstall completely..
Can anyone help me what are the registry keys, files etc need to be deleted
for this unstallation to complete?How to clean it properly?
Thanks in adavnce
Suchi
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/kb/290991/en-us
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:CC2377D2-7128-4C59-AF25-29136F9AB016@.microsoft.com...
> Hi All,
> Environment:windows2003 sp1
> SQl server 2000, sp2, and It is clustered(2 nodes)
> I need to uninstall SQL server2000 . When i tried to uninstall from
> setup,
> i have got error and so i have deleted manually so sql binaries and
> registry
> key(services\mssqlserver and sqlagent).
> Now i am not able to uninstall completely..
> Can anyone help me what are the registry keys, files etc need to be
> deleted
> for this unstallation to complete?How to clean it properly?
> Thanks in adavnce
> Suchi
|||Thanks Hiten for the quick reponse.
I have gone through the below Link before uninstalling .
As i was getting error while uninstalling from setup(method 2),I removed the
data and some of binaries . I cloud not delete the reg key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer.
Getting "Cannot delet MSsqlserver: Error while deleting key" error.
SQL server is clustered.Even i could not delet some binaries. Getting access
denied error. I am using admin account with full permissions..
Thanks..
Suchi
"Geoff N. Hiten" wrote:

> How to manually remove SQL Server 2000 default, named, or virtual instance
> http://support.microsoft.com/kb/290991/en-us
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:CC2377D2-7128-4C59-AF25-29136F9AB016@.microsoft.com...
>
|||You may have to reboot nodes to clear some leftover file locks.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:2CBE9799-2529-40D0-B4F3-621629258E63@.microsoft.com...[vbcol=seagreen]
> Thanks Hiten for the quick reponse.
> I have gone through the below Link before uninstalling .
> As i was getting error while uninstalling from setup(method 2),I removed
> the
> data and some of binaries . I cloud not delete the reg key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer.
> Getting "Cannot delet MSsqlserver: Error while deleting key" error.
> SQL server is clustered.Even i could not delet some binaries. Getting
> access
> denied error. I am using admin account with full permissions..
> Thanks..
> Suchi
> "Geoff N. Hiten" wrote:
|||Hiten,
can you please let me know any reg keys need to be deleted before rebooting?
"Geoff N. Hiten" wrote:

> You may have to reboot nodes to clear some leftover file locks.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:2CBE9799-2529-40D0-B4F3-621629258E63@.microsoft.com...
>
|||It sounds like you may have some SQL services still running. That will lock
down certain file folders and possibly registry keys. Stop all the SQL
services and follow the instructions that match your setup (named or default
instance) exactly on all nodes. If something prevents a folder or reg key
deletion, then it is time to reboot, verify the services are not running,
and try again.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:07AC7A23-0505-473D-BC3D-FFB13321AC07@.microsoft.com...[vbcol=seagreen]
> Hiten,
> can you please let me know any reg keys need to be deleted before
> rebooting?
> "Geoff N. Hiten" wrote:
|||You my need to remove some virtual resources if the processes outlined in
the KB article do not clear them out. Basically, try and get the cluster
back to where it was before the blown SQL install.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:CEF3C105-C5F4-4B53-926A-B4D90C8CD53F@.microsoft.com...[vbcol=seagreen]
> Thanks much..
> Do i need to delete resources from cluster admin?
> If yes, is it from resorces or from groups?
>
> "Geoff N. Hiten" wrote:

How to remove (uninstall ) cluster sql server manually

HI All,
As HIten said,(in my previous post) I am able to remove all the registry
entries except hklm\software\microsoft\mssqlserver after couple of reboots of
the both the nodes.
I am still getting Getting "Cannot delet MSsqlserver: Error while deleting
key" error.
I did not delete any resources in cluadmin. Do i need to delete
sqlserver,agent, search resources only or disk resources also need to get
deleted?
Thanks in advance
Suchi
To be clear enough, In below Kb article it is mentioned as
If the instance of SQL Server you are removing was clustered, remove any
cluster resources for the instance that may remain in the Cluster
Administrator.
I am new to Clusters, what are all the resourcs do i need to delete?
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/kb/290991/en-us
"Suchi" wrote:

> HI All,
>
> As HIten said,(in my previous post) I am able to remove all the registry
> entries except hklm\software\microsoft\mssqlserver after couple of reboots of
> the both the nodes.
> I am still getting Getting "Cannot delet MSsqlserver: Error while deleting
> key" error.
> I did not delete any resources in cluadmin. Do i need to delete
> sqlserver,agent, search resources only or disk resources also need to get
> deleted?
> Thanks in advance
> Suchi
>
>
|||You'll need to go into ClusterAdmin and remove the resources. Don't remove
the disk resource.
Also, check out www.clusterhelp.com for suitable training in clusters.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:DDE03400-B723-4800-BD98-B0891596660A@.microsoft.com...
To be clear enough, In below Kb article it is mentioned as
If the instance of SQL Server you are removing was clustered, remove any
cluster resources for the instance that may remain in the Cluster
Administrator.
I am new to Clusters, what are all the resourcs do i need to delete?
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/kb/290991/en-us
"Suchi" wrote:

> HI All,
>
> As HIten said,(in my previous post) I am able to remove all the registry
> entries except hklm\software\microsoft\mssqlserver after couple of reboots
> of
> the both the nodes.
> I am still getting Getting "Cannot delet MSsqlserver: Error while
> deleting
> key" error.
> I did not delete any resources in cluadmin. Do i need to delete
> sqlserver,agent, search resources only or disk resources also need to get
> deleted?
> Thanks in advance
> Suchi
>
>
|||Thanks Much tom..
Do i need to delete sql group also to clean the sql server?
"Tom Moreau" wrote:

> You'll need to go into ClusterAdmin and remove the resources. Don't remove
> the disk resource.
> Also, check out www.clusterhelp.com for suitable training in clusters.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:DDE03400-B723-4800-BD98-B0891596660A@.microsoft.com...
> To be clear enough, In below Kb article it is mentioned as
> If the instance of SQL Server you are removing was clustered, remove any
> cluster resources for the instance that may remain in the Cluster
> Administrator.
> I am new to Clusters, what are all the resourcs do i need to delete?
> How to manually remove SQL Server 2000 default, named, or virtual instance
> http://support.microsoft.com/kb/290991/en-us
>
>
> "Suchi" wrote:
>
>
|||No, just keep the group and the disk resource. Remove everything else
within the SQL group. You'll probably want to reboot afterwards (both
nodes).
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:7611F8B8-0FE7-4B7A-AA1B-DCC928F7DFA0@.microsoft.com...
Thanks Much tom..
Do i need to delete sql group also to clean the sql server?
"Tom Moreau" wrote:

> You'll need to go into ClusterAdmin and remove the resources. Don't remove
> the disk resource.
> Also, check out www.clusterhelp.com for suitable training in clusters.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:DDE03400-B723-4800-BD98-B0891596660A@.microsoft.com...
> To be clear enough, In below Kb article it is mentioned as
> If the instance of SQL Server you are removing was clustered, remove any
> cluster resources for the instance that may remain in the Cluster
> Administrator.
> I am new to Clusters, what are all the resourcs do i need to delete?
> How to manually remove SQL Server 2000 default, named, or virtual
> instance
> http://support.microsoft.com/kb/290991/en-us
>
>
> "Suchi" wrote:
>
>
|||Thanks much Tom.
I have deleted cluster resources (except disk)as you said.
I could delete all except hklm\software\microsoft\mssqlserver on node1.
Node2 is completed cleaned. Eeven deleted
hklm\software\microsoft\mssqlserver from node2.
Still getting cannt delete key while deleting above reg key on node1.
Is there anythng I am missing here?Done several reboots also..
Thanks a lot..
"Tom Moreau" wrote:

> No, just keep the group and the disk resource. Remove everything else
> within the SQL group. You'll probably want to reboot afterwards (both
> nodes).
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:7611F8B8-0FE7-4B7A-AA1B-DCC928F7DFA0@.microsoft.com...
> Thanks Much tom..
> Do i need to delete sql group also to clean the sql server?
>
> "Tom Moreau" wrote:
>
>
|||Hmm. Have you removed all of the binaries, e.g. C:\Program Files\Microsoft
SQL Server\...
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:4F2A3078-2465-421E-BF4C-8D86978E442E@.microsoft.com...
Thanks much Tom.
I have deleted cluster resources (except disk)as you said.
I could delete all except hklm\software\microsoft\mssqlserver on node1.
Node2 is completed cleaned. Eeven deleted
hklm\software\microsoft\mssqlserver from node2.
Still getting cannt delete key while deleting above reg key on node1.
Is there anythng I am missing here?Done several reboots also..
Thanks a lot..
"Tom Moreau" wrote:

> No, just keep the group and the disk resource. Remove everything else
> within the SQL group. You'll probably want to reboot afterwards (both
> nodes).
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:7611F8B8-0FE7-4B7A-AA1B-DCC928F7DFA0@.microsoft.com...
> Thanks Much tom..
> Do i need to delete sql group also to clean the sql server?
>
> "Tom Moreau" wrote:
>
>
|||Yes Tom. I deleted all binaries.
"Suchi" wrote:
[vbcol=seagreen]
> To be clear enough, In below Kb article it is mentioned as
> If the instance of SQL Server you are removing was clustered, remove any
> cluster resources for the instance that may remain in the Cluster
> Administrator.
> I am new to Clusters, what are all the resourcs do i need to delete?
> How to manually remove SQL Server 2000 default, named, or virtual instance
> http://support.microsoft.com/kb/290991/en-us
>
>
> "Suchi" wrote:
|||And the appropriate keys were removed from CurrentControlSet\Services etc.?
If so, then you may very well have to rebuild the node.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:9D35C0B0-7488-4747-B56B-E787062E5C39@.microsoft.com...
Yes Tom. I deleted all binaries.
"Suchi" wrote:
[vbcol=seagreen]
> To be clear enough, In below Kb article it is mentioned as
> If the instance of SQL Server you are removing was clustered, remove any
> cluster resources for the instance that may remain in the Cluster
> Administrator.
> I am new to Clusters, what are all the resourcs do i need to delete?
> How to manually remove SQL Server 2000 default, named, or virtual
> instance
> http://support.microsoft.com/kb/290991/en-us
>
>
> "Suchi" wrote:

How to reinstall?

Hello all,
can anyone tell, is there anyway to reinstall/repair full-text without
having to actually uninstall and resintall the whole Sql Server?
Thanks in advance,
- Arthur Dent.
http://support.microsoft.com/default...b;en-us;827449
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:O7P0WgNjFHA.3256@.TK2MSFTNGP12.phx.gbl...
> Hello all,
> can anyone tell, is there anyway to reinstall/repair full-text without
> having to actually uninstall and resintall the whole Sql Server?
> Thanks in advance,
> - Arthur Dent.
>
|||Thank you very much for the link.
I checked it and went through all the steps.
My full text is still not working however.
I have the menu-options all there in Enterprise Manager,
however they are all greyed out.
The log file from the Full-Text command-line install contained
the following message:
FulltextSetup returned error code: 0x0
Any ideas?
Thanks in advance,
- Arthur Dent.
|||You may be running into this problem.
http://support.microsoft.com/default...b;en-us;270671
or check this out
http://www.indexserverfaq.com/TableNotEnabled.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:e6UNCVajFHA.3960@.TK2MSFTNGP12.phx.gbl...
> Thank you very much for the link.
> I checked it and went through all the steps.
> My full text is still not working however.
> I have the menu-options all there in Enterprise Manager,
> however they are all greyed out.
> The log file from the Full-Text command-line install contained
> the following message:
> FulltextSetup returned error code: 0x0
> Any ideas?
> Thanks in advance,
> - Arthur Dent.
>
|||I dont think it is a security issue. I had had FT working perfectly on my
system before.
Then i installed a sql tool, to try out. It was slow, so i removed it,
however the uninstall
was not well-behaved and took a bunch of the SS system files with it,
effectively killing
my install of the client tools.
So i uninstalled Sql Server, and then reinstalled it, and now i cant get FTS
working again.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23OLAUvdjFHA.2852@.TK2MSFTNGP14.phx.gbl...
> You may be running into this problem.
> http://support.microsoft.com/default...b;en-us;270671
> or check this out
> http://www.indexserverfaq.com/TableNotEnabled.htm
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
> news:e6UNCVajFHA.3960@.TK2MSFTNGP12.phx.gbl...
>
|||Heres some more info... if i try to run the FT wizard through Tools >
Wizards, i get a message that says
"The Full-Text Server service needs to be running in order to open this
wizard."
Which service is it? The Microsoft Search service already is running.
The Indexing Service wasn't so i started that, but that didnt help.
Is somehow my EM not aware of my FT service being there, and just needs to
be told?
Thanks in advance.
|||its MSSearch alright. What happens when you try to run SQLftwiz from the
command line?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:%23bMwM4fjFHA.1048@.tk2msftngp13.phx.gbl...
> Heres some more info... if i try to run the FT wizard through Tools >
> Wizards, i get a message that says
> "The Full-Text Server service needs to be running in order to open this
> wizard."
> Which service is it? The Microsoft Search service already is running.
> The Indexing Service wasn't so i started that, but that didnt help.
> Is somehow my EM not aware of my FT service being there, and just needs to
> be told?
> Thanks in advance.
>
|||sqlftwiz runs fine.
When i tried to add a column to an existing ft catalog though, it tells me
the catalog has been lost, and i need to use the SPs to recreate it.
If i try to delete the old catalog in EM, it tells me that the FT service
must
be running in order to delete a catalog, which it is, but EM cant see it.
If i use sqlftwiz to make a brand new catalog though, it works fine.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ORIFA9gjFHA.2920@.TK2MSFTNGP14.phx.gbl...
> its MSSearch alright. What happens when you try to run SQLftwiz from the
> command line?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html