SharePoint 2010-“无法连接到配置数据库" [英] SharePoint 2010-“Cannot connect to the configuration database”

问题描述

I have TFS 2012 which integrated with SharePoint service, recently I duplicated the same machine for testing, and modified some parameters on the testing machine to avoid conflict due to they are in the same networking. They works well.

今天，生产服务器的SharePoint网站提示无法连接到配置数据库"，但是团队基础服务运行良好，我怀疑测试服务器中的某些因素导致了此问题，并且我关闭了测试服务器，该问题仍然存在.

Today the production server's SharePoint site prompt "Cannot connect to the configuration database", but team foundation service works well, I doubt that something in the testing server cause this, and I shutdown testing server, the issue still exists.

在获得此问题的经验之前，大多数问题都与这样的SQL Server实例配置相关:"

Before I have experience for this issue, most of them are related with SQL server instance configuration like this "https://mikessharepoint.wordpress.com/2011/11/22/cannot-connect-to-the-configuration-database-error-of-central-administration/" or some authentications issue in the IIS application pool.

这是来自事件查看器的错误事件:"发生未知的SQL异常53.下面包括来自SQL Server的其他错误信息.建立与SQL Server的连接时发生与网络相关或特定于实例的错误.这 找不到服务器或无法访问服务器.验证实例名称正确，并且已将SQL Server配置为允许远程连接. (提供者:命名管道提供者，错误:40-无法打开与SQL Server的连接)"

and here is the error event from event viewer: " Unknown SQL Exception 53 occurred. Additional error information from SQL Server is included below. 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

我怀疑生产服务器上的某些内容(可能是SQL Server实例名称)是否会通过某些操作更改为测试服务器，但我不知道在哪里以及如何进行.

I doubt that something (probably SQL server instance name) on production server change to testing servers by some action, but I don't know where and how.

并且我怀疑新服务器会导致错误，原因是我在生产服务器的wss_config数据库中找到了不正确的东西，即"ServerName".在表TimerJobHistory中归档，某些值是新服务器，某些值是旧服务器.但是，即使 我将所有值更新为旧服务器，然后重新启动生产服务器，它不起作用.

And I doubt that the new server cause the error, the reason is I find something incorrect in wss_config database of production server, the "ServerName" filed in table TimerJobHistory, some value are new server, some value are old server. But even I update all the value to old server and restarted the production server, it does not work.

我检查了我能用Google搜索的所有内容，但没有任何效果，是否有人可以为此提供任何帮助，感谢您的任何帮助.

I check all things I can googled, but nothing works, is there anybody could provide any help on this, appreciate for any kindly help.

.NET/SharePoint上的Mac Lee-Focus

Mac Lee-Focus on .NET/SharePoint

推荐答案

检查对此

Check the best answer to this thread

这篇关于SharePoint 2010-“无法连接到配置数据库"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！