1543702 - Error: “(Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)” while creating a new ODBC.

While creating a new connection in ODBC with SQL Server 2008 driver, getting error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005/2008, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (Provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)

BusinessObjects Enterprise XI 3.1 Service Pack 3

Named Pipes, error: 40, Could not open a connection, Error: 1326, ODBC create err, BOE XI 3.1. , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem