468,743 Members | 2,186 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,743 developers. It's quick & easy.

SQL Server Windows Authentication Issues

Hello,

I am currently attempting a small project to create an installer to add IIS files to a Windows 2008R2 server and a SQL database to a Windows2008R2 /SQL2008R2 server instance. version of AI = 7.6.1.Our network requires the use of Windows/Domain based accounts for all SQL connectivity, as such SQL server only logins are disabled and the SQL server is running in Windows Authentication Mode only. Herein lies my issue, I cannot get the AI installer to connect to the SQL server when I choose to use "Trusted Connection" in the Authentication seciton of the Database server connection page. The default [proprty] applied to the trusted connection is [Logonuser] whihc only captures the username of the person logged on, not the domain as well, thus when it is passed to the SQL server it is denied access as it is not a valid user. i.e the user expected is Domain\Username as is loaded into SQL as an administrator, but the credentials passed are Username.
Oddly though this error only presents itself when attempting to do something with the need for Sysadmin rights on the SQL server, e.g create a database or SQL Agent jobs. if the Database already exists the system seems to like the connection and allow it to perform amemndemnts to it.Are you abel to advise is there something silly I am missing or have configured incorrectly?

Please help

I didn't find the right solution from the internet.

References:
https://www.advancedinstaller.com/fo...ic.php?t=21186


Thanks
Mar 24 '18 #1
0 1243

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Bob Everland | last post: by
1 post views Thread by Adi Sapir | last post: by
2 posts views Thread by Lior Amar | last post: by
reply views Thread by Simon Smith | last post: by
xarzu
2 posts views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.