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 "" I deleted the ShareWebDb. (No backup).
4. After realising my mistake I tried to follow these instructions "" 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:
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.


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 . 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Written by Glen Knight (demazter) as part of a series of how-to articles. Introduction One of the biggest consumers of disk space with Small Business Server 2008(SBS) is Windows Server Update Services, more affectionately known as WSUS. For t…
The problem of the system drive in SBS 2003 getting full continues to be an issue, even though SBS 2008 and SBS 2011 are both in the market place.  There are several solutions to this, including adding additional drive space or using third party uti…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now