we cannot add new ODBC connections to sql server

PROBLEM DESCRIPTION
============================================
we cannot add new ODBC connections to sql server

ERROR MESSAGES:
============================================Connection Failed:SQLState:'01000'SQL Server Error:2[Mirosoft][ODBC SQL Server Driver[Named Pipes]ConnectionOpen(Connect()).Connection failed:SQLState:'08001'SQL Server Error: 17[Microsoft][ODBC SQLServer Driver][Named Pipes]SQL Server does not exist or access denied.

Resolution:
=========
Check on which port is SQL Server Listening on
if the SQL Server is not listening on Default port
Make the Server alias To Listen on right port on which SQL is listening
Run CLICONFG from Start -- Run Command