Connection to remote SQL Server Database
Posted: Mon 04 May 2020 23:32
I have a Windows desktop database application based on connection to local MS SQL Database (TUniConnection) and many forms using UniQuery.
I want to connect to remote SQL Server Database using UniDAC. The connection is encrypted, remote server has basic DDOS protection. And I have got some questions. Is it safe and recommended way to use UniDAC this way?
I thought about creating some kind of server application to connect it instead of direct connection to database service. But I could not find something like TUniServerConnection, which could replace direct connect to database. Is it possible to build a remote service, which can be connected like a remote database with remote driver?
In fact I do not know, if connection to middle tier service would be much more safe than connection to SQL database.
Could you recommend some solution? How to organize it?
I was thinking about SecureBridge, but it looks it has no sense for MS SQL Server: if I understand it well, all protection of Secure Bridge is already included in MS SQL Server.
What are your experience, recommendations, solutions?
I want to connect to remote SQL Server Database using UniDAC. The connection is encrypted, remote server has basic DDOS protection. And I have got some questions. Is it safe and recommended way to use UniDAC this way?
I thought about creating some kind of server application to connect it instead of direct connection to database service. But I could not find something like TUniServerConnection, which could replace direct connect to database. Is it possible to build a remote service, which can be connected like a remote database with remote driver?
In fact I do not know, if connection to middle tier service would be much more safe than connection to SQL database.
Could you recommend some solution? How to organize it?
I was thinking about SecureBridge, but it looks it has no sense for MS SQL Server: if I understand it well, all protection of Secure Bridge is already included in MS SQL Server.
What are your experience, recommendations, solutions?