SQL Server error 229 occurs when users try to execute a SQL query. It may also occur while trying to connect to the database server. The error message displayed is “The SELECT permission was denied on the object.” The user account executing the query or stored procedure lacks the necessary permissions, causing the error. In this post, we will discuss the causes of this error, and the steps you can take to resolve it.
MS SQL Server
How to match passwords for SQL Logins
Whenever a SQL login is created using password, it is assigned a unique SID and then converted into a hexadecimal hash value.
Fixed: SQL Server Query Performance Issue
Troubleshooting SQL Server query slowness issue. Query optimization through parameterization. Fixing duplicate plan issue.
SQL Server Hardening: Initial Checklist
SQL Server is a popular database management system that helps organizations store, manage, and analyze large amounts of data. With the rise of cyber attacks and data breaches, it’s crucial to harden your SQL Server to protect your data from unauthorized access and malicious activities. This SQL Server Hardening post will guide you through the first steps to harden your SQL Server and secure your database.
Fixed: Login failed for user ‘(null)’
Cannot connect to SQL instance.
Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)
Error Number: 18452
Severity: 14
State: 1
SQL Server Replication Error 113 – Missing end comment mark ‘*/’
Replication is one of the trickiest things in SQL Server and especially when you don’t know the solution of the issue. One such issue we faced a few days back which we were able to solve using a small trick. Here is what happened.: Snapshot got generated on publisher but failed to apply on subscriber. … Read more
Transparent Data Encryption In SQL Server
Introduction
SQL Server Transparent Data Encryption (TDE) is a security feature. TDE is known as encryption at rest. Database files and backups are protected from unauthorized access using AES or 3DES algorithm.
Row was not found at the Subscriber
We got one replication related alert for one of the critical database. Distribution agent was failing with below error message: The row was not found at the Subscriber when applying the replicated DELETE command for Table ‘[dbo].[TableXXX]’ with Primary Key(s): [PrimaryKeyID] = 12345678 (Source: MSSQLServer, Error number: 20598) Above error could be seen in replication … Read more
Upgrade OS on MS SQL Server Box
Recently we got one request to upgrade OS of a MS SQL database server. Customer asked us to perform in-place upgrade from Windows 2012 datacenter to Windows 2019. We educated customer that in-place upgrade should be avoided considering associated risks. However, customer was fine with risks considering it was a development database server. Anyways, customer … Read more
SQL Server performance tuning – how to look for memory issue
We in the first post saw how capturing and analyzing wait statistics can help a SQL DBA to look for potential performance issue. In the second post we looked at some of the example and potential scenario of wait stats which were similar to a production environment. In this post, we will see how we … Read more