Copy mssql lbi database and lbi documents

 0 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
MikeL
New Member
Posts: 2
New Member
    I can successfully copy the mssql database and the lawson documents from one lbi environment to another on a different server. But I have to manually go into reporting services Tools-> Services and reset the server names on the EFS, Reporting Services and SmartNote dashboards. The setup is identical between boxes, all I do is update the server name. Since I am only restoring a database from x to y the server name must live as an attribute within the mssql db. However I cannot find it.

    Does anyone know in what table the server names live and in what format? I have found some instances of the names by perfoming a sql search of the 'readable' columns but not all.

    thx