Messages

1

General Board / Re: [SOLVED] Unable to connect via OLEDB to SQLServer from EA

« on: August 19, 2022, 05:12:42 am »

Thanks for the comment. The driver has already been installed. After I did that i stopped getting the SSL error. But I am getting the 'invalid data source instead'. As said, everything does work when i connect to the same repository using the same EA version from a PC.

2

General Board / Re: [SOLVED] Unable to connect via OLEDB to SQLServer from EA

« on: August 17, 2022, 11:03:30 pm »

I have similar problem and even with the driver update the connection doesn’t work. However, there is a different error I get now “Invalid Data Source… Check configuration”. Repository DB looks fine though as I can connect to it from my PC. More details:
•   EA 12.1 installed on Windows Server 2012 VM
•   Repository DB has been migrated from SQL 2012 to SQL 2019
•   There are no network restrictions between the server and the DB.
•   The DB seemed to be migrated correctly. I can connect to it from my PC (using same version of EA). The repository looks just fine.
•   Initially I got SSL Security Error when connecting from Windows Server 2012 so I reinstalled DB drivers to the one referred in this topic.
•   When using a connection wizard everything goes fine now. I enter DB , user and pass. Connection test is successful. But, when I finish the config I get “Invalid Data Source… Check configuration” and the connection is neither established nor added to the project list. Often EA crashes in the end.
•   As said , the DB with my repository can be accessed and managed from EA installed on my PC. It’s the connection from the server which doesn’t work.

Do you have any suggestions?