Some users may be experiencing issues when trying to access customer resources like the Case Portal or the Product Licensing Center. Our team is aware of the issue and is working to resolve it. Click here for more information.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Moving SCCM DB to a new server

Hello - We have moved our SCCM DB to a new SQL server and it is now listening on a custom port.   The old DB still exists on the old server for now, in read only mode.  

Under Site Admin -> Settings -> Deployment we have updated the DB Server name field in the format <servername>,<port #>, and the Test button says everything is fine.  However, it seems the App Portal is still referencing the old SQL server.   When we lookup Apps / Packages on the CI Deployment tab, to associate CIs to CM objects we do not see new objects that were created after the migration.   And we continue to see objects that were deleted from CM since the migration.  

Are there any other places to reference the new SQL server name?  

Thanks-

(1) Solution
CharlesW
By Level 12 Flexeran
Level 12 Flexeran

On the SCCM server where the ESD Web Service is installed, open the web.config in C:\Program Files (x86)\Flexera Software\App Portal Web Service. You will want to update the connection string to the SCCM DB in this file. You will want to recycle the ESDWebService application pool after doing this.  There are no other locations where SCCM DB connection strings are defined, so I think that this should take care of the problem.

View solution in original post

(1) Reply
CharlesW
By Level 12 Flexeran
Level 12 Flexeran

On the SCCM server where the ESD Web Service is installed, open the web.config in C:\Program Files (x86)\Flexera Software\App Portal Web Service. You will want to update the connection string to the SCCM DB in this file. You will want to recycle the ESDWebService application pool after doing this.  There are no other locations where SCCM DB connection strings are defined, so I think that this should take care of the problem.