Thursday 4 December 2014

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

12:04  AMIT KUMAR  No comments

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.
at 12:04

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)