Re: Premium SQL Sharepoint to Standard MSDE Sharepoint?

I tried your suggestion.

I replaced the files from my SQL Sharepoint restore over the newly
installed MSDE installation and ensured the file names matched the MSDE
names. The MSSQL$SHAREPOINT service restarted without error but I
received the error below when trying to view the companyweb.

Unable to connect to database. Check database connection information
and make sure the database server is running. For tips on
troubleshooting this error, search for article 823287 in the Microsoft
Knowledge Base at http://support.microsoft.com.

1. The MSDE sharepoint service is started
2. IIS is confirmed as not running is isolation mode
3. Unable to perform check 3 as I do not have Enterprise Manger as I no
longer have SQL2000. I'll assume this area is the problem.

I should mention that my backup of the original Sharepoint database was
created using the SBS builtin backup tools. I did not know about the
special Sharepoint tools until I started to panick a bit.

.

Relevant Pages

  • Re: WSS MSDE DB Location Change Nightmare
    ... STS_servername_1 database. ... able to do your reinstall of MSDE and restore over top of the new Content DB ... Sharepoint Services was installed. ... Pool Is the Account That Has the Required Permissions to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • WSS MSDE DB Location Change Nightmare
    ... Sharepoint Services was installed (with MSDE). ... the Windows SharePoint Services database files" ... Pool Is the Account That Has the Required Permissions to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: WSS MSDE DB Location Change Nightmare
    ... After the STSADM backup do I want to run an uninstall, ... I.E all MSDE/SQL references and the MS WIndows SHarepoint Services 2.0? ... STS_servername_1 database. ... able to do your reinstall of MSDE and restore over top of the new Content DB ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: WSS MSDE DB Location Change Nightmare
    ... Site Collections are just how they sound, they are a collection of sites. ... After you get MSDE ... I have a single Sharepoint instance with 6 "subsites" ... STS_servername_1 database. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Restoring individual Files from Share point.
    ... > all documents are stored inside the sharepoint WSS database. ... > SQL or MSDE to maintain your WSS site? ... I dont want to restore all of the database. ...
    (microsoft.public.windows.server.sbs)
Loading