One of my blog readers contacted me via email for an error message which he was receiving while using the backup to URL feature. Using this feature, SQL Server can take database backup directly to Azure Blob Storage. I have already written a blog about few errors which I received earlier but this error was new. I replied him asking more details and it was an easy error to fix. In this blog we would discuss how to fix 3271, The remote server returned an error: (403) Forbidden.
SQL SERVER – Why SQL Server Service is Stuck in Starting / Change Pending State?
Recently, I wrote a blog about “Change Pending” state of SQL Server service. After looking at that blog one of my readers contacted me via email for the “similar” issue. In this blog, we would learn about another variation of “Change Pending” state.
SQL SERVER – How to Execute the Query Without Using Management Studio?
One of my clients asked few interesting questions during my performance tuning consultation. If you are interested, you can check more details here SQL Server Performance Tuning and Optimization. In this blog, we would discuss how to execute the query without SQL Server Management Studio (SSMS).
SQL SERVER – Unable to Start SQL Server Agent. Error – Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed
If someone tells me any situation, the first question which I always ask is “What is the error message?”. Now to get the right error message, it is important to look at the right log file. In this blog, we would learn about SQL Server Agent startup issue.
SQL SERVER – Unable to Start Jobs – Error: Enumerate Target Servers Failed for Job
They showed me below error when they were trying to run a job. Let us see how we can fix the error Enumerate Target Servers Failed for Job.
SQL SERVER – Don’t Ignore Warning: Cluster Resource DLL Update Restart Check
This was one of the hard lessons learned, so I am sharing with blog readers. This is about an error in cluster resource DLL.
While applying the patch to SQL instance, I cluster, sometimes we get warning “Cluster Resource DLL Update Restart Check.” If we check Detail.txt file in setup logs, we will find below.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘sqlagent100_msdb_upgrade.sql’ – Error: 5041: MODIFY FILE Failed
I have helped many clients in upgrade failures via my On-Demand consulting and I am amazed to see various ways which can break SQL Server upgrade. In this blog we would learn about fixing error Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’