It's been so long that I really don't remember the details either, but I think there is an .exe file in the wwwroot folder where BP is installed that you can run to change the DB pointer... Unfortunately I don't recall the name, but I think it may have "config" or "setup" in it.
Another thing I do remember is that you need to sync the BusinessPortal DB user to the current db. So run something like this on the newly created test db:
Alter user BusinessPortalUser set login=BusinessPortalUser
Or this if it's a very SQL version (2008...)
sp_change_users_login 'Update_one','BusinessPortalUser','BusinessPortalUser'
------------------------------
John Lian
Principal Consultant
The ERP Group, LLC
portland
------------------------------
Original Message:
Sent: Jul 14, 2022 10:33 AM
From: David Safstrom
Subject: Business Portal - Repoint to Test Databases
Does anyone have any thoughts on the above questions. I know part of it has to do with the web.config file but there must be additional steps. I have researched the issue and cannot find any information. I have check BP documentation all the way back to version 7.0 and can't find anything.
------------------------------
David Safstrom
Senior Consultant
NexTec Group
Roswell GA
Original Message:
Sent: Jun 29, 2022 10:59 AM
From: David Safstrom
Subject: Business Portal - Repoint to Test Databases
I have a client that is setting up a test environment for SL 2011, long story why they are still on it, and need to repoint the Business Portal instance to the test databases.
It has been a long time since the need to connect to a different database. Can someone please refresh my memory.
Thanks in advance.
------------------------------
David Safstrom
Senior Consultant
NexTec Group
Roswell GA
------------------------------