cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
UNeverNo
Level 6

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...
Labels (1)
0 Kudos
(4) Replies
hidenori
Level 17

Please try the workaround provided in this thread and see if it solves your issue.
0 Kudos
UNeverNo
Level 6

Hi hidenori,

seems as if you forgot the link 🙂
0 Kudos
hidenori
Level 17

I am sorry, I fixed it. Please try it again.
0 Kudos
UNeverNo
Level 6

Seems to work, thanks!
0 Kudos