troubleshooting Question

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

Avatar of PDIS
PDIS asked on
DatabasesMicrosoft SQL Server
2 Comments1 Solution86 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Bharat Bhushan
Solution Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros