uninstall sqlexpress - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

uninstall sqlexpress

Author

Topic

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-14 : 20:36:28

Hi friends
I insalled Visual Studio 2005 standard edi on XP machine. as you all know it also installs sqlexpress. i want to uninstall this sqlexpress as i also have sql server 2005 standard edition on my machine.

but i dont see any option to uninstall in add/remove programs or in start menu for sqlexpress.
any ideas on this ?
Thanks for your help.

Cheers

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-14 : 21:09:29

Are you sure it installed SQL Express?

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-14 : 21:14:36

yes,i am Paul .
when i open sql server configuration manager i can see service for sqlexpress.
i can start the service and connect to it !!

Cheers

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-14 : 21:28:04

ok - got to Add/Remove Programs and select Remove for Microsoft SQL Server 2005. You'll get a wizard that lists the instances on your machine. Select the one called SQLEXPRESS and you can uninstall just that one.

Thanks

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-14 : 22:51:52

thanks for that Paul.
it'll show up as u suggested and i seleted "sqlexpress" to uninstall.
now i got a screen which says "sql server setup preparing to make the requested configuration settings" and it has been i hour since i started uninstall but still am on the same screen !!

Cheers

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-15 : 01:42:33

Are you still connected to the instance?

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-15 : 14:47:33

no.i stopped the service but i connected to my sql server instance though. would it be an issue Paul?

Cheers

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-15 : 16:27:55

This looks like a setup bug. You can either call PSS, or we can attempt to debug this over the forum - no guarantees.

If you want to go the latter route, kill setup and look in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG to see if there are any log files (substitute your install path if different)

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-15 : 17:00:14

Probably we'll give a try over the forum paul.
in the abv path under files folder i found 2 files dated yesterday. i believe they are related uninstall i tried yesterday.
u want me to email to you or post it here ?
Thanks again for your help

Cheers

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-15 : 17:10:24

Can you email them to me? I'll PM you my address so you can send attachments.

Edit: You need to setup some contact info so I can email you through sqlteam.

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-15 : 17:32:21

Paul
i setup my contact info now u should be able to see my emailid.

Cheers

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-15 : 22:53:24

Hi Paul
i dont know whats any difference today . i tried again and it successfully uninstalled it !!

BTW on the same machine 've sql server 2005 stand edi with reporting services. i cant access report manager page suddenly (i.e. http://localhost/reports) .i remember it worked perfectly until i tried uninstalling sqlexpress.
if i try to access report manager page after trying for couple of minutes i get reuqest timed out error. any ideas how to troubleshoot this one.
Thanks

Cheers

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-17 : 13:26:36

Very strange. There's certainly a problem with the uninstaller - I'll file a bug. Glad it worked eventually - quite often setup problems go away the 2nd time through, but that's still a problem we don't want to see.

Don't know much about RS - suggest you post in the RS forum here.

Thanks

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-19 : 14:45:26

Thanks Paul.
finally my report manager page also worked after restarting my machine.

Cheers

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources