Solved

Sharepoint Services 3.0 installation error Configuration Database not found MSSQL$Microsoft$##SSEE Error

Posted on 2011-03-23
8
533 Views
Last Modified: 2012-05-11
I currently am running WIndows Server 2008 (32bit).  Sharepoint 3.0 was configured and working flawlessly on SQL2005 along with an instance installed from our CRM system (ACT).  Upon upgrading ACT, the tech rep from ACT completely removed SQL2005, and during the upgrade it installed a new instance of SQL2008R2 for ACT.  Unfortunately this completely removed SQL2005 and our Sharepoint DB.  Unfortunately there is no backup to go to so we are at square one with NO data.  

I have tried repairing, uninstalling, re-installing Sharepoint, and still no luck.  When performing a basic install I get the error (configuration database not found, and a MSSQL$Microsoft$##SSEE error).  I tried an advanced sharepoint install and it made it further, but threw an error later in the configuration steps saying there was no database to install to or connect to.  The only instances I see in SQL2008R2 management console is my ACT instance.  

I am completely locked up right now with no way to proceed in installing and configuring a new Sharepoint site/database.  I attached the error log when trying to configure the Sharepoint DB as well.   Sharepoint-Error-Log-PSCDiagnost.log
0
Comment
Question by:xyntekinc
[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
  • 4
8 Comments
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 500 total points
ID: 35199183
Not really clear here.  Since all your db's are gone, you are just starting from scratch, correct?

The only time it would complain about a config db not found (for the most part) is if you are trying to join an existing farm instead of creating a new one.

You are wanting to use the SQL 2008 box to host your db's, correct?  If so, do NOT do a basic install.  You need to do an Advanced (farm) - Complete install.  
0
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 500 total points
ID: 35199188
AFter the install, you run the config wizard to create a NEW farm.  This is when you direct it to the SQL 2008 box, it will create SharePoint_Config db on the sql box, as well as a Central Admin db.
0
 

Author Comment

by:xyntekinc
ID: 35199570
So it seems as though the problem was that SQLServer 2008 was causing the error when sharepoint was trying to install.  I tried both basic and advanced setup's and it would not create a new config db nor allow me to connect to any other sql instance.  

I would like to completely start from scratch, therefore have and have completely removed and un-installed SQL Server 2008, and now have NO SQL Server installed.

I then tried installing sharepoint services 3.0 fresh and it goes all the way to the end and I get an error "Sharepoint Services 3.0 Setup has stopped working"  Then when I go to the Sharepoint Services Configuration wizard I get the attached error (See Image). Sharepoint_Error
I was under the assumption that the sharepoint install would install the appropriate MSSQL2005 components, but it doesn't seem like it does.  Do I need to install SQL Server Express 2005 prior to the Sharepoint Services Setup & Config?
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 500 total points
ID: 35199597
Why wouldt you want to install SQL Express if you have a full 2008 version?  You didn't answer my questions above.

0
 

Author Comment

by:xyntekinc
ID: 35199728
My understanding is that we currently do not own a full version of SQL. When we purchased the server it already had Sharepoint installed, all we needed to do was configure it.  I'm not sure if a FULL version of SQL 2005 was installed or an express 2005 version of SQL was pre-iinstalled when we purchased our server.  Either way, when we upgraded our CRM application (ACT) yesterday, the tech removed/un-installed all components of SQL Server 2005 and SQL Server 2008 express was installed as part of the CRM (ACT) application.  

Due to the errors this caused, we wanted to start from scratch so we removed the CRM application and all components of SQL Server 2008 Express.  So right now we have no SQL Server components installed, and I am looking at what I need to do to first get my sharepoint installed and configured.  I hope this explains things a bit more.  Thanks.
0
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 500 total points
ID: 35199773
Ok let's just end the questions.  Go download and install SQL 2008 Express (and mgmt tools) FIRST, before doing anything with SharePoint.  If you already have SHarePoint on your server, uninstall it.  After, go into the Management Tools and grant your install account sysadmin rights in SQL.

http://www.microsoft.com/express/Database/

Is SQL and SharePoint going to run on the same server?  If so, after you install SQL Express, then install SharePoint using Advanced - Complete.  After, run the Config wizard.  Your SQL instance will be the name of your SharePoint server.
0
 

Accepted Solution

by:
xyntekinc earned 0 total points
ID: 35200055
Great thanks so much.  One more issue....I downloaded 2008 Express w/ Management tools, and began the installation and it threw a .Net Framework errror.  Here is the error:
 .net Framework Error
This is the .net Framework that is currently installed
 Installed .net
0
 

Author Closing Comment

by:xyntekinc
ID: 35372916
ACH1LLES was a great help.  Thanks again.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

732 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