Solved

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

Posted on 2011-03-23
8
527 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
  • 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
 
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

705 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now