Why We Built SQL Instance Info Finder
There are times where you want to quickly retrieve information about a SQL Server instance without having to connect with SQL Server Management Studio (SSMS) and retrieve this information with T-SQL queries. We created SQL Instance Info Finder for this exact purpose. You can retrieve useful information such as SQL Server version, build, edition, service pack and much more, and you can export this information to a text file or directly print it.
SQL Instance Info Finder enables the user to easily retrieve information about SQL Server instances. By just selecting the information to be retrieved, the program connects to the SQL Server instance with minimum priviledges and retrieves the requested information.
Figure 1: Main Screen of SQL Instance Info Finder.
Connecting to a SQL Server Instance
You can connect to a SQL Server instance with either Windows Authentication or SQL Server Authentication. The login to be used needs only two permissions for running the program with all the information retrieval options selected:
- Connect to Database Engine
- VIEW SERVER STATE
The program checks for the necessary permissions (based on the selected information retrieval options) during runtime and reports to you a possible lack of permissions and how to grant them.
Selecting the information to be retrieved
Currently there are 15 information retrieval options available. These are:
- Instance Name
- Server Name
- SQL Server Version
- SQL Server Build
- Product Level (i.e. Service Pack)
- Authentication Mode
- NETBIOS Name
- Domain Name
- Full-Text Status
- Clustered Status
- Default Collation
- SQL Instance Process ID
- SQL Instance Port
- List of All Databases
Modifying an Existing Snippet
You can modify snippets by navigating to File --> Open Snippet. When you open a snippet, its data is automatically retrieved and imported into the relevant fields. Then you can modify the snippet and re-generate it.
Currently there are 3 available output options for the retrieved information:
- Export to Text File
- Copy to Clipboard
Figure 3: Retrieving the Requested Information.