Error connection to SQL Server instance

Got a problem you cannot solve? Try here.
Post Reply
pokr
Posts: 14
Joined: Wed Apr 21, 2010 10:11 pm

Error connection to SQL Server instance

Post by pokr »

Hi,

Our installer installs a SQL Server Express SP3 instance on the local machine, and after that connects to that same instance and executes a script that creates a database.
It was running fine on IA 9.06, but after installing 9.07 (R2) it does not create the database anymore - the plugin returns CONNECT_ERROR.

Any idea of why this might be failing? I've tried to add a port number to the server as specified in a sticky message in this forum, until now without success.

Thanks in advance, regards,

Octavio
kaepteniglo
Posts: 16
Joined: Mon Apr 19, 2010 2:15 am
Location: Germany

Re: Error connection to SQL Server instance

Post by kaepteniglo »

pokr
Posts: 14
Joined: Wed Apr 21, 2010 10:11 pm

Re: Error connection to SQL Server instance

Post by pokr »

Yes, that was the one I was referring to.

Thanks - Octavio
MichaelNesmith
Posts: 3452
Joined: Thu Dec 22, 2005 7:17 pm
Contact:

Re: Error connection to SQL Server instance

Post by MichaelNesmith »

We actually implemented the suggestion in the sticky post, as part of the InstallAware 9 R2 update. But go figure, this has made things worse for some of our customers. It is impossible apparently to get SQL Server connections working for everyone :evil:

I have attached the old version of the SQL Server plug-in DLL to this message. Just use it instead of the one included with InstallAware 9 R2 if you are affected by this problem. If anybody can provide further troubleshooting assistance by monitoring connections and ports like in the sticky post, I'd be much thankful :D

Extract the file inside the archive and place it here, overwriting the newer DLL:
C:\Program Files\InstallAware\InstallAware 9 R2\Plug-Ins\MS SQL Server
(typical install path)
Attachments
mMSSQLExec.zip
Previous version of MS SQL Plug-In.
(525.74 KiB) Downloaded 466 times
Michael Nesmith
Install[b]Aware[/b]
[i]Home of The Next Generation MSI Installer[/i]
Get your free copy today - http://www.installaware.com/
pokr
Posts: 14
Joined: Wed Apr 21, 2010 10:11 pm

Re: Error connection to SQL Server instance

Post by pokr »

Thanks, Michael!

This works as previously.

Regards - OH
Post Reply