Post has been published on Varinder Sandhu 's Blog
Post has been published on http://www.varindersandhu.in/2010/09/27/access-sql-server-instance-from-the-network/
Access SQL Server Instance from the network
<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->
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.
Related Article:
http://www.smallbizserver.net/Articles/tabid/266/Id/171/How-to-create-a-new-SQL-instance-and-move-databases.aspx