Skip to content
09/09/2008 / dimarzionist

SQL Server remote access in “secure environment”

This is part of my latest experience on working at the client side with some sensible network security restrictions (most port are closed even in local area network, default proxy is set up for all machines etc.)

There is one problem here when you trying to connect SQL Server 2005 from another machine in network and in doesn’t connect without any good error raised. The problem is Windows Firewall restricts access to the SQL Server by default. As soon as you can’t switch firewall off you need to add exception for SQL Server process to allow remote connections to your SQL Server instance:

So your Firewall Exceptions list should contain sqlserver record after all:

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: