471,077 Members | 1,003 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,077 software developers and data experts.

SQL Server Windows Authentication Issues


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.


Mar 24 '18 #1
0 1320

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.