• Repost - originally posted 01-10-2012

SQL Server 2008R2 silent installation issue

We had a question the other day with a client trying to install SQL Server 2008 R2 (yes people are still using and installing SQL Server 2008R2 – in this case to support a legacy application that the vendor will not upgrade) doing a silent mode installation on Windows 2003 server and on Windows 2008 it gave the error : SQL Server setup has encountered following error \is not a valid value for setting 'ACTION' ERROR CODE:0X84B40000. The issue came down to something quite simple - not double quoting the configuration file parameter. See the following link. https://connect.microsoft.com/SQLServer/feedback/details/522592/sql2008r2-install-admin-script-fails-with-action-null


Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t