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: sP00000 | Created on: 2013/01/15

Back to overview