?
Solved

Sharepoint 3.0 restore?

Posted on 2014-01-16
7
Medium Priority
?
408 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

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…
Check out this step-by-step guide for using the newly updated Experts Exchange mobile app—released on May 30.
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

801 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