I have this copy of my old Navision 3.60 / SQL Server 2000 database from my old company BMI Partners, which I really want to pull out some data (customers/contacts and some reports).
I have attached the database again to my SQL Server 2005 server.
But now comes the tricky question. I remember my user name (can also look it up in the User table - so a database user not an ad/windows user). But I don't remember my old password.
I have created a new SQL user with the same name.
But I can not log into the system.
Don't forget to "Verify Solution" the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.
Hi Erik
Try after deleting all user & windows users after opening table from sql mgmt.
Ashish Bhardwaj
Erik,
"New" user is not the same, as name doesn't mean anything - like in Windows, SID is used, and recreating user with the same name creates different SID.
If you can access User table with SQL tools- try to delete ALL records from it - thus removing login control, as in CRONUS...
Modris Ivans MCP-Dynamics NAV ApplicationPlease specify in your posts1.product and DB version;2.locale, or use International Forums"Verify Solution" to post that helped you solve your problem
Thank you Modris,
That worked perfectly!
When I do this, I prefer just to create a new user. Just go to an existing NAV database on the same machine with windows log ins, there you can copy the SID and paste it into the old database. Then copy the SUPER group. That way you keep all the old setup.
I guess it depends if you need the other stuff or not. Problem with deleting the data is inconsistencies with the User Setup table.
David Singleton - MVP Dynamics NAV Dynamics NAV Consultant since 1991 Available for Navision Go-Live assistanceDynamics Book