Solved

Sharepoint 2010 http 500 error

Posted on 2011-02-26
16
1,564 Views
Last Modified: 2012-05-11
I have Sharepoint 2010 enterprise running on Windows Server 2008 R2, no AC, SQL is on a seperate box with same OS.
Everything was installed and working fine for a few months. Then yesterday I tried to open up the CA and it wouldn't open, giving me a HTTP 500 error.
That last time I was able to open it was 4 days ago. Since then I have installed two programs. Cold Fusion 9 Trial version and TeamVeiwer. I suspect it was CF9 that messed it up so I uninstalled it and all related components (.NET integration & 2 others). I am trying a Sharepoint Repair in the meantime.
Any suggestions on how to troubleshoot or fix this issue?
0
Comment
Question by:AccessYourBiz_Com
[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
  • 9
  • 3
  • 3
  • +1
16 Comments
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34987257
The repair did not do the trick.
I looked at the event log and found two entries that may give some clues. One entry says:
"No user profile available to service the request."

I see another entry that says:
"Cannot open database "SharePoint_Config" requested by the login. The login failed. Login failed for user wsi\sqlsvc.

When I checked the DC for that user I notice the checkbox for "Password doesn't expire" was NOT checked. Could it be that the password expired?

This is a managed service account so I can't figure out how to reset the password...but then again I don't know if that is the cause. How can I be sure?
0
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34987264
Well, I figured out how to change the password, so I am doing that and will reboot and test it again.
0
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34987625
After the restart I got the same results. HTTP 500 error and the log still says the logon failed as mentioned above.
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 51

Expert Comment

by:Ted Bouskill
ID: 34990115
I'd guarantee that CF9 broke the installation.

Have you tried rerunning the SharePoint Configuration Wizard?
0
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34991230
No I haven't. I will try that. Thanks.
0
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34991265
I reran the SP Configuration Wizard, accepting all defaults and tried to open SP CA and still have HTTP 500 error. BTW I have not installed Windows 2008 R2 SP1 yet. Someone else said they had a problem with that.
Are there any other ideas or ways to troubleshoot this?
0
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34991316
Should I rerun the SP Configuration wizard and "Disconnect" from the farm and then rerun it? If yes will I be able to reconnect to the same farm and still have access to my other sharepoint sites?
0
 
LVL 6

Expert Comment

by:sabby447
ID: 34992442
Ok, Have you reset the password to same password as earlier ? If not there are lot of other steps to do as follows :

Here is step by step of SharePoint 2k7 which will work in 2k10: http://support.microsoft.com/kb/934838 

The easiest way is to reset the password to what it was earlier and restart the machine

If you still face issues then open IIS and look under application pools, Your pool would be stopped, Try starting that

Though it is a pain when the password change happens, Disconnect and reconnect will not harm your settings however will not resolve the issue either

Hope this helps
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 34993025
Changing the password could have done more harm than good.  Be sure to run the configuration wizard as the farm administrator.  Local admin or domain admin doesn't automatically inherit that permission.
0
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34993163
I kept the password the same when I reset it.
when I try to run the SP Configuration Wizard as logged in as sps_FarmAdmin, I get an Sql exception error:

An error has occurred while validating the configuration settings. An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: The EXECUTE permission was denied on the object 'pro_GetProductVersions', database 'SharePoint_Config', schema 'dbo'.

Not sure why this is happening. any ideas on how to troubleshoot it further.
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 34993241
Hmm, that's an indication that SharePoint role permissions were changed possibly by the other applications which is a big problem.  You might be better off getting Microsoft support involved.

You can search for KB articles on pre-installing the DB's by a DBA for a new SharePoint installation because those articles discuss setting the permissions manually.

Generally the farm service and farm admin accounts need sysadmin permissions for all the SQL DB's for the installation.  Also, make sure both accounts are local admins on the SharePoint server.
0
 
LVL 6

Accepted Solution

by:
sabby447 earned 500 total points
ID: 34993803
Check SQL and make sure hte account has the DBO permission on the database and on SQL in general. Disconnect the server from farm and then rejoin it to the farm.
0
 
LVL 5

Expert Comment

by:navdeepmadan
ID: 34994613
1) Please take the SQL-trace and try to identify if you connecting to the correct database or not.
2) check other sites aprt from sharepoint is working or not.
3) please share the ULS and IIS logs.
0
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34997073
Thanks for all the comments guys.

sabby447, I did what you suggested and I was able to pull up CA but my other sites that uses Access Services says "error loading". I looked at the event log and see "No Access Database Service is available in the farm.[User: wsi\administrator]". I think I may have changed this when I tried to fix stuff. How do I reset that to my "sps_farmAdmin" account....do you even think that could be the problem?
0
 
LVL 3

Author Closing Comment

by:AccessYourBiz_Com
ID: 34997155
Disconnecting and reconnecting to the farm was the key to this resolution.
0
 
LVL 6

Expert Comment

by:sabby447
ID: 34997327
Hi, I hope the problem is resolved completely, If you are still having issues with Access services then create a new one and attach that to site. You can do that in application managment -> Check service application and association and create a new one and add that to the respective sites
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Suggested Solutions

Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

752 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