Microsoft SQL Express

To enable vScope to discover and inventory Microsoft SQL Express instances, you need to configure SQL Express to allow remote connections and dynamic port discovery. This setup requires that the SQL Server Browser Service is active, as it is not enabled by default on SQL Express.

Note

Before starting, ensure that Microsoft SQL Server is configured in your environment. Refer to the detailed setup guide available at Microsoft SQL Server.

---

Discovery of SQL Express on Dynamic Ports

Activate TCP/IP for SQL Express

To allow remote connections, TCP/IP must be activated for SQL Express. Follow Step 1 in this Microsoft guide: Discovery of SQL Express instances running on dynamic ports.

Ensure SQL Server Express Listens on the Public IP

Confirm that SQL Server Express is set to listen on the appropriate public IP address to enable vScope access.

Start the SQL Server Browser Service

Activate the SQL Server Browser Service, which is necessary for vScope to detect SQL Express instances. For instructions, refer to: How to Start and Stop the SQL Server Browser Service.

Open Required Ports in the Firewall

1. Port 1434: Ensure that port 1434 (used by the SQL Browser Service) is open in the firewall.
2. Dynamic Port for SQL Instance: Open the dynamic port used by the SQL instance. To find the port number, follow this guide: Finding the TCP Port Number SQL Instance is Listening On.

---

Configuring these settings will allow vScope to connect and inventory Microsoft SQL Express, enhancing your asset management and monitoring capabilities.