Encountering error messages and solving them is something I often do. I think each and every error we encounter is validating our understanding in using the software and how we make simple mistakes. Let us learn about what we should do when we are unable to drop login.
SQL SERVER – Login failed for user . Reason: Token-based server access validation failed
This is one of the most common error searched on my blog search https://blog.sqlauthority.com/search-sqlauthority/ and lately I realized that I have not written any blog about the cause of such error and fixing that. Let us learn about how to fix the error login failed.
SQL SERVER – Difference Between SQL Login and SQL User – SQL in Sixty Seconds #070
“What is the difference between SQL Login and SQL User in SQL Server?”
SQL SERVER – Importance of User Without Login
Some questions are very open ended. Here is one question I was asked in recent User Group Meeting about user without login.
SQL SERVER – Logon Trigger Feature for Managing Data Access
This blog post is about SafePeak “Logon Trigger” Feature for Managing Data Access. Just a quick update the product is no longer available.
SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
This error is quite common and I have received it few times while I was working on a recent consultation project. Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’. This error occurs when you have configured your application with IIS, and…
Read More
SQL SERVER – Check if Current Login is Part of Server Role Member
I often work on consulting projects with umpteen clients from across the globe. The nature of the works I usually receive necessitates me to take on the role of a system admin. Now, this role is trailed by come common issues. This article revolves around one such concern. Let us learn about Server Role Member.