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%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Back Incorrect Client name after taking over session
Next No connection to database
btnimage