jayprajapati857 · June 4, 2019 05:40 · Jun 4, 2019 · Jun 4, 2019 · Jun 4, 2019
diff --git a/Installing SQL Server 2008 from command line.md b/Installing SQL Server 2008 from command line.md
@@ -4,7 +4,7 @@
 - Download [SQL Server 2008 Express](https://www.microsoft.com/en-in/download/details.aspx?id=1695) 
 - If you want to know all the available Options and Switches which you can make use of this Installation, Run this command ```SQLEXPR_x64_ENU.exe /?``` in command propmp running as Administrator mode and navigating it to the Downloaded path of SQL Server exe.
 - After getting all the Options and Switches use them as per your requirements
-- In this Gist we are going to install only SQL Server 2008 DB Engine. You can also install the other tools from command line, such as [SSAS, SSRS, SSIS]([https://soltech.net/software-development-technologies/ssas-ssis-ssrs/](https://soltech.net/software-development-technologies/ssas-ssis-ssrs/)) and Tools(like SSMS).
+- In this Gist we are going to install only SQL Server 2008 DB Engine. You can also install the other tools from command line, such as [SSAS, SSRS, SSIS](https://soltech.net/software-development-technologies/ssas-ssis-ssrs/) and Tools(like SSMS).
 - The parameters I am going to set are:
 
 	**Instance Name:** SQL2008
@@ -27,4 +27,4 @@
 - After some time I was returned to the main command prompt without any issues and you can also see in config manager with our instance(**SQL2008**) being successfully installed.
 
 ## Helpers
-- [Installation Guide]([https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt](https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt))
+- [Installation Guide](https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt)
diff --git a/Installing SQL Server 2008 from command line.md b/Installing SQL Server 2008 from command line.md
@@ -1,7 +1,7 @@
 
 ## Installing SQL Server 2008 from command line
 
-- Download [SQL Server 2008 Express]([https://www.microsoft.com/en-in/download/details.aspx?id=1695](https://www.microsoft.com/en-in/download/details.aspx?id=1695)) 
+- Download [SQL Server 2008 Express](https://www.microsoft.com/en-in/download/details.aspx?id=1695) 
 - If you want to know all the available Options and Switches which you can make use of this Installation, Run this command ```SQLEXPR_x64_ENU.exe /?``` in command propmp running as Administrator mode and navigating it to the Downloaded path of SQL Server exe.
 - After getting all the Options and Switches use them as per your requirements
 - In this Gist we are going to install only SQL Server 2008 DB Engine. You can also install the other tools from command line, such as [SSAS, SSRS, SSIS]([https://soltech.net/software-development-technologies/ssas-ssis-ssrs/](https://soltech.net/software-development-technologies/ssas-ssis-ssrs/)) and Tools(like SSMS).

diff --git a/Installing SQL Server 2008 from command line.md b/Installing SQL Server 2008 from command line.md
@@ -0,0 +1,30 @@
+
+## Installing SQL Server 2008 from command line
+
+- Download [SQL Server 2008 Express]([https://www.microsoft.com/en-in/download/details.aspx?id=1695](https://www.microsoft.com/en-in/download/details.aspx?id=1695)) 
+- If you want to know all the available Options and Switches which you can make use of this Installation, Run this command ```SQLEXPR_x64_ENU.exe /?``` in command propmp running as Administrator mode and navigating it to the Downloaded path of SQL Server exe.
+- After getting all the Options and Switches use them as per your requirements
+- In this Gist we are going to install only SQL Server 2008 DB Engine. You can also install the other tools from command line, such as [SSAS, SSRS, SSIS]([https://soltech.net/software-development-technologies/ssas-ssis-ssrs/](https://soltech.net/software-development-technologies/ssas-ssis-ssrs/)) and Tools(like SSMS).
+- The parameters I am going to set are:
+
+	**Instance Name:** SQL2008
+
+	**SQLSVCACCOUNT (Service Account for DB Engine):** NT Authority\System
+
+	**AGTSVCACCOUNT (Service Account for SQL Agent):** NT Authority\System
+
+	**SQLSYSADMINACCOUNTS:** Sysadmins on SQL Server. I will add myself here.
+
+	**Features:** SQL(This implies just DB Engine, If you want to Install SSIS, SSRS, SSAS as well on the same server - which you should never do; you can enter IS, RS and AS as well)
+
+	**SECURITYMODE:** Windows Authentication / SQL Authentication - I'll choose SQL in this demo.
+
+	**SQLUSERDBDIR, SQLUSERDBLOGDIR, SQLTEMPDBDIR** are pretty much self explanatory.
+- So combining all together my syntax would become:
+
+	``` SQLEXPR_x64_ENU.exe /?  C:\Downloads>SQLEXPR_x64_ENU.exe /QUIETSIMPLE /ACTION=install /FEATURES=SQL /INS TANCENAME=SQL2008 /SQLSVCACCOUNT="NT Authority\System" /SQLSYSADMINACCOUNTS="jaypc\jay" /AGTSVCACCOUNT="NT Authority\System" /SECURITYMODE=SQL /SAPWD="Pa$$w0rd" /SQLTEMPDBDIR="C:\SQL2008\TempDB\\" /SQLUSERDBDIR="C:\SQL2008\SQLData\\" /SQLUSERDBLOGDIR="C:\SQL2008\SQLLog\\" ```
+
+- After some time I was returned to the main command prompt without any issues and you can also see in config manager with our instance(**SQL2008**) being successfully installed.
+
+## Helpers
+- [Installation Guide]([https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt](https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt))
No results found