Solved

I deleted the ShareWebDb. (No backup).

Posted on 2013-11-22
7
841 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
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!

 

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

Independent Software Vendors: 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

Suggested Solutions

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…
I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
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…
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…
Suggested Courses

738 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