i installed sql server 2005 express by running SQLEXPR_ADV.EXE....now i can not uninstall it because the exe created a temp file to unpack the install files....of course those files are cleaned up after install or whenever i cleaned up the temp files on my pc.....so how do i uninstall?
View 5 RepliesHi
I am trying to install SQL Server Express from command line, without much success. For install, I am using:
Setup /qb INSTANCENAME=SQLEXPRESS ADDLOCAL=SQL_Engine,Connectivity,SAPWD=xxxxxxx
This installs, but SA does not seem to have SA privileges.
I try to uninstall,
Setup /qb REMOVE=ALL INSTANCENAME=SQLEXPRESS
This does not uninstall, even with a reboot.
I have 2005 client tools installed on my machine as well.
Any suggestions?
Thanks
Jim
I have to uninstall Sql Express because of a problem that arose after I tried to make a connection from VS2008 Server Explorer to SqlExpress ( connection strings run from C3 code worked fine). I began getting weird errors and the issue has not been resolved after a long thread I ran in this forum.
It turns out there are plenty of dire warnings on the web and MSDN not to do this or that before you tried to uninstall. To tell you the truth I have uninstalled Sql Express in the past quite a few times but every time you fight new challenges and it is difficult to learn from experiecne. I have always done it headlong without considering consequences, eventually this bulldozed approach worked every time but there is a chance that with the .NET getting more complicated this time I may get in trouble.
I am referring to this article on MSDN: before you uninstalled Sql Express:
http://msdn2.microsoft.com/en-us/library/ms143365.aspx
which is awfully unclear. It seems it recommends uninstalling ALL versions of .NET from 2.0 on.
These are versions on my Vista machine:
v1.0.3705, v1.1.4322, v2.0.50727, v3 .0, v3.5
Do I have to uninstall any? I don't think I've done it before.
Now, those .NET versions I listed above are just folders in my WindowsMicrosoft.NETFramework directory. When I try to open Turn Windows features On & Off I can see only .NET 3.0 Framework, nothing else. Not even .NET 3.5!
Also there is this frightening link:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.server&tid=0187b017-4ea2-4b32-aa28-6f6778d6b47b&mid=925c9341-fcc3-4678-ba53-80f30ee7aa28&cat=en_US_671e06d0-f20d-4bb3-9c6a-42c825ddb1dc&lang=en&cr=US&sloc=&p=1
Any comments will be appreciated.
Thanks.
Hi,
While building a vista 64 Ultimate machine recently, I temporarily installed the express edition toolkit with visual studio 2005.
I have since uninstalled sql, and reinstalled the 64-bit developer edition. However it appears the toolkit did not uninstall completely - now when I try to install workstation components, bol, etc. It says that the upgrade is blocked.
Hard as it is to believe that an express install can block a developer edition install, it does.
I've tried reinstalling the ee toolkit, as any client/management tools are better than none - but this fails, saying that the components are already on the machine!! sheesh!
It doesn't give an option to uninstall.
Has anyone got any ideas. I've uninstalled *everything* sql related, reinstalled with sp2 twice. I can see and create databases using visual studios server explorer, but this does not give any management options. Does anyone know how I can remove whatever registry entries are fouling up this installation?
Thanks,
mk17
Hi guys,
I'm trying to create a all-in-one installation package for my application which make use of the SQL 2005 Express edition. It seems that there's no way to roll my application MSI installation with the database engine, the only ways around this problem is to use a bootstrap exe to launch the sql setup before or after my main application's MSI. This works fine during installation and I have modified the original .NET framework bootstrapper to do just that.
The problem comes when uninstalling my application. Since the uninstall process is all done through the MSI engine, how would I take the sql instance with me during my application's uninstall? Since the sql engine is also based on MSI technology, I won't be able to do that during the removal step of my application's MSI, right? Any one know any "clean" ways around that? Besides not letting users uninstall my application directly from Add/Remove program and force them to call another exe simular to my installation bootstrap?
I'm considering to use 3rd party tools like InstallShields, but even them are recommending people to stay with the MSI technology which is where the problem is. I'm running out of ideas really fast...
Thanks in advance!
William
I installed MS Express 2005 a few years ago and now I want to uninstall it and reinstall 2008. I played with 2005 but never used it for anything but now I need to get serious about it because my job is requiring it. I installed 2005 express compenents like SQL server, VB, C, ect... When I go to my programs and try to add/remove any of the 2005 express components the uninstall 'install' just hangs. I choose the option to uninstall the component (not reinstall or repair) but no matter what I try it hangs. After it hangs if I try to uninstall another component it says cannot perform the task because another install process is running. I even let the uninstall sit for 45 minutes to see if it would finish but the process is not using any CPU and the progress bar does not move so it is truly hung. I briefly tried an uninstaller but it crashed too. Any clues on what to do next or what I should try to clean my machine so I can install express 2008? Thanks.
View 1 Replies View RelatedI had a problem with the install so I planned to uninstall everything and reinstall SQL EXPRESS, instead I'm stuck.
Pasted below is actual uninstall log. Thanks in advance
Microsoft SQL Server 2005 Setup beginning at Thu Aug 17 21:44:16 2006
Process ID : 2336
D:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/7/17 21:44:16
Complete: LoadResourcesAction at: 2006/7/17 21:44:16, returned true
Running: ParseBootstrapOptionsAction at: 2006/7/17 21:44:16
Loaded DLL:D:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/7/17 21:44:16, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x800706b5 (1717)
Windows Error Text: The interface is unknown.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50
1717
Running: ValidateWinNTAction at: 2006/7/17 21:44:16
Complete: ValidateWinNTAction at: 2006/7/17 21:44:16, returned true
Running: ValidateMinOSAction at: 2006/7/17 21:44:16
Complete: ValidateMinOSAction at: 2006/7/17 21:44:16, returned true
Running: PerformSCCAction at: 2006/7/17 21:44:16
Complete: PerformSCCAction at: 2006/7/17 21:44:16, returned true
Running: ActivateLoggingAction at: 2006/7/17 21:44:16
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
02B5CFC4Unable to proceed with setup, there was a command line parsing error. : 1717
Error Code: 0x800706b5 (1717)
Windows Error Text: The interface is unknown.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2336"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 1717
Hi!
I'm trying to uninstall SQL Server 7.0 going through Add/Remove Program and getting message "sqlserver.exe in use".
All my applications are closed, SQL Server service is stopped and Agent is stopped also.
What else should I check to be able to uninstall it?
Thanks
Lena
can someone show me how to uninstall Mirosoft SQL Server 2005 from my machine....
View 2 Replies View RelatedI have a server with a fresh install of SQL Server 2000. I accidentilly installed the Sql server 2005 SP1 disk (instead of the actual software). And what it did was a nightmare. It installed the client tools and link them to the 2000 instance. I went back and attempted to install the actual 2005 copy. Ever since I have items in my add/remove that will not uninstall. I removed everything except the 2005 Engine and Analysis services. I've followed the MS article (http://support.microsoft.com/kb/909967) with removal, trying everything. All got removed except the Engine and Analysis services!!!!
I've gone into the registry and reviewed the keys, etc! I've run removal attempts fof both command prompt and add/remove, does not work. I've tried reapplying SP's, etc no luck.
Unless I get these services off I can not install 2005 and 2000 again.
When I installed Visual Studi C# Express, SQL Server Express was not installed because SQL Server Beta was already there. I tried to uninstall SQL Server Beta several times and failed to do so through Add/Remove Programs. Accidentally, I uninstalled SQL Server Set-up programs from Add/Remove and consequently, I am unable to uninstall SQL Server Beta through Add/Remove anymore.
Is there a utility to download that enable me to uninstall SQL Server Beta? I have no way to install SQL Server Express without removing the previous version. It seems to be a real problem from the many questions I found on MSDN.
Please help.
I am following the 2005 BOL article "How to: Remove a SQL Server 2005 Failover Clustered Instance (Setup)". The process is very simple, but perhaps the documentation is missing some steps. I am receiving the following errors during the uninstall.
The setup has encountered an unexpected error while Completing Commit. The error is: The cluster resource cannot be moved to another group because other resources are dependent on it.
If I click OK I receive the error below.
Failed to set registry settings for server network libraries. The action is SetShilohRoot. The error is 2 (The system cannot find the file specified.)
Am I supposed to do something to the cluster prior to performing the uninstall?
Thanks, Dave
Hi all,
I had installed Sql Server 2005 Express Edition Beta 2 on my computer.
Now i would like to upgrade with SQL Server 2005 Express édition. It is noticed
(http://www.microsoft.com/france/msdn/vstudio/uninstall/default.mspx ) that i have
to uninstall all previous version following a specific order.
In my Add/Remove program i have :
1 -Microsoft .Net Framework 2.0 Beta
2 -SQL Server 2005 Express Edtion Beta 2
3 -SQL Server 2005 Tools Express Edtion Beta 2
4 -Microsoft SQL Server Setup support files
The problem is :
2 & 3 can't be uninstalled from my computer: the uninstalling program is blocked
Can somebody have a solution forme?
I had SQL Express 2005
then I uninstalled it and installed SQL Server 2005 Beta 2
No i want to totally remove the Beta 2 but it's removing the items from Add/Remove Programs but the applications is not removed!!
I tried the installer Cleanup utility but I am getting this error:
Run-time error '-2147024882 (8007000e)'
System Error &H80004005 (-2147467259)
what should i do plz?
I am following the 2005 BOL article "How to: Remove a SQL Server 2005 Failover Clustered Instance (Setup)". The process is very simple, but perhaps the documentation is missing some steps. I am receiving the following errors during the uninstall.
The setup has encountered an unexpected error while Completing Commit. The error is: The cluster resource cannot be moved to another group because other resources are dependent on it.
If I click OK I receive the error below.
Failed to set registry settings for server network libraries. The action is SetShilohRoot. The error is 2 (The system cannot find the file specified.)
Am I supposed to do something to the cluster prior to performing the uninstall?
Thanks, Dave
Hi there, I've been having a problem of being unable to connect to my DBs when I open them up in Sql Management Studio Express. First I thought that the DBs were corrupted however, I picked up signs that this may not be the case. There is a chance that it is a problem with the Management Studio. Thus instead of uninstalling SqlExpress I want now to uninstall only the management studio.
My problem started after I attempted to connect my Sqlxpress DBs with my VS2008. In the Server Explorer window there is an option to display Sql Express DBs, so I made an attempt. After that when i tried open the same DBs in the management studio I began getting numerous errors.
I ran a thread to resolve it but nothing helpful transpired.
Now, I attempted to uninstall the Management Studio via Start==>Control Panel==>Programs==>Uninstall Programs. Iam running Vista Ultimate. The problem is that when I attempted to uninstall it the system said that I do not have the administrative rights. There is no way to right click on the menu item and confirm the administrative rights.
I have two options:
(1) To find out the uninstall exec for the Management Studio and run it thru cmd cmd prompt as administrator.
(2) To invoke the window GUI for Uninstall programs thru cmd prompt and do the same. For that I need to find the exec or msc file that generates the GUI. I am now going to try to find this out.
In the meantime, if anybody knows the name of the file that uninstalls Sql Management Studio Express, please let me know.
Thanks.
i am having some issues..hopefully someone can help me..i just finished my database class...we had to install sql server 2005...i am running windows xp home...when i went to install sql...there was one error that i was getting...it was about the iis function, which i know that it won't work with the home edition...i finished the install, without the iis, so i can try to work on some things for class...i also had to install northwinds and pubs...now that the class is over, i want to get rid of it all...i tried to follow somewhat of the uninstall process but now i am getting problems...i can't figure out how to uninstall the northwinds and pubs..it keeps saying that it is being used by another person or program and it won't let me uninstall....can someone what me through the uninstall process of both the northwinds, pubs, and all of sql server 2005...i don't know much about computers....thanks you so much for helping in advanced...
crystal
I am running into an issue trying to uninstall SQL Server 2005 64-bit. It hangs at the same point: Removing backup files. I then get a message that, "The setup has encountered an unexpected error while Completing Commit. The error is: The cluster resource cannot be moved to another group because other resources are dependent on it." The instance that I am trying to uninstall is in a cluster hosting two other SQL Server installations. I have tried a few combinations when attempting to uninstall: running the cluster group containing the server I am uninstalling on a different cluster node than all the other cluster groups; running them all on the same node. The only one I haven't tried is moving the Cluster Group containing the IP address of the cluster, cluster name, etc to another node while running the other groups on the other node. Has anyone run into this issue? Each of the nodes has been rebooted several times during these attempts and we are using Windows Server 2003 Clustering. Again, the hang happens at the same point every time. The exact error(s) from the even log are as follows:
Product: Microsoft SQL Server 2005 (64-bit) -- Error 29528. The setup has encountered an unexpected error while Completing Commit. The error is: The cluster resource cannot be moved to another group because other resources are dependent on it.
Product: Microsoft SQL Server 2005 (64-bit) -- Error 29530. Failed to set registry settings for server network libraries. The action is SetShilohRoot. The error is 2 (The system cannot find the file specified.
)
Thanks,
Todd
Hi,
Recently I have installed Visual Studion Team System 2008 Development Edition in my sytem. Along with this, MS-SQL Server aand MSSQL Server Compact Edition is also installed. I need to install the SQL Server 2005 in my system.
In such a scenario, does the Compact Edition is required? Can I uninstall them and install Sql Server 2005 only? If I uninstall anything, would it cause any problems for the .Net programs to work?
Please respond asap.
Thanks for any help.
meeram.
Hi
I have another question : 1) Restoring SQL Server Databases after uninstalling and reinstalling SQL Server.
Two days ago there was some problem with Norton Antivirus, so Windows 98 restored itself to a previous state. The SQL Server name was not available when I tried to start again, so I had to uninstall and reinstall SQL Server. I started a new Database just a week before this happened (the change from Access to SQL Server as I stated in the other thread http://www.dbforums.com/showthread.php?threadid=987880) and after reinstallation I could not access the Database any more - even while it is in the Data directory. I did not have any backup to restore from - I just started creating tables, so there was only the Log file created and the MDF database file. I tried to import it for a while to the new server, but as the database is not shown in the new server, it was unable to import like I hoped. So how do you restore it back to SQL Server when you have no backup and only the (undamaged) MDF database file if you only have one server? I had to recreate the Database from scratch again - I don't want it to happen again.
Regards
Corné
No, I'm not having any problems(yet) with servicepack 5a. However, in order to fine-tune an installation script, I need to install 5a on my test server several times.
So....how do I uninstall it? I was going from sp 3 to 5a. TIA
I am trying to use this database thing. with visual basic express 2005 but It sais before I have to uninstall all this stuff. what will happen If don't uninstall it. do I have to uninstall it to get this software????
View 1 Replies View RelatedI'd like to uninstall the MSDE SQL desktop files off my local harddrive, and then re-install. What is the safest way to do this?
Thankx
Chum
I downloaded the SQLEVAL but did not install it on my computer. It is not something I am going to need to use. Can I just delete the file folders to remove it, or do I have to finish the install, then go through the uninstall process? I would rather avoid the install because it has caused problems for a co-worker and I don't want to run into similar issues.
This may be the silliest question you guys see on the boards, but I would rather look stupid then to do something I shouldn't and screw up my computer.
If you need to know I am running Windows XP with SP2 installed.
Thanks in adavance for your help!
Hi,
I tried to uninstall SSRS and SQL Server from my machine. I removed it using ADD/REMOVE Program. Now I can not see SQL Server in ADD/REMOVE Program. But Still SSRS is runing in my machine. But I can not initiate SSRS in configuration manager. It says smthing abt WMI error. When I try to install SQL, it says another service is running.
Now I think If I remove SQL and SSRS from my machine smhow, and install it again I can fix this. But now I can not either install it or uninstall it. Can smone please help me?
Thanks
I am trying to uninstall SQL Server 2005 CTP version before installing Beta version and keep getting an ARP Wrapper Error message that states "Registry Enumeration Failed". I ran Registry Mechanic, etc, but there are no indications of a problem.
View 3 Replies View RelatedIi have installed msde 2000 now all my Access files are in 2000 format how do i change back to 2003?
View 1 Replies View Relatedhi
can we uninstall reporting service without uninstalling data base engine. I want to keep all the data bases. But when I try to uninstall RS, it will promt me to select both RS and data base engine.
Thanks
When I am trying to uninstall SQL Server 2005 Express on XP Home I get the following error message:
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine MARTINS Error:2147749896 (0x80041008).
I have tried restarting the WMI service but that doesn't help. Any ideas?
Hi,
I've got some SQL2000 instances that i want to uninstall, but i cant find them in add/remove programs, is there any manual procedure to uninstal instances ?
I've got also a MSDE instance, that i cant get rid off , it appears on add remove programs , but there is no option to uninstall it ...
thanks for your help
I'm trying to uninstall SQL Server 2005 CTP. When I remove it through control panel/add remove programs, I get this error
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <my machine name> Error:214779896 (0x80041008)
I've tried this with both the WMI service running and not running.
Hi. I'm a newbie for sql server. I have a laptop loaded with win vista home premium edition. I installed sql server 2005 developer edition service pack 1 on it. It said that this version is not supported by vista so upgrade it with sp2, so I did the same. I upgraded it to sql express 2005. Now it got installed but it doesn't let me create new database and displayed the msg "LOGON FAILED FOR 'USER' " . I thought of reinstalling it. But now it is not uninstalling. I tried it through add/remove programs. The 'sql server management tools' is not visible in the start program list,but 'sql server 2005' and some other components of it are visible in add/remove programs. Then I tried using command prompt that was given in microsoft's site only http://support.microsoft.com/?kbid=909967#
Step 2: Run the command to uninstall the SQL Server components
c:"%ProgramFiles%Microsoft SQL Server90Setup BootstrapARPWrapper.exe /Remove"
But this was also of no help. Now What should I do??? Need your HELP!!!!!!!!!!!!!!
THANKS!!
I have some programmes to uninstall but for some time now my "Add/Remove" page has only listed some of my programmes. Ihave some very recent downloads to remove but they do not appear anywhere.
View 1 Replies View Related