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 Script installation - "Login failed for user '(null)'" w/ Windows Authentication
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 11, 2008
11:13 AM
SQL Script installation - "Login failed for user '(null)'" w/ Windows Authentication
Hello - I've been spending all day on the forums and knowledgebase trying to assess this issue, but so far I've turned up nothing.
I am building an installer in InstallShield 2008 Professional that creates a connection based on user information in the default SQLLogin dialog box.
However, whenever a user selects "Windows Authentication", I get the response "Login failed for user '(null)'". For some reason, InstallShield isn't properly assessing the current login on the machine. This happens on EVERY computer I put the installer on.
I have already checked the usual suspects (ForceGuest is turned off on both the target machine as well as the SQL server, the user I'm logging in as has full permissions, etc), and every other program we have works fine contacting the database using integrated Windows Authentication *except* InstallShield - so I'm at a loss as to why InstallShield can't figure out what username is logged in.
I could really use some help with this as nothing in the documentation or on google seems to cover this exact problem. Thanks...
I am building an installer in InstallShield 2008 Professional that creates a connection based on user information in the default SQLLogin dialog box.
However, whenever a user selects "Windows Authentication", I get the response "Login failed for user '(null)'". For some reason, InstallShield isn't properly assessing the current login on the machine. This happens on EVERY computer I put the installer on.
I have already checked the usual suspects (ForceGuest is turned off on both the target machine as well as the SQL server, the user I'm logging in as has full permissions, etc), and every other program we have works fine contacting the database using integrated Windows Authentication *except* InstallShield - so I'm at a loss as to why InstallShield can't figure out what username is logged in.
I could really use some help with this as nothing in the documentation or on google seems to cover this exact problem. Thanks...
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 11, 2008
12:31 PM
If you try to connect to your database from InstallShield locally (run the setup on the machine that has your database server installed), does the problem reproduced?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 11, 2008
12:52 PM
No, the problem can't be reproduced on the SQL server itself.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 11, 2008
01:24 PM
Try the solution provided in this thread, and let me know if it solves your issue.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 11, 2008
02:09 PM
Aha! Thank you so much, that worked. Hopefully future versions will have that documented/changed? 🙂 Thanks!
![](/skins/images/CC38E504FC9E1309DC48ACFEB4925670/responsive_peak/images/icon_anonymous_message.png)