1. Run Query Analyzer
Select POST database and Exceute the following command
Select sid from sysusers where name = 'DCL'
Eg. The result like this 0xB7165F12378..........
Copy this value
2. Execute these commands one by one
sp_configure 'allow updates', 1 Highlight the query Press Ctrl E
reconfigure with override Press Ctrl E
3. Select Master databse and excute the following statements:
Update sysxlogins set sid = <Paste previous copied value eg. 0xB7165F12378.........>
where name = 'DCL'
4. Execute these commands one by one
sp_configure 'allow updates', 0 Highlight the query Press Ctrl E
reconfigure with override Press Ctrl E
Select POST database and Exceute the following command
Select sid from sysusers where name = 'DCL'
Eg. The result like this 0xB7165F12378..........
Copy this value
2. Execute these commands one by one
sp_configure 'allow updates', 1 Highlight the query Press Ctrl E
reconfigure with override Press Ctrl E
3. Select Master databse and excute the following statements:
Update sysxlogins set sid = <Paste previous copied value eg. 0xB7165F12378.........>
where name = 'DCL'
4. Execute these commands one by one
sp_configure 'allow updates', 0 Highlight the query Press Ctrl E
reconfigure with override Press Ctrl E
0 comments:
Post a Comment