Manage sqlexpress instances

If weProgramThe instance is used in the database connection information, such as the following connection information:

<AddName= "Sitesqlserver"Connectionstring= "Data Source =. \ sqlexpress; Integrated Security = true; user instance = true; attachdbfilename = | datadirectory | database. MDF ;"Providername= "System. Data. sqlclient" /> 

At this time, the program can start an independent SQL instance to automatically load the MDF file for processing, but if you want to observe the database status during the running process, then use SSMs to connect ". \ sqlexpress "cannot see the corresponding database, then we can use the following method:

1. Use SSMs to connect to ". \ sqlexpress", open the query window, and enter"SelectOwning_principal_name, instance_pipe_name, heart_beatFromSYS. dm_ OS _child_instances ";

2. Now we can see the list:

 

Find the expected MPs queue name and connect it with the MPs queue name, which is also applicable to the monitoring tool.

 

Reference: http://blogs.msdn.com/ B /sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx