I am moving a database to a new computer. The Windows Authentication is being used, by the user name on the new computer is not the same as the old.
So when trying to access the database when moved to the new computer it says access denied due to name change. How do I get the database on the new machine to take a new name in order to allow access? I tried going in the old machine SQL but it would not accept the new machine name for allowing access.
I tired some solutions I found in web searches but they really did not work for this problem.
I appreciate any help on this. Thanks.
