Wednesday, April 15, 2020

Infor CSI Installation and Database Server Change name after install


If you are facing the same with me . I have duplicate CSI VM to changing VM name for CRP but after change server name we found we can't create customer order online . we have checked because of server name of SQL still the same of live so you have to use my script as below  after that you have to restart SQL Service and try to create customer order line again.

select @@servername

exec sp_dropserver 'Current SERVERName'


exec sp_addserver 'To be SERVERName','local'

select @@servername


How to fixe database in restoring mode

  RESTORE DATABASE YourDatabaseName WITH RECOVERY;