Skip to content
Geeks Hangout
  • Home
  • Fixes
  • Tips
  • Scripts
  • Tools
  • About

SQL

Microsoft SQL – Saving changes is not permitted (SSMS Design Mode)

November 27, 2022 by Phil

Have you ever attempted to alter the design on a Microsoft SQL table using the Microsoft SQL Server Management Studio (SSMS) tool. Maybe, to add an additional column, or change an existing columns data type, only to be greeted by …

Read more

Leave a comment

SQL – The SELECT permission was denied [FIXED]

September 4, 2022 by Phil

Recently I had to solve an issue with a users permissions to Microsoft SQL. When running a report from Microsoft Excel, they would get the message; Unable to connect We encounter an error while trying to connect. Details: “Microsoft SQL: …

Read more

Leave a comment

SQL – Use of WITH CREDENTIAL syntax is not valid for credentials containing a Shared Access Signature

September 2, 2018August 24, 2018 by Phil
SQL Server Banner

Overview Recently I wanted to create a SQL Backup Maintenance plan that would backup to an Azure storage blob container. After completing the GUI the backup step would not complete, instead I got the error “Use of WITH CREDENTIAL syntax …

Read more

1 Comment

Unable to manually failover a SQL Availability Group

July 11, 2021March 26, 2018 by Phil
SQL Availability Group Failover 41131

Problem After recently setting up a SQL Availability Group my automatic and manual failovers were not working. When I attempted a manual failover I received the error “Failed to perform a manual failover of the availability group“…..“Failed to bring availability group …

Read more

Leave a comment

SQL Availability Group Setup – The local node is not part of quorum

October 9, 2021March 24, 2018 by Phil
The local node is not part of quorum and is therefore unable to process this operation

Problem While trying to set up a couple of SQL Enterprise servers in an Availability Group I kept getting the message “The local node is not part of quorum and is therefore unable to process this operation” I had already …

Read more

11 Comments

Recent Posts

  • Azure App Services and WordPress with PHP 8.1 / 8.2
  • Microsoft SQL – How to use variables
  • Microsoft Teams – Channel name is already taken [Fixed]
  • Azure Data Factory – How to backup and restore a pipeline

Recent Comments

  • Phil on PowerShell – Notify users of an upcoming AD password expiry via email
  • Amos on PowerShell – Notify users of an upcoming AD password expiry via email
  • Phil on Drift Life App Not Connecting With Camera
  • Not withit on Drift Life App Not Connecting With Camera
© 2023 Geeks Hangout
Hosted by: Cloudways | Ads by: Ezoic | Theme: Generate Press
🛠 The Tools I Use 🛠
Privacy Policy | Contact Me