SQL Server Performance

SBS 2003 R2, SQL Workgroup 2005, Sharepoint MSDE, Cant create new 2005 Instance

Discussion in 'SQL Server 2005 General DBA Questions' started by jeffr, May 18, 2010.

  1. jeffr New Member

    We have an SBS 2003 SP2 server that had the SharePoint with MSDE (Ver 80).We installed the SQL Server 2005 Workgroup Edition from SBS Premium 2 DVD. Throughout the installation we were not prompted for authentication method or collation sequence however SQL installed without problem and we then installed Sp2 & SP3. We then created some empty databases but later realised they were created under the MSDE instance but we want them installed under SQL 2005 work-group which we installed. The databases are empty so we are happy to recreate them if need be.We tried uninstalling SQL 2005 database to start again but get the message to reinstall from the source DVDs with SKUUPGRADE=1. We have reinstalling with SKUUPGRADE=1 numerous times however we are not able to create a new instance or upgrade the MSDE Sharepoint instance. Whenever we attempt update we are only able to update the client components & documentation. We then shutdown the Sharepoint timer service & Sharepoint SQL service and removed the Sharepoint Desktop Engine MSDE from Add/Remove programmes as per these instructions: http://www.smallbizserver.net/Artic...the-Sharepoint-MSDE-instance-to-SQL-2005.aspx and http://download.microsoft.com/downl...51-4308-a876-e1b83ee4e77a/sqlinstallsteps.htmWe then attempted to reinstall sql server again from the source DVD but we don't get the prompt for the instance name or other database setup options, only get the options to install the client components and documentation.The workgroup database now has no default instance (as the MSDE SharePoint was removed via Add Remove Programmes) and we cannot run SQLServer as there is no MSSQL Service listed in services now. We have tried uninstalling all SQL Server 2005 from Add/remove programmes and the dialogue shows no instances installed.We then uninstalled SQL server via C:program FilesMicrosoft SQL Server90Setup Bootstraparpwrapper /REMOVE which removed all the components, including the SP3 upgrade. But when we attempted to reinstall 2005 again from the source DVD, we still don’t get prompted for the instance name, collation etc and no instance was created. So we have the programmes installed but no instance.Every way we try to uninstall & reinstall we either get the SKUUPGRADE=1 message which we use at the command line with setup from the DVD’s and doesn’t help, so we have been unable to create a new 2005 instance. How do we for a new install a new 2005 Workgroups instance?
    How do we reinstall/upgrade so that SharePoint in Workgroups and not in MSDE?
  2. FrankKalis Moderator

    It might be better to ask this question in a Sharepoint related community. For a SQL Server- only question I would say, backup the MSDE database, restore it to SQL Server 2005 workgroup, change the compatibility level (if the application has no problems with it), and be done with it.

Share This Page