#sql server instance

[datanumen]

In this article, we will learn how to get the list of all mirrored databases from our SQL Server environment.

[indiandotnet]

How to hide my SQL Server instance in network ? TIP #99

How to hide my SQL Server instance in network ? TIP #99

  In TIP #70  we saw how to find all the running SQL SERVER instance in a network or a machine.

to revise see below image.

This tip is just opposite to tip #70 you don’t want that your co-worker see your SQL Server instance running on your machine machine. (There are several reason behind this   and security is one of the most valuable aspects)

To achieve this you just need to do a very simple…

View On WordPress

[varindersandhu-blog]

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