This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: SQL Connection fails for remote server
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
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.
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.
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
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
So, excuse me for beginning a duplicate thread. H