Solved

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

Posted on 2011-03-23
8
531 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
InfoPath 2010 signature from external agent 4 69
Convert a Master Page to HTML 16 122
Sharepoint 2013 error 4 53
Yet more SharePoint App with Angular and Bootstrap 4 34
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 …
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

770 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