Restored Navisoin 5.1 sql database backup. User Management.

delaghetto · 2012-05-04

Dear All..

Yesterday our SQL Server got burned, so today we set up a new Server. I have .bak SQL Database backup of Navision 5.1

I am restoring the backup in our new SQL Server. The thing is that we are using SQL server authentication for all the users, and this users are not created in the new SQL Server.

After restoring the backup, how do I proceed so that all the users continue using the same user from their client?? What I would need is that all the users are created again in SQL Server so that all the users can just open the client, point to the new server, and continue working with their own user.

Do I have to manually create all the users again in sql server, or are they somehow stored in the database so I can just synchronize or something??

Thanks.. best regards!

kriki · 2012-05-04

They need to be recreated:

Check these for some help:
http://www.databasejournal.com/features/mssql/article.php/2228611/Migrating-Logins-from-One-SQL-Server-to-Another.htm
http://www.techrepublic.com/blog/howdoi/how-do-i-transfer-logins-from-one-sql-server-2005-instance-to-another/140

PS: It would be better to use Windows logins or even better Windows groups. In the Windows domain, you can create different groups of users and than create logins for those Windows groups in SQL Server and NAV. It is a lot easier to maintain.

delaghetto · 2012-05-06

Thanks Kriki..

The thing is that the old SQL Server burnt.. so I cannot transfer de logins from the burnt server to the new one.. What would be the less messy way of all the users to continue using their own credentials??

DenSter · 2012-05-06

From SSMS, logged in as a sysadmin, you can read the "user" table in the NAV database, and that should give you all the database users that you need to create on SQL Server. Give them public and assign the NAV database under user mapping, also with public. They'll have to reset their passwords, but they should be able to use their old login IDs.

Restored Navisoin 5.1 sql database backup. User Management.

Comments

Categories