New database on SQL 2019.  Topic is solved

Discussions relating to plugin development, and the Jiwa API.

New database on SQL 2019.

Postby pricerc » Thu Nov 12, 2020 5:02 pm

I notice from the docs that only up to SQL 2016 is supported for creating a new or demo database?

Is there a workaround for SQL 2019?

I'm getting this:
Microsoft.SqlServer.Dac.DacServicesException: Could not import package. ---> Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: Unable to connect to master or target server 'JiwaDemo'. You must have a user with the same password in master or target server 'JiwaDemo'.
...
at JiwaFinancials.Jiwa.JiwaApplication.DatabaseManager.Main.RestoreDemoDataFromBACPAC(Object sender, ExecuteActionEventArguments e)
/Ryan

ERP Consultant,
Advanced ERP Limited, NZ
https://aerp.co.nz
User avatar
pricerc
Senpai
Senpai
 
Posts: 504
Joined: Mon Aug 10, 2009 12:22 pm
Location: Auckland, NZ
Topics Solved: 20

Re: New database on SQL 2019.  Topic is solved

Postby Mike.Sheen » Thu Nov 12, 2020 5:05 pm

Hi Ryan,

Please see DEV-8340 - it has a work-around mentioned.

Mike
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2444
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 756

Re: New database on SQL 2019.

Postby SBarnes » Sun May 02, 2021 11:36 am

Now that this is solved can this be retrofitted into 7.2.1 in a service release?
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1618
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 3 guests