472,958 Members | 2,373 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 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 1450

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

Similar topics

by: Bob Everland | last post by:
I have an application that is ISAPI and the only way to secure it is through NT permissions. I need to have a way to login to windows authentication so that when I get to the ISAPI application no...
by: Adi Sapir | last post by:
Hi, We're currently planning to migrate from SQL Auth to Windows Auth. Personally, I do not have too much experience with Windows authentication but have heard that there are some problems when...
by: Lior Amar | last post by:
Hey All, Trying to understand why I can not get SQL server to trust my IIS server. I have two machines set up, 1 App and 1 DB, and I'm trying to validate the applications access to the DB server...
by: Simon Smith | last post by:
Hi I have a small ASP.NET application that is running on a dedicated web server. This application is attempting to make a remote DCOM call to another server in order to log into another system as...
by: Alice Wong | last post by:
I am setting up my Web ASP.net application to connect to Sql server using windows authentication. I set up IIS to have integrated windows authenication and sql to allow Windows authentication....
by: tshad | last post by:
I have my windows authentication on our intranet set up as: <authentication mode="Windows"/> This works for 15 machines at work fine. Doesn't ask you to logon. It uses the logon credentials...
by: Luwk | last post by:
I have an application that communicates with the Company's Active Directory to get the OU of the users. This said application is an ASP.Net web site and has the Windows Authentication enabled. ....
by: WT | last post by:
Hello, I tryed to fix a variable with the current authentication mode, I tryed to use Request.LogonUserIdentity AuthenticationType for this but when I traced with this code if...
by: Daxthecon | last post by:
I'm using VS 2008 and Microsoft SQL Server Express Edition to program an ASP.NET/VB web application. The web application has to do with putting in products to populate a table veiwed by another page...
by: karthik12chintu | last post by:
i am using mysql for my application. now i want to use mssql server windows authentication. i would b thankful if any one help me in step by step procedure for accesing mssql database from perl...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.