cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted
Pilgrim

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)".
Labels (1)
0 Kudos
2 Replies
Highlighted
Pilgrim

Re: Which protocols ISSQLServerValidate uses?

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.
0 Kudos
Highlighted
Pilgrim

Re: Which protocols ISSQLServerValidate uses?

Thank you Hidenori. It helped me indeed very much.
0 Kudos