We are trying to run our database redgate sql package directly on client computer and the redgate package application fails immediately - does not even give the dialog box that shows 'local', etc.
The client is running Windows Vista with SQL Server Express 2005. There are 2 instances on the computer as well.
We tried running the package directly after our install wrapper also failed with an error in the Windows Event log referencing 'SQLTestConnection.exe' failed.
The redgate packager error in Windows Event log was:
Faulting application SQLPackageFull_v151_29.exe, version 1.0.3237.29324, time stamp 0x491a0479, faulting module unknown, version 0.0.0.0, time stamp 0x00000000, exception code 0xc0000005, fault offset 0x0022ec4c, process id 0x10cc, application start time 0x01c971d94bea66a8.
[ Name] Application Error
- EventID 1000
[ Qualifiers] 0
[ SystemTime] 2009-01-08T21:37:25.000Z
Does anyone have an idea why the packager is failing or our wrapper is failing? Is there a quick fix? We can access the database instance through windows and sql auth using SQL Management Studios but cannot connect via either our installer wrapper or red-gate packager. We believe the problem is tied to the SQLTestConnection.exe but we don't know for sure. Where is the SQLTestConnection.exe being called from? By OS or SQL? Can someone explain more about SQLTestConnection?
Any information will be appreciated. Thanks!