This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Which protocols ISSQLServerValidate uses?
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 20, 2011
09:47 AM
Which protocols ISSQLServerValidate uses?
Which protocols use ISSQLServerValidate to check the connection to the SQL Server? TCP/IP, Shared Pipes, VIA, Named Pipes?
I ask this because I tried to use ISSQLServerValidate to check the connection to a SQLExpress 2008 which had enabled only "Named Pipes" and "Shared Memory" protocols and I got an error like:"Error 27502. Could not connect to Microsoft SQL Server ....\SQLEXPRESS'. [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found. (6)".
I ask this because I tried to use ISSQLServerValidate to check the connection to a SQLExpress 2008 which had enabled only "Named Pipes" and "Shared Memory" protocols and I got an error like:"Error 27502. Could not connect to Microsoft SQL Server ....\SQLEXPRESS'. [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found. (6)".
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 06, 2011
05:00 PM
The ISSQLServerValidate action uses the Win32 Winsock TCP/IP network library by default when establishing a connection. If you want to specify a different type of network library, change the value of the IS_SQLSERVER_NETLIB_MS Windows Installer property in the Property Manager.
Network protocol codes
dbnmpntw -Named Pipes
dbmslpcn - Shared Memory
dbmssocn - Winsock TCP/IP
dbmsspxn - SPX/IPX
dbmsvinn - Banyan Vines
dbmsrpcn - Multi-Protocol (Windows RPC)
dbmsadsn - Apple Talk
dbmsgnet - VIA
Hope that helps.
Network protocol codes
dbnmpntw -Named Pipes
dbmslpcn - Shared Memory
dbmssocn - Winsock TCP/IP
dbmsspxn - SPX/IPX
dbmsvinn - Banyan Vines
dbmsrpcn - Multi-Protocol (Windows RPC)
dbmsadsn - Apple Talk
dbmsgnet - VIA
Hope that helps.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 07, 2011
02:26 AM
Thank you Hidenori. It helped me indeed very much.