guidetechsite

[guidetechsite]

Configuring LDAP with Jenkins and managing access through LDAP users/groups

In order to configure LDAP with Jenkins, you just need to install LDAP plugin and identify correct LDAP/Active Directory configuration which you can use within your org. and enable it. Below is my settings, which I have tested working -

Once these are enabled, you can start adding LDAP users/groups in roles based strategy and assign access. Manger DN, I am using here which will connect to above Server and will search User base. This is very much required in case anonymous search is not enabled in AD.

[guidetechsite]

How to automate Installshield installer creation with CI tools like Jenkins

In order to have automate installer creation using install shield, there is command/tool available with their license named as iscmbld.exe .You need to locate or find out the this tool under path where you have installer installshield. This tool will be under /System folder of installshield's installed location. Once you have created installer using installshield and able to build through GUI then you can build the same in jenkins like below using windows batch command- rd /Q /S "Your Project/staging" mkdir "Your Project/staging" xcopy "Path to your project components\*" "Your Project\staging" /e /f /i "E:\Program Files\Installshield2013\System\IsCmdBld.exe" -p "%WORKSPACE%\Your Project\Your Project.ism" -y %BUILDNO% where, you can provide BUILDNO pre your project needs. Basically, what does above program do is remove older staging folder, create empty staging folder, copy contents there and then build installer from there. You need to link your components to your staging folder in install shield project file.

[guidetechsite]

Shared Label Plugin for CCNET

Recently, i have to develop plugin to share the build label across CCNET projects depending upon previously success or failure build. So, I came up with below solution in C#- using System; using System.Collections.Generic; using System.Linq; using System.Text; using ThoughtWorks.CruiseControl.Core; using ThoughtWorks.CruiseControl.Remote; using System.IO; using Exortech.NetReflector; namespace ThoughtWorks.CruiseControl.Core.labeller {     // this is the labeller name that will be used in  ccnet.config     [ReflectorType("sharedLabeller")]     public class SharedLabeller : ILabeller     {         [ReflectorProperty("sharedLabelFilePath", Required = true)]         public string sharedLabelFilePath { get; set; }         [ReflectorProperty("buildSuccessFile", Required = true)]         public string buildSuccessFile { get; set; }         [ReflectorProperty("alwaysincrement", Required = true)]         public string alwaysincrement { get; set; }         #region ILabeller Members         public string Generate(IIntegrationResult previousResult)         {             if (ShouldIncrementLabel(previousResult))                 return IncrementLabel();             if (previousResult.Status == IntegrationStatus.Unknown)                 return "0";             return previousResult.Label;         }         public void Run(IIntegrationResult result)         {             result.Label = Generate(result);         }         #endregion         private string IncrementLabel()         {             if (!File.Exists(sharedLabelFilePath))                 return "0";             using (FileStream fileStream = File.Open(sharedLabelFilePath,                  FileMode.OpenOrCreate,                  FileAccess.ReadWrite,                  FileShare.None))             {                 // read last build number from file                 var bytes = new byte[fileStream.Length];                 fileStream.Read(bytes, 0, bytes.Length);                 string rawBuildNumber = Encoding.ASCII.GetString(bytes);                 // parse last build number                 int previousBuildNumber = int.Parse(rawBuildNumber);                 int newBuildNumber=0;                 if (File.Exists(buildSuccessFile) && alwaysincrement=="yes")                     newBuildNumber = previousBuildNumber + 1;                 else                     newBuildNumber=previousBuildNumber;                 // increment build number and write back to file                 bytes = Encoding.ASCII.GetBytes(newBuildNumber.ToString());                 fileStream.Seek(0, SeekOrigin.Begin);                 fileStream.Write(bytes, 0, bytes.Length);                 return newBuildNumber.ToString();             }         }  private static bool ShouldIncrementLabel(IIntegrationResult previousResult)  {      return (previousResult.Status == IntegrationStatus.Success || previousResult.Status == IntegrationStatus.Unknown);  }     } }

[guidetechsite]

Sample CCNET nightly scheduled build

Hi Recently I have developed nightly scheduled build for cruise control .net dashboard. Below is sample project where version polling will happen at 4 pm and if changes are there other then builduser account then build will be triggered. I have also created recently plugin to accommodate whether and ion what case build label should increase.                                    Monday          Tuesday          Wednesday          Thursday          Friday          Saturday Sunday                       Nightly Scheduled Build             E:\Program Files\CruiseControl.NET\server\buildnumber.txt E:\Program Files\CruiseControl.NET\server\buildSuccessFile.txt yes           http://tfs01:8080/tfs/projectoffice       $/Project/Main       E:\Project\Main       true       mymachineworkingcopy false C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\TF.exe       builduser       password                       builduser             Modifications.$(buildlabel).xml C:\Data False               C:\Program Files\NANT\bin\nant.exe         E:\saratoga\ga\Main\BuildScripts_CCNET         -D:outputType=Xml -D:BuildType="Full" -D:branchname="Main"         false         BuildMain.build                   $(TargetName)                 200000         false Modifications.$(buildlabel).xml   C:\Data                                                                          Always                                                          xsl\header.xsl    xsl\compile.xsl      C:\Data\KeyFile.txt    C:\Data\Modifications.$(buildlabel).txt                

[guidetechsite]

How to share CCNET label across multiple projects and get incremented for each success build

There is already one post below where I have implemented this but it also increment for failure build also-

How to share CCNET label across multiple projects and get incremented for each build

Now here's how you can stop it to increment during failure builds-

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using Exortech.NetReflector;

using ThoughtWorks.CruiseControl.Core;

using ThoughtWorks.CruiseControl.Remote;

namespace ccnet.SharedLabeller.CruiseControl.plugin

{

    [ReflectorType("sharedLabeller")]

    public class SharedLabeller : ILabeller

    {

        ///

        /// The path where the file that holds the shared label should be located

        ///

        /// none

        [ReflectorProperty("sharedLabelFilePath", Required = true)]

        public string SharedLabelFilePath { get; set; }

        ///

        /// Any string to be put in front of all labels.

        ///

        [ReflectorProperty("prefix", Required = false)]

        public string Prefix { get; set; }

        ///

        /// If true, the label will be incremented even if the build fails. Otherwise it will only be incremented if the build succeeds. 

        ///

        [ReflectorProperty("incrementOnFailure", Required = false)]

        public bool IncrementOnFailure { get; set; }

        ///

        /// Allows you to set the initial build number.

        /// This will only be used when on the first build of a project, meaning that when you change this value,

        /// you'll have to stop the CCNet service and delete the state file.

        ///

        /// 0

        [ReflectorProperty("initialBuildLabel", Required = false)]

        public int InitialBuildLabel { get; set; }

        public SharedLabeller()

        {

            IncrementOnFailure = false;

            InitialBuildLabel = 0;

        }

        #region ILabeller Members

        public string Generate(IIntegrationResult integrationResult)

        {

            if (ShouldIncrementLabel(integrationResult.LastIntegration))

            {

                return Prefix + IncrementLabel();

            }

            else

            {

                return integrationResult.LastIntegration.Label;

            }

        }

        public void Run(IIntegrationResult integrationResult)

        {

            integrationResult.Label = Generate(integrationResult);

        }

        #endregion

        private string IncrementLabel()

        {

            ThoughtWorks.CruiseControl.Core.Util.Log.Debug("About to read label file. Filename: {0}", SharedLabelFilePath);

            using (FileStream fileStream = File.Open(this.SharedLabelFilePath,

                     FileMode.OpenOrCreate,

                     FileAccess.ReadWrite,

                     FileShare.None))

            {

                // read last build number from file

                var bytes = new byte[fileStream.Length];

                fileStream.Read(bytes, 0, bytes.Length);

                string rawBuildNumber = Encoding.UTF8.GetString(bytes);

                // parse last build number

                int previousBuildNumber;

                if (!int.TryParse(rawBuildNumber, out previousBuildNumber))

                {

                    previousBuildNumber = InitialBuildLabel - 1;

                }

                int newBuildNumber = previousBuildNumber + 1;

                // increment build number and write back to file

                bytes = Encoding.UTF8.GetBytes(newBuildNumber.ToString());

                fileStream.Seek(0, SeekOrigin.Begin);

                fileStream.Write(bytes, 0, bytes.Length);

                return newBuildNumber.ToString();

            }

        }

        private bool ShouldIncrementLabel(IntegrationSummary integrationSummary)

        {

            return integrationSummary == null || integrationSummary.Status == IntegrationStatus.Success || IncrementOnFailure;

        }

    }

}

This is how you can implement in ccnet.config under project-

         <sharedLabelFilePath>E:\Program Files\CruiseControl.NET\server\buildnumber.txtsharedLabelFilePath>

[guidetechsite]

How to share CCNET label across multiple projects and get incremented for each build

There is stateFileLabeler which you can use in ccnet.config to share same build label across multiple projects in CCNET like below-

"stateFileLabeller"> Project Name to pull Build Label From

But, build label will remain same, which is disadvantage,if you need incremental build label across multiple projects. You can create your own custom plugin for CCNET to do that. I have implemented like below- 1) Create C# Class Library Project and name it as sharedLabeller. Put below code in .cs file using System; using System.Collections.Generic; using System.Linq; using System.Text; using ThoughtWorks.CruiseControl.Core; using ThoughtWorks.CruiseControl.Remote; using System.IO; using Exortech.NetReflector; namespace ThoughtWorks.CruiseControl.Core.labeller {     // this is the labeller name that will be used in  ccnet.config     [ReflectorType("sharedLabeller")]     public class SharedLabeller : ILabeller     {         [ReflectorProperty("syncronisationFilePath", Required = true)]         public string SyncronisationFilePath { get; set; }         #region ILabeller Members         public string Generate(IIntegrationResult previousResult)         {             if (ShouldIncrementLabel(previousResult))                 return IncrementLabel();             if (previousResult.Status == IntegrationStatus.Unknown)                 return "0";             return previousResult.Label;         }         public void Run(IIntegrationResult result)         {             result.Label = Generate(result);         }         #endregion         private string IncrementLabel()         {             if (!File.Exists(SyncronisationFilePath))                 return "0";             using (FileStream fileStream = File.Open(SyncronisationFilePath,                  FileMode.OpenOrCreate,                  FileAccess.ReadWrite,                  FileShare.None))             {                 // read last build number from file                 var bytes = new byte[fileStream.Length];                 fileStream.Read(bytes, 0, bytes.Length);                 string rawBuildNumber = Encoding.ASCII.GetString(bytes);                 // parse last build number                 int previousBuildNumber = int.Parse(rawBuildNumber);                 int newBuildNumber = previousBuildNumber + 1;                 // increment build number and write back to file                 bytes = Encoding.ASCII.GetBytes(newBuildNumber.ToString());                 fileStream.Seek(0, SeekOrigin.Begin);                 fileStream.Write(bytes, 0, bytes.Length);                 return newBuildNumber.ToString();             }         }  private static bool ShouldIncrementLabel(IIntegrationResult previousResult)  {      return (previousResult.Status == IntegrationStatus.Success || previousResult.Status == IntegrationStatus.Unknown);  }     } }

2) Change properties of the project to output dll and name it like- ccnet.sharedLabeller.plugin 

3) Build solution and copy in \server folder

4) Edit ccnet.config and ccnet.exe.config for Plugin location value and give path to the folder where you placed Plugin.

5) Create some file like buildnumber.txt in \server folder and edit ccnet.config for your project where to want to share your label incrementally-

        E:\Program Files\CruiseControl.NET\server\buildnumber.txt

    Whenever build is triggered, it will increment label in buildnumber.txt and use in the project where it is being called.

Well, one drawback in above plugin is that it will increment label even for failure builds also.

[guidetechsite]

Unlocking or Undoing TFS files when someone left team

Well, you just found that someone is not there in your team or probably has left organisation keeping few files checked out and locked. And you want to work on those files, what shall you do? You can contact your TFS admin team. They can help by achieving this command to unlock those files- C:\Program Files\Microsoft Visual Studio 10.0\VC>tf undo "$/Path to file in TFS" /workspace:WORKSPACENAME;OWNER /recursive Note: workspace name and owner details can be find out in TFS properties of file.

[guidetechsite]

Writing your first WiX Project

As, you may be aware that Visual Studio Installer for MSI/EXE has been discontinued from TFS 2012 and there are two ways you can create setup now, one is using Install Shield and another is WiX which is itself developed as open source by Microsoft. Lets have look at WiX project by creating our First project. 1) Download WiX toolset and install it. 2) Add path of WiX installer bin to PATH  environment variable. As, we might need to do lot of command line things. 3) Create New Setup WiX Project from Visual Studio 2012. WiX is also compatible with 2010. However, first thing you will notice is that it is all XML format and not so user friendly and hence it needs to lots of learning to master it. 4) Rename Product.wxs as per your suitable name for creating MSI. Can also change Product ID name an feature ID name suitable to you. 5) Add below under Component Group -         or alternatively use below to add like below-

6) Run "candle.exe yourproject.wxs". It will generate wixobj file with same name 7) Run "light.exe yourproject.wixobj". It will generate desired MSI. Run MSI to install files in Program Files folder.

[guidetechsite]

Useful TFS commands

Below are TFS commands which may be required on day to day basis. Location of TF.exe is C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE- 1) Finding Difference between local folders to TFS source folder- C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE>tf folderdiff "$/pathtotfs"  D:\pathtolocalfolder [/recursive] [/noprompt] 2) Getting Code to local folder from TFS- C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE>tf get  D:\pathtolocalfolder [/force] [/all] [/overwrite] [/recursive] /force is combination of /overwrite and /all. You can also them exclusively if you dont want to get all code again. 3) Deleting a Workspace from TFS server- C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE> tf workspace /delete [/server:tfsservername] workspacename[;owner] [/login:username,[password]]

If you are not sure about workspaces details and workspace details you can easily get those by typing : "tf workspaces [/owner:ownername] [/computer:computername] [/server:servername] [workspacename] [/login:username,[password]]" Anything in [] are optional fields to give. Anyways, you can always refer TFS help by typing > tf /? or you can refer MSDN site itself

[guidetechsite]

How to check if DLL or Assembly is Strong Typed Assembly or Not

Using sn.exe from command prompt, you can verify is DLL is Strong Typed Assembly or not. Example below- C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin>sn.exe -vf C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Data.dll For more information on this command, check help by typing- > "sn.exe /?". In above command, it is mentioned to use -vf for verifying / checking strong name assembly forcefully even if disabled in the registry.Also, you can put below in a script-@ echo off if "%1"=="" goto END sn -q -vf %1 > NUL if ERRORLEVEL 1 goto NOT_STRONG :STRONG echo Strongly named assembly: %1 goto END :NOT_STRONG echo Not a strongly named assembly: %1 goto END :END

[guidetechsite]

Setting up Cruise Control . NET with TFS for ASP .NET Web Application

I have setup Cruise Control .NET from scratch very recently in integration with TFS 2010 for ASP .NET MVC3 application. I am writing down steps which I followed to set it up here – 1) Download Cruise Control .NET from this location and unzip it to use it. 2) Install .NET framework, IIS and NANT as well. 3) Add "WebDashboard" as an IIS application. 4) Update Dashboard.config file with admin password for CC dashboard. 5) You can browse URL in IIS to check if dasboard is working fine. You can reach admin dashboard to install any required packages. For me loading http://localhost/ccnet/ViewFarmReport.aspx errored out for TCP connecton not made. It was happening because ccnet service was not running from "Server". To make it run as background I used below VB script- Set WshShell = CreateObject("WScript.Shell")WshShell.Run chr(34) & "C:\pathtoinstallfolder\Server\ccnet.exe" & Chr(34), 0Set WshShell = Nothing (Run it with .vbs extension. Put above code and double click to execute it) 6) Create project in TFS 2010 and map it to local folder. 7) Edit "ccnet.config" to below in order to compile and publish website-                         TFS Server name till collection                         Source Code path of TFS Project under collection                         Path to local working directory                         tfs server workspacename true C:\Windows\Microsoft.NET\Framework\v4.0.30319\MSBuild.exe Path to local working directory MSBuild.xml /noconsolelogger /p:Configuration=Debug /v:diag BuildAndPublish 150 C:\CruiseControl.NET-1.6.7981.1\Server\ThoughtWorks.CruiseControl.MsBuild.dll Path to Site where we have published output with compilation Path to copy published site to IIS directory false false 8) Create MSBuild.xml and put below code. I have customized this according to my web application under same TFS location which we are referring in same ccnet.config- Path to source code or solution folder Path to output directory (Note: I have used testwebapplication everywhere because I created testwebapplication project in tfs 2010, change name according to your project)9) Go to Dashboard and Click Force Build to compile and deploy code in IIS.10) You might also need to install AJAX 1.0 or ASP .NET MVC 3.0 to make your website work in IIS. Also, you need to give "Users" as full access if you are using IIS 7.0 on Windows 7. If any dll reference is missing while running site in IIS, then you can change "Copy Local" to true from TFS 2010 Project to make it working.

[guidetechsite]

Removing patches or hotfixes from windows server remotely

Below is the powershell script you can use to remove patches/hotfixes from servers remotely : if($args[0] -eq $null) { $servernamefile = "c:\serverlist.txt";     $hotfixidfile= "c:\hotfixlist.txt"; } else { $servernamefile = $args[0];     $hotfixidfile = $args[1]; } $info1 = get-content $servernamefile; $info2 = get-content $hotfixidfile; foreach ($hotfixid in $info2)  {       foreach ($computername in $info1)     {         $KBhotfix="KB"+$hotfixid;         if ((get-hotfix -id $KBhotfix -computername $computername))         {         Write-Host $hotfixid ' found on' $computername ', removing it......';         wmic /node:$computername process call create "powershell wusa /uninstall /kb:$hotfixid /quiet /forcerestart";         }               else         {         Write-Host $hotfixid ' not found on' $computername '.';         }     }       Start-Sleep -s 600;  }

[guidetechsite]

Finding SCCM client health of windows servers

Below is powershell script you can use to find healthcheck of SCCM clients on servers remotely- $comp = get-content serverlist.txt $strFileResults = "sccmclientstatus.txt" $strOffLinePCs = "offlineservers.txt" $skipped = @() $comp | foreach {   $Global:currentpc = $_   if (Test-Connection $currentpc -Quiet -Count 1)    {       $status = get-service -ComputerName $currentpc | where-object { $_.Name -eq "CcmExec"} |                 ForEach-Object { $_.status}     $strLine = $currentpc + "," + $status         $strLine | Out-File $strFileResults -append     Write-Host $currentpc","$status         }    else    {      $skipped += $currentpc    } } $skipped | Out-File $strOffLinePCs

[guidetechsite]

Nant Error : log4net:ERROR XmlConfiguratorAttribute: Exception getting ConfigurationFileLocation.

I recently installed nant latest installer and added the location of path /bin to System Environment Variables after extracting the zip file and it resulted in below error when I run:

C:\>nant -buildfile:build.xml

  log4net:ERROR XmlConfiguratorAttribute: Exception getting ConfigurationFileLocat

ion. Must be able to resolve ConfigurationFileLocation when ConfigFile and Confi

gFileExtension properties are not set.

System.Security.SecurityException: Request for the permission of type 'System.Se

curity.Permissions.FileIOPermission, mscorlib, Version=4.0.0.0, Culture=neutral,

 PublicKeyToken=b77a5c561934e089' failed.

   at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMa

rk& stackMark, Boolean isPermSet)

   at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, S

tackCrawlMark& stackMark)

   at System.Security.CodeAccessPermission.Demand()

   at System.AppDomainSetup.VerifyDir(String dir, Boolean normalize)

   at log4net.Util.SystemInfo.get_ConfigurationFileLocation()

   at log4net.Config.XmlConfiguratorAttribute.ConfigureFromFile(Assembly sourceA

ssembly, ILoggerRepository targetRepository)

Unhandled Exception: System.Security.SecurityException: Request for Configuratio

nPermission failed while attempting to access configuration section 'nant'. To a

llow all callers to access the data for this section, set section attribute 'req

uirePermission' equal 'false' in the configuration file where this section is de

clared. ---> System.Security.SecurityException: Request for the permission of ty

pe 'System.Configuration.ConfigurationPermission, System.Configuration, Version=

4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed.

   at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMa

rk& stackMark, Boolean isPermSet)

   at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, S

tackCrawlMark& stackMark)

   at System.Security.CodeAccessPermission.Demand()

   at System.Configuration.BaseConfigurationRecord.CheckPermissionAllowed(String

 configKey, Boolean requirePermission, Boolean isTrustedWithoutAptca)

   --- End of inner exception stack trace ---

   at System.Configuration.BaseConfigurationRecord.CheckPermissionAllowed(String

 configKey, Boolean requirePermission, Boolean isTrustedWithoutAptca)

   at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String co

nfigKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Bool

ean requestIsHere, Object& result, Object& resultRuntimeObject)

   at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)

   at System.Configuration.ClientConfigurationSystem.System.Configuration.Intern

al.IInternalConfigSystem.GetSection(String sectionName)

   at System.Configuration.ConfigurationManager.GetSection(String sectionName)

   at NAnt.Console.ConsoleStub.Framework.GetRuntimeFramework()

   at NAnt.Console.ConsoleStub.Main(String[] args)

Then I did some research and found that this is due to extra security in windows 7. So, when you are extracting zip make sure it is unblocked by going to properties of zip file and then do extract and then add it to environment variable. This will resolve this problem.

[guidetechsite]

How to test SMTP functionality ( Telnet ) in a server

First of all , you should have telnet installed in your server/system from add/remove features of windows control panel to test smtp functionality. You can do like below to test it through command prompt- telnet yourmaildomain.ext 25 helo yourmaildomain.ext mail from: [email protected] rcpt to: [email protected] data subject : your subject followed by twice enter key Your body of email followed by . quit

[guidetechsite]

How to do IISReset on remote server list using C# .NET

Below is the code using which we can IISRESET on the remote servers list through C# (Windows Form implementation approach which consumes psutil.bat to do iisreset)- string[] textlines = textBox1.Lines; string servername; String[] serverstatus = new String[20000]; textBox2.Lines = serverstatus; int i = 0; foreach (string line in textlines) { servername = line; try { string[] args = { servername, "reset" }; Process.Start("psutil.bat", String.Join(" ", args)); string tmp = servername + " check command prompt"; serverstatus[i] = tmp; } catch (Exception ex) { string tmp = servername + " check command prompt"; serverstatus[i] = tmp; } i++; } textBox2.Lines = serverstatus; I have used PSutil.bat in C# for calling PsExec.exe given by Microsoft.  ------------------------------------------------------------------------------------- if %2==stop goto A if %2==start goto B if %2==reset goto C :A PsExec.exe \\%1 iisreset /stop goto END :B PsExec.exe \\%1 iisreset /start goto END :C PsExec.exe \\%1 iisreset /restart goto END :END pause -----------------------------------------------

[guidetechsite]

HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open aconnection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL ServerNative Client 10.0 : A network-related or in stance-specific error hasoccurred while establishing a connection to SQL Server . Server is notfound or not accessible. Sqlcmd: Error: Microsoft SQL Server NativeClient 10.0 : Login timeout expired.

I did installed SQL server 2008 R2 and tried to connect to sql using "sqlcmd.exe" in command prompt but it reflected below err0r-

HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or in stance-specific error has occurred while establishing a connection to SQL Server . Server is not found or not accessible. Check if instance name is correct and i f SQL Server is configured to allow remote connections. For more information see  SQL Server Books Online.. Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

To fix this problem I did change the Named pipe value from below \\.\pipe\MSSQL$SQLEXPRESS\sql\query to

\\.\pipe\sql\query using SQL Server Configuration Manager.