125
I have been geetting "You are not authorized to sign in.Verify that you are using valid credentials and that you have been set up as a user in Microsoft Dynamics NAV." error messages while trying to run client window in demo mode.How do I remove this error?
*This post is locked for comments
Hi Raja Venkatesh,
you missed a step in before query Execution i.e
USE [Database Name]
after this you can run this commands
delete from [dbo].[User]
delete from [dbo].[Access Control]
delete from [dbo].[User Property]
delete from [dbo].[Page Data Personalization]
delete from [dbo].[User Default Style Sheet]
delete from [dbo].[User Metadata]
delete from [dbo].[User Personalization]
Regards,
Ramesh.
Hi Sulav Raj Thapaliya,
Check your permissions SQL Server Management Studio .
Have you set Log on as service right,check by Run--->services.msc --->your instance make your credentials . then check again RTC.
still not working
Databases--->Database--->Security--->users-->user--->Properties-->add membership
db_reader and db_writer /db_owner/admin.
If still not working then
1. Open SQL Server Management studio.
2. Click on New Query form Top Left.
3. Copy below listed query and paste it in query window
delete from [dbo].[User]
delete from [dbo].[Access Control]
delete from [dbo].[User Property]
delete from [dbo].[Page Data Personalization]
delete from [dbo].[User Default Style Sheet]
delete from [dbo].[User Metadata]
delete from [dbo].[User Personalization]
4. Run/Execute the query.
5. Once done, start the service and Start the RTC Client.
Regards,
Raja Venkatesh.
If my answer helped you, please mark it as verified
If you are using Windows authentication, your Administristrator should associate your Windows account (with you SID) to your NAV user (that must be done in NAV). Then it replicates to SQL with the defined set of permissions :-)
Request your system admin to create a user login to you.
msdn.microsoft.com/.../dd355093.aspx;MSPPError=-2147217396
it means that there are users added in users section of RTC but not you.
You need to add your windows login details from backend SQL or delete existing users.
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 (