SCCM 2007 R2 - Console reads ' Connecting to Site Database '

Good Morning,

We currently have SCCM 2007 R2 running in our domain.
SCCM is installed on one server, the Sql database is installed on another server.
Today a colleague decided to update the SCCM server.
To begin with he installed MDT2010, and this seemed to go ok.
Then he decided to install SCCM SP2 and it was whilst the install was running the prerequisite check, that things went wrong.
A message popup appeared stating ' Message Failure ' and then everything closed.
I now cannot open the Configuration manager Console from the SCCM server (or anywhere else for that mattter).
When trying to open the console, it just sticks at ' Connecting to Site Database '
Any ideas what has gone wrong and the best way to resolve the issue ?

Thanks,

Andrew
AndrewLegAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AndrewLegAuthor Commented:
Forgot to mention, i've tried rebooting both servers several times.

Andrew
0
merowingerCommented:
could you please post the setup logfiles. They should be located on your C:\ drive
0
AndrewLegAuthor Commented:
Please find attached the setup and prereq log files.
ConfigMgrPrereq.log
ConfigMgrSetup.log
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

merowingerCommented:
- are all services running?
- eventvwr warnings and errors?
- can you connect to the sql server via mgmt studio from remote?
- could you post the sccm logfiles?
0
AndrewLegAuthor Commented:
Attached are the Log files (change the extension back to .rar)
I'll check the other items you mentioned.

Thanks,
Logs.txt
0
merowingerCommented:
i cannot read the logfile
0
socrates2012Commented:
Put in your SCCM SP1 CD and run the install.  Choose Perform site repair or reset this Site.  That should repair any kinks in your database.  For the future, if you're trying to upgrade an x64 server by chance you will need to install KB960037 first in order to get it to upgrade the boot images and go through flawlessly.  Good luck!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.