You’re offline. This is a read only version of the page.
700
Dear All,
I am getting the below error while running the GP Utilities for TWO company creation.
GP Version is GP 2018, SQL Server Version is SQL Server 2016 SP2 Standard Edition
"Install of database TWO failed! Microsoft Dynamics GP Utilities will now shut down".
Please help, what could be wrong here.
When you connect to the SQL Server via SQL Studio Manager - what login do you use? if SA, then under Security, what other logins do you see?
If this is a fresh installation, and you are at the point on creating the TWO database for the first time, the DYNSA and SA users should be all that you have. If you have restored an other DYNAMICS database onto the installation and then tried to create the TWO database then the user DYNSA may already exist.
In this case, can you or have you created your operational company database yet?
If not, I would start from blank. Delete the databases, uninstall SQL and make sure all the files and folders are removed. Then start fresh and go simple - get through the install and create of the TWO database without stopping.
Keep posting and we will keep on replying.
It might look like you already had a previous SQL users account called DYNSA on that instance.. I'd simply start from scratch by deleting that DYNSA user from the SQL security and make sure no other GP related Databases are present on that SQL instance.
Run GP utilities again and try installing a new GP instance and a new demo 'Fabrikam' company (TWO).
That should work.
Hello Suresh,
That is an odd error to get out of nowhere.
What account are you running GP Utilities as?
Are you using DYNSA for this?
Hai All,
Thanks for your replies, I tried all the above mentioned, nothing resolved the issue. This is a fresh installation of GP 2018 18.2.1013 on SQL Server 2016 Standard Edition 64 bit. While utility runs for creating TWO database (sample company), this issues pops up. But no idea why this is happening. In the SQL Profiler it says "Login failed for user 'DYNSA'. Reason: Password did not match that for the login provided" repeatedly , but not showing as error, just Profiler entries.
Question - is this a new install of GP 2018 on this SQL Server? or are you doing an update from a prior version?
From this error message I would be guessing that the TWO database already exists or did exist in this installation of DYNAMICS - so somewhere in the Dynamics database there is a reference to the TWO database. Once encountered, it is tough to get rid of, however, Richard has provided a great way to deal with it.
Good luck, and post back to the community on what caused and what solution solved your problem.
Richard's idea is great in that starting over isn't a bad idea.
Outside of this, you can run a SQL Trace or a DEXSQL.log to see what error is occurring on the backend.
You can delete the TWO database using SSMS and then run the ClearCompany script. Once you have done this try to create the TWO company again.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (