Today I renamed the sa account on 23 SQL Server 2005/2008 instances. I used the CMS to assist with this task. Later we realized all of the SQL Agent jobs were failing on these instances with the following error: “The job failed. The owner (sa) of job XYZ does not have server access.” We use sa as the job owner, and it had correctly changed the owner to our new name as the sids had not changed. We were at first confused why the jobs were failing but then realized restarting the SQL Agent service might help. ...
If you use RDP to remotely connect to your servers, you've probably encountered a clipboard issue where copy/paste stops working. A quick Google search on the problem indicates you can easily fix the problem by logging out/logging back in or killing/restarting rdpclip.exe on the remote server. Here's an article which covers this topic. But what do you do when copy/paste is intermittent? It works one second, stops working for 5-30 seconds, and then on its own starts working again. This is what’s occurring in our new non-production environment. The DBA team is setting up 16 new physical servers and...