SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


how to uninstall sql server


how to uninstall sql server

Author
Message
SpeedSkaterFan
SpeedSkaterFan
Mr or Mrs. 500
Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)

Group: General Forum Members
Points: 576 Visits: 400
Hi Bob,

After a (hopefully) well - earned weekend away I have completed the "task" of deleting everything related to the previous installations of SQL Server.
A moment ago I have installed Enterprise again and the installation process was without problems.

The reason for this "excercise" was that SSIS wasn't installed.
Apparently now it is, I have made my first project and that seems to work.

I have to do some more testing but for now I am very happy! :-D

May I thank you for your advise, and guidance. It gave me, as a non - dba, enough confidence to do the job.

Hein
EdVassie
EdVassie
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13273 Visits: 3893
If you want to treat your windows instance as a scratchpad, installing and uninstalling software multiple times, then do not be surprised if you get unexpected side effects.

If you want to know how SQL Server 2012 will behave on a clean instance of Windows, then always install it on a clean instance of windows. If you want to find if you can get SQL Server to appear to install OK on a server that has had many installs and uninstalls and which may not work in exactly the same was as on a clean install, carry on as you are.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
SpeedSkaterFan
SpeedSkaterFan
Mr or Mrs. 500
Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)

Group: General Forum Members
Points: 576 Visits: 400
Ed
Thanks for your, somewhat harsch, reply.

The situation that you describe (Scratchpad etc) is just what I wanted to avoid by asking my question.
Just because there are so many SQL Server (related) programs active, I was wondering how to tackle the Uninstall. How to do it right and how to avoid bits and pieces of "old" installs lying around and interfering with a new try.

And because I am extra careful not to damage the system I had, I made, prior to all attempts, a restore point, as well as a systemimage, just to be save.
So I share your concern.

After my thread I have uninstalled and reinstalled SQL Server and so far it all seems to works alright.

Hein
dan-572483
dan-572483
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3397 Visits: 2000
SpeedSkater is describing what I consider to be a bug in MSSQL. If you have installed SQL Express, you cannot install SSIS on the same machine, even to design packages for other servers. Well you can do the installation, but you will not be able to do any SSIS work.

I found this to be inconvenient to me, as I like to have SQL Express installed on my workstation for testing and experimentation with no approval process hoops or risk of breaking something important. The only solution I found was to uninstall SQLExpress, try installing SSIS, and install SQLExpress again. I didn't want to do this, as I find the more uninstalls\installs you do, the more unstable the system becomes. I ran SSIS remotely on server instead.
Robert klimes
Robert klimes
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4803 Visits: 3464
dan-572483 (8/18/2014)
SpeedSkater is describing what I consider to be a bug in MSSQL. If you have installed SQL Express, you cannot install SSIS on the same machine, even to design packages for other servers. Well you can do the installation, but you will not be able to do any SSIS work.

I found this to be inconvenient to me, as I like to have SQL Express installed on my workstation for testing and experimentation with no approval process hoops or risk of breaking something important. The only solution I found was to uninstall SQLExpress, try installing SSIS, and install SQLExpress again. I didn't want to do this, as I find the more uninstalls\installs you do, the more unstable the system becomes. I ran SSIS remotely on server instead.


I have multiple version of express(2008R2,2012,2014) as well as SSIS (2102) and the SSIS data tools project templates(2012) installed on my workstation. I have no trouble designing or executing SSIS packages. I am not sure what kind of trouble you are running against when trying to have SSIS and express on the same workstation.

Bob
-----------------------------------------------------------------------------
How to post to get the best help
dan-572483
dan-572483
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3397 Visits: 2000
This issue may be limited just to SQL 2012. I know SQLExpress 2012 was installed first and I had this issue when subsequently installing SSIS from either SQL 2012 Developer or Enterprise media. The OS was Windows 7 32-bit if that makes a difference.

I had another workstation (also Windows 7 32-bit) with SQL 2008 R2 Express and 2008 R2 BIDS/SSIS and everything worked. This was set up a few years earlier and I don't recall the order of installation.
EdVassie
EdVassie
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13273 Visits: 3893
Sorry for the tone of my previous response...

It can be hard to remove all traces of a SQL install, that is why I was suggesting a scratchpad machine if you want to try out SQL installs. Also, not all editions will install on Win 7, you need a server edition of Windows to install SQL Enterprise and BI editions. However, you can get all the features of Enterprise by installing Developer edition.

Your approach of taking a system image is probably the best one for rolling back a SQL install. It will guarantee there are no odd files, registry entries, permissions or accounts left in your system, and should give you a clean base to try another install.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
SpeedSkaterFan
SpeedSkaterFan
Mr or Mrs. 500
Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)

Group: General Forum Members
Points: 576 Visits: 400
No harm done Ed,
I agree with you on many topics.
Because I didn't want for people having to read a very long story I skipped some parts.
Your suggestion on installing SQL Server on a "blank machine" I just what I did, with 1 difference: the test machine is 32-bits, my regular machine is 64.
The tryout gave me enough confidence to go for the installation on the regular computer, and then I ran into SSIS trouble.

With help from Bob (thanks again!) I figured out and did the uninstall,and reinstalled SQL Server.
As far as I can see all works fine, except..

I found on you tube a (very good) tutorial series made by WiseOwl.
Since I am new to SS I started with tutorial 1, SSIS-ing data from SS to Excel.
I have the entire process working, except the last step gives me a hard time: the excel connection and column types in Excel
Trying to find the problem on internet I see that it is a well known problem. so I have some reading to do ...
Hein
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search