Kendra Thorpe’s VU Blog

Installing MOSS 2007 on SQL 2005 Instance on a non-default port:
In order to use an alias for SQL you must have the following installed on your MOSS 2007 servers:
1. Connectivity Tools
2. SQL Management Studio

On each MOSS 2007 server:
1. All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager -> SQL Native Client Configuration -> Aliases
2. Create a new alias. I used the IP address of the SQL instance because it’s on a cluster and seemed to work a little better.
3. I also used a FQDN for my alias name and created a DNS CNAME record for that name. (i.e. ALIASNAME.COMPANY.COM)