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,
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 reference a previous field Alias in TSQL as in Jet SQL?

My question is simple, I'd like to do something I do in Jet ANSI-89 SQL. Mind you I'm just adding numbers here - they are not actual columns in 'SomeTable'

SELECT 1 AS A, 2 AS B, A+B AS C
FROM SomeTable

The Jet engine evaluates and does arithmetic on the Aliased column names - handy when they contain their own functions. The resultset would show:

A B C
1 2 3

However from what I can tell SQL Server 2005 is not picking this up. Is their an equivalent?

The Jet syntax is non-standard SQL syntax so it will not work in SQL Server. You will have to use a derived table or CTE (in SQL Server 2005) or use a view or computed column in the table (if the expression involves columns from a single table).

select A, B, A+B as C

from (select 1 as A, 2 as B

from sometable

) as t

with t as (

select 1 as A, 2 as B

from sometable

)

select A, B, A+B as C

from t