troubleshooting Question

Error logging into SQL server from my program: Could not find a login matching the name provided. [CLIENT:]18456, Severity: 14, State: 5.

Avatar of Justin Blanchard
Justin BlanchardFlag for United States of America asked on
Microsoft SQL Server
4 Comments1 Solution17 ViewsLast Modified:
On a Server 2008 R2 install sits a Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)  that was kept running only to access previous medical records as the company migrated to new software and servers, but medical records need to be kept for 7 years.  on 2/15/21 I see this in the log file, Running SQL Server 2005 SP2 to SQL Server 2008 upgrade script, and a large series of events.  Fast-forward a few months and an Audit pops up plus a product recall and the old database and program need to be accessed. Now when a user attempts to log into the program the user gets rejected for not being a user and the log records the error above.
The original software company wants extortion money to get their old software up and running and I have been tasked with trying to get the software going. Can someone help me get around this error?
I'm thinking permissions and or groups... I am NOT an expert in any of this!!

Join our community to see this answer!
Unlock 1 Answer and 4 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 4 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