You install the Microsoft Application Compatibility Toolkit (ACT) on a client computer
named Computer1. Computer1 has the ACT Log Processing Service and Microsoft SQL
Server 2012 Express installed.
You install the ACT on a client computer named Computer2.
When Computer2 attempts to connect to a SQL Server database, you receive the following
error message: “The SQL Server you entered either does not exist or you do not have the
required credentials for access.”
You need to ensure that Computer2 can connect to the SQL Server database successfully.
Which should you do on Computer1?
A.
Create firewall exceptions for TCP port 443 and UDP port 389.
B.
Add Computer2 to the local Administrators group.
C.
Add Computer1 to the local Administrators group.
D.
Create firewall exceptions for Sqlservr.exe and Sqlbrowser.exe.
no!!!!!!!!! D is the right answer
JJ r u sure ‘D’ is right one… bcoz every where i found ‘A’ is right. please help !!
http://www.descosupport.com/html5/Content/How_To/How_To_-_Configure_the_Windows_Firewall_to_work_with_SQL_Server.htm
yes adeel!!!
TCP 443 is for https and UDP 389 is for LDAP communication (domain controllers) not sure they have anything to do with SQL server…answer D is the best one.
thanks for the url confirming D as the answer jj
As per microsoft tech the ports should be TCP port 1433 (SQL Server) and for UDP port 1434 (SQL Server Browser) not TCP port 443 and UDP port 389.
So the almost matched answer is D.
Please refer to
https://technet.microsoft.com/en-us/library/hh825066.aspx