Salesforce

Connecting to an MSSQL Instance that Is Not Using the Default Port (Magic xpa 4.x)

« Go Back

Information

 
Approval Process StatusPublished
Objective
Description

Connecting to an MSSQL Instance that Is Not Using the Default Port (Magic xpa 4.x)

Objective

Some MSSQL database servers use a non-default port number (not the default 1433).

This Technical Note describes the required configuration to communicate with this type of database.

Solution

Entering a server name – comma – port (for example: MyServer,1444) is not possible because the INI is sensitive to commas; using a comma causes a corruption of the INI database entry.

The solution is to define an alias.

There are two ways to define an alias:

1. If SQL Native Client is installed on the machine:

  1. Open the Native Client console using the command:

    C:\WINDOWS\system32\mmc.exe /32 "C:\WINDOWS\system32\SQLServerManager.msc"

    Or by using the menu:

    Start -> All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> SQL Server Configuration Manager

  2. Define a new alias as shown in the image below:

2. If SQL Native Client is not present on the machine:

  1. Open the Client Network Utility console using the command:

    c:\WINDOWS\system32\cliconfg.exe

  2. Define a new alias as shown in the image below:

Using the alias from Magic xpa:

Define a new database entry using the alias name as the "server name".

Reference
TitleConnecting to an MSSQL Instance that Is Not Using the Default Port (Magic xpa 4.x)
URL NameConnecting-to-an-MSSQL-Instance-that-Is-Not-Using-the-Default-Port-xpa-4x