Connecting SQL Express Manager to User Instances 

Use Master
GO
Select owning_principal_name, instance_pipe_name
FROM sys.dm_os_child_instances
GO

HOSTNAMEUserName	\.pipe4104C6A7-5175-45tsqlquery

Connect to
np:\.pipe4104C6A7-5175-45tsqlquery

About this entry

You’re currently reading “ Connecting SQL Express Manager to User Instances ,” an entry on Chui's Counterpoint

Published:
4.10.06 / 12pm
Category:
SQL Server