Options

All users have been deleted - NAV 5.01 SQL

SYLV1GSYLV1G Member Posts: 93
Hello

A user has deleted all the users in NAV and now it it not possible to connect to NAV.

Has anybody a solution to solve this problem

Thanks

SG

Comments

  • Options
    ufukufuk Member Posts: 514
    You can go to user and member of tables in sql and insert appropriate records.
    Ufuk Asci
    Pargesoft
  • Options
    SYLV1GSYLV1G Member Posts: 93
    Thank you for your help.

    Everything is ok now

    SG
  • Options
    krikikriki Member, Moderator Posts: 9,098
    Use this to create the 'SA' user in your NAV DB:


    USE yourNAVDB

    INSERT INTO [dbo].[User]
    ([User ID]
    ,[Password]
    ,[Name]
    ,[Expiration Date])
    VALUES
    ('SA'
    ,''
    ,''
    ,'1753-01-01 00:00:00.000')
    GO


    INSERT INTO [dbo].[Member Of]
    ([User ID]
    ,[Role ID]
    ,[Company])
    VALUES
    ('SA'
    ,'SUPER'
    ,'')
    GO
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Options
    andrea38andrea38 Member Posts: 1
    Hello!

    Thanks for some info,
    It really helps,
    I have the same problem,
    but it is okey now,
    Thanks a lot.........
    Regards...........
  • Options
    Nicole53Nicole53 Member Posts: 1
    Hello!

    I am new in this site...
    Thanks for the info you shared here...
    This is really a great site....
    Good day and God bless....

    how to treat depression
  • Options
    AndwianAndwian Member Posts: 627
    Use the Form 355 Receivables-Payables Line, in NAV5SP1 ID Version
    Regards,
    Andwian
Sign In or Register to comment.