windows authentication fails after migrating from 2.1 to 3.6
Hello,
I'm migrating from 2.1 to 3.6 with the following scripts :
- Upgradev2-2.sql
- CreateTables.sql
- CreateViews.sql
- CreateProcs.sql
- Upgrade_v3.0-step1.sql
The problem is that the users can't connect any more using Windows Authentication.
I don't have an account on it and admin account was deleted. Is there a way to manually add an account in the database so I can connect ?
Thx
dav_natixis
· 1 |
|
Thursday, January 14, 2010, 5:17:13 PM |
0
|
See the create_tables script, it creates an admin account but you will need to add it to the admin group. What is the issue with windows auth? Do you get an error? |
||||
|
0
|
How can I add the admin in the admin group without having any access? what tables are implied? Well, users can't connect using windows auth because i didn't do anything yet with the groups definition. I guess i will be able to do it when i log as an admin. Thanks |
||||
|
0
|
Ok, if you were in forms authentication mode and just changed to windows, simply change back to forms, add your user (DOMAIN\User) and make it an admin. Switch to winodws and that should be it for you.
|
||||
|
0
|
It's working fine Thanks! Windows Auth is working properly too. The admin account is well created in CreateTables.sql but for some reason i don't know, it's not in the geminiusers table once every scripts are run. |
||||
|
0
|
Yes, this is because the upgrade scripts remove all entries from the new table to bring in the existing (old) data. |
||||
|