error while loggin in

(0) Share

Report

Posted on by Sulav Raj Thapaliya

127

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

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

Request your system admin to create a user login to you.

msdn.microsoft.com/.../dd355093.aspx;MSPPError=-2147217396

Was this reply helpful? Yes No
Suggested answer

Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

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 :-)

Was this reply helpful? Yes No
Verified answer

Raja Venkat 192 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

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.

Was this reply helpful? Yes No