InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 21:15:43 GMT20http://www.sqlservercentral.com/Forums/Topic767220-146-1.aspxDid you verify that the Named Pipes provider is enabled using the SQL Server Surface Area Configuration manager?Fri, 07 Aug 2009 13:29:46 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic767220-146-1.aspxHi All,i am run the sqlcmd the following erros is came how to slove...........like.......SET @SQLCmd ='sqlcmd -d SMS -q "set nocount on;Select * From TEMP_AH_PRE_REQUEST_DETAILS where nrequestid='+CAST(@nRequestid AS VARCHAR(100)) +'" -o"' + @FilePath + '" -W -s "' + '#' + '" -h -1'EXEC master..xp_cmdshell @SQLCmdhere i am export the data in text file but the text file comes these errorHResult 0x2, Level 16, State 1Named Pipes Provider: Could not open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.Fri, 07 Aug 2009 12:46:13 GMTpolo.csit