SQL Server Security Archives - Page 11 of 47 - SQL Authority with Pinal Dave

SQL SERVER – You Are Not Logged on as the Database Owner or System Administrator

November 2, 2018

SQL Documentation, SQL Error Messages, SQL Server, SQL Server Security

Every day I spend a good amount of time with my regular and new clients, helping them with SQL Server Performance Tuning issues. Today, in this blog, I will discuss a situation faced where I was engaged in Comprehensive Database Performance Health Check. I saw below message on client’s SSMS while he was trying to create a table – You are not logged on as the database owner or system administrator.

SQL SERVER – Azure Key Vault Deletion Error – Vault ‘ProdRecoveryVault’ Cannot be Deleted as There are Existing Resources Within the Vault

October 16, 2018

Pinal Dave

SQL

Powershell, SQL Azure, SQL Scripts, SQL Server, SQL Server Security

Along with my performance consulting, I also help many clients in fixing some quick issue. You can refer to various consulting services which I provide. This blog is an outcome of one such engagement where the has Azure Key vault and was not able to delete it. In this blog, we would learn about how to fix error Vault ‘Name’ cannot be deleted as there are existing resources within the vault.

SQL SERVER – How to Change Authentication Mode Using T-SQL Query

October 13, 2018

Pinal Dave

SQL

SQL Scripts, SQL Server, SQL Server Security

One of my clients asked an interesting question. It took a while for me to figure out the answer so sharing with my blog readers. In this blog, we would learn how to change authentication mode of SQL Server using T-SQL query instead of SQL Server Management Studio.

Azure Virtual Machine – You Must Change Your Password Before Logging On The First Time

October 10, 2018

Pinal Dave

SQL

SQL Azure, SQL Error Messages, SQL Server, SQL Server Security

One fine day when I tried connecting to my Azure Virtual Machine in a cloud, I was welcomed with this error message.

SQL SERVER – Error: 45207 – SQL Server Managed Backup to Microsoft Azure Cannot Configure the Database Because a Container URL was Either not Provided or Invalid

October 4, 2018

Pinal Dave

SQL

SQL Azure, SQL Backup, SQL Error Messages, SQL Log, SQL Scripts, SQL Server, SQL Server Security

While using SQL Server on Virtual Machines in Azure, I ran into an interesting error. In this blog we would learn how to fix Msg 45207 – SQL Server Managed Backup to Microsoft Azure cannot configure the database ‘sqlauthdb’ because a container URL was either not provided or invalid. It is also possible that your SAS credential is invalid.

SQL SERVER – FIX: Error – The Job Failed. Unable to Determine If The Owner Domain\User of Job Job_Name Has Server Access

August 20, 2018

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

I keep on breaking my lab environment and have learned many things from it. Here is one of the recent errors which I fixed. In this blog, we would learn how to fix error “The job failed. Unable to determine if the owner of job has server access.” While executing a SQL Agent job.

SQL SERVER – How to Generate Random Password? – Enhanced Version – Part 2

August 15, 2018

Pinal Dave

SQL Tips and Tricks

, SQL Password, SQL Random, SQL Scripts, SQL Server, SQL Server Security

I have previously written about Random Password before in the blog posts here, here and here. This blog is sent by James Curran, who has created the following generate random password stored procedure keeping the base of the original solution of Tim Cartwright. Thanks to both of this individual SQL Server Expert who has helped me to come up with a more robust solution for a random password.