3.4.3 MxDB for SQL Server Installation and Administration Guide

Chapter 2: Install SQL Server 28

7. Authentication Mode. Although you can use either mode, Mixed

Mode allows you to assign a password to the sa login. (The Service

Pack installation requires that a password be assigned to the sa

account.)

8. Collation Setting. Choose the collation settings appropriate for your

site.

9. Network Libraries. Type a port number for TCP/IP Sockets. You can

enter any unused port number; however, the same port number must

be used on the backup nodes for the associated Virtual SQL Server.

Do not use port number 0, which configures dynamic port

assignment. MxDB for SQL Server needs to know which port the SQL

clients will use to access the SQL database. This means that SQL

Server cannot use dynamic port assignment.