This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
heiner_violet
Level 7
‎Sep 27, 2007 08:13 AM

SQL Connection fails for remote server

Hi all, I'm working with IS 2008, Basic-MSI
My setup executes a number of SQL-Scripts added in the SQL Scripts View. If the user chooses a local SQL-Server (in the dialog SQLLogin) the scripts are executed.
Problem: if the user chooses an SQL-Server on a remote computer, the connection to the SQL-Server fails. In the log a message like the following is created:

Error while login 'NT-AUTORITÄT\ANONYMOUS-ANMELDUNG'. Source: Microsoft OLE DB Provider for SQL Server SQL State: 42000 Native Error: 18456
Error 27502. No connection to the SQL-Server could be established.

Note: I have configured the SQL-Server so that remote clients can connect to it.

Does anyone, what I'm doing wrong here?
Thanks in advance, H.
Labels (1)
Labels
0 Kudos
(1) Reply
heiner_violet
Level 7
‎Sep 27, 2007 09:17 AM

I found the solution in this thread: http://community.installshield.com/showthread.php?p=391861#post391861. I had to change the In-Script Execution property of the ISSQLServerInstall and ISSQLServerUninstall actions from the "Deferred Execution in System Context" to "Deferred Execution".

So, excuse me for beginning a duplicate thread. H
0 Kudos