Overriding the Default TCP/IP Network Library with a Different Protocol for a SQL Server Database
InstallShield 2018
Project • This information applies to the following project types:
By default, InstallShield installations use the TCP/IP network library when connecting to a SQL Server database. You can override this default behavior as needed if you want to use a different protocol.
To override the default TCP/IP network library when connecting to a SQL Server database:
|
1.
|
In the View List under Server Configuration, click SQL Scripts. |
|
2.
|
Right-click the SQL Scripts explorer and click New SQL Connection. InstallShield adds a new connection in the explorer. Use the tabs in the right pane to configure the settings that are associated with this connection. |
|
3.
|
In the View List under Additional Tools, click Direct Editor. |
|
4.
|
In the Tables explorer, click the Property table. |
|
5.
|
Find the IS_SQLSERVER_NETLIB_MS field. The default value is: |
Network Library=DBMSSOCN
DBMSSOCN refers to the name of the module for the TCP/IP network library, without the file extension.
|
6.
|
Replace the default DBMSSOCN name as required. For example: |
|
•
|
To use the Named Pipes network library, specify DBNMPNTW. |
|
•
|
To use SPX/IPX, specify DBMSSPXN. |
|
•
|
To use Banyan Vines, specify DBMSVINN. |
|
•
|
To use Multi-Protocol (Windows RPC), specify DBMSRPCN. |
At run time, the installation uses the protocol that you specified when connecting to a SQL Server database.
See Also
Direct Editor
SQL Scripts View
Open topic with navigation