So it turns out I have an old password on my 2005 SQL server that does not meed the current Domain password requirements. I have not renewed it yet as it is running my production database. I am also in the middle of bringing up a new test production database server at a different site we'll be moving to in a few months. The sa password on the SQL 2014 instance is sufficient to meet the domain password requirements. Obviously both passwords are different. I believe this password is keeping me from connecting to my new db on the new server. I can think of two options but will need some guidance.
1. I can set the existing 2005 sa password to the same as the 2014 sa password on the new server. Question is, will that kill my existing db or can I just set the password and stop/restart and all is good?
2. I can set my login to the same User Mappings as the 2005 sa logon and make the same changes to my 2014 logon. I think this on is more work and error prone than the first?
Once I do either of these I will need to do another 2005 db backup of all the databases then copy and restore them to the 2014 instances.
Am I missing anything?