Is changing SQL Server's default port to other than 1433 supported in BP?
+9
I seem to recall a certain issue with using non-default SQL ports but I can't recall where I read that (my fuzzy memory seems to remember something to do with the comma when specifying the port).
I do know that accessing via named instances works (i.e. SQLSVR1SVRINST1) as I have done installations using this format before.
+3
ports other than 1433 should work same as how a named instance will probably not be running on 1433 but a port other than that. One thing to watch out for though is your SQL SPNs for kerberos, the syntax will be different, for example a SQL instance on port 1455 your SPN would now be "MSSQLSVC/SQL.K2.COM:1455". Also make sure that if you are using a named instance that the port assignment is set to static and not dynamic!
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.