Access SQL Server Instance from the network

Whenever we create any SQL instance and after that if we want to access from our network.
We need to setup some setting on Client Machine also! This is  only point that people missed

Now we need to install the Client Network Utility on Client Machine and following setting needs to be done.

·         Open Client Network Utility

·         Go to “Alias” Tab

·         Click on “Add…” Button

·         Just type the Server alias (see eg. ABC-1\111) “ABC-1” is server name and “111” instance name

·         Click “OK”

After applying above you can access your instance(sqlservername\instancename) from network.