我已粘贴下面错误的具体技术细节 . 我在Windows Server 2012 R2虚拟机上运行SQL Server 2017 Developer Edition .

我知道这个问题已被多次询问,我已经尝试了所有已发布但仍然没有运气的建议修复程序 . 那么让我详细说明到目前为止我到底做了什么:

  • 在SQL Server Management Studio上,我已为服务器身份验证设置启用了SQL Server和Windows身份验证模式

  • 再次,在服务器propeties>连接中的SSMS中,我确保最大并发连接数为0 =无限制

  • 在SQL Server配置管理器中,我现在启用了命名管道和TCP / IP . 客户端协议顺序如下:1.Shared Memory,2.TCP / IP和3.Named Pipes .

  • 在所有改变之后,我做了一个冰雹玛丽并运行了我从另一个论坛发现的查询 . 它应该确保不止一个人能够登录到SQL服务器(它仍然失败)

sp_configure'show advanced options',1;去重新配置去sp_configure'用户连接',0去重新配置去


Here is the specific error I get when I try top log in with the user account that I created:

无法连接到A98SV201BDD2T . 已成功与服务器 Build 连接,但在登录过程中发生错误 . (提供者:共享内存提供者,错误:0 - 没有进程在管道的另一端 . )( . Net SqlClient Data Provider)-------------------- ----------如需帮助,请单击:http://go.microsoft.com/fwlink?ProdName = Microsoft%20SQL%20Server&EvtSrc = MSSQLServer&EvidID = 233&LinkId = 20476 ---------- --------------------服务器名称:A98SV201BDD2T错误号码:233严重性:20状态:0 ---------------- --------------程序位置:at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity,SqlConnectionString connectionOptions,SqlCredential credential,Object providerInfo,String newPassword,SecureString newSecurePassword,Boolean redirectedUserInstance, System.Data.SqlClient.SqlConnectionFactory.CreateConnection中的SqlConnectionString userConnectionOptions,SessionData reconnectSessionData,DbConnectionPool pool,String accessToken,Boolean applyTransientFaultHandling(DbConnectionOptions选项,DbConnectionPoolKey poolKey,Object poolGroupProviderInfo,DbConnell) System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection,TaskCompletionSource1 retry,DbConnectionOptions userOptions,DbConnectionInternal)上的System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection,DbConnectionPoolGroup poolGroup,DbConnectionOptions userOptions)中的ctionPool池,DbConnection owningConnection,DbConnectionOptions(userOptions) System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection,DbConnectionFactory connectionFactory,TaskCompletionSource1 retry,DbConnectionOptions userOptions)中的System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection,DbConnectionFactory connectionFactory,TaskCompletionSource1 retry,DbConnectionOptions userOptions)中的oldConnection,DbConnectionInternal&connection) )System.Data.SqlClient.SqlConnection上的System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) .TryOpen(TaskCompletionSource`1重试)位于Microsoft.SqlServer.Management.UI的Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci,IServerType服务器)的System.Data.SqlClient.SqlConnection.Open()处 . ConnectionDlg.Connector.ConnectionThreadUser()===================================没有进程在另一端管道

Interestingly, when I try to log in again immediately after the first failed attempt I get a slightly different error message:

用户'PhocasAdmin'登录失败 . (.Net SqlClient数据提供程序)------------------------------如需帮助,请单击:http://go.microsoft . com / fwlink?ProdName = Microsoft%20SQL%20Server&EvtSrc = MSSQLServer&EvtID = 18456&LinkId = 20476 ------------------------------服务器名称: A98SV201BDD2T错误号码:18456严重性:14状态:1行号:65536 ------------------------------ Program location:at System .Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity标识,SqlConnectionString connectionOptions,SqlCredential凭证,Object providerInfo,String newPassword,SecureString newSecurePassword,Boolean redirectedUserInstance,SqlConnectionString userConnectionOptions,SessionData reconnectSessionData,System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection)上的System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions选项,DbConnectionPoolKey poolKey,Object poolGroupProviderInfo,DbConnectionPool池,DbConnection owningConnection,DbConnectionOptions userOptions)中的DbConnectionPool池,String accessToken,Boolean applyTransientFaultHandling)在System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection,DbConnectionFactory connectionFactory)的System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection,TaskCompletionSource1 retry,DbConnectionOptions userOptions,DbConnectionInternal oldConnection,DbConnectionInternal&connection)中的owningConnection,DbConnectionPoolGroup poolGroup,DbConnectionOptions userOptions) System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection)中的,TaskCompletionSource1重试,DbConnectionOptions userOptions)在System.Data.SqlClient.SqlConnection的System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1重试)的System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1重试)中的outerConnection,DbConnectionFactory connectionFactory,TaskCompletionSource1 retry,DbConnectionOptions userOptions . 在Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()的Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci,IServerType服务器)上打开()

关于什么导致这个问题的任何想法?