Archives

Archives / 2003 / September
  • PDC and Arranged Marriages

    All this hype in the run up to PDC really confounds me. Do people really have the right expectations about this – it is a big teaser!

  • ASP.NET: Windows Authentication on SQL Server

    Many of you know that Microsoft suggests using the security provided by inherent windows auth when logging into SQL Server from an ASP.NET application. With Windows 2000 this usually means adding the ASPNET user to SQL Server or the NETWORK SERVICE user for Windows 2003. This is all fine except when you are faced with authenticating against a SQL instance that is not local. It is at this point that most developers usually give up and use SQL authentication. Those who Google the problem however will be presented with a solution that advises a change to the machine.config processModel element. Here you will specify a username and password other than the default MACHINE/AutoGenerate pair.