Solved

Sharepoint 3.0 restore?

Posted on 2014-01-16
7
372 Views
Last Modified: 2014-01-21
We have a Sharepoint 3.0 server that seems to have basically gone belly up all by itself in the past day. It almost seems to me that it's like somene did a new install of sharepoint.

When navigating to the sharepoint site, we get an error message saying that it cannot connect to the config database. We then have the following even log ID:

Insufficient SQL database permissions for user '' in database 'SharePoint_Config_65302242-1fcc-48c5-880a-963f22972619' on SQL Server instance 'np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query'. Additional error information from SQL Server is included below.
The EXECUTE permission was denied on the object 'proc_getObjectsByClass', database 'SharePoint_Config_65302242-1fcc-48c5-880a-963f22972619', schema 'dbo'.

I was unable to get the central administration page to load, but I finally fixed that. Somehow there was another virtualdirectory created in inetpub with a different port number and sharepoint was set to use that port number. I had to go into IIS and change the properties of the Central admin site to use the original port number and change the directory to the correct directory.

I can now get to the central administration site, but unfortunately the site is still down.

It seems that somehow perhaps the connection between the sharepoint site and the databases is incorrect, but I'm not sure how to correct it. I see my correct sharepoint_config database, wss_content and wss_search databases, but the correct sharepoint_config database is a different name from the above event log error.

Hopefully some of that makes sense. Somehow, I need to tell sharepoint to connect to the config and content databases that I know are correct rather than the ones it's trying to connect to right now, but I'm not sure how to make that change. I saw somewhere that I should go to application management, then cick on content datbases, and add my content databse there, but when I do, I can't click on the link that says "Add a content Datbase" and there are no content databases in there right now.

is my best bet to uninstall sharepoint, re-install and try to re-connect it to the databases when i do the re-install?
0
Comment
Question by:themightydude
  • 4
  • 3
7 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39786084
That does indeed seem like there was a reinstall of SharePoint.

Is SP and SQL running on the same machine?  The Central Admin that opens correctly, do you see your Web App and Site Collections listed (under App Mgmt tab)?  If not then you are on the wrong Central Admin and connected to the wrong config database.
0
 
LVL 4

Author Comment

by:themightydude
ID: 39786102
SP and SQL are on the same server (small company).

Originally I did not see any of my sites in Central admin, but I found an artcile here: http://www.sharepoint-insight.com/2008/07/16/registry-setting-for-sharepoint-configuration-database-connection-string/

I modified that registry key for the DSN so it points to the correct configuration database and restarted my server. Now I do see my sites and everything in Central administration, but the main sharepoint site still says unable to connect to the configuration database.

I now see this in event log:
SQL Database 'SharePoint_Config_e49dbe51-28c7-495e-8250-1dc2ab9465b3' on SQL Server instance 'np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query' not found. Additional error information from SQL Server is included below.

Cannot open database "SharePoint_Config_e49dbe51-28c7-495e-8250-1dc2ab9465b3" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.

That's the correct database name now, I guess i just need to set the correct permissions for the LOCAL SERVICE login on that database.
0
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 500 total points
ID: 39786156
Rather than modifying the registry (you need to change it back before doing this), you should run the config wizard and disconnect from the farm.  Then run the config wizard again and connect to an existing config db....specifying your original.
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.

 
LVL 4

Accepted Solution

by:
themightydude earned 0 total points
ID: 39786189
I would do that with the sharepoint products / technologies config wizard?

WHen I turn through it, it asks me if I want to:

a. Overwrite the existing site with a new default sharepoint site
b. do not ovewrite the existing site. create a new sharepoint site
c. no, do not create a default site

The site is working now after I gave the local service login rights to the config and content databases.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39786210
If it's working, leave it alone.
0
 
LVL 4

Author Comment

by:themightydude
ID: 39786216
Sounds like a good idea to me. We'll be upgrading it soon anyway.

Thanks for the help
0
 
LVL 4

Author Closing Comment

by:themightydude
ID: 39796422
Fixed
0

Featured Post

The curse of the end user strikes again      

You’ve updated all your end user’s email signatures. Hooray! But guess what? They’re playing around with the HTML, adding stupid taglines and ruining the imagery. Find out how you can save your signatures from end users today.

Question has a verified solution.

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

Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…

910 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

21 Experts available now in Live!

Get 1:1 Help Now