| |
|
Can we hide instance of SQL Server if yes then how?
Question Posted on 24 Oct 2021
Home >> DataBase >> sql questions >> Can we hide instance of SQL Server if yes then how? |
Can we hide instance of SQL Server if yes then how?
Yes, we can hise the instance of Sql Server instance. To hide the instance we will use below 4 steps:-
(1)In first step in Sql Server Configuration Manager we will expand SQL Server Network Configuration.
(2)In second step we will right click on protocols for "Server Instance" and then select "Properties".
(3)AFter second step we will find a "HideInstance" box in which we need to on the "Flags" tab after thet we need to select "Yes".
(4)In last step we will click on "Ok".
Kindly note when we are hiding any named instance we need to provide a port number in connection string so that even the browser is running it is possible to connect to hidden instance. | |
|
|
|
|