Welcome to our Knowledge Base
Enter your search terms below.
No access to the database after restoring
Description of the problem
The steadyPRINT database user looses database permissions after a database restore.
After a restore of the steadyPRINT database, the steadyPRINT database user has lost its permissions for accessing the data base.
While setting the permissions the error code “15023” appears. This is a Microsoft error, described in the following MS article: support.microsoft.com/kb/819261/en-us
Solution
For solving this problem you have to run the following SQL query and replace it with your steadyPRINT database user and password:
USE PrinterMap GO EXEC sp_change_users_login'
Auto_Fix'
, '
pm'
, NULL, '
printerMapping1!'
GO
ID: 21669 | Zur deutschen Version