UBS Software knowledgebase

Description

Reason   : The login.dbo file is corrupted.

Solution

1.        First login to Enterprise Manager in Microsoft SQL Server

2.        Navigate the  data  folder, select table and look for the  table ‘login.dbo’

3.        Highlight by right click the  file , rename to ‘login1.dbo’

4.        Minimize the  screen then  select the  UBS program folder (e.g.  c:\Qubsacc)

5.        Double click the  filename ‘ubssqldb.sql’

6.        Find the  name  ‘login’ by using Edit  >  Find and replace  >  Quick find, type the  name  ‘login’ and enter, system  will highlight the  name  you have  typed  just now. Double click the  login, highlight the  whole script and run Execute button (refer  Fig. 1)

7.        Exit the  whole screen and  finish done.