Pipe name of Windows Internal Database

Hi.

I need to move WSUS database from WID to a SqlServer. The 1st problem is I cannot get access to this WID instance.

When I try to connect WID within this server, my SqlServer management studio returns:

TITLE: Connect to Server
------------------------------

Cannot connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------

The system cannot find the file specified

------------------------------
BUTTONS:

OK
------------------------------

I've tried management studios from sqlserver 2012 and sqlserver 2005.

Any idea? Thanks.

December 11th, 2012 12:07pm

MSSQL$MICROSOFT##SSEE\sql\query is not listed by pipelist but server is running well.

Maybe name is changed.

Free Windows Admin Tool Kit Click here and download it now
December 11th, 2012 12:32pm

OK.

The right pipe name is \\.\pipe\MICROSOFT##WID\tsql\query

and must use local Administrator to login.

December 11th, 2012 12:37pm

thank you ; i only signed in to upvote you! the wrong string is prolific - the correct string is hard to find.
Free Windows Admin Tool Kit Click here and download it now
February 13th, 2015 10:41pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics