Link to home
Start Free TrialLog in
Avatar of PDIS

asked on

Event ID 18456 in event viewer and error in application when trying to import database from .bak

I have an application that I'm trying to import a database from backup through the application itself.  I received the following error in the application, USER must a SQL Server Administrator to use this screen.  I have tried this while logged into the computer as two different users both have the sysadmin Server Role in SQL and both have db_ddladmin and db_owner permissions in user mappings to the necessary databases.  When I looked in the event log, I have the following error.  Event ID:  18456 from source MSSQLSERVER.  This error populates in the event viewer as soon as I try to import the database from backup.  I looked in the SQL logs, I have Error 18456, Severity 14, State: 11 logged at the same time.
Avatar of lcohan
Flag of Canada image

"import a database from backup through the application itself." - what IS the actual login that the application uses to "import a database from backup". you need to figure that out first and make sure that the "application login" running the code that does the "import a database from backup " has actually sufficient rights in that particular SQL Server to do so.
Avatar of Bharat Bhushan
Bharat Bhushan
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial