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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
"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.
Bharat BhushanSolution ManagerCommented:
There are following reasons of this error:

  • Login is not available
  • Incorrect password
  • Windows Authentication is not in mixed mode
  • Damaged logins etc

In this blog you can get useful solutions to fix this error: https://dzone.com/articles/sql-server-error-18456-best-solution-to-fix-it


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.