I’m just writing this quick little trouble shooter, because there doesn’t seem to be much on the net about it. And I always seem to forget to do it.
So after doing some database restores and moving things around, I always seem to forget to change the profile partition connection string.
It’s quite simple… Open the Commerce Server Manager…
Right click on the SQLSource and modify the connection string to where your profile database is actually located.
Stack trace: at Microsoft.CommerceServer.Interop.Profiles.ProfileServiceClass.Initialize(String sConfigStore, String sCatalog)
at Microsoft.CommerceServer.Runtime.Profiles.ProfileContext..ctor(String profileServiceConnectionString, String providerConnectionString, String bdaoConnectionString, DebugContext debugContext)