首页 文章

Windows 8.1服务无法连接到SQL Server数据库

提问于
浏览
0

我有一台服务器,我连接到运行Windows 8.1 . 它正在运行SQL Server 2014 Express .

我有一个连接到数据库的C#服务 . 不幸的是,当它作为服务安装时,它不会连接抛出如下所示的错误 .

我可以运行应用程序,它可以成功运行,但是当它是一个服务时,它不起作用 .

我启用了TCP / IP . 我可以通过另一台机器上的vpn与管理工作室连接到实例 .

这是我的配置文件中的连接字符串

<value>Server=localhost\MSSQLSERVER2012;Initial CataLog=lms;Persist Security Info=No;Password=pw;User ID=user;Connect Timeout=5</value>

例外:

已捕获DomainExceptionHandler:System.Data.SqlClient.SqlException(0x80131904): Build 与SQL Server的连接时发生与网络相关或特定于实例的错误 . 服务器未找到或无法访问 . 验证实例名称是否正确,以及SQL Server是否配置为允许远程连接 . (提供程序:SQL网络接口,错误:26 - 在指定服务器/实例时指定错误)在System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning的System.Data.SqlClient.SqlInternalConnection.OnError(SqlException异常,Boolean breakConnection,Action'1 wrapCloseInAction)中(TdsParserStateObject stateObj,Boolean callerHasConnectionLock,Boolean asyncClose)System.Data上的System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo,SqlInternalConnectionTds connHandler,Boolean ignoreSniOpenTimeout,Int64 timerExpire,Boolean encrypt,Boolean trustServerCert,Boolean integratedSecurity,Boolean withFailover) . System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover中的SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo,String newPassword,SecureString newSecurePassword,Boolean ignoreSniOpenTimeout,TimeoutTimer timeout,Boolean withFailover)(ServerInfo serverInfo,String newPassword,SecureString newSecurePassword,Boolean redirectedUserInstance,Sq System.Data.SqlClient.SqlInternalConnectionTds..ctor上的System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer超时,SqlConnectionString connectionOptions,SqlCredential凭证,String newPassword,SecureString newSecurePassword,Boolean redirectedUserInstance)中的lConnectionString connectionOptions,SqlCredential凭证,TimeoutTimer超时)( System.Data.SqlClient.SqlConnectionFactory.CreateConnection中的DbConnectionPoolIdentity标识,SqlConnectionString connectionOptions,SqlCredential凭证,Object providerInfo,String newPassword,SecureString newSecurePassword,Boolean redirectedUserInstance,SqlConnectionString userConnectionOptions,SessionData reconnectSessionData)(DbConnectionOptions选项,DbConnectionPoolKey poolKey,Object poolGroupProviderInfo,DbConnectionPool池, System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool池,DbConnec)上的DbConnection owningConnection,DbConnectionOptions userOptions) System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject,DbConnectionOptions userOptions,DbConnectionInternal)上的System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject,DbConnectionOptions userOptions,DbConnectionInternal oldConnection)中的owningObject,DbConnectionOptions选项,DbConnectionPoolKey poolKey,DbConnectionOptions(userOptions) oldConnection)在System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject,UInt32 waitForMultipleObjectsTimeout,Boolean allowCreate,Boolean onlyOneCheckConnection,DbConnectionOptions userOptions,DbConnectionInternal&connection)处于System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject,TaskCompletionSource'1 retry, System.Data.ProviderBase.DbConnectionFactory.TryGetConnection上的DbConnectionOptions userOptions,DbConnectionInternal&connection)(DbConnection owningConnection,TaskCompletionSource'1 retry,DbConnectionOption System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection,DbConnectionFactory connectionFactory)上的System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection,DbConnectionFactory connectionFactory,TaskCompletionSource'1 retry,DbConnectionOptions userOptions)中的s userOptions,DbConnectionInternal oldConnection,DbConnectionInternal&connection) ,在System.Data.SqlClction.SqlClction.SqlConnection的System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource'1重试)的System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource'1 retry)处,TaskCompletionSource'1重试,DbConnectionOptions userOptions . LMS.Core.Environment.SQLDeviceStateWriterProvider.SQLDeviceStateWriter.writeState(DateTime timestamp)中的Open()

1 回答

  • 0

    对不起,这是我的错 . 连接字符串未正确调用 .

相关问题