- #How to reinstall microsoft sql express 2012 how to
- #How to reinstall microsoft sql express 2012 install
Well you can do the installation, but you will not be able to do any SSIS work.
#How to reinstall microsoft sql express 2012 install
If you have installed SQL Express, you cannot install SSIS on the same machine, even to design packages for other servers. SpeedSkater is describing what I consider to be a bug in MSSQL. Leave them and install Enterprise again, or should this cause problems? My question: what to do with the remaining SQL Server and Visual studio programs in "programs and features"? If I look in Services, there is no reference to SQL Server at all. It opens but has only a few options, not the same as there were before.Īlso: in "programs and features" there are still a lot of SQL Server programs visible, most are dated on the day Express was installed.Īnd, not surprisingly, there are references here to Visual studio
However: there is still an option to start "Microsoft Visual Studio 2010", and that still works. This proces gave no problems and there are no (SQL Server) options left in "all programs". I then used "programs and features" to uninstall SQL Server 64 bit. After this still a lot of SQL server options were available under "all programs". I have spent the best part of the evening reading al kinds of articles, inclusing your suggestions.Īpart from that: before I started installing enterprise I have made a restore point, as well as a image from the C-drive. This kind of things makes me jumpy, just because it is Terra incognita. The reason why I hoped that uninstalling both instances and installing Enterprise again is that, prior to installing Enterprise on my "regular computer" I did a "test installation" (just to see what happened during installation) on a test computer and there SSDT / SSIS / SSAS and SSRS work fine (that computer has no Express instance installed)īob, let me start by thanking you for all your advise. SQL server Integration services 11.0 is running and starts automatic. I tried to do the installation another time (and hoped that I could change this field it wasn't, again, not possible (so I left this process)įor your question about integration services being listed and running: When I installed Enterprise the Data tools selection was already chosen, but I could not change it. To install SSDT run SQL Server setup and select sql server data tools." To design Integration packages in SQL Server Data tools (ssdt), SSDT has to be installed by one of these editions of SQL Server 2012: Standard, enterprise developer or evaluation. If I start data tools (or start visual studio 2010, which is I believe the same), start a new project, choosing integration services / integration services project and then >, this gives me the message "Microsoft Visual studio is unable to load this document. You are right about the SSIS / data tools. Should I delete them all or is there a better way of doing this?īTW: the list in "programms and features" and "Revo uninstaller" are different,
#How to reinstall microsoft sql express 2012 how to
If yes, I have a next question: how to delete both instances: if I look in "programms and features" of "Revo uninstaller" there are a lot of programs that seem linked to SQL Server.
I came up with the solutuon to delete both instances (why keep express if you have enterprise) and reinstall enterprise from scratch, hoping that SSIS and the rest will work. If this is true (and why shouldn't it be) I see no possibility to get SSIS working. You connect to the service by using the computer name. * You can only install one instance of the Integration Services service on a computer. You can install SQL Server 2012 Integration Services (SSIS) side-by-side with an existing instance of SQL Server 2005 Integration Services (SSIS) and SQL Server 2008 Integration Services (SSIS).Īnd a little further to the bottom of that page:.You can install SQL Server Integration Services on a computer that has no previous instances of SQL Server.
Today I have searched intenet and on the msdn.microsoft website I found this information: Unfortunately no useful response to my question. Prior to that, last year I have installed SQL Server 2012, the Express edition.Įnterprise seems to work alright, except for SSIS (as far as I can tell SSAS and SSRS work).Ī few days ago I have asked if and how I can SSIS get to work. Last week I have installed SQLServer 2012 Enterprise.
0 kommentar(er)
