RESTORING CRASHED SITE WEBS

My server crashed. I reformatted and reinstalled Windows 2003. I want
to restore my WSS System. Everything was backed up prior to the Crash.
I have everything kind of restored but can't access the SQL databases
from Central Administrator. The error I get is
Login failed for user 'DOMAINNAME\ACCOUNTNAME. (Error code: 18456)
This error comes up when selecting to login with a domain or a windows
account. I can't login using any existing accounts. When trying to
access using Windows Security the account returned in the failed login
message is 'NT AUTHORITY\NETWORK SERVICE'. That account doesn't exist
in my Active Directory anywhere. I'm not sure how to proceed. Below
is a step-by-step of how I restored the system. Perhaps some kind &
knowledgable person can review my procedure and tell me what went
wrong.

1. INSTALL WINDOWS
2. INSTALL WINDOWS SP1
3. ACTIVE DIRECTORY SETUP (Join domain)
4. ADD SERVER ROLL (IIS - COM+ - ASP.NET - FP2002)
5. INSTALL SQL2000
6. INSTALL SQL 2P3 (Used Domain Account MAC\Administrator)
7. RESTORE ALL SQL (master) AND WSS DATABASES
8. RESTORE WEBS
Application Pools: create from XML backup files
WEB Sites : create from XML backup files
9. INSTALL SHAREPOINT (failed with error)
10. COPY BACKED UP \INETPUB DIRECTORIE STRUCTURE TO SERVER
C:\INETPUB
11. REINSTALL SHAREPOINT (repair mode)

>>From here everything looks good. In IIS Manager I can see my web sites
and all the config info looks OK. The SQL database is restored and In
SQL manager I can open databases.

12. RUN SHAREPOINT CENTRAL ADMINISTRATION FOR FIRST TIME
Inital page says I must create or connect to a share point
configuration databse. I put in the database server name and existing
database name, check the box to use existing configuration database,
check box to use Windows authentication.

Can't login to database. I try using a domain account that I know
exist in the domain and in the SQL security logins list. Either option
returns the Error 18456.

.

Relevant Pages

  • Re: WIN XP boots into Safe Mode but freezes at Login screen
    ... I set a new restore point after ... It's strainge because Windows as I said runs flawlessly in every way. ... Last is there and alternative way to bot ito safe mode? ... I can account for all of my running processes and startup ...
    (microsoft.public.windowsxp.help_and_support)
  • Wish List for ActiveSync 3.9 - dropped connections
    ... I just submitted the feedback below through the feedback section of Windows ... someone else logs onto their account on the PC whilst I am logged on. ... has been around for years now and they still can't get the ActiveSync ... I have been attempting to Restore a backup image onto my HP iPAQ Pocket PC ...
    (microsoft.public.pocketpc.activesync)
  • Re: Beginner security questions
    ... Since you've installed with "Windows Only" you may have a few steps to take ... You could try to create a user account on the SQL ... Reinstall sql server in mixed mode (remember to back up your database ...
    (microsoft.public.sqlserver.security)
  • Re: Hard Drive Crash, Restoring to Original Registered User
    ... programs work except a database I use which is locked, ... Probably doesn't matter what name is used for your Windows account. ... Everytime a new user account is created, and new SID is assigned to it. ... The "registered to" isn't used by your database. ...
    (microsoft.public.windowsxp.general)
  • Re: Udate: Safe Mode Frezzes at logon screen
    ... FAQ for Windows Antispy http://www.geocities.com/marfer_mvp/FAQ_MSantispy.htm ... I was able finale able to boot into Safe Mode. ... > point it froze at was as soon as I clicked my cursor on my Admin account ... > I scan my system after turning off system restore then ...
    (microsoft.public.windowsxp.help_and_support)