Upgrade from 2.2.6 to 3.0.4 DB upgrades OK but can't login
Hi,
I am doing an upgrade of my Gemini 2.2.6 system on SQL Server 2000 on IIS6 on a Windows 2003 Server to Gemini 3.0.4 on an IIS7, SQL Server 2005, Windows 2008 Server.
Here is what I have done:
1) Backup DB on SQL Server 2000 to file
2) Transfer DB file to new Server 2008 machine
3) Restore DB to SQL Server 2005
4) Run CREATETABLES.sql
5) Run CREATEVIEWS.sql
6) Run CREATEPROCS.sql
7) Run Upgradev3-0-Step1.sql
8) Run Upgrade_v3-0-Step2.sql
9) All SQL upgrade scripts execute successfully.
10) Run Gemini 3.0.4 installer
11) Install ASP.NET AJAX 2.0 file
12) Convert Gemini to an application in IIS7
13) Set Trust Level for IIS7 for Gemini folder to "Full"
14) Edit web.config and enter initial catalog, username, and password for DB.
15) Launch Gemini via http://localhost/gemini
16) Main screen appears and I see all issues and projects
17) Login with old admin password account. NOTHING HAPPENS
When I try to login with any account the screen simply refreshes and I am presented with a login screen. I have tried other accounts from the old Gemini installation and also tried the new "manager:manager" u/p combination but this does not work (as it is only installed with the new Gemini sample DB).
I tried changing web.config to Windows authentication instead of "Forms" and adding a Windows user to full access on the DB but was not able to login still.
I am sure this is probably an IIS7 authentication issue but I need to get access to my Gemini installation.
Possible Solutions:
1) Create an admin account by hand and then fix user roles and rights once logged in. This would be dangerous as I don't know what new roles are created and how it would affect existing issues.
2) Add "manager" account and do same steps as above.
3) Reset password for old admin user. This is binary data in the DB so not sure how to do this.
4) Use Windows Authentication. Again this may be an IIS7 issue as after the login I am still at the same page.
Any idea of what I am doing wrong?
TR
teleriddler
· 1 |
|
Saturday, September 6, 2008, 7:53:44 PM |