Access SQL Server Instance from the network

Varinder Sandhu SQL, SQL-General, SQL-Tips and Tricks, Varinder Sandhu

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-1111) “ABC-1” is server name and “111” instance name
Click “OK”

After applying above you can access your instance(sqlservernameinstancename) from network.

http://www.smallbizserver.net/Articles/tabid/266/Id/171/How-to-create-a-new-SQL-instance-and-move-databases.aspx