SCCM setup using External SQL and non-standard port

I have spent some time struggling with the initial setup of SCCM. I am using
an external SQL server. Our organization mandates non-standard ports for SQL
server. So far I can't get the SCCM setup to accept a port designation. It
errors if I try.

SQL Server and instance, if applicable
netbios-servername,portnumber
fails
netbios-servername:portnumber
fails
netbios-servername
fails


Does anyone have any quick suggestions?

SCCM setup using External SQL and non-standard port

Install SQL Server on the same device as SCCM. (that was pretty quick ;)

Let me do some checking and report back...

Steve

SCCM setup using External SQL and non-standard port

Steve,

Check out Jeff Gilbert's blog (he is one of the authors of the SCCM doc's):

http://myitforum.com/cs2/blogs/jgilbert/archive/2007/10/11/using-sql-server-named-instances-to-host-the-configuration-manager-site-database.aspx

The relevant part (from the blog) is here, you need to define a "custom"
SPN:

... to register the SPN for the domain user account running a named instance
using port 1400 (1400 is just a random port I picked out of my head, not a
recommendation) would be:

Setspn -A MSSQLSvc/<SQL Server name>:1400 <domain>\<user>

SCCM setup using External SQL and non-standard port

Steve,

Thanks for your reply.

I had already set the SPN's before, but that was a good thought. What I
ended up needing was a SQL Alias. That resolved that part, but I still can't
pass the pre-req checks. I posted again for the latest error.


Steve