This post is based on a document I wrote a long time ago as part of my DBA knowledge transfer to other DBAs. It’s also goes hand in hand with a question I like to ask in interviews: ‘Someone has raised a ticket with your IT Service Desk and assigned Continue Reading
Troubleshooting
SSRS Database Migration – Cannot View Subscriptions
Moving the SSRS database to another server is a fairly straightforward process. You can detach/attach or Backup (copy_only)/Restore or even generate scripts (really?). The only other thing to do is point reporting services to the new report server database using Reporting Services Configuration manager and you are all set. Unless Continue Reading
2 Issues with PowerShell Steps in SQL Agent
Both of the issues I’m going to discuss have been documented before but for my own benefit I’m going to put them on my blog as they are bound to come up again one day.. Unable to start execution of step 2 (reason: line(50): Syntax error). The PowerShell Script works Continue Reading
Login Failed for User ‘NT AUTHORITY\ANONYMOUS LOGON’
I was recently asked to look at an issue that was occurring when someone tried to run a simple SELECT query on a table. The error they received was ‘Login Failed for User ‘NT AUTHORITY\ANONYMOUS LOGON” Strange. The first thing I did was run a query using my own account Continue Reading
SQLPS Error After Upgrading PowerShell
Another Error I thought that was worth blogging about. I upgraded to PowerShell 5.1 and then suddenly the SQLPS module seemed to disappear. When I start PowerShell, the SQLPS module should be automatically loaded but I received the below error. Even manually importing the module wouldn’t work. So I needed Continue Reading
The Proposed New Database Owner is Already a User or Aliased in the Database
This was a strange one although to be fair, the error message is self-explanatory but the root cause may not be. This error occurred after an attempt at changing the Database Owner. The account I was changing to was already listed as the database owner in the Login Permissions but Continue Reading