Sync User Error on Nav 4.0 SQL 2008 R2

GreatMahar

Dear Experts,

I am trying to move Nav 4.0 SQL DB from SQL 2000 to SQL 2008 R2. When trying to Sync the user with roles, Attached Error Occurs. Is there any solution for this? Thanks in advance for you help and I hope to get back suggestions asap. Thanks alot.

Best Regards,
Mahar

mohana_cse06

http://www.mibuso.com/forum/viewtopic.php?f=23&t=28333&start=0

GreatMahar

Dear Mohana,

I have the admin right on server and give all the sql roles to user that i initiate the sync. To upgrade to 4.03 means, you just want me to change the client and change the db version no. in Nav DB??

Thanks for your reply.

Best Regards,
Mahar.

mohana_cse06

GreatMahar wrote:

To upgrade to 4.03 means, you just want me to change the client and change the db version no. in Nav DB??

I never know we can upgrade like this also :-k

Are you an end user?

GreatMahar

Dear Mohana,

I am not from end user. My customer still got no time to upgrade the version yet. This is how i tried out only. I have restored db in 4.0 SP1, can Sync properly with no problem. I use the 4.0 SP1 client but i go and change db version in sql table from 30 to 40, there got no error and i can sync too. But these are not the proper ways. I would like to get solutions with proper ways. Thanks.

Best Regards,
Mahar.

mohana_cse06

GreatMahar wrote:

But these are not the proper ways. I would like to get solutions with proper ways.

The proper way is suggested by kine in above link

I advise to upgrade to klient NAV 4.03 to use Normal security mode and you do not need to syc anymore...

GreatMahar

Dear Mohana,

Thanks for your time and help. Means that there got no way to use NAV 4.0 on SQL 2008 R2??

Best Regards,
Mahar.

mohana_cse06

No, only way is to upgrade to 4.0SP3 to use SQL 2008 and 5.0SP1 to use SQL R2