July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
available database

SQL SERVER – List Database Available for Current User – HAS_DBACCESS

May 16, 2020
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL Server Security

In those scenarios, we end up on a very elaborated training session. Let us learn today about how to List Database Available for Current User.

Read More
authentication

SQL SERVER – Why Server Authentication is Disabled? What Mode is SQL Server Using Currently?

March 18, 2020
Pinal Dave
SQL
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Security

I would share my learning about the cause of Server Authentication mode disabled. If it is disabled, how would you know what mode is used by SQL Server?

Read More
GetToken

SQL SERVER – LogonUserExEx Fails for User & GetToken – Logging on as the CNO Failed With Error 1326

March 17, 2020
Pinal Dave
SQL
AlwaysOn, SQL Error Messages, SQL Server, SQL Server Cluster, SQL Server Security

In this blog I would share my learning about fixing error LogonUserExEx fails for user & GetToken – Logging on as the CNO failed with error 1326.

Read More
process ID

SQL SERVER – Msg 17177 – This Instance of SQL Server Has Been Using a Process ID of %s since %s (local) %s (UTC)

March 9, 2020
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Error Messages, SQL Log, SQL Server, SQL Server Security, SQL Server Services

In this blog today, I would share my understanding of the message “This instance of SQL Server has been using a process ID of”

Read More
administrator rights

SQL SERVER – Install Error – The Account Running SQL Server Setup Does Not Have Administrator Rights On the Computer. To Continue, Use an Account With Administrator Rights

March 4, 2020
Pinal Dave
SQL
SQL Error Messages, SQL Server, SQL Server 2019, SQL Server Installation, SQL Server Security, Starting SQL

In this blog, I would share the steps to identify and fix error – The account running SQL Server Setup does not have administrator rights on the computer.

Read More
GUID

SQL SERVER – Error 15580 – Cannot Drop Master Key Because Dialog “GUID” is Encrypted by It

February 26, 2020
Pinal Dave
SQL
Service Broker, SQL Error Messages, SQL GUID, SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Security

In this blog, I would share my knowledge about how to fix error 15580 – Cannot drop the master key because dialog “GUID” is encrypted by it.

Read More
database master key

SQL SERVER – Always On Error: This Database is Encrypted by Database Master Key, You Need to Provide Valid Password When Adding it to the Availability Group

February 22, 2020
Pinal Dave
SQL
AlwaysOn, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Security

This database is encrypted by the database master key, you need to provide a valid password when adding it to the availability group.

Read More
Previous 1 … 3 4 5 6 7 8 9 … 47 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version