?
Solved

Sharepoint 3.0 restore?

Posted on 2014-01-16
7
Medium Priority
?
414 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 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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

On September 18, Experts Exchange launched the first installment of the Help Bell, a new feature for Premium Members, Team Accounts, and Qualified Experts. The Help Bell will serve as an additional tool to help teams increase question visibility.
How to effectively resolve the number one email related issue received by helpdesks.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Suggested Courses

840 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