Announcements
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
thank you it worked after delete the users and setup the instance as your example
In my environment it's a local Windows User.
And yes, you don't have to add the domain, you can use the PC name or enter .\ in the Domain.
But I still think it is a NAV user problem. If you still have a backup, you can clear all the current users in it first, and then try to open it.
Hope this helps.
Thanks.
ZHU
Hi ZHU thanks for your answer.
The user is a Windows user?
I need to install Active Directory and create a domain? Can't work without domain?
Thanks
This user is the user that needs to have permissions to run NAV and to have access to the database.
For example,
If you are copying the original database to the local, it is recommended to run the following SQL statement, so that when your user logs in, it will be automatically added as a super user. (Of course, there is a way not to delete users, which is more complicated)
http://navguides.blogspot.com/2013/07/delete-all-users-from-nav-2013-sql.html
Hope this helps.
Thanks.
ZHU
sorry but I don't know which users I can put in there, I'm trying to put my windows user but it's not working...
Please put your credentials here and then restart the instance.
"start with correct login id" how can I check that?
I've edited the post updating with the instance database settings
In your Dynamics NAV server instance please check if your correctly put the Database name and Server name, and start with correct login id and then restart the instance.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156