Just to confirm, owning two accounts is perfectly fine. Just remember that you will lose all progress you have made - it will be a truly new account.
If you are logged in on your "old" PSN Account that was originally linked, and you bought FFXIV on it or registered it to it, you should see the game available for download in your PlayStation Store library. Worth a check! If you installed the game from a physical medium (BluRay retail version of the game), try reinstalling it from that while having that account active.