Share via

Microsoft Report Builder connection to SQL Server DB behind VPN

Linda Doan 6 Reputation points
2021-01-21T21:06:13.33+00:00

I have MS Report Builder installed on my Windows 10 laptop and unable to connect to the SQL Server database that is housed on a different network and only accessible through VPN.

How can I connect directly to that database to develop reports? Thank you

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,616 Reputation points
    2021-01-22T16:17:51.473+00:00

    VPN always mean Firewall, so my educated guess is: The IP port (default 1433) to communicate with SQL Server is blocked by the Firewall.

    Contact the 3rd party IT support and give them this link:

    https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15

    Was this answer helpful?

    1 person found this answer helpful.
  2. Linda Doan 6 Reputation points
    2021-01-22T15:30:25.523+00:00

    Hi Criszhan,

    Thank you for the response. In Report Builder, I'm trying to set the new connection properties to the following:

    Data Source = Microsoft SQL Server (sqlclient)
    Server name = <The name of the SQL server that is only accessible via VPN since it is on a 3rd party network infrastructure>
    Logon to the server = I use 'Use SQL Server authentication'
    Username = Administrator

    Because it is on a 3rd party's network and only accessible via VPN, when I perform a test connection, it cannot find the SQL database and in the database name, there is no database instance listed.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.