So after moving all my databases to the new SQL server I run this on my SharePoint central admin box, http://technet.microsoft.com/en-us/library/cc512725(v=office.15).aspx#Man
Everything goes through and I can see connections to my new configuration database. So I detach the original from the old SQL server and when I try to open SharePoint Powershell I get the following:
the local farm is not accessible. cmdlets with featuredependencyid are not registered
As soon as I reattach the old SQL database everything works again. I assume SharePoint is referencing that old database somewhere but I can not for the life of me find the reference.
I have tried to do the following to no avail:
Connect-SPConfigurationDatabase -DatabaseServer "sql-db-alias" -DatabaseName "SharePoint15_Config" -Passphrase (ConvertTo-SecureString "yourpassphrase" -AsPlainText -Force)
I AM running it as an administrator, and I have checked all the permissions on the new SQL server to have full rights to this database. Still nothing. Help!