MS SQL Server Plugin - What method of connection?
Posted: Thu Dec 06, 2012 10:30 am
Ran into an issue on a customer site this week trying to test whether SQL was connecting during the installation (using IA15).
They had a remote SQL server (2008 R2) with standard TCP port 1433 being used for connections. SQL browser and UDP 1434 was also enabled.
My installer setup was using the SQL Server Script plugin and doing the test by sending the connection info along with the single "GO" sql script to the master database on the remote server.
It would never connect. When they ran wireshark on it, they said is was trying to use SMB to discover the server which was blocked by that server. I had to have them manually install the sql scripts remotely. The connection from my application worked fine once we bypassed the installer dialogs.
Can someone explain what is being used to discover and establish a connect to SQL instances?
Thanks,
Brian
They had a remote SQL server (2008 R2) with standard TCP port 1433 being used for connections. SQL browser and UDP 1434 was also enabled.
My installer setup was using the SQL Server Script plugin and doing the test by sending the connection info along with the single "GO" sql script to the master database on the remote server.
It would never connect. When they ran wireshark on it, they said is was trying to use SMB to discover the server which was blocked by that server. I had to have them manually install the sql scripts remotely. The connection from my application worked fine once we bypassed the installer dialogs.
Can someone explain what is being used to discover and establish a connect to SQL instances?
Thanks,
Brian