Synchronize users from the NAV database to external SQL server database

Business Central/NAV Technical Forum
1

Hi

I am new to Dynamics NAV. In our project we have got a task to Synchronize the users from the NAV database to external SQL server database.

Could you please let me know the process and steps involved here.

Could you please provide me some good links regarding this topic or any suggestions for me. Thanks in advance.

Regards,

Usha.

2

Go to Tools → Security → Synchronize all logins. This will synch nav logins with SQL logins. Go through this link.

http://msdn.microsoft.com/en-us/library/dd568725.aspx. This would help you

3

Do you mean that you have a second SQL Server, besides your NAV server, on which you need to have the same users as your NAV server? If that’s the case then see the following article.

http://support.microsoft.com/kb/918992/

4

Hi Kathik,

Thank you for your reply. Do you mean here synchronization between SQL server in Nav server or is it an external SQL Server database. Please explain more.

Thanks and regards,

Usha.

5

Hi Babown,

Do you mean if it is synchronising an external SQL server DB and the database in Nav 2009 means do we need to use SSIS pcakage. Please let me know.

Thanks and regards,

Usha.

6

Can you explain in more detail what you are trying to do?

7

Hi Babown,

Thank you for your reply. I am thinking Navision is hosted on SQL Server 2005 and if we add any data in Navision should come to SQL server 2005(hosted one) in the Navision and is this the Synchronisation of Nav 2009 with SQL Server 2005.

If this understanding is correct can you please provide me links to know about this Synchronization.

Please suggest.

Regards,

Usha.

8

I have to admit I’m now more confused. Are you talking about syncing user between two databases? That is the same users exist in both. Or are you asking about syncing data?

9

hi Babrown,

Thank you for your reply. I am not clear what the process involves when we say synchronizing user logins between Nav database and SQL database. Can you please explain.

Thanks and regards,

Usha.

10

Hi Usha,

Go through this link. You will get idea about security synchronization.

http://dynamicsuser.net/media/p/3851.aspx

11

hi Babrown,

Thank you for your reply. Do we use SSIS to synchronise the users between Dynamics Nav 2009 and SQL Server 2008. Please suggest.

Regards,

Usha.

12

hi Babrown,

Thank you for your reply. I am talking about synching the data between Dynamics Nav and the SQL Server. Do we use SSIS to synchronise the data between Dynamics Nav 2009 and SQL Server 2008. Please suggest.

Regards,

Usha.