Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 554
  • Last Modified:

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

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
xyntekinc
Asked:
xyntekinc
  • 4
  • 4
5 Solutions
 
Justin SmithSr. System EngineerCommented:
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
 
Justin SmithSr. System EngineerCommented:
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
 
xyntekincAuthor Commented:
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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
Justin SmithSr. System EngineerCommented:
Why wouldt you want to install SQL Express if you have a full 2008 version?  You didn't answer my questions above.

0
 
xyntekincAuthor Commented:
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
 
Justin SmithSr. System EngineerCommented:
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
 
xyntekincAuthor Commented:
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
 
xyntekincAuthor Commented:
ACH1LLES was a great help.  Thanks again.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now