All users have been deleted - NAV 5.01 SQL

SYLV1G

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

ufuk

You can go to user and member of tables in sql and insert appropriate records.

SYLV1G

Thank you for your help.

Everything is ok now

SG

kriki

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

andrea38

Hello!

Thanks for some info,
It really helps,
I have the same problem,
but it is okey now,
Thanks a lot.........
Regards...........

Nicole53

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

Andwian

Use the Form 355 Receivables-Payables Line, in NAV5SP1 ID Version