You can use the aliases in the SQL Configuration Manager to setup user-friendly SQL Server names
Provider: Sql server native client 10 or 11
Product Name: SQLSERVER
Data source: www.publicaddress.com\SQLSERVERNAME,port
example: test.mydomain.com\TEST,1433
Port 1433 has to be open through the public address, and forwarded to the sql server
Security: tick be made using this security context, enter remote sa password
No comments:
Post a Comment