プロバイダー:共有メモリプロバイダー、エラー:40-SQLServerへの接続を開くことができません



Provider Shared Memory Provider



1.エラーの説明



=================================== 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.エラーの原因

データベースサーバーに接続するときに、間違ったサーバー名が選択されたため、エラーが発生しました




3.解決策