Microsoft Secure Tech Accelerator
Apr 03 2024, 07:00 AM - 11:00 AM (PDT)
Microsoft Tech Community
Specifying a non-standard SQL port when installing AD RMS
Published Sep 07 2018 08:34 PM 938 Views
First published on CloudBlogs on Apr, 28 2012

(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:

tcp: <SQL_server_name> : <port_number>

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:

  1. On the (soon-to-be) AD RMS server, run cliconfg.exe.
  2. Click the Alias tab, and then click Add.
  3. In the Server alias box, type the alias you want to use for the SQL server.
  4. Click TCP/IP .
  5. type the computer name of the SQL server in the Server name box.
  6. Clear the Dynamically determine port check box, and then in the Port number box, type the port number that the SQL server is using.
  7. Click OK to close everything.

You can then use the alias you created as the name of the SQL server when you install AD RMS.

Version history
Last update:
‎Sep 07 2018 08:34 PM