Connecting to SQL Server from externally with proxy server
0
votes
1
answer
638
views
I have a server running SQL Server 2022 with a couple of instances.
There is the need to grant access to an external supplier working with us on a project.
The idea is: the supplier connects to our sql server on a specific database they need to access.
We have created a configuration on a proxy server running nginx that allows the connection to the local sql server.
However, I cannot reach the database when testing from outside.
Is there any configuration I need to do on the SQL server to allow this hebavior?
Thanks in advance!
nginx entry
-----------
server {
access_log /var/log/nginx/porgreencloud1433.log upstream_time;
error_log /var/log/nginx/porgreencloud1433_error.log;
listen 1433;
server_name porgreencloud.company.com;
location / {
proxy_connect_timeout 60s;
proxy_socket_keepalive on;
proxy_pass http://dbtcp ;
}
ssl_certificate /etc/letsencrypt/live/porgreencloud.company.com/fullchain.pem; # managed by Certbot
ssl_certificate_key /etc/letsencrypt/live/porgreencloud.company.com/privkey.pem; # managed by Certbot
include /etc/nginx/sites-available/sslsettings.conf;
}
SQL Server settings
-------------------
Connection String
-----------------
SQLUser = "ourUser"
SQLPassword = "LetsConnect2DB!!"
SQLServer = "porgreencloud.company.com,1433"
DbConn = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=" & SQLUser & ";Password=" & SQLPassword & ";Initial Catalog=" & DBName & ";" & _
"Data Source=" & SQLServer & ";Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;" & _
"Use Encryption for Data = False;Tag with column collection when possible=False"



Asked by aganju82
(1 rep)
May 24, 2024, 08:39 AM
Last activity: May 12, 2025, 07:05 AM
Last activity: May 12, 2025, 07:05 AM