Hi all
In my SQL Server 2000, i've created linked server to
MachineA. I didn't remove the link before I reinstall
MachineA to become MachineB. Now, I'm failed to delete
MachineA link server from the Enterprise Manager. How can
I fix it? Thanks.You should be able to run the below in Query Analyzer
exec sp_dropserver 'MachineA','droplogins'
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jon" <klliu98@.yahoo.com> wrote in message
news:075201c3d5aa$7df68390$a401280a@.phx.gbl...
> Hi all
> In my SQL Server 2000, i've created linked server to
> MachineA. I didn't remove the link before I reinstall
> MachineA to become MachineB. Now, I'm failed to delete
> MachineA link server from the Enterprise Manager. How can
> I fix it? Thanks.
>|||You should be able to use the sp_dropserver procedure to do this. It is
documented in Books on Line.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql
Showing posts with label reinstall. Show all posts
Showing posts with label reinstall. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
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.
| > |
| > |
| > |
| >
|
|
|
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 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
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
How to reinstall SQL 2005 in Windows Server 2003 for SBS?
I've got a Windows Server 2003 for Small Business Server. It had got SQL
installed. But then SQL was uninstalled. Now I need to put SQL back in, but
I don't see how!
There're three CD-Rom but I don't see how and from which CD to install back
SQL.
PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005, right?I don't know, but I seriously doubt that SQL Server comes with Windows
Server 2003, unless it is the Express version ...
Licensing for SQL Server can run into some serious money.
"TFS" <TFS@.discussions.microsoft.com> wrote in message
news:B877BB42-5FBA-4DF8-9ACC-24DD96F55AB4@.microsoft.com...
> I've got a Windows Server 2003 for Small Business Server. It had got SQL
> installed. But then SQL was uninstalled. Now I need to put SQL back in,
> but
> I don't see how!
> There're three CD-Rom but I don't see how and from which CD to install
> back
> SQL.
> PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005,
> right?
>|||Hello Jay,
SBS is a package of softwares and it consists of Windows Server 2003, SQL
Server, Exchange Server etc...
Windows Small Business Server 2003 R2:
http://www.microsoft.com/windowsserver2003/sbs/default.mspx
Also, please do not post your question more than one newsgroup TFS.
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Jay" <spam@.nospam.org> wrote in message
news:ufiHseaEIHA.4748@.TK2MSFTNGP06.phx.gbl...
>I don't know, but I seriously doubt that SQL Server comes with Windows
>Server 2003, unless it is the Express version ...
> Licensing for SQL Server can run into some serious money.
> "TFS" <TFS@.discussions.microsoft.com> wrote in message
> news:B877BB42-5FBA-4DF8-9ACC-24DD96F55AB4@.microsoft.com...
>> I've got a Windows Server 2003 for Small Business Server. It had got SQL
>> installed. But then SQL was uninstalled. Now I need to put SQL back in,
>> but
>> I don't see how!
>> There're three CD-Rom but I don't see how and from which CD to install
>> back
>> SQL.
>> PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005,
>> right?
>
installed. But then SQL was uninstalled. Now I need to put SQL back in, but
I don't see how!
There're three CD-Rom but I don't see how and from which CD to install back
SQL.
PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005, right?I don't know, but I seriously doubt that SQL Server comes with Windows
Server 2003, unless it is the Express version ...
Licensing for SQL Server can run into some serious money.
"TFS" <TFS@.discussions.microsoft.com> wrote in message
news:B877BB42-5FBA-4DF8-9ACC-24DD96F55AB4@.microsoft.com...
> I've got a Windows Server 2003 for Small Business Server. It had got SQL
> installed. But then SQL was uninstalled. Now I need to put SQL back in,
> but
> I don't see how!
> There're three CD-Rom but I don't see how and from which CD to install
> back
> SQL.
> PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005,
> right?
>|||Hello Jay,
SBS is a package of softwares and it consists of Windows Server 2003, SQL
Server, Exchange Server etc...
Windows Small Business Server 2003 R2:
http://www.microsoft.com/windowsserver2003/sbs/default.mspx
Also, please do not post your question more than one newsgroup TFS.
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Jay" <spam@.nospam.org> wrote in message
news:ufiHseaEIHA.4748@.TK2MSFTNGP06.phx.gbl...
>I don't know, but I seriously doubt that SQL Server comes with Windows
>Server 2003, unless it is the Express version ...
> Licensing for SQL Server can run into some serious money.
> "TFS" <TFS@.discussions.microsoft.com> wrote in message
> news:B877BB42-5FBA-4DF8-9ACC-24DD96F55AB4@.microsoft.com...
>> I've got a Windows Server 2003 for Small Business Server. It had got SQL
>> installed. But then SQL was uninstalled. Now I need to put SQL back in,
>> but
>> I don't see how!
>> There're three CD-Rom but I don't see how and from which CD to install
>> back
>> SQL.
>> PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005,
>> right?
>
how to Reinstall SQL 2000 Performance Monitor
Please i need know how to Reinstall SQL 2000 Performance Monitor Counters because i can't see this.What do you mean you cant' see PERFMON counters, is it for SQL Server or for OS too?|||Is only for SQL Server.|||Sometimes, for a wide variety of different reasons, the SQL Server Performance Monitor counters will not show up as they should. Often, but not always, this problem can be fixed by following these two steps:
At the command prompt, type in the following: unlodctr.exe MSSQLServer
Then type in the following: lodctr.exe <SQL Server path>\binn\sqlctr.ini
Reboot the server
Rest is yours.sql
At the command prompt, type in the following: unlodctr.exe MSSQLServer
Then type in the following: lodctr.exe <SQL Server path>\binn\sqlctr.ini
Reboot the server
Rest is yours.sql
Subscribe to:
Posts (Atom)