asked on

Uninstall SQL before Transition Pack

I am planning on using the transition pack on the SBS server to move it to a Win2003 Standard. I currently use SBS 2003 SQL for our sharepoint servies. I do not use SQL for anything else but Sharepoint Services so i was wondering if i could just uninstall SQL and used MSDE for Sharepoint Services.

I do not want to purchase the full SQL license so that is why I do not want it when i transition. Exchange is already on another server so that is no problem.

Also, if this is possible does anyone know how to switch sharepoint to MSDE from SQL.

Thanks for all the help.

Jeffrey Kane - TechSoEasy

To clarify... are you sure that you are using SQL for SharePoint? That would mean that you have SBS 2003 PREMIUM edition.

So, are you saying that you want to buy the Standard version of the Transition Pack instead of the Premium Version? While it's not a FULL SQL license, it is more expensive.

You can do that, but you will need to move back to MSDE and uninstall SQL (and ISA if you have that installed) before using the transition pack. Moving back to MSDE would only entail backing up your Sharepoint Databases and then restoring them. You can follow this KB article: http://support.microsoft.com/kb/829113

If you do not have the PREMIUM version of SBS, then SharePoint is already using MSDE (actually it uses WMSDE which is a version of MSDE that doesn't have a 2GB size restriction).

Jeff
TechSoEasy

dbrosnan

ASKER

It is SBS 2003 Standard. However, in add/remove programs it lists:
"Microsoft SQL Server Desktop Engine (SBS Monitoring)"
"Microsoft SQL Server Desktop Engine (Sharepoint)"

What I'm worried about is when I use the transition pack will I lose my current Sharepoint http://companyweb web?

Other than that is there anything else I should worry about when transitioning?

Appreciate the help.

ASKER CERTIFIED SOLUTION

Jeffrey Kane - TechSoEasy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dbrosnan

ASKER

Thanks for all of the help.

Jeffrey Kane - TechSoEasy

No prob. Good Luck!

Jeff
TechSoEasy