Is it possible to configure SQL server alias names on an existing SharePoint 2010 farm? A lot of info out there suggests that this is done during the installation of SP, but I am not see much info on performing this after the fact. The farm I currently manage was inherited; meaning the admin before me did not set this up during the initial install of the farm. Any advice would be greatly appreciated.
This is the only way to do it. Yeah, it might be confusing, but for the Config/Admin database, it is the only option available post-psconfig.
There is no reason you wouldn’t be able to do it afterwards. However, it could be confusing namewise.
I have previously solved this by creating an alias with exactly the same name as the current sql server that the farm is configured with. By doing it this way you should be able to skip all configurations..
I´m not sure if this is a good way to solve it, since it causes some confusion. I would also recommend to try this on a test environment prior to production servers.
