Windows Server 2012 with SQL 2012 | Performance issue when you want to to a database from a workstation

Performance issue when using Windows server 2012 and SQL 2012 express and you want to connect to a database from a workstation

Go to Start > Control Panel

Go to Windows Firewall

Click on Allow an app or feature through Windows Firewall

Allow an another app. > search for the location where you installed the MS SQL 2012 express installation. Select and click OK.

In this occasion

D:\Program Files\Microsoft SQL Server\MSSQL11.SNELSTART\MSSQL\Binn\sqlservr.exe
Allow the program for Domain, Private and Public.

If this is not enough you have to add more ports to the firewall. You can follow the following URL:
http://support.microsoft.com/kb/968872

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