What do I do if I'm not using the standard database port number in SecurityExpressions Server or SecurityExpressions Console?
If you’re not using the standard port number (1433) to connect to the database, you need to make SecurityExpressions aware of the correct port number. You can do this in the Windows Registry.
To configure a nonstandard port number for use with SecurityExpressions:
- Open the Windows Registry Editor.
- Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo and add the following REG_SZ value:
servername1 REG_SZ connectiontype,servername2,port#
Where servername1 is the name or IP address of the computer running the database software, connectiontype is the network-connection type, such as dbmssocn for Winsock TCP/IP, servername2 is the same string as servername1 (no interchanging IP addresses and computer names in the same value), and port# is the nonstandard port number you’re using.
Note: If the registry key doesn't exist, create it first.
- Close Registry Editor.