• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 887
  • Last Modified:

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
0
sharepoint_newbie
Asked:
sharepoint_newbie
  • 4
  • 2
1 Solution
 
David AtkinIT ProfessionalCommented:
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
 
sharepoint_newbieAuthor Commented:
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
 
David AtkinIT ProfessionalCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
sharepoint_newbieAuthor Commented:
when re-installing sharepoint should i delete the old sharepoint_configurationdatabase
id that what is causing the problem
0
 
donnkCommented:
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
 
sharepoint_newbieAuthor Commented:
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
 
sharepoint_newbieAuthor Commented:
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!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now