Can "Windows Authentication" be used for SQL in distributed env.?

From: Novice (6tc1ATqlinkDOTqueensuDOTca)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 06:00:01 -0700

Hi all, we are about to move our SQL Server database onto a different machine from the machine that houses our web server (IIS). Currently our web application uses "windows authentication" - but once we move it to a different machine will we have to change the security mode? Or is there another way for our web server machine to flow the identity to the other machine.

I tried looking this issue up online - but I saw no reference to it. I did find this:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxcondatabasesecurity.asp

and it seems that the advice from Microsoft is that if you just create an identical account on both machines (including password) you can effectively connect from the one machine to the other.

Or have I misunderstood?

Thanks for any advice,
Novice

Relevant Pages

  • Re: Another problem with KB825732
    ... "KB835732" issue - have generally been the type of advice that is given to ... My machines aren't affected by this and none of my ... > Does this only occur on this one particular drive mapping? ... > Microsoft MVP - Windows NT Server ...
    (microsoft.public.windowsupdate)
  • Re: Another problem with KB825732
    ... "KB835732" issue - have generally been the type of advice that is given to ... My machines aren't affected by this and none of my ... > Does this only occur on this one particular drive mapping? ... > Microsoft MVP - Windows NT Server ...
    (microsoft.public.windowsxp.general)
  • Re: Compatibility issue?
    ... Could this be the issue as you mentioned the different versions of outlook ... Do you also have Outlook 2003 installed on both machines, ... failing vba I'd be very surprised the reference is not marked as MISSING, ... Microsoft Office 10.0 Object Library ...
    (microsoft.public.excel.programming)
  • Re: Workbook code works on my machine but noy others
    ... Outlook reference in the project, I had to define each constant. ... Sub MultipleAppointment(Addressee, AddresseeOptional, OnDate, StartTime, ... Microsoft Office 10.0 Object Library ... Weird as the application works ok on some machines but not other ...
    (microsoft.public.excel.programming)
  • Re: Cannot find VBA definition in XP Only
    ... I just wanted to get back to you guy's and tell you your advice was right on! ... >>We are experiencing problems with the VBA Reference even though the Visual ... >>is that previous version has a reference of Microsoft Access 9.0 Object ... >>The VBE6.DLL we are using on both machines is the identical version. ...
    (microsoft.public.access.modulesdaovba)