Named Pipes error from PowerShell

• mysorian

  Ten Centuries

  Points: 1048

  More actions

  June 15, 2015 at 9:20 pm

  #398598

  1) I can connect to SQL Server 2012 named instance from SSMS.

  I can launch Power shell in any of the supported data contexts, for example from the named instance.

  However when I try to run a query in Power Shell, I get the named pipes error.

  2)I can also provide a connection string and connect to the SQL Server Instance form Windows PowerShell after launching SQLPS, the same as in the above. I can open the connection and verify its state, but trying to run a query results in the same error.

  I also see that named pipes is enabled in the SQL Server Configuration Manager.

  Some of this is the result of some ambiguity in the Windows User Account in Windows 8 computer. Some of this is documented in more detail here:

  http://hodentekmsss.blogspot.com/2015/06/powershell-cannot-connect-to-sql-server.html

  http://hodentekmsss.blogspot.com/2015/06/powershell-connection-string-to.html

  This link is not directly related to the above problem, but arises out of the ambiguity in the Username retrieval:

  http://hodentekmsss.blogspot.com/2015/05/errors-installing-sql-server-2016-ctp2.html

  I appreciate for any kind of suggestion. Thanks