Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




windows authentication fails after migrating from 2.1 to 3.6

migration

Hello,

I'm migrating from 2.1 to 3.6 with the following scripts :
- Upgradev2-2.sql
- Create
Tables.sql
- CreateViews.sql
- Create
Procs.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
dav_natixis
Replies (5)
helpful
0
not helpful

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?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

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


dav_natixis
· 1
dav_natixis
helpful
0
not helpful

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.

To add an admin user you need:

  • Create the user (make sure the username is not in the table already, password is admin):
    • INSERT INTO geminiusers (username,firstname,surname,pwd,emailaddress,roles)
          VALUES (N'admin',N'Jon',N'Smith',0x21232F297A57A5A743894A0E4A801FC3,N'jon@smith.com',N'G!')
  • Add the user to the admin,everyone and everyone authneticated groups:
    • INSERT INTO geminiglobalgroupmembership (globalgroupid,userid)
          SELECT 1 AS globalgroupid, THE NEW USER ID
      INSERT INTO geminiglobalgroupmembership (globalgroupid,userid)
          SELECT 2 AS globalgroupid, , THE NEW USER ID
      INSERT INTO gemini
      globalgroupmembership (globalgroupid,userid)
          SELECT 3 AS globalgroupid, , THE NEW USER ID


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

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.


dav_natixis
· 1
dav_natixis
helpful
0
not helpful

Yes, this is because the upgrade scripts remove all entries from the new table to bring in the existing (old) data.


Mark Wing
· 9108
Mark Wing