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 Netherlands
seen from Germany
seen from Romania
seen from Russia
seen from Yemen
seen from United States
seen from France
seen from Italy
seen from Italy
seen from United States
seen from Georgia
seen from Sweden
seen from China
seen from Brazil
seen from United Kingdom
seen from United States
seen from Germany
seen from France
seen from United States
seen from France
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