Skip to main content
Nintex Community Menu Bar

Any known issue with changing SQL Server default port for BP?

  • May 6, 2009
  • 2 replies
  • 15 views

Forum|alt.badge.img+13
Is changing SQL Server's default port to other than 1433 supported in BP?  

2 replies

Forum|alt.badge.img+9
  • Nintex Partner
  • May 7, 2009

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.


Forum|alt.badge.img+3
  • May 21, 2009
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!