Connecting SQL Express Manager to User Instances

Monday, 10 April 2006

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

HOSTNAME\UserName	\\.\pipe\4104C6A7-5175-45\tsql\query

Connect to
np:\\.\pipe\4104C6A7-5175-45\tsql\query

You should follow me on twitter here

The entry 'Connecting SQL Express Manager to User Instances' was posted on April 10th, 2006 at 12:29 pm and last modified on April 26th, 2006 at 3:49 pm, and is filed under SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.