Quickly and easily reporting on all DB's in your SQL Instances on space usage is a requirement that is not that easy to achieve for multiple databases. It can be made simpler with the use of the .sql script that I have created that is available for download.
Error 18456 is the generic error message for Login Failures in SQL Server. Depending on your situation this could be a simple misspelled password or the windows account does not have permission to the Instance and/or database. However I am not looking at those simple issues around this SQL Server error message.
“Error: 18456, Severity 14, State 38. Login failed for user 'DomainServiceAccountName'. Reason : failed to open the explicitly specified database.
Hi, I'm Warwick Rudd, I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting.
In my blog I will look at all things SQL Server as well as some things outside of the SQL Server relm but hopefully you will find them helpful and interesting.