Aug 14, 2017
In this article, we will learn how to get the list of all mirrored databases from our SQL Server environment.
Loading...
seen from Türkiye
seen from Canada
seen from Italy
seen from Australia
seen from China
seen from China
seen from United States
seen from China
seen from United Kingdom
seen from Philippines
seen from Germany
seen from Germany
seen from Israel
seen from China
seen from China
seen from Belgium
seen from United States
seen from United Kingdom
seen from China
seen from Germany
In this article, we will learn how to get the list of all mirrored databases from our SQL Server environment.
Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.
Free to watch • No registration required • HD streaming
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