Skip to main content

NAV 2015, “How-to” solve “You are not authorized to sign in..” error

NAV 2015, “How-to” solve “You are not authorized to sign in..” error


you are not aut
How to login in “any database”
Follow this and you can login in any database (delete ALL existing configuration and can login)
Source Waldo Blog  http://dynamicsuser.net/blogs/waldo/archive/2012/12/05/nav-2013-how-to-log-in-any-database.aspx
By SQL Script > Grant SUPER to Role ID in Access control table
There are 2 ways for your case, run SQL script on your database:
1. Come back to no user as before you create the user:
DELETE [Access Control]
DELETE [User]
2. Set all users as SUPER users:
UPDATE [Access Control] SET [Role ID] = ‘SUPER’
Source https://community.dynamics.com/nav/f/34/p/166672/408485#408485
by “PowerShell”, nice RESCUE Solution
1. Start the NAV 2015 Administration Shell or Powershell ISE
2. Execute the command:
  1. New–NAVServerUser –ServerInstance YOURINSTANCENAME –WindowsAccount YOURUSERACCOUNT
(of course replace the ‘YOUR…’ with your data :D  ; probably YOURINSTANVCE should be: DynamicsNAV80 )
3. Execute the command:
  1. New–NAVServerUserPermissionSet –ServerInstance YOURINSTANCENAME –WindowsAccount YOURUSERACCOUNT –PermissionSetID SUPER
Source https://community.dynamics.com/nav/f/34/p/166672/408485#408485
NAV MSDN Bible
You can find info on assigning permissions here: https://msdn.microsoft.com/en-us/library/dd338839(v=nav.80).aspx
And also general info on creating users here: https://msdn.microsoft.com/en-us/library/dd355093(v=nav.80).aspx
Source https://community.dynamics.com/nav/f/34/p/166672/408485#408485
Have Fun

Comments

Post a Comment

Popular posts from this blog

The Difference Between Microsoft Dynamics NAV and AX

The Difference Between Microsoft Dynamics NAV and AX Microsoft Dynamics offers a variety of ERP solutions. You might say there is a solution for every purpose and every industry. Two of the offerings,  Dynamics NAV  and  Dynamics AX (now part of  Dynamics 365 ) share some of the same features so you might wonder: ‘what are the differences and which is right for my organization?’ Both ERP solutions are highly customizable, available in and adaptable to many languages and currencies used around the world. The two solutions can also be employed in a central location or across diverse satellite locations and are designed to grow as a business grows. Their industry-specific functionality can assure compliance with local and regional requirements. In short, both solutions could rightly be described as comprehensive and well equipped to manage complex requirements of supply chain and inventory. So, what is the difference? Is one better than the other for your...
Post a Comment
Read more

RUNREQUESTPAGE, EXECUTE, PRINT, SAVEAS in NAV

RUNREQUESTPAGE, EXECUTE, PRINT, SAVEAS in NAV …nice reporting functions are available from NAV 2015:  EX: RUNREQUESTPAGE, EXECUTE, PRINT, SAVEAS MY BEST FUCTION IS:  “RUNREQUESTPAGE” -> “ This function lets you run a request page for a report, without actually running the report. When the user clicks OK, the function simply returns a text value , which is an XML document describing the user’s selection and filters of the request page.”; you can use this function also to schedule a report on Job Queue (OnDemand report schedule) ex: a reports launcher page, scope of this page is run selected reports and generate PDF files after reports printing (or after preview mode report printing) The system use fiunction REPORT.RUNREQUESTPAGE to read and retrieve reports parameters RUNREQUESTPAGE XmlParameters:= REPORT.RUNREQUESTPAGE(intIDReport); … after you get the following XML document as a result: EXECUTE Now is time to run report with EXECUTE f...
Post a Comment
Read more

Powershell Script to create a “Self-Signed Certificate” that works on Dynamics NAV Ipad APP

Powershell Script to create a “Self-Signed Certificate” that works on Dynamics NAV Ipad APP Powershell Script to create a “Self-Signed Certificate” that works on Dynamics NAV Ipad APP   PURPOSE Automated scripts (with Powershell) to create a self-signed certificate usable for Dynamics NAV App on Ipad (if you haven’t a Real Verified Certificate): Powershell automation based on procedure manual “ How to get Microsoft Dynamics NAV for tablets to connect using a self-signed certificate” http://blogs.msdn.com/b/nav/archive/2014/10/09/how-to-get-microsoft-dynamics-nav-for-tablets-to-connect-using-a-self-signed-certificate.aspx STEP 1: REQUIREMENTS FOR USE PRE-USE CERTIFICATE “SELF-SIGNED” – Best Practice Microsoft  suggest  to use a valid certificate  (ex: Purchased from Verisign) – Suggested (but not mandatory) is to install at least the cumulative NAV Update 8 2015 (CU8), it needs to use better management of self-signed certificate (unoffici...
Post a Comment
Read more