Alternatively, you can leave **Pipe Name** blank and SQL Server Configuration Manager will complete the appropriate pipe name after you specify the **Protocol** and **Server**.

Right click 'Aliases', create a new one Enter '.\SQLEXPRESS' as the Alias Name Enter 'localhost' as the Server Select 'tcp' as the Protocol. Repeat this process for the 'SQL Server Client 11.0 ...

We've got a DNS alias in our DNS server so that we can reference the SQL Server via a generic easy to remember name. It's used in our client app's ODBC ...

Now, enter your SQL Server's name and choose the authentication type that you want to use. If necessary, enter the credentials to be used for SQL Server authentication.