Creation by Ankur the ' IT Guy '

Hi guys , This post is about the silent installation of SQL Server Express Addition.. I was searching for " SQL Installation using Command Prompt "  and i got something very interesting on Technet Forums to do it..  More Info:   http://social.msdn.microsoft.com/Forums/sqlserver/en-US/835c123e-7c3e-4eef-bc47-e2ee700187c1/sql-server-express-silent-installation How you can do it To install SQL Express in quiet mode open Command Prompt with Administrative privileges  type the following Command line Setup.exe /q /Action=Install /Hideconsole /Features=SQL,Tools /InstanceName=SQLExpress /SQLSYSADMINACCOUNTS="Builtin\Administrators" /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword> In the preceding example: /q– specifies that Setup run in a quiet mode without any user interface. /Action– specifies which action to perform. In this example, the action is Install. /Hideconsole– specifies that the con...

Hi Guys , recently i thought most of us ignores SCCM Warnings when Prerequisites Check detects them. As we ignore them & after some  time Warnings Become   Errors. and We Spent hours to solve them... Warning Mostly Ignored..... 1. WSUS binaries 2. Sql Server Memory Usage Configuration 3. Sql Server Process Memory Allocation AS Shown in Screen Shot  Here is the work around that u can do to solve them 1.   WSUS Warning can be solved by ----Installing WSUS 3.0 SP2 2.     Any warnings related to memory you can resolve them in the  SQL Server Management Studio . Steps: Right click in the Database Engine and Select Properties. Now change the minimum and maximum server memory & click on OK. If you Run Check again the warnings will disappear. If you get an error around the server collation, you will have to replace the current collation. Note: Don't do ...