985
I restored a backup from our live server to a test server. When i connected nav 2013 to it. It said I was not authorized to run the nav. I then added my windows account to the users in sql. When I now ran the nav client, I got this error: "Microsoft.Dynamics.Nav.Client has stopped working" with options to either check online for a solution and close or close the program. Please any help will be appreciated. Thanks.
*This post is locked for comments
hi,
to add a new nav user in the sql database you have to add a new entry in tables User, User Property and Access Control.
use this T-SQL Statement:
USE [YOUR DATABASE]
DECLARE @USERSID uniqueidentifier, @WINDOWSSID nvarchar(119), @USERNAME nvarchar(50)
SET @USERNAME = '<domain\user>'
SET @USERSID = '<random security id>'
SET @WINDOWSSID = '<windows security id>'
INSERT INTO [dbo].[User]
([User Security ID],[User Name],[Full Name],[State],[Expiry Date],
[Windows Security ID],[Change Password],[License Type])
VALUES
(@USERSID,@USERNAME,'',0,'1753-01-01 00:00:00.000',@WINDOWSSID,0,0)
INSERT INTO [dbo].[User Property]
([User Security ID],[Password],[Name Identifier],[Authentication Key],[WebServices Key],[WebServices Key Expiry Date])
VALUES
(@USERSID,'','','','','1753-01-01 00:00:00.000')
INSERT INTO [dbo].[Access Control]
([User Security ID],[Role ID],[Company Name])
VALUES
(@USERSID,'SUPER','')
GO
Hey Sandeep,
He is unable to login and there is no Super user in database as of Now, please go through the trail.
@Toffsam - Are you a customer or Partner?
You need to check on the Codeunit which Page its returning while opening windows client, if you are a customer then i think you should contact your partner for same.
Hi Toffsam
Please check, you are facing the same problem with super permission or not.
If not please let me know.
Hi Saurav,
May be I do not understand what you want me to do at this point. Please explain to me how to do this, Because what I did was to select the line(9170 Conf./Personalization Mgt. ) under the codeunit and clicked run.
Thanks
Hey Toffsam,
You are supposed to run it you need to provide me the Exit value of the function. Just copy the Text inside the function.
Hey Toffsam,
I need the value in the Function DefaultRoleCenterID.
Hey Toffsam,
Just check what is the Page Id in Below location.
Codeunit 9170 - Function - DefaultRoleCenterID
Let me know the value at this point.
I still get the same issue after following these steps:
1. Take Backup of Page 9006 - Order Processor Role Center.
2. Design Page, and Delete Second and Third Line, i.e Group & <SO Processor Activities> Page.
Save the page and Try running Widows Client.
please see what else I can do.
Thanks.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (