Monday, May 21, 2012

Gemini Database Permission using Windows Authentication


This is just a reminder for myself on how to get the Gemini Issue Tracker up and running.
  1. Install the database using Windows Authentication
  2. Add [MachineName]\ASPNET as user on the created database
  3. Select db_owner under both Schemas owned by this user and Database role membership
  4. Edit the Gemini website web.config file.
  5. Set the connection string to
    <add name="Gemini" connectionString="Data Source=[ServerName];Initial Catalog=[DatabaseName];Integrated Security=SSPI;"/>
    (Note: This connection string is for SQL 2008)
The website should open now.

No comments:

Post a Comment