cancel
Showing results for 
Search instead for 
Did you mean: 

Integrated login mapping lost with dbunload -an

Miro_Marek
Explorer
318

I rebuild two SQL Anywhere 17 databases with command "%SQLANY17%\\bin64\\dbunload" -v -c "ENG=dbunl;UID=xxx;PWD=xxx;start=%SQLANY17%\\bin64\\dbeng17.exe;dbf=C:\\Backup\\data.db" -an "C:\\temp\\data_new.db" -ap 4096 -ea None -kdi 0 -ii -up

Both databases contain integrated login mappings and have the same structure. After a reload, the integrated login mappings are missing in one of the databases, in the other they are complete. If I only unload the reload script and then compare them, there are no differences and both databases contain "GRANT INTEGRATED LOGIN TO ..." and "SET OPTION "PUBLIC"."login_mode"='Mixed'".

What else can I check?

jack_schueler
Product and Topic Expert
Product and Topic Expert
0 Kudos

Are the integrated logins that are missing still valid. The user(s) must exist at the present time in the context in which the rebuild is being done (otherwise, the GRANT INTEGRATED LOGIN will fail).

Accepted Solutions (0)

Answers (0)