Aug 14, 2017
In this article, we will learn how to get the list of all mirrored databases from our SQL Server environment.
seen from Australia
seen from Canada
seen from United States
seen from China
seen from Belgium
seen from China
seen from Türkiye
seen from Spain
seen from Italy
seen from Italy
seen from Germany
seen from Italy
seen from Malaysia
seen from United States
seen from Belgium
seen from Türkiye
seen from United States
seen from Türkiye
seen from China
seen from Malaysia
In this article, we will learn how to get the list of all mirrored databases from our SQL Server environment.
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
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