Thursday, May 12, 2011

SQL Server Replication and Alias

When trying to create a replication it is necessary to have an Alias in order to correctly name the server and open the connection. You can create the alias in SQL Server Configuration Manager.

These should be the steps:
Aliases created with SQL Server Configuration Manager can be used with any client application. The connection strings described in SQL Server Configuration Manager Help can be useful for programmers who create their own connection strings.
To access alias information in SQL Server Configuration Manager Help
1. In SQL Server Configuration Manager, expand SQL Native Client Configuration, right-click Aliases, and then click New Alias.
2. Press F1, or click Help.
3. The New Alias (Alias Tab) topic describes the New Alias dialog box, and contains links to valid connection strings for each type of protocol.
Then you should be able to use the Server’s name in the Replication creation process.

No comments:

Post a Comment