This article talks about common errors seen when deploying and using SQL Server Docker containers, and provide troubleshooting techniques to help resolve the issue. Docker command errors If you get errors for anydockercommands, make sure that the docker service is running, and try to run with ele...
Logging on to the server interactively using the service account isn't recommended and is blocked in many secure environments. Changes to the configured proxy settings might require restarting the SQL Server instance to take effect as they're cached when the Connector first attempts to connect ...
With a little bit of troubleshooting, we figured out that the RunAs Administrator (it can really catch you off-guard) option was not used to launch the command prompt. So when running such VBscripts, do not forget to use RunAs Administrator option! Now let us look under the hood a bit!
We traced it back to a faulty RAID controller and, after doing some research, we're turned on checksums on the database pages. My question is: How can I tell when there's a checksum problem without waiting until the monthly maintenance plan?
General troubleshooting tips Make sure to provision Read and Write permissions to the SQL Server Service account on the folder that the backups are being written to. For more information, seePermissions for backup. Make sure that the folder that the backups are being written to have enough spac...
No troubleshooting effort goes without uncovering additional tips or tricks. Kerberos Cache = KEYRING Make sure your Kerberos cache is KEYRING (DIR works as well) and not FILE or MEMORY. For example, the default (/etc/krb5.conf) on Ubuntu set the cache to the type...
Error message when you connect to a cluster virtual server by using the named pipes protocol: "The machines selected for remote communication is not available at this time." http://support.microsoft.com/kb/306985/ Technorati Tags:Setup Troubleshooting,SQL Server 2008,Cluster Setup ...
Troubleshooting SQL Server AlwaysOn Vijay Rodrigues Summary: SQL Server AlwaysOn is the latest High Availability (HADR) offering in Microsoft SQL Server. SQL Server AlwaysOn has been introduced in SQL 2012. This document is meant as a quick reference. This document has common troubleshooting ...
My last post of debugging an assertion didn’t have any cool debugging tips since there is not much that you can do with an assertion dump unless you have access to private symbols and sometimes even access to the source code. In this post, I am going to not disappoint and show you so...
The change_tracking_* table(s) are internal. When you enable a table for CT, SQL Server creates this internal table to track and store the changes. You can use the below query to see all the CT internal tables and the corresponding base table. ...