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

Subscribe Post Reply

1450

Similar topics

Windows authentication

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...

ASP / Active Server Pages

Problems with Windows Authentication

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...

Microsoft SQL Server

ASP.NET + SQL Server Windows authentication

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...

ASP.NET

Authentication issues

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...

ASP.NET

Windows authentication from ASP.net application to Sql Server

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....

ASP.NET

Windows Authentication not working for all machines

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...

ASP.NET

IIS6.0 vs IIS5.1 - Integrated Windows Authentication Issue

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. ....

ASP.NET

Howto know if we are in Forms or Windows authentication mode ?

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...

ASP.NET

Windows Authentication In ASP.NET SQL 2005 VB

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...

.NET Framework

Connection to MSSQL windows authentication

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...

Perl

React to native button blinking effect

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=()=>{

Software Development

Windows 11 and Access Combo Box Issue

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...

Microsoft Access / VBA

How to find best mobile app development company in usa

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...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

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...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

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...

Python

Send Current Object to PDF

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 :...

Microsoft Access / VBA

Report value list

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...

Microsoft Access / VBA

VBA Class Basics (Report Class)

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...

Microsoft Access / VBA

Take a Database to the Next Level

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...

Microsoft Access / VBA