Synchronizing Errors

eagle_eye

NAV 2009
I am a super user
I am SQL dbo & sysadmin

I have a Cronus DB installed on SQL 2008 with a 'Production' company in it.

I am having issues getting RTC clients to work - so I decided to try just SQl classic client - but I get the following error when trying to connect via classic SQl client:

15161, "42000" Cannot set application role because it does nbot exist or the password is incorrect (I'm using windows logins).

I decided to check if the lohghins were synched ...

When I tried to synch the login (just one) ... I get the following error:

15151, "42000", [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the user because it does not exit or you so not have permission

SQL: GRANT, SELECT. INSERT, UPDATE, DELETE ON "Object" TO ..

Help please!! I am at aloss of what else I can do here. Thank you.

David_Singleton

Change the security model from Enhanced to Standard.

eagle_eye

From where do I do that?

David_Singleton

eagle_eye wrote:

From where do I do that?

File -> Database -> Alter

on the "Advanced" Tab

Security

---

Model . . . . . STANDARD

Ian_Piddington10199

You will need to have the SQL database running in single user mode in order to make the change.

Ian

eagle_eye

Thank you !!

That worked.