sniedzējs: koplietotās atmiņas nodrošinātājs, kļūda: 40 nevar atvērt savienojumu ar SQL Server

Provider Shared Memory Provider

1. Kļūdas apraksts

=================================== Unable to connect to SKY-20160824VTF SQLEXPRESS. =================================== A network-related or instance-specific error occurred while establishing a connection with SQL Server. The server was not found or could not be accessed. Please verify that the instance name is correct and SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40-Unable to open connection to SQL Server) (.Net SqlClient Data Provider) ------------------------------ For help information, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476 ------------------------------ Error number: 2 Severity: 20 Status: 0 ------------------------------ Program location: At System.Data.SqlClient.SqlInternalConnectionTds..ctor (DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionFoolBoolean apply String access) At System.Data.SqlClient.SqlConnectionFactory.CreateConnection (DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) At System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection (DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) At System.Data.ProviderBase.DbConnectionFactory.TryGetConnection (DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal & connection) At System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal (DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) At System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection (DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) At System.Data.SqlClient.SqlConnection.TryOpenInner (TaskCompletionSource`1 retry) At System.Data.SqlClient.SqlConnection.TryOpen (TaskCompletionSource`1 retry) At System.Data.SqlClient.SqlConnection.Open () At Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection (UIConnectionInfo ci, IServerType server) At Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser () =================================== The system can not find the file specified.

2. Kļūdas cēlonis

Savienojot ar datu bāzes serveri, tika izvēlēts nepareizs servera nosaukums, kā rezultātā radās kļūda

3. Risinājums