web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / what password for sa i...
Microsoft Dynamics GP (Archived)

what password for sa in GP utilities?

(0) ShareShare
ReportReport
Posted on by robson 175

Hi, i just installed MS Dynamics GP and in utilities window configuration

encountered a problem, Don't know what password is default for sa?

I tried SQL server sa password but didn't work. BTW I see after installation

no new datavse was created.

thanks

*This post is locked for comments

I have the same question (0)
  • robson Profile Picture
    robson 175 on at

    I have verified DYNAMICS database was not installed although I have choose to be installed.

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Microsoft Dynamics GP Utilities will use the same 'sa' password as SQL Server. There is no other 'sa' - it's just the one. If it's not working, it could be the ODBC is not set up properly. If you can post the entire error message you're getting, that may help.

    The DYNAMICS database will not get created until you've logged into Utilities. If you're not able to log in there, as I am gathering from the issue with the password, then you cannot create the DYNAMICS database.

  • Verified answer
    Rob Klaproth Profile Picture
    Rob Klaproth 1,730 on at

    If you are entering the correct sa password for your SQL server and it's not working then there must be a problem with the connection to the database.

    First, verify that you are able to login to SQL Server with the sa account directly on the SQL Server itself, by going into SQL Management Studio and logging in.

    Once you have verified you are able to login to SQL and have the correct sa password, go back to the workstation where you have installed GP and verify that your DSN is correct.  You can enter in the sa user name and password in the DSN and click on test to verify connectivity.

    Remember, GP installs a DSN under the 32 bit ODBC drivers, so if you created a DSN in the ODBC Data Sources in control panel - administrative tools on a 64 bit machine, it will not  show the GP DSN, so you need to go to c:\windows\syswow64 and run the odbcad32.exe file to see the GP DSN.  When in the DSN admin, click on the system tab and verify you have a Dynamics GP DSN.

    Open up the Dynamics GP DSN and make sure all the ANSI options are unselected on the first screen, and on the second screen make sure perform translation for character data is unchecked.

    Once you have verified your DSN to be working, try to run GP Utilities again and login as sa.

  • Teekay Profile Picture
    Teekay 15 on at

    how can i log in there ? Note i install GP on a PC no server

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans