DCL IS NOT VALID USER IN DATABASES FOR SQL 2000 / 2005 / 2008

Fix  DCL User For Sanchay Post Databases

After Restore the Sanchay Post databases into SQL Server 2000 / SQL Server 2005 / SQL Server 2008 it shows an one of the below error message 

1. Server user 'dcl' is not a valid user in database 'POST'
2. Server user 'dcl' is not a valid user in database 'BPRO'
3. Server user 'dcl' is not a valid user in database 'BPLOG'
4. Server user 'dcl' is not a valid user in database 'SOSB'
5. Server user 'dcl' is not a valid user in database 'PROJECT'
6. Server user 'dcl' is not a valid user in database 'SIGN'
7. Server user 'dcl' is not a valid user in database 'NREGAEMO'

In SQL 2000 we are using SQL SID Query to fix this " DCL is not a valid user in database " issues. But we have no option to fix this on SQL 2005 / 2008.

PoTools Provide Solution to fix DCL user issues in SQL 2000 / 2005 / 2008 . 

Download

• Download attached Patches from PoTools.
• Execute at once after Restore Sanchay Post Databases.