I'm trying to install a copy of a database backup in my local computer for testing purposes.
This is my database:
This is my Instance:
Developer is working fine:
When I try to run a page or connect to the client I just can't connect because the instance can't run...
This is the Event viewer log when I try to run the instance:
Server instance: Inrema2018
Tenant ID:
<ii>User:
Type: System.Data.SqlClient.SqlException
ClientConnectionId: e9f6d91c-b61c-46fc-86d0-3a214422a1d6
Class: 14
LineNumber: 65536
Number: 18456
Server: DESKTOP-G7FKVG7\INREMA
State: 1
Source: .Net SqlClient Data Provider
ErrorCode: -2146232060
Message: <ii>User login error 'WORKGROUP\DESKTOP-G7FKVG7$'.</ii>
StackTrace:
en 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)
en System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
en System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
en System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
en System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
en System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
en System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
en System.Data.SqlClient.SqlConnection.Open()
en Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.TryConnect()
en Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.<>c__DisplayClass111_0.<ExecuteAction>b__0()
HResult: -2146232060
</ii>
I've been 2 days already trying to setup this but I can't figure out what I'm missing...
EDIT: sharing my instance database settings