07-31-2023, 09:45 AM
I have faced the same issue. In case you see it, run this query:
```sql
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
```
then it shows a 18456 error code.
Do one thing again run same query after reconnecting SQL server. It will work fine.
```sql
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
```
then it shows a 18456 error code.
Do one thing again run same query after reconnecting SQL server. It will work fine.