Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

I deleted the ShareWebDb. (No backup).

Posted on 2013-11-22
Last Modified: 2013-12-06
I guys,

During a migration from SBS 2003 to SBS 2011 I some how managed to get the instructions mixed up.
1. all went well until I got to 'Migrate SharePoint Web site'
by which stage I was tired and should have called it a day (1st mistake)
2. I stupidly followed the instruction for migrating from SBS 2008 to SBS 2011.
Instead of from SBS 2003.
3. By wrongly following these instructions "TechNet.microsoft.com/en-us/library/gg615995.aspx" I deleted the ShareWebDb. (No backup).
4. After realising my mistake I tried to follow these instructions "TechNet.microsoft.com/en-us/library/gg680312.aspx" to recreate the windows sbs sharepoint web application. but after recreating I get this error.
Cannot open database "ShareWebDb" requested by the login. The login failed.
Login failed for user '<domainNAME>\spfarm'.

Troubleshoot issues with Microsoft SharePoint Foundation.
which doesn't make sence as im using ,<domainNAME>\spwebapp not spfarm
Question by:sharepoint_newbie
  • 4
  • 2
LVL 22

Expert Comment

by:David Atkin
ID: 39669257
Your first and most costly mistake here is trying to migrate without a good backup.  It is listed as one of the first things to do in the SBS 2008 or SBS 2003 migration steps.

I think the only option I see you having here is to re-install sharepoint.


Author Comment

ID: 39670278
I have just re-installed sharepoint and got to the point of creating a new web application SBS SharePoint but it has finnised the same as before:-
Cannot open database "ShareWebDb" requested by the login. The login failed. Login failed for user '<Domainname>\spfarm'

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: 80ccf734-e6c1-4ccd-b411-650034ccae66
LVL 22

Expert Comment

by:David Atkin
ID: 39670321
Does the spfarm account exist?

If so, see here on how to reset the password of the sharepoint accounts:
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Author Comment

ID: 39670401
when re-installing sharepoint should i delete the old sharepoint_configurationdatabase
id that what is causing the problem

Expert Comment

ID: 39671239
you may be able to recover the DB from the deleted location if shadow copies are enabled.

right click the folder and choose 'previous versions' tab.

fingers crossed bud.

Accepted Solution

sharepoint_newbie earned 0 total points
ID: 39688640
Hi ,
After trying several methods to fix the problem I took a chance and deleted the ShareWebDb database and the sharepoint_configurationDatabase database and then successfully reinstalled sharepoint server using your instructions http://technet.microsoft.com/en-us/library/gg680310.aspx . I am happy to report all went well and the old is server is removed with the new one working perfectly. Thank you for all your help

Author Closing Comment

ID: 39700529
previous answer gave part answer the rest i figured out myself

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question