fuel9 / DisplayMonkey

Display Monkey digital signage solution
Other
126 stars 50 forks source link

error connecting to database #174

Closed cjordan19671 closed 4 years ago

cjordan19671 commented 4 years ago

I have the displaymonkey_management application running but when I try the displaymonkey application it gives error using the same connection info, username and password for the database. I get the following.

"System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception (0x80004005): The system cannot find the file specified at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) 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, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) 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, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at DisplayMonkey.DataAccess.ConnectionWrap(SqlCommand cmd, Action action) at DisplayMonkey.Canvas.InitFromDisplay(Int32 displayId) at DisplayMonkey.getCanvas.Page_Load(Object sender, EventArgs e) ClientConnectionId:00000000-0000-0000-0000-000000000000 Error Number:2,State:0,Class:20"

michaelmalmgren commented 4 years ago

I guess this one is related to your other posts and can be closed?

cjordan19671 commented 4 years ago

yes please. named pipes problem

On Wed, Feb 26, 2020, 3:11 AM Michael Malmgren notifications@github.com wrote:

I guess this one is related to your other posts and can be closed?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/fuel9/DisplayMonkey/issues/174?email_source=notifications&email_token=AOS7TQKTGA5SAWYWX3IS24TREYW5JA5CNFSM4KZDNPA2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEM7NH7Y#issuecomment-591320063, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOS7TQNWXXHAHL2H7JP5H6TREYW5JANCNFSM4KZDNPAQ .