I have a customer who is planning on utilizing a MSSQL 2019 server to host a database for 2 Production servers. I’m testing a few items related to this in my virtual environment. First I installed SQL Express 2019 on a separate system, but after v2021.1.2 failed to connect, I loaded SQL Express on the PPC system just to test the installation process with. I’m able to connect using a 64 bit ODBC System DSN, but the Server configuration still fails.
Same if I rerun the installer to modify and remove MySQL.
Is v2021.1.2 compatible with MSSQL 2019?
Is v2021.1.2 compatible with MSSQL Express 2019?
Hi @UomoDelGhiaccio,
Never tried installing Microsoft SQL Server db, we just leave it to the default MySql db setup.
Not sure if this can help or point you to the right path? The section for “Installing Connect using an existing Microsoft SQL Server instance” Database Considerations
I’ve got this working before by adding the parameter integratedSecurity and set it’s value to True but that’s only relevant when using a Windows user to access the database.
Alternatively, I have found that you need to enabled TCP/IP in the SQL Server Configuration and then use the dynamic port to connect.
I was able to get it to connect eventually.
Add parameter integratedSecurity with value of true
Set the port to the to the Dynamic Port from SQL Server Configuration Manager
Change from localhost to the name of the computer
Add the computers ip address and name to the host file (C:\Windows\System32\drivers\etc\hosts)
It appears to have created the database and I need to verify that it functions as expected first, but it at least connected.
The next test will be to try and connect to a SQL Server that is hosted on a different computer.
I’m running PPC v.2020.2.1 and SQL Server 18. Where would i enter the Integrated Security parameter. there are no additional parameters in the setup. btw, we are using Windows Authentication in SQL
When you are going through the setup, checking the box Windows authentication should do the trick.
that is if you are using MS SQL as your data source for your Datamapper…
If you are refferring as using it as your db for the Connect Server, it is another thing completely and will leave it to more knowledgeable people than me.
it is as a connect server.
Have to add a parameter and type it in.
so, i found where to add it. you cannot add a parameter in the installer, only in the Connect Server Configuration. I will try it.
still unable to establish a database connection
Got it. IntegratedSecurity is one word
thanks very much
