Solved

Sharepoint 3.0 restore?

Posted on 2014-01-16
7
382 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
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 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 Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
In this video we show how to create a Contact 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 Recipients >> Contact ta…
In this video we show how to create an Accepted Domain 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 Mail Flow >> Ac…

773 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