Thursday, May 22, 2014

Step by step installation process for Sql Server.....

Here are the steps....



 click Installation on the left to display the installation options. We are then going to select New Installation or Add Features to an existing installation.
 On the Setup Support Rules you should be able to just click OK. If you click Show Details it will look something like this…
Enter your product key then click Next

 Accept the license agreement click Next

 On the Setup Support Files click Install

 On the Setup Support Rules screen, you can see that I have a couple warnings

  • The .NET warning is that I do not have Internet access on this computer. Not a problem so I am just moving on.
  • The Firewall warning will be ignored as well. I will go back and modify the firewall later.
  • I will just click Next and move on.
  • On the Setup Role – I will keep the default SQL server Feature installation and click Next  On the feature selection, I am going to make many changes…

 check all the check boxes or simple click on select all button, then just simply click next

The next screen is the Server Configuration. We need to do a few things here

  • On the Service Accounts Tab change the SQL Server Agent to Automatic startup. 
  • We are are going to use the same account for all of our services. just click on the Use the same account for all SQL server Services button to bring up a small dialog box. 
  • In the Account Name field select NT Authority\SYSTEM then click OK 
  • We will keep the defaults for Collation so just click Next 

On the Database engine configuration Page we have much to do…

  • On the Account Provisioning tab I am changing to Mixed Mode. This gives me the capability to manage users from inside of SQL. Without it users have to use Windows authentication. Once you change to mixed mode you will need to put in a password for the “SA” account which is the internal SQL Administrator account. You will need to use a complex password for this. If you do not need mixed mode, you can just leave Windows authentication mode turned on.
  • You have to specify SQL Server administrators. In my case, I clicked “Add Current User”.


 then put as it is selected one click on next,
 next,,don't check the check boxes,
 No Error reporting for me so just click Next

  •  Almost done. You can show the details on the Installation Configuration Rules if you like,
  • All applicable tests should be passed so just click Next


  • On the Ready To install screen you can review your configuration and then just click Install.
  • Then just let it chug for about 20 mins or so (depending on performance of your machine it could be longer)









No comments:

Post a Comment