Solved

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

Posted on 2011-03-23
8
532 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone 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

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

830 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