Welcome to our Knowledge Base

Enter your search terms below.

Categories
< All topics
Print

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

Was this article helpful?
0 out of 5 Stars
5 stars 0%
4 stars 0%
3 stars 0%
2 stars 0%
1 stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
btnimage