The Administration Service Setup program incorrectly allows you to identify SQL Server by client alias or data source name (DSN). If you do so, the Administration Service cannot be configured to participate in ActiveRoles Server replication.
When attempting to promote such Administration Service to Publisher, or to make it a Subscriber, you encounter the error "An alias cannot be used for replication. Use the name of the SQL Server instance."
To avoid this issue, you must supply the computer name (short NetBIOS name) and, optionally, the instance name, in the form computername\instancename. When you specify only computername, you identify the default instance of SQL Server. When you specify computername\instancename you identify the named instance.
The only workaround is to uninstall the Administration Service and then install it again.
When installing the Administration Service, identify SQL Server by using the syntax computername\instancename where computername is the short NetBIOS name of the computer running SQL Server and instancename is the name of a SQL Server named instance; for the default instance, only specify computername.
1. From SQL Query Analyzer, run the following commands:
select serverproperty ('servername')
It should return identical names in the window below. If they are different, that is the problem.
The suggested solution is to rename the SQL server, or to install on a computer which returns the same name.
Here is how to rename the computer using SQL commands:
WARNING: Making any changes to SQL can cause problems for other database applications.
The name of the server running SQL has been changed. Run the following transact-SQL statement using SQL QUERY ANALYZER:
exec sp_dropserver 'oldname', 'droplogins'
exec sp_addserver 'newname', 'local'
Restart the computer running SQL server.
'oldname' - Old server name (returned by select @@servername)
'newname' - New server name (returned by select serverproperty ('servername') )
To retain the Administration Service configuration after re-install, choose the installation option to connect to the existing database. Note that the uninstall operation does not delete the Administration Service database from SQL Server.
Waiting for fix. A release date for this fix has not yet been determined.