title: Web2py + MS SQL Server 2008 R2 + LDAP Authentication HelloWorld application?
body: <p>I have been using Web2py in the awesome *nix environment for sometime along with opensource RDMS (MySQL,Postgre,SQLLite,etc) for my personal projects.</p>
  
  <p>For my workplace which is completely working in a .Net environment I need to make a quick web app (employee master data maintenance) which runs on the local intranet with authentication and user roles.</p>
  
  <p>I planned to develop the application on web2py and deploy it on the default rocket server BUT am stuck with the DAL. I have tried pyodbc, mssql, mssql2 adapters and all work arounds people have done on the google Group and other forums.</p>
  
  <p>My production and deployment environment details are:</p>
  
  <p>O/S: MS Windows Server 2008 <br/>
  DB: MS SQL Server 2008 R2 (hosted over LAN and with Windows Authentication not SQL Authentication) <br/>
  Python: 2.7 <br/>
  WebServer: IIS 7.0 ideally but I can work on Rocket.<br/></p>
  
  <p>Is there any 'HelloWorld' application tutorial out there which covers these topics:</p>
  
  <ol>
  <li>Windows Domain Authentication with user roles in Web2py</li>
  <li>Web2py-to-MSSQLServer2008R2 DAL</li>
  <li>Web2py-IIS7.0 Deployment</li>
  </ol>
  
  <p>If someone can help me I can post this as a web2py appliance once I am done.</p>