Microsoft Rights Management (RMS) Team Blog

The official team blog of Microsoft's Rights Management product team with news and updates for IT professionals using AD RMS or Azure RMS.

Specifying a non-standard SQL port when installing AD RMS

Specifying a non-standard SQL port when installing AD RMS

  • Comments 2
  • Likes

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

Comments
  • hi Dan

    i'm trying to do this with AD RMS 2012 but i'm getting

    AD RMS setup could not retrievea list of sql instance names. no such host is known

    is there is other way to do that  

  • Did you find a solution to this. With Windows server 2012 this doesn't seem to work

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment