Breaking News
Loading...
Sunday, 7 September 2014

Info Post

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.


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

Download

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

0 comments:

Post a Comment