DB can’t be accessed from other machines.

For e.g.:- <<PC-NAME>>DB can’t be accessed from other machines.

Solution

Start Menu>sql server configuration

Change db browser to automatic

Check for TCP connection

Open Properties

If value of dynamic port is zero

Delete it

Insert value of port number as 1433

Restart Service!!!

Done!!!

To create a firewall exception

http://msdn.microsoft.com/en-IN/library/ms175043.aspx