例外：在System.Data.SqlClient.SqlInternalConnection.OnError .net SqlClient数据提供（SqlException异常，

Question

我在做Sitecore的7.0安装与安装...但在数据库设置每次它抛出同样的错误：

例外：.net SqlClient数据提供

在System.Data.SqlClient.SqlInternalConnection.OnError（SQLEXCEPTION 例外，布尔breakConnection，动作1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource 1重试，DbConnectionOptions USEROPTIONS，DbConnectionInternal &连接）在 小号ystem.Data.ProviderBase.DbConnectionFactory.TryGetConnection（的DbConnection owningConnection，TaskCompletionSource 1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource 1重试，DbConnectionOptions USEROPTIONS）在 System.Data.SqlClient.SqlConnection.TryOpen在System.Data.SqlClient.SqlConnection.Open（TaskCompletionSource`1 重试） （）在 SitecoreInstallWizardCore.Utils.SQLUtil.TestSqlServerConnection（字符串 的connectionString，用户名字符串，布尔verifyUserSysadmin，布尔 verifyInstanceLocal）

件事我想：

上的SQL Server /窗口认证
• 指出错误的登录凭据..
• 清理临时的所有缓存
  • 安装MVC 3和4

仍然安装程序提示给定的错误与上述错误

尝试连接到SQL Server时发生错误：登录 用户''失败。详细信息请参阅日志文件。

我用Google搜索，但无法找到相关的很多关于Sitecore的...... 请建议

Answer 1

你需要禁用命名管道SQL服务器，并通过协议，只启用TCP/IP。

得到这个从这个链接 - http://sdn.sitecore.net/Products/Sitecore%20V5/Sitecore%20CMS%205,-d-,3/Installation/Troubleshooting.aspx

思考 - 可能是它第一次使用命名管道的尝试和失败，但如果它被禁止，必定会使用TCP连接，并应解决的问题。

以上链接 - How to solve a login/database missing error regarding Sitecore Training Website?

Answer 2

你能检查是否设置为“仅适用于Windows认证”模式，SQL服务器，这可能是什么造成这个问题。 如果是这样，您需要将其更改为“SQL Server和Windows身份验证模式”，请参阅此link以获得帮助

Answer 3

这似乎是SQL连接字符串问题，并且与sitecore无关。检查您的connectionstrings.config以查看您是使用集成安全性（Windows）还是在连接字符串中传递用户凭据。