DB can’t be accessed from other machines.

Posted: July 29, 2015 in System Administration
Tags: , , , , ,

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

Advertisements
Comments
  1. […] DB can’t be accessed from other machines.. […]

    Like

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