Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Windows GP issues to l...
Microsoft Dynamics GP (Archived)

Windows GP issues to login into GPUtils via "sa"

(0) ShareShare
ReportReport
Posted on by Christoph Klima 290

I have a new installation of Dynamics GP 2010 on a Windows server 2012 after succesfull running the GPUtils i have the problem that i cant login into Dynamics GP. when i try to login i get the following error message: Youre attempting to log in from a data scource using a trusted connection. Update the Sql Server settings for this data source to disable trusted connections and try logging in again.

im using a blank passwort and the login is set to SQL and windows authentication, what could be the problem?

*This post is locked for comments

  • Christoph Klima Profile Picture
    Christoph Klima 290 on at
    RE: Windows GP issues to login into GPUtils via "sa"

    when trying to add new members or changing passwords of existing members "sa" that users get no acces to the system

  • Santosh Profile Picture
    Santosh 766 on at
    RE: Windows GP issues to login into GPUtils via "sa"

    Give some password to "sa" even though you have mixed mode authentication.

  • Christoph Klima Profile Picture
    Christoph Klima 290 on at
    RE: Windows GP issues to login into GPUtils via "sa"

    it is a test environment, so removing it would be no problem to do it again. wich step are u refering to when u say its incorrect? how should the SQL Server setup look like?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Windows GP issues to login into GPUtils via "sa"

    If it's a test environment, remove everything and do it again.  Your first step is already incorrect, the SQL Server setup; therefore, what goes after will be worse.  If this is a learning process, best suggestion is to pickup a copy of Victoria Yudin book.

  • Verified answer
    Christoph Klima Profile Picture
    Christoph Klima 290 on at
    RE: Windows GP issues to login into GPUtils via "sa"

    So i fixes the problem by changing the ODBC settings to sql authentification and now i have several other problems.

    I seem to be in a endless loop now, when i try to loggin into Dynamics GP, it asks me to run GPUtils first, i am using the DYNSA account and start the utils. the GPUtils now wants to update some forms and dictionaries, but when i follow the instructions, it just says there is nothing to update and it allows me to start Dynamics GP again. When i try to start the GP it asks me to run Utils again. i tried to create 2 new users 1 with sql authentification and 1 with windows authentification i cant log into the system with any of them, the only account that can loggin into the system is the DYNSA account i used to be able to loggin with the sa account with blank passwort wich doesnt work anymore either.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans