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
- :
- Multiple SQL Connections problem
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
May 06, 2013
04:57 PM
Multiple SQL Connections problem
I will have three possible connections, they might be on seperate servers, or, all on the same server. I started with one connection and it worked fine, when I added the second connection, I started getting errors. Whether or not I run using the Ui sequence, or silently (and this will need to run silent, no SQL LOGIN dialog), I get "Error 27502, could not connect to microsoft SQL server ServerName. Invalid authorization specification". I then set the property IS_SQLSERVER_CONNECTIONS_TO_VALIDATE set to the name of the first connection only in the property table, and IsSQLServerValidate in the UI sequence right before the InstallWelcome, and when running with the UI I can get past the SQL Login dialog, but when it gets to the execution of the SQL scripts, the error does appear again.
I then put both connections in the IS_SQLSERVER_CONNECTIONS_TO_VALIDATE property, and the error came up in the welcom dialog. I was able to continue with the install, but ran into the error again in the SQL login dialog.
How do I get around this?
I then put both connections in the IS_SQLSERVER_CONNECTIONS_TO_VALIDATE property, and the error came up in the welcom dialog. I was able to continue with the install, but ran into the error again in the SQL login dialog.
How do I get around this?
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
May 07, 2013
09:33 AM
I should have slept on t before I posted. when I came in this morning I figured it out. It was not the multiple connections, it was invalid data (name\pw) for the second connection. Too much copying and pasting.:)
![](/skins/images/8C9D13A71C7F7695F3262372C0172D68/responsive_peak/images/icon_anonymous_message.png)