Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

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

Posted on by

I'm trying to install a copy of a database backup in my local computer for testing purposes.

This is my database:

pastedimage1668517613407v1.png

This is my Instance:

pastedimage1668517662104v2.png

Developer is working fine:

pastedimage1668517724023v3.png

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

pastedimage1668523700903v1.png

  • Kuhicop Profile Picture
    Kuhicop on at
    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 Profile Picture
    YUN ZHU 69,760 Super User 2024 Season 2 on at
    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 Profile Picture
    Kuhicop on at
    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 Profile Picture
    YUN ZHU 69,760 Super User 2024 Season 2 on at
    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,

    pastedimage1668574951996v1.png

    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 Profile Picture
    Kuhicop on at
    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 Profile Picture
    Nitin Verma 21,023 Moderator on at
    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.

    pastedimage1668524508496v1.png

  • Kuhicop Profile Picture
    Kuhicop on at
    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 Profile Picture
    Nitin Verma 21,023 Moderator on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans