Deactivate automatiocal synchronisazion

MarcelW

Hello,

is it possible to deactivate the auto sync.

The Problem:
In Navision are much users in the user table.
It seems like all users cant be synchronized.
Why -> I dont know!
All users exists with the same names in the SQL Server
as DB User?!

So, i want to delete all users and create some new.
But when i try to delete a user the synchronization
starts and finds another user wich cant be synchronized
and the prozess breaks.

Result: I cant delete a user because the sync failed every time.
but i have to delete the users to create new ones wich can be synchronized.

Is this a trap?
Is there a way out of this problem?

Thanks

ara3n

I haven't seen this, but try to filter on users that don't exists and delete them all at once.

kine

You must be db_owner to do this job... mainly if you are using MS SQL 2005...

MarcelW

Hello,

Whatever i do - it doesnt works.
Ich cant delete one or more or all user at once in navision,
because the auto sync says: User xy doesnt exists in SQL Server.
If i want to delete Mr.A the system says User Mr.B isnt at the sql server and the same backwards.

At SQL Server Layer i can delete and create users with no problem,
but i have this to do in Navision.

IS THERE NO WAY OUT OF THIS CIRCLE. HELP!

Bye

kine

Are you really using MS SQL 2005 or MS SQL 2000?

MS SQL 2005 is not recommended if you are using database logins...

ovicash

MarcelW wrote:

Hello,

is it possible to deactivate the auto sync.

The Problem:
In Navision are much users in the user table.
It seems like all users cant be synchronized.
Why -> I dont know!
All users exists with the same names in the SQL Server
as DB User?!

So, i want to delete all users and create some new.
But when i try to delete a user the synchronization
starts and finds another user wich cant be synchronized
and the prozess breaks.

Result: I cant delete a user because the sync failed every time.
but i have to delete the users to create new ones wich can be synchronized.

Is this a trap?
Is there a way out of this problem?

Thanks

Hello

I had the same problem. I use Sql Server 2000.
The only thing I could do was to manualy erase records from table user and member of. Hope it helps.

MarcelW

I tried to delete the record directly in the table.
No chance!

Other ideas?

PS: I do not use SQL Server 2005!

Budishu

Hi

I think i had simular problems when trying to alter the user table in Navison. Are you sure all userID's are in CAPITAL letters? If you create them directly from an SQL server, the names may appear in small caption in Navision.

Jkh