We are in the process of replacing our old Windows 2000/SQL 2000\Navision Server with a much newer Windows 2003 server.
I have built a test rig to iron out any issues, and have hit an obstacle right from day one. The server build and SQL install went fine. I restored our 70GB database onto the test rig, and it seems fine. I can see all the tables etc.
However when I tried to log on it said user-id/password invalid, so I created the user ID, because there were no users in the \security\logins area. This still didnt work either. So what I would like to know is this :-
How do I port across all the user IDs and permissions into the new server? If it is still part of the same Active Directory, shouldnt I just be able to add the new server in and away they go, since we use windows authetication for logging in purposes.