No access to the database after restoring

Skip to main content
Categories
< Alle topics
Print

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