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
- :
- SQL-Connection failed...
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
‎Oct 08, 2008
10:55 AM
SQL-Connection failed...
During my setup progress I want to run a sql script, but unfortunately setup is unable to connect to my database.
From a prestarting setup.exe I set the property IS_SQLSERVER_SERVER and skip the SQLLogin-Dialog. So the IS_SQLSERVER_AUTHENTICATION-property should be by default 0, that's what the property manager says (this means windows authentication).
I get the error message, that the user (null) is not part of a trusted sqlserver-connection (ADO Error: -2147467259.
If I try the same thing in M$ SQL Server Management Studio I can connect without any problem to the server...
P.S. I get this error only for sql servers running in LAN, local sql servers work fine.
P.P.S. Same problem if I don't skip SQLLogin-dialog...
From a prestarting setup.exe I set the property IS_SQLSERVER_SERVER and skip the SQLLogin-Dialog. So the IS_SQLSERVER_AUTHENTICATION-property should be by default 0, that's what the property manager says (this means windows authentication).
I get the error message, that the user (null) is not part of a trusted sqlserver-connection (ADO Error: -2147467259.
If I try the same thing in M$ SQL Server Management Studio I can connect without any problem to the server...
P.S. I get this error only for sql servers running in LAN, local sql servers work fine.
P.P.S. Same problem if I don't skip SQLLogin-dialog...
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 08, 2008
09:47 PM
Please try the workaround provided in this thread and see if it solves your issue.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 09, 2008
09:45 AM
Hi hidenori,
seems as if you forgot the link 🙂
seems as if you forgot the link 🙂
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 09, 2008
09:55 AM
I am sorry, I fixed it. Please try it again.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 13, 2008
04:10 AM
Seems to work, thanks!