IDI-Systems / SSProCloud-Docker

Docker setup for Sparx Systems Pro Cloud Server for Enterprise Architect.
7 stars 7 forks source link

MS SQL Server not possible? #4

Closed paphko closed 1 year ago

paphko commented 1 year ago

Thank you for sharing your setup! On Windows, I failed to mount the installer file into the container, but after I copied it manually, I could finally install the server via an RDP connection. However, the MS SQL server is not available when adding a new database: image

Is this the same for you? I use the 32bit Pro Cloud Server v5.0.105. I also ran winetricks mdac28.

Do you have any idea why I cannot configure a MS SQL server?

jonpas commented 1 year ago

Can confirm, Microsoft SQL Server is not available. It might be a case of missing driver (although Native DBMS should not need any external driver) or some incompatibility. I am not sure how it works in a regular installation to compare, or what the requirements are.

paphko commented 1 year ago

Thanks for checking this. I already asked Sparx support, waiting for response now...

paphko commented 1 year ago

I got a very disappointing answer:

Thanks for contacting Sparx support.

Please be informed that currently it is not possible to define a Native SQL Server connection while running in Wine. It was found that Wine did not include a number of necessary drivers that come natively in Windows and therefore to avoid issues we disabled the SQL Server option when running under Wine.

If you have any further questions please let us know.

I guess we can close the issue 😞

jonpas commented 1 year ago

That's too bad, but understandable with it being software specifically designed to work in the native Windows ecosystem.