Solved

I deleted the ShareWebDb. (No backup).

Posted on 2013-11-22
7
836 Views
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.
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
0
Comment
Question by:sharepoint_newbie
[X]
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
  • 4
  • 2
7 Comments
 
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.

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

Author Comment

by:sharepoint_newbie
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:-
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
0
 
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:
http://blogs.technet.com/b/sbs/archive/2011/08/17/http-error-503-accessing-company-web-on-sbs-2011-standard.aspx
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

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

Expert Comment

by:donnk
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.
0
 

Accepted Solution

by:
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
0
 

Author Closing Comment

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction At 19:33 (UST) on Tuesday 21st September the long awaited email arrived with the subject title of “ANNOUNCING THE AVAILABILITY OF WINDOWS SBS 7 PREVIEW”.  It was time to drop whatever I was doing and dedicate as much bandwidth as possi…
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

756 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