SQL Server


‘MEDIALAYOUT’ in SQL Server ConfigurationFile.Ini

While trying to install new instance of SQL Server using command line and the ConfigurationFile.ini unattended answer file, you may receive the following error message : MEDIALAYOUT in SQL Server ConfigurationFile.Ini Don’t waste your time searching in different documentations about the allowed keywords for the configuration file. This error means […]

SQL Server Logo

Could not obtain information about Windows NT group/user ‘domain\user’, error code 0x5

When getting this error message Could not obtain information about Windows NT group/user ‘domainname\username’, error code 0x5 in SQL Server you may be wondering what’s happening. This error message can happen in numerous occasions and while executing different T-SQL Statements, such as xp_logininfo

Or while executing sp_xp_cmdshell_proxy_account while you […]


Automated maintenance for SQL Server Express

One of the drawbacks of using Express Editions of SQL Server is the lack of working SQL Agent Jobs. In particular when you are using Ola Hallengren’s excellent maintenance solution for backups and other maintenance tasks. His FAQ just suggests that you use sqlcmd to execute the stored procedures, but […]