Avatar of sharepoint_newbie
sharepoint_newbie
 asked on

I deleted the ShareWebDb. (No backup).

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

Avatar of undefined
Last Comment
sharepoint_newbie

8/22/2022 - Mon
David Atkin

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.

http://technet.microsoft.com/en-us/library/gg680310.aspx
sharepoint_newbie

ASKER
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:-
Error
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
David Atkin

Does the spfarm account exist?

If so, see here on how to reset the password of the sharepoint accounts:
http://blogs.technet.com/b/sbs/archive/2011/08/17/http-error-503-accessing-company-web-on-sbs-2011-standard.aspx
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
sharepoint_newbie

ASKER
when re-installing sharepoint should i delete the old sharepoint_configurationdatabase
id that what is causing the problem
donnk

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.
ASKER CERTIFIED SOLUTION
sharepoint_newbie

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
sharepoint_newbie

ASKER
previous answer gave part answer the rest i figured out myself
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.