Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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: Inrema2018Tenant ID: <ii>User: Type: System.Data.SqlClient.SqlExceptionClientConnectionId: e9f6d91c-b61c-46fc-86d0-3a214422a1d6Class: 14LineNumber: 65536Number: 18456Server: DESKTOP-G7FKVG7\INREMAState: 1Source: .Net SqlClient Data ProviderErrorCode: -2146232060Message: <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
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.
"start with correct login id" how can I check that?
I've edited the post updating with the instance database settings
Please put your credentials here and then restart the instance.
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...
This user is the user that needs to have permissions to run NAV and to have access to the database.
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)
Hope this helps.
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?
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.
thank you it worked after delete the users and setup the instance as your example
Business Applications communities