![]() It’s recommended to set Start-up type of SQL Services to Automatic. You can set startup type as Manual or Automatic. Under Service Account tab, you’ll find option to set account name and password for any of the services also you can choose start-up type of those services. Step 14: Server Configuration On this step you’ll find options to specify Service Accounts and Collation Configuration. Step 13: Disk Space requirement summary At this step, you’ll get disk space summary which will show how much disk space your instance will take on the machine. After doing instance configuration, click Next. As shown in above screenshot, I already installed 2 instances on my machine. It’ll also show you the instance already installed on your machine. If you want to change the root directory of your instance, you can change it from ‘ Instance root directory’ option. Select type of instance you want to install. If default instance is already installed, you’ll have to have proceeded with named instance. Step 12: Instance Configuration This step will ask, what type of instance you want to configure, as we all know, either we can install Default or Named instance. ![]() Step 11: Installation Rules After selecting the features to install, setup again runs a check to ensure whether your machine’s configuration is compatible or not to proceed further. If you selected “ All Features with Default” in previous step, all these components will be checked automatically. Management Tool: Allow you to install SQL Server management configuration tool including command line and power shell tool.Integration Services: Allow you to install Integration Services.In SQL Server 2008 installation you’ll find this service named as ‘Business Intelligence Development Studio’. SQL Server Data Tool: Allow you to install SQL Server Developer tool to work with integration packages.Reporting Services: Allow you to install the server as report server.Analysis Services: Allow you to install an Analysis Services instance on standalone or on cluster node.Database Engine Services: Allow you to install SQL Server instance.The following is the description for above listed components. Step 10: Components or Features to Install Select the components you want to install on your machine. On Database Engine Configuration page, your current logon account will be added as a Server Administrator.On Server Configuration page, default accounts will be set.On the Feature Selection page, all features will be selected by default.If you select “ All Features with Default”, the following things will be set by default: By default it’ll select ‘ SQL Server Feature Installation’. Step 9: Setup Role At this step, you’ll find options like install SQL Server instance or install instance of Analysis Service with SharePoint integration. Step 8: Setup Support Rules After successful completion of previous step, setup will again run a check to ensure everything looks good for the installation. Step 7: Install Setup Files At this window, you’ll get Install button to install the updates. Step 6: Product Updates Here, setup will look for latest product updates to enhance SQL Server performance as my setup found one update of 22 MB for enhancement as shown below. Step 5: License TermĪccept the license by clicking on “I accept license terms.” Click Next. Step 4: Product Key Select edition of SQL Server you want to install on your machine with your product key and click Next. If all requirements fulfill, you’ll get passed in Status column. ![]() If any of the check fails, you’ll get a failed notification in status column and you won’t be able to proceed further with the installation. This check is nothing but a kind of verification to ensure you can proceed further or not. Step 3: Setup Support Rules Before proceeding with the installation steps, SQL Server setup runs a setup to check all the things required for installation. Click on the first link and the installation process begin. As we want to perform stand-alone installation, we’ll go with option 1. Also if you want to upgrade you version of SQL Server, there’s an option for that as well. From here, you can perform stand-alone installation of SQL Server or you can add any additional features to installed instances of SQL Server. Click on Installation section and you’ll find something like the following window. As we’re working on the installation, we won’t dig other parts. Step 2: Installation Center After running the setup file, you’ll be redirected to Installation Media Center where you find various options. Step 1: Open installation media in new window and right click on setup file to run it “ As Administrator”. Here we’ll install named instance of SQL Server 2012 and we’ll see the installation steps required during the installation process. In our previous article we learned how to install SQL Server 2008 on machine.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |