Solved

Sharepoint 3.0 restore?

Posted on 2014-01-16
7
397 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 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
In this video we show how to create a Shared Mailbox 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 >> Sha…
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …

749 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