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.