NAV instance won't run because WORKGROUP\DESKTOP-G7FKVG7 is not a valid login

(0) Share

Report

Posted on by Kuhicop

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

All responses (8)

Answers (1)

Kuhicop on at

Like (1)

Report

RE: NAV instance won't run because WORKGROUP\DESKTOP-G7FKVG7 is not a valid login

thank you it worked after delete the users and setup the instance as your example
Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

RE: NAV instance won't run because WORKGROUP\DESKTOP-G7FKVG7 is not a valid login

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
Kuhicop on at

Like (0)

Report

RE: NAV instance won't run because WORKGROUP\DESKTOP-G7FKVG7 is not a valid login

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
Verified answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (1)

Report

RE: NAV instance won't run because WORKGROUP\DESKTOP-G7FKVG7 is not a valid login

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
Kuhicop on at

Like (0)

Report

RE: NAV instance won't run because WORKGROUP\DESKTOP-G7FKVG7 is not a valid login

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...
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: NAV instance won't run because WORKGROUP\DESKTOP-G7FKVG7 is not a valid login

Please put your credentials here and then restart the instance.
Kuhicop on at

Like (0)

Report

RE: NAV instance won't run because WORKGROUP\DESKTOP-G7FKVG7 is not a valid login

"start with correct login id" how can I check that?

I've edited the post updating with the instance database settings
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: NAV instance won't run because WORKGROUP\DESKTOP-G7FKVG7 is not a valid login

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.