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?
Many Thanks
Kevin