MS SQL Server Plugin - What method of connection?

Interested in developing new plug-ins? Got one to share? Post here!
wbrussell
Posts: 11
Joined: Thu Apr 27, 2006 3:57 pm

MS SQL Server Plugin - What method of connection?

Postby wbrussell » 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

FrancescoT
Site Admin
Posts: 5361
Joined: Sun Aug 22, 2010 4:28 am

Re: MS SQL Server Plugin - What method of connection?

Postby FrancescoT » Thu Dec 06, 2012 10:47 am

Dear Brian,

Honestly, I never used WireShark and I don't follow you when you say;
they said is was trying to use SMB to discover the server which was blocked by that server

Can you try to be more clear?

Anyway, could you post as "IntallAware Clipboard Format" the command you used?

Regards
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE

wbrussell
Posts: 11
Joined: Thu Apr 27, 2006 3:57 pm

Re: MS SQL Server Plugin - What method of connection?

Postby wbrussell » Thu Dec 06, 2012 12:44 pm

Wireshark is just a packet capture utility

SMB is server message block protocol

Code: Select all

~InstallAware Clipboard Data~
~MS SQL Server~
~{04B717CB-C6E5-41F7-9058-72A196150C14}~
~$SERVERNAME$,$INSTANCENAME$,master,$SQLUSER$,$SQLPASSWORD$,SQLTEST,GO,0,0~
~mMSSQLIDE.dll\mMSSQLExec.dll~

FrancescoT
Site Admin
Posts: 5361
Joined: Sun Aug 22, 2010 4:28 am

Re: MS SQL Server Plugin - What method of connection?

Postby FrancescoT » Mon Dec 10, 2012 1:33 pm

Dear Brian,

the code you posted doesn't contain the values you used to test your connection (server name, instance & so on).
However, I have just verified (using the project sample that comes with IA) to connect with remote SQL server 2008 R2 wich uses a standard TCP port 1433 ... and works fine.

I can only suspect that you are passing (maybe) not correct paramenters.

Regards
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE


Return to “Plug-In Development”

Who is online

Users browsing this forum: No registered users and 29 guests