SQL Server Client Network Utility

If you haven’t installed the SQL Server 2005/2008 client tools, you can still create an alias using the SQL Server Client Network Utility. This has come installed automatically on every operating system from Windows 2000 on. To bring up the utility, click on Start, then Run, and run cliconfg.exe. To view or create aliases, click on the Alias tab. Aliases created by SQL Server Configuration Manager can be seen by the SQL Server Client Network Utility.

Synonyms in SQL Server 2005

In Sql Server 2005, they enhanced this feature. Now you can give the Alise on Database/Table. Here is the example of table level

USE AdventureWorks;
GO
– Create a synonym for the Product table in AdventureWorks.
CREATE SYNONYM MyProduct
FOR AdventureWorks.Product;
GO

Here is the example of Database level
USE AdventureWorks ;
GO
CREATE SYNONYM MyDatabase
FOR AdventureWorks;
GO