Can't access Operations or Applications tabs from Central Admin

Question

MOSS 2007 Enterprise on Windows Server 2003 R2 Std, SQL Server 2008 Std.
==========================
Problem:  When I click on either the Operations or Applications tab within Central Admin, I get the following verbose error message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)

How this came up:  I haven't had to get into Central Admin for several months now.  I've been working on building a library and adding contents.  I wanted to add Rights Management to my training site and had to get into Applications to setup IRM - that's when I found out I couldn't get into either tab in Central Admin.  A couple weeks ago, I went into SQL Server Management Studio and enabled trace logging on the DB's, set backup schedules for them, set each DB Recovery mode to Full.  I can get to the SSP Admin sites, the main page of Central Admin and everywhere withing my main site on port 80.

What I've done to look into the problem:  Run the SP Config and Tech Wizard 3-4 times; reset the password for the SQL Server access account in the Central Admin App Pool in IIS; ensured that account had the proper permissions for the DB's in SQL Server Management Studio.  I was getting the following error in the Application log, but not anymore (don't know why):

Event Type:    Failure Audit
Event Source:    MSSQL$WCTINTRANET
Event Category:    Logon
Event ID:    18456
Date:        10/22/2009
Time:        3:07:00 PM
User:        WHOOPER\SQL2005
Computer:    WCT-SHAREPOINT
Description:
Login failed for user 'WHOOPER\SQL2005'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00   .H......
0008: 1b 00 00 00 57 00 43 00   ....W.C.
0010: 54 00 2d 00 53 00 48 00   T.-.S.H.
0018: 41 00 52 00 45 00 50 00   A.R.E.P.
0020: 4f 00 49 00 4e 00 54 00   O.I.N.T.
0028: 5c 00 57 00 43 00 54 00   \.W.C.T.
0030: 49 00 4e 00 54 00 52 00   I.N.T.R.
0038: 41 00 4e 00 45 00 54 00   A.N.E.T.
0040: 00 00 07 00 00 00 6d 00   ......m.
0048: 61 00 73 00 74 00 65 00   a.s.t.e.
0050: 72 00 00 00               r...   

============
So ... where do I go from here?
Mike

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 1

Mike,

Did you reset the central admin app pool id directly in IIS?  You should not do it in IIS.  Run this:

stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword

Here is more info:  http://support.microsoft.com/default.aspx/kb/934838

You set your Database recovery to full.  Have you checked the hard drive space on the SQL server?  Have you tried a reboot of the SQL server? Often this error is an indication of a connection problem.  Is the database engine configured to accept remote connections. Have you looked at the SharePoint ULS logs does anything show in logs?


Thanks,

Aseem Nayar - MSFT

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

I just ran the stsadm command to update the credentials for that account.  HD space is fine.  Will reboot in a minute.  I don't know how, in SQL Server 2008, to check whether it is configured for remote connections.  I looked through the ULS logs and finally found this:

10/29/2009 10:29:47.17     Bamboo.SPAnalyzer.exe (0x2520)              0x252C    Windows SharePoint Services       Database                          5big    Critical    Database 'WSS_Content_baf76d9d14ca41f4b25a45ec4fb27468' on SQL Server instance 'wct-sharepoint\wctintranet' is not empty and does not match current database schema.     
10/29/2009 10:29:48.39     Bamboo.SPAnalyzer.exe (0x2520)              0x252C    Windows SharePoint Services       Database                          5big    Critical    Database 'WSS_Content' on SQL Server instance 'wct-sharepoint\wctintranet' is not empty and does not match current database schema.     
10/29/2009 10:29:49.39     Bamboo.SPAnalyzer.exe (0x2520)              0x252C    Windows SharePoint Services       Database                          5big    Critical    Database 'SharePoint_AdminContent_be8e47d7-571b-4c36-b199-72593e990c9f' on SQL Server instance 'wct-sharepoint\wctintranet' is not empty and does not match current database schema.     
10/29/2009 10:29:49.95     Bamboo.SPAnalyzer.exe (0x2520)              0x252C    Windows SharePoint Services       Database                          5big    Critical    Database 'WSS_Content_baf76d9d14ca41f4b25a45ec4fb27468' on SQL Server instance 'wct-sharepoint\wctintranet' is not empty and does not match current database schema.     
10/29/2009 10:29:50.17     Bamboo.SPAnalyzer.exe (0x2520)              0x252C    Windows SharePoint Services       Database                          5big    Critical    Database 'WSS_Content' on SQL Server instance 'wct-sharepoint\wctintranet' is not empty and does not match current database schema.     
10/29/2009 10:29:50.41     Bamboo.SPAnalyzer.exe (0x2520)              0x252C    Windows SharePoint Services       Database                          5big    Critical    Database 'SharePoint_AdminContent_be8e47d7-571b-4c36-b199-72593e990c9f' on SQL Server instance 'wct-sharepoint\wctintranet' is not empty and does not match current database schema.     
10/29/2009 10:29:59.02     Bamboo.SPAnalyzer.exe (0x2520)              0x252C    Windows SharePoint Services       Database                          5big    Critical    Database 'SharePoint_AdminContent_be8e47d7-571b-4c36-b199-72593e990c9f' on SQL Server instance 'wct-sharepoint\wctintranet' is not empty and does not match current database schema.     
10/29/2009 10:29:58.56     Bamboo.SPAnalyzer.exe (0x2520)              0x252C    Windows SharePoint Services       Database                          5big    Critical    Database 'WSS_Content_baf76d9d14ca41f4b25a45ec4fb27468' on SQL Server instance 'wct-sharepoint\wctintranet' is not empty and does not match current database schema.     
10/29/2009 10:29:58.80     Bamboo.SPAnalyzer.exe (0x2520)              0x252C    Windows SharePoint Services       Database                          5big    Critical    Database 'WSS_Content' on SQL Server instance 'wct-sharepoint\wctintranet' is not empty and does not match current database schema.     
10/29/2009 10:29:59.61     Bamboo.SPAnalyzer.exe (0x2520)              0x252C    Windows SharePoint Services       Database                          5big    Critical    Database 'WSS_Content' on SQL Server instance 'wct-sharepoint\wctintranet' is not empty and does not match current database schema.     
10/29/2009 10:29:59.36     Bamboo.SPAnalyzer.exe (0x2520)              0x252C    Windows SharePoint Services       Database                          5big    Critical    Database 'WSS_Content_baf76d9d14ca41f4b25a45ec4fb27468' on SQL Server instance 'wct-sharepoint\wctintranet' is not empty and does not match current database schema.     
10/29/2009 10:29:59.84     Bamboo.SPAnalyzer.exe (0x2520)              0x252C    Windows SharePoint Services       Database                          5big    Critical    Database 'SharePoint_AdminContent_be8e47d7-571b-4c36-b199-72593e990c9f' on SQL Server instance 'wct-sharepoint\wctintranet' is not empty and does not match current database schema.    
===========
I then tried to access the Application tab frm Central Admin, but I'm still getting the same error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)
=============
I'll reboot and report back with the results.

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 3

Reboot complete, but I still get the same error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)
=================
Nothing remarkable in the Application log.

Opened the latest ULS log (<server name>-20091029-1211.log) and saw these entries at the beginning:

Timestamp                  Process                                     TID       Area                              Category                          EventID    Level         Message     Correlation
10/29/2009 12:11:46.62     OWSTIMER.EXE (0x0A38)                       0x0AD8    Windows SharePoint Services       Database                          5586    Critical    Unknown SQL Exception 64 occured. Additional error information from SQL Server is included below.  A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)     
10/29/2009 12:11:47.56     OWSTIMER.EXE (0x0A38)                       0x0AD8    Windows SharePoint Services       Topology                          88bl    Monitorable    An exception occured while trying to acquire the local farm: System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)     at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()     at...    

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 4

I've been doing some searches on the terms in the errors of my last post and saw mention of Connections.  I remoted in to the server and using SSMS, I right-clicked on the server/instance name > Properties > Connections and see that Connections is set to "0" and that down below I have checked "Allow remote connections to this server".

I checked the log files in SSMS and this is a typical entry:
10/29/2009 10:04:00 AM   Logon   Error: 18456, Severity: 14, State: 38
10/29/2009 10:04:00 AM   Logon   Login failed for user 'DOMAIN\ACCT'. Reason: Failed to open the explicitly specified database. (CLIENT: <local machine>)

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 5

Decided to try something.  I got into SSMS and set all DB's to "Simple" Recovery and "SQL Server 2008 (100)" compatibility.  I also unchecked Transaction Log Shipping.  Rebooted.

Same problem.  I ca get to my sites, admin for SSP1 and SSP2, but not the Shared Services Admin page, Operations page or Applications page in Central Admin.

I couldn't find any specific errors in the Application log, SSMS logs, or the ULS logs.

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 6

Looks like you are having SQL issues.  Do you see any errors in the Application logs on the SQL or Central Admin servers?  If so what do you see?
Run a profiler trace making sure to select the event Errors & Warnings; Security Audit in the log, then recreate the error and review the trace.  Do you see any errors? 

Are any of your sharepoint databases inacessible?  If you look in SSMS and right click on all your databases and go to properties are you able to get to properties on the databases?

-Aseem

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 7

No errors in the Application Log.

I ran the Profile Trace and only see 2 errors (all errors show up in red type, correct?), and they repeat every so often:

User Error Message    Changed database context to 'SharedServices2_DB'.    Windows SharePoint Services    SQL2005    WHOOPER\SQL2005                    2640    59    2009-10-30 10:04:14.403            5701    18    SharedServices2_DB    100962    WCT-SHAREPOINT        0X010500000000000515000000166D93C56EE082F0BFD5F86152050000    WHOOPER    0    WCT-SHAREPOINT\WCTINTRANET    WHOOPER\SQL2005                            10    2        0        1           

and

User Error Message    Changed language setting to us_english.    Windows SharePoint Services    SQL2005    WHOOPER\SQL2005                    2640    59    2009-10-30 10:04:14.403            5703    18    SharedServices2_DB    100963    WCT-SHAREPOINT        0X010500000000000515000000166D93C56EE082F0BFD5F86152050000    WHOOPER    0    WCT-SHAREPOINT\WCTINTRANET    WHOOPER\SQL2005                            10    1        0        1           


I can get to the Properties of every database in SSMS.

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 8

Just had a thought .... what if I ran the SP Tech and Config Wizard and chose to create a new server farm?  'Course I'd have to disconnect the current DB's and then reconnect all but the problem DB to the new farm.

A lot of work, but I don't know what else to do at this point.

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 9

Hi,

I would suggest you to run the configurationn wizard without disconnecting from the farm first. Running the configuration wizard, fixes the issue most of the time..

Try this out. If it doesnt work, how much time would it take for you to create a new farm and add the servers to the new farm. it is advisable not to tease the sharepoint databases through backend.


hope this helps.

Answer 10

Well, I've run the Wizard several times now with no change. I'm hoping someone has an idea to solve this without having to create a new farm and migrate over the DB's.

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 11

Hi Mike,

 

When creating a Shared Services Provider (SSP) in MOSS 2007, a SQL Server job called SSPDBNAME_Job_DeleteExpiredSessions is created. This job executes a stored procedure against the Shared Services Provider database every minute. If the SSP database has been deleted or a problem occurred when deleting an SSP, the job may not be deleted. When the job attempts to run, it will fail since the database no longer exists.

For such problem, you can try the following steps:

1.     Connect to the SQL Server using SQL Server Management Studio

2.     Expand SQL Server Agent and then click on Jobs.

3.     Review the list of Jobs for any named XXXXX_Job_DeleteExpiredSessions.

4.     Open the properties of the first Job with this name.

5.     Click on Steps and choose to Edit the Step listed.

6.     Note the name of the Database selected for this Step and close out of the Job properties.

7.     Repeat Steps 5 and 6 for each Job with this name.

8.     In SQL Server Management Studio, expand Databases to see a list of database names on this server.

9.     Compare the list of databases with the database names obtained from the Jobs.

10.   If any of the databases are not found, the associated Job should be disabled.

11.   Go back to Jobs, right click on the appropriate Job and click Disable Job.

12.   Monitor the Application Event Log and SQL Server Event Log to ensure the errors are no longer occurring.

 

If this is not the issue, you can follow the steps in this article to find the cause of the login failed error:

Identifying the source of SQL Server login failures (18456 errors)

http://www.eraofdata.com/blog/2009/01/loginfailures/

 

Hope this helps.

 

Lu Zou

TechNet Subscriber Support in forum

If you have any feedback on our support, please contact [e-mail]

Answer 12

I checked the DB's for the XXXXX_Job_DeleteExpiredSessions, and both exist.

I tried the steps in the post you linked to, but I am not getting 18456 errors anymore.  The only error I see in that server's Application log is:
Event Type:    Warning
Event Source:    ASP.NET 2.0.50727.0
Event Category:    Web Event
Event ID:    1309
Date:        11/2/2009
Time:        8:59:51 AM
User:        N/A
Computer:    WCT-SHAREPOINT
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 11/2/2009 8:59:51 AM
Event time (UTC): 11/2/2009 2:59:51 PM
Event ID: 9851adade6a541108399e761d64e843f
Event sequence: 616
Event occurrence: 15
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/2061701963/Root-1-129016259909170977
    Trust level: WSS_Custom
    Application Virtual Path: /
    Application Path: C:\Inetpub\wwwroot\wss\VirtualDirectories\whooper80\
    Machine name: WCT-SHAREPOINT
 
Process information:
    Process ID: 7072
    Process name: w3wp.exe
    Account name: WHOOPER\ssp_app_pool_acct
 
Exception information:
    Exception type: SPException
    Exception message: Cannot complete this action.

Please try again.
 
Request information:
    Request URL: http://whooper/default.aspx
    Request path: /default.aspx
    User host address: 192.168.16.3
    User: WHOOPER\sspsearchdb_acct
    Is authenticated: True
    Authentication Type: NTLM
    Thread account name: WHOOPER\ssp_app_pool_acct
 
Thread information:
    Thread ID: 11
    Thread account name: WHOOPER\ssp_app_pool_acct
    Is impersonating: False
    Stack trace:    at Microsoft.SharePoint.Library.SPRequest.GetViewsSchemaXml(String bstrUrl, String bstrListName, Boolean bFullBlown, ISP2DSafeArrayWriter p2DWriter, Int32& plDefaultViewIndex)
   at Microsoft.SharePoint.SPViewCollection.EnsureViewSchema(Boolean fullBlownSchema)
   at Microsoft.SharePoint.SPViewCollection..ctor(SPList list, Boolean fullBlownSchema)
   at Microsoft.SharePoint.SPList.get_LightweightViews()
   at Microsoft.SharePoint.WebPartPages.ListViewWebPart.EnsureListAndView(Boolean requireFullBlownViewSchema)
   at Microsoft.SharePoint.WebPartPages.ListViewWebPart.UseSchemaXmlToolbar()
   at Microsoft.SharePoint.WebPartPages.ListViewWebPart.get_ToolbarControl()
   at Microsoft.SharePoint.WebPartPages.ListViewWebPart.CreateChildControls()
   at System.Web.UI.Control.EnsureChildControls()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.WebControls.WebParts.WebPart.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
===============
The error I see when trying to go to the Operations or Application tab, and it takes about 2 minutes, is this (as of this morning):

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 13

There are few things you need to check -

1> see that SQL is into the exception list of your server firewall.
2> check for the admin database if its in read-only mode. If so, you need to change that..

3> from the web server try to get an ODBC connection, by going into the administrative services on the server. See if the connection to the SQL works.

Try for these....

Answer 14

SQL is part of the internal network, and is hosted on the same server as SharePoint; plus, I can get to all my sites, so (1) and (3) aren't an issue.  And on (2), Read-Only is set to "FALSE".

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 15

Just in case I have to run the Wizard and create a new server farm, what is the name of the database(s) that is used ONLY by Central Admin?  All the rest I'll import, but I don't want to bring in the "bad" Central Admin database.

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 16

One other thought .... I've got some backups (using the Backup & Restore function within SharePoint) going back several months.  What if I used STSADM.exe to restore just the database(s) for Central Admin? 

If so, what is/are the default name(s) of the database(s)?

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 17

I've done some more investigating and offer the following to help the readers of this thread figure out what's wrong and how to fix it.

I downloaded and installed SharePoint Manager from Codeplex.  I drilled down to the URL for Central Admin and saw the following in the Properties page > UserAccountDirectoryPath:

Property accessor 'UserAccountDirectoryPath' on object 'Microsoft.SharePoint.SPSite' threw the following exception: 'Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))'

I Bing'd the part in single quotes and saw lots of results, but not any for the object.

In the Application log, I saw a number of these errors (1 for each database), but none in the last 25 minutes.

Event Type:    Error
Event Source:    Windows SharePoint Services 3
Event Category:    (484)
Event ID:    3759
Date:        11/4/2009
Time:        1:50:09 PM
User:        N/A
Computer:    xxxxxxxxxx
Description:
The description for Event ID ( 3759 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: SharePoint_AdminContent_be8e47d7-571b-4c36-b199-72593e990c9f, xxxxxxxx\xxxxxxx.

About once/90-min I'm seeing these:

Event Type:    Warning
Event Source:    SQLAgent$WCTINTRANET
Event Category:    Job Engine
Event ID:    208
Date:        11/4/2009
Time:        12:40:00 PM
User:        N/A
Computer:    WCT-SHAREPOINT
Description:
SQL Server Scheduled Job '0D909B13-D633-4DE1-B8EA-E766FA8C8750' (0xEC4D433F4AF8164EB8E1FDC40036B10A) - Status: Failed - Invoked on: 2009-11-04 12:40:00 - Message: The job failed.  The Job was invoked by Schedule 10 (Schedule_1).  The last step to run was step 1 (0D909B13-D633-4DE1-B8EA-E766FA8C8750_step_1).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Lastly, I saw 3 of these in a row from 2 hrs 20 min ago:

Event Type:    Error
Event Source:    Office SharePoint Server
Event Category:    Office Server General
Event ID:    7888
Date:        11/4/2009
Time:        11:59:48 AM
User:        N/A
Computer:    WCT-SHAREPOINT
Description:
A runtime exception was detected. Details follow.
Message: Access Denied! Only site admin can access Data Source object from user profile DB.

Techinal Details:
System.UnauthorizedAccessException: Access Denied! Only site admin can access Data Source object from user profile DB.
   at Microsoft.Office.Server.UserProfiles.SRPSite.AdminCheck(String message)
   at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(IDataRecord rec)
   at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(String strDSName)
   at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site, Boolean fAllowEveryoneRead)
   at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site)
   at Microsoft.Office.Server.UserProfiles.UserProfileConfigManager.GetDataSource()
   at Microsoft.Office.Server.UserProfiles.BDCConnector.RefreshConfiguration(String sspName)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 18

Since the last post, I have backed up the databases and completely uninstalled MOSS and SQL Server.  I had no other option; I have to get this back up.  I will spend today and tomorrow reinstalling both (backing up at each major step), and then will "join" MOSS and the original DB's (except for then one that is used by Central Admin).  I should be able to move forward from there.

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 19

If it wasn't for bad luck, I'd have no luck at all ..........

I've tried for the last 9 hours to install SQL Server 2005 with no luck; keeps failing on the Database Services.  As SharePoint is completely off the box, I posted my questions at microsoft.public.sqlserver.setup with subject line: Can't reinstall SQL Server 2005 Std Database Services.
I'll post the results here when available.

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)

Answer 20

Got it solved!  A reply to my post at microsoft.public.sqlserver.setup with subject line: Can't reinstall SQL Server 2005 Std Database Services had the answer.

It suggested that I try using the Local System account as the SQL setup account, since it appeared the account I was using didn't have the right permissions.  It also suggested I try disabling Windows Defender if the above didn't work.

I now have SQL Server 2005 Std installed, and am installing SP2 and SP3 on my way to an upgrade to SQL Server 2008 Std later today.  Then I can restore my databases and (hopefully) get SharePoint's Central Admin to work.

---

Mike Webb, IT Admin, Platte River Whooping Crane Maintenance Trust, Inc. (a 501(c)(3) conservation nonprofit org.)