(This post was published on the original RMS team blog in December 2010.)
The AD RMS setup wizard assumes that the SQL database server you use for the AD RMS configuration and logging databases is listening on the standard SQL TCP port, 1433. If your SQL server is configured to use a different port, this can create problems when you install AD RMS.
There are a couple ways to work around this. The first is simply to specify the port with the SQL server name in the setup wizard, using the following format:
The other is to use the SQL Server Client Network Utility to create an alias for the SQL server on the server you’re going to install AD RMS on:
On the (soon-to-be) AD RMS server, run cliconfg.exe.
tab, and then click
box, type the alias you want to use for the SQL server.
type the computer name of the SQL server in the
Dynamically determine port
check box, and then in the
box, type the port number that the SQL server is using.
to close everything.
You can then use the alias you created as the name of the SQL server when you install AD RMS.