Browse by Tags

How to enable remote SQL Management via Microsoft Firewall
22 June 11 08:12 PM | yuval14 | with no comments

Microsoft firewall block by default access to the SQL server by using SQL Management Studio. To allow access to the SQL server by using SQL Management Studio please add the following executable files as "Program Exceptions”: "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe" "C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\Binn\sqlservr.exe" Note: The executable files location depend on the SQL server version and the installation path.  

תגים:SQL, SQL Security, ITPRO, Firewall