Hi All,
I am facing issue with access database to connect to SQL server in different domain. I am using
connetionString = "Provider=sqloledb;Network Library=DBMSSOCN;Data Source=xxx.xx.xx.xxx;Initial Catalog=people;User ID=user;Password=pass;Encrypt=True;"
Error : [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Also, we have recently implemented ssl on the sql server. And installed the cert in my local machine. But all the time getting error to connect from access to sql.
I have also tried new data source widget in access but same error.
Any suggestions?