Also, it will list only the SQL Server Engine instances without showing the SQL Server Reporting Service, SQL Server Integration Service, and SQL Server Analysis Service instances that are installed in these servers. The list of the SQL Server instances that are installed in your network servers can be checked using the SQLCMD -L command, as shown below:īut this command will not list the SQL Server instances that are installed locally to the machine from where we are running this CMD command. This window provides you with the list of SQL Server Engine, SQL Server Reporting Service, SQL Server Integration Service, and SQL Server Analysis Service instances that are installed locally to your server, from the Local Servers tab, or installed in the servers connected to your local network, from the Network Servers tab, as shown below:Ĭhecking the list of instances installed in your network servers using SSMS is not efficient, as this list is not exportable and will not show the complete list of SQL Server instances most of the time, due to network-related limitations. The simplest way of getting the list of SQL Server instances that are installed locally at your server or remotely in other servers within your local network is the Connect to Server window of the SQL Server Management Studio (SSMS), where you need to choose the option in the Server name field. For example, the list can help you in making sure that all these instances are installed based on the company baselines, the number of licenses consumed until now and tracking the SQL Server and Windows updates so that you will make sure that the servers are updated properly.
The SQL Server instances list helps in managing and administrating the instances in different ways. Working as a SQL Server database administrator in an international company, you should keep track of all SQL Server instances that are installed in the company machines and servers and have an up-to-date list of these instances. In this article, we will show how to use the ApexSQL Discover tool to list all available SQL Server Engine, SQL Server Reporting Service, SQL Server Integration Service, and SQL Server Analysis Service instances that are installed in the current domain, remote domain or a specific IP addresses or TCP ports range.
0 kommentar(er)
