Synchronization from SQL?

Storm
Storm Member Posts: 27
edited 2008-09-15 in SQL General
Hi

We have created a new database in NAV with many data in it... we then created some users but before we could Synchronize with the SQL database the client crashed and now we cannot get access to the database... saying that the username and password does not match...

We are pretty sure that we need to synchronize the database with the SQL server but we cannot do that from NAV since we no longer have access to this... so perhaps it is possible from the SQL server?

Anybody can help?

Thanks

Comments

  • dougmiles
    dougmiles Member Posts: 4
    I'm not sure that this is the right way, but I had an almost identical symptom recently that I had to resolve.

    In the SQL database, select one of the user accounts that you will be using, preferably a SUPER user. Set that user as database owner (database role=db_owner). You should then be able to go to NAV, log in as that user, and synchronize.

Categories