Access SQL Server Instance from the network

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.

Related Article:

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

 

facebookShare on Facebook
TwitterPost on X
FollowFollow us
PinterestSave
, ,