Run Query analyzer, select ‘Master’ database and execute the following command –
>· Select sid from sysxlogins where name = ‘DCL’
>For example: The result of this command may be as follows:
>0x603B633FF489D411AD9A000021DD037E
>2. Execute these commands one by one
>Ø sp_configure ‘allow updates’,1 Press Ctrl E
>Ø reconfigure with override Press Ctrl E.
>3. Select ‘post’ database and execute the following statements:
>Ø Update sysusers set sid = 0x603B633FF489D411AD9A000021DD037E
> where name = ‘DCL’
>
>Note: Value of sid obtained by step 1 has to be used in the above update statement.
>Repeat step 3 after selecting the other four (BPRO, BPLOG, SOSB, SIGN and SO’s if necessary) databases one by one and executing the same query. After all the databases have be modified with the SID, go to the next step.
>
>4. Execute these commands one by one
>Ø sp_configure ‘allow updates’,0 Press Ctrl E
>Ø reconfigure with override Press Ctrl E.
>
>5. You can now run the data entry / online transactions as usual.
