Monday, March 19, 2012

SQL Server : Step by step installation guide for SQL Server 2012 (Denali)

I have so exciting news! Microsoft has released SQL Server 2012 RTM (Code name “Denali”) on March 6 for manufacturing and download the evaluation edition from http://www.microsoft.com/download/en/details.aspx?id=29066

As my laptop is 32-bit system, so I have downloaded the following files from the above link. Likewise, you can download the files for 64-bit system(x64) too. :) Finally, check your system requirements from the same link.

ENU\x86\SQLFULL_x86_ENU_Core.box
ENU\x86\SQLFULL_x86_ENU_Install.exe
ENU\x86\SQLFULL_x86_ENU_Lang.box

After downloading the above files, your system will look like below:



Double click the “SQLFULL_x86_ENU_Install.exe”, it will extract the required files for installation in the “SQLFULL_x86_ENU” folder as shown below:



Click the “SQLFULL_x86_ENU” folder and double click “SETUP” application.



Checking your system requirements for installation.



When you see “SQL Server Installation Center” screen, it means that your system configuration is perfect for “Denali” installation. :)



Click installation from the left pane and select “New SQL Server stand-alone installation or add features to an existing installation”.



In the “Setup Support Rules” Click "OK" button when you have failed 0. Otherwise fix the issue and click "Re-run" button.



Here, I left default edition “Evaluation”, but you can also choose “Express” edition from the drop down list. (Leave the product key as of now, later you can convert to licensed version at any time, refer the above link.



Press “Next” button.



Select the “I accept the license terms” and click “Next” button.



I have installed in “Offline” mode, So I got the above error message otherwise, it does windows update automatically and will continue the process. :)

Press “Next” button.





Press “Next” button, if all status are passed. Otherwise fix the issue and press “Next” button.



I left the default feature “SQL Server Feature Installation”, if you do not want to change the option then  press “Next” button.



Select the features and change the “Shared feature directory” if you want, otherwise press “Next” button.





Press “Next” button if failed count is 0.



As I have already 2 instances, so I have selected “Named Instance” and given the instance (server) name.  You can change “Instance root directory” if you want. Otherwise, press “Next” button.



It will not allow, if you do not have sufficient space in the disc. Press “Next” button.



You can change the “Startup Type” for SQL services in the tab. Which also can be done in the Control Panel “Services” after installation.



Change the “Collation” if you want, otherwise Press “Next” button.



Choose the authentication mode and specify the “Administrator” user. Here, I have selected “Add Current User”. Also, you can change the “Data Directories” and enable “FILESTREAM” if you want , otherwise Press “Next” button.



You can change the Analysis Services “Server Mode” and “Administrator” user. Here, I have selected “Add Current User”. Also change the “Data Directories” if you want , otherwise Press “Next” button.

Note : You can select only one server mode to use: “Multidimensional and Data Mining Mode” or “Tabular Mode”. If you want both, you need to run the setup again after the first instance setup. Refer Books online.



Here, you need to choose “Reporting Services Native Mode” and press “Next” button.




“Distributed Replay Controller” service feature is new in SQL Server 2012, here specify the user who should have permission to use this service. Press “Next” button.

Note : Distributed Replay feature helps you assess the impact of future SQL Server upgrades.
Refer http://msdn.microsoft.com/en-us/library/ff878183(v=sql.110).aspx



Specify the Controller Machine name which should have “Distributed Replay Controller” service. Also you can change the working directory and Press “Next” button.





Press “Next” button, if failed count is 0.



Here, you can find the list of "SQL Server 2012" features which will be installed. If you would have missed to enable any features, click “Back” button and enable. Otherwise press “Install” button to proceed.



You can see installation progress. Press “Cancel” button, if you want to stop the installation.





After the successful installation, your screen should look like below :



Wow, you have successfully installed SQL Server 2012 and to confirm the successful of installation from the screen, you can find the “Succeeded” for all the features and refer summary log file for further info.
Press “Close” button.

Now, you can play with SQL Server 2012 features.
Go to “SQL Server 2012” menu and click “SSMS”.







Select appropriate SQL Server 2012 instance and authentication mode and click “Connect” button.



Now, you are in SQL Server 2012 management studio. :)



Now, you can right click and change the “New Vertical Tab Group”.



Write your favorite query and execute. All the very best for your learning :)

I hope, this article would have guided you to install SQL Server 2012 ("Denali").

166 comments:

  1. Thanks Siva...

    You made it very easy to install "Denali" :)

    ReplyDelete
  2. @Siva

    Thank you!

    We are expecting articles on sql server 2012 to use new features as well.

    Hope they will come soon....

    ReplyDelete
  3. Thanks Siva!..... I Appreciate it. I heard that power view is integrated with SQL Server 2012(Denali) is that true?, if so where can i get that & how to use that. please Teach me.

    ReplyDelete
    Replies
    1. @ Ananth,

      Sure, will publish one article on power view.... soon :)

      Thanks
      Siva

      Delete
    2. Thank You Brother......Its very useful for my profession

      Delete
  4. @ Ananth,

    Sure, will publish one article on power view.... soon :)

    Thanks
    Siva

    ReplyDelete
  5. Good post,
    Siva... it is very useful information to all.

    Thanks siva.

    ReplyDelete
  6. Good Post,
    Thank u so much Shiva
    its help a lot.

    ReplyDelete
  7. Thank u Siva;
    it was very useful to everyone.

    ReplyDelete
  8. Thank you for putting this together, just finished my install - worked perfectly.

    ReplyDelete
  9. Thank you so much! It was really self explanatory.

    ReplyDelete
  10. thanking Y :) U
    Its help full for me .

    ReplyDelete
  11. Good Post,
    Thank u so much Shiva it very useful information to all.

    ReplyDelete
  12. Hi Siva,

    In between the installation of SQL Server 2012 Developement Edition on my Windows 7 - 64bit, i got an error as 'Incorrect Function'.
    And after the installation completes, these are list of files which got failes:
    1. Reporting Service - Native
    2. Database Engine Services
    3. Data Quality Services
    4. Full-Text and Semantic extractions for search.
    5. SQL Server Replication
    Cause of which the SSMS is not running, please help me out.
    Although i have SQL Server 2008 r2 on the same C: drive.

    ReplyDelete
  13. Siva,
    Thanks for your post.Really it helped lot.Could you please tell what are the additional features of 2012 compared to 2008 R2.

    ReplyDelete
  14. Thank you so much

    ReplyDelete
  15. In the installation step am getting an error

    @ Product key

    error message: "Incorrect function"

    Can anyone help me out

    ReplyDelete
    Replies
    1. Hi Ramakrishna Kirthi,

      How are you installing the SQL Server by CD or dump?

      This problem might have occurred due to the installation files are corrupted.

      Please try to use other media for the installation.

      Thanks
      Siva

      Delete
  16. Thank U very much for the step by step installation process.

    ReplyDelete
  17. it would be great if you can publish by point wise the pre-requisites and points to check before installtion and post installation.

    -Thanks,
    Vino

    ReplyDelete
  18. Thank you for putting this together, just finished my install - worked perfectly.

    ReplyDelete
  19. Hi,nice method for Installing Sql Server 2008 Software.Thanks for your help..

    -Aparna
    Theosoft

    ReplyDelete
  20. Thank you...it was very helpful

    ReplyDelete
  21. Wow this is very useful. Thankz

    ReplyDelete
  22. thanks siva it is very helpful article.

    ReplyDelete
  23. Thanks for your information...it was very helpful.

    ReplyDelete
  24. Hi,

    I m getting error as "Wait on the Database Engine recovery handle failed!! SQL Server 2012 installation". Can you please help me out? Thanks

    ReplyDelete
  25. Hi Lara,

    Just proceed the installation with errors and refer http://blogs.msdn.com/b/sqljourney/archive/2012/03/16/sql-2008-r2-setup-fails-with-quot-wait-on-the-database-engine-recovery-handle-failed-quot.aspx

    Please let me know, still if you have any issue.

    Thanks
    Siva

    ReplyDelete
  26. I installed but not able to connect the Database Engine. As it is failed to install :-(

    I also take a look of the following link- at step 13.f -- I cannt change the name to NT AUTHORITY\LOCAL SERVICE

    http://www.bu.edu/csmet/files/2013/01/SQL-Server-2012-Installation-Guide.pdf

    I found something here also --

    http://stackoverflow.com/questions/17613094/wait-on-the-database-engine-recovery-handle-failed-sql-server-2012-installatio/19379173#19379173


    ReplyDelete
  27. Hi Siva

    I Have the Diploma for Information Technology and now am working to the Company in South Africa.I Work as IT Technical Ass I never did SQL server but Why is important to PC.

    ReplyDelete
    Replies
    1. Hi,

      Please refer this link http://en.wikipedia.org/wiki/Microsoft_SQL_Server
      This may help you to understand why SQL Server is required.

      Thanks
      Siva

      Delete
  28. thanks sivA beause o you i am able to install easily

    ReplyDelete
  29. Thank you very much Siva, Your article really helped me a lot while installing my SQL Server 2012.
    Thank you for the Steps.. :)

    ReplyDelete
  30. can u explain how to schedule a job to take differential backup in ssms?

    ReplyDelete
  31. I installed SQL Server 2012 but when I open my SQL Server Configuration Manager. It shows that "The remote procedure call failed" when i click on SQL Server Services. I see that all the folders looks correct in SSMS in the object explorer. How can I make sure if everything is installed properly?

    ReplyDelete
    Replies
    1. Hi Priyanka,

      Try to install the SQL Server 2012 SPs (http://www.microsoft.com/en-in/download/details.aspx?id=35575). Hope this will fix the "The remote procedure call failed" error.

      Also, refer the link http://technet.microsoft.com/en-us/library/ms366339.aspx to make sure the installation in correct.

      Thanks
      Siva

      Delete
  32. Hi Siva,

    Thanks for your great effort. i search all the day for the sqlserver 2012 setup configration. but i found nothing. but when i found your blog so i install it very easily. Thanks again ....

    Regards.

    Sikandar khan

    ReplyDelete
  33. Thanks Shiva its help a lot to me

    ReplyDelete
  34. It really really helps thanks geek...

    ReplyDelete
  35. It is very good article, and fantastic steps.... :) Thanks...!

    ReplyDelete
  36. Thank you , It is very good article.. :)

    ReplyDelete
  37. we have sql 2005 sp3 databases, we need migrare sql 2005 databases to sql 2012,what cani do? help me

    ReplyDelete
    Replies
    1. Hi Nethaji,

      Please go through the below link which will guide you for SQL Server 2005 to SQL Server 2012 upgradation.
      http://technet.microsoft.com/en-us/library/ms143393.aspx

      Let me know, still if you have any questions.

      Thanks
      Siva

      Delete
  38. Dear Mr. Siva,

    Thanks a lot for making it so simple. It's really very help ful for new folks in SQL.

    ReplyDelete
  39. Dear Mr. Siva,

    Thanks a lot of making it so simple.!! It's really very help ful for new folks in SQL.

    Have a great time ahead...!!

    ReplyDelete
  40. hello siva, Is internet connection necessary to install sql 12 ?

    ReplyDelete
    Replies
    1. .NET Framework 4 is required for SQL Server 2012 installation, if its already installed in your machine.. you no need to have internet connection.

      Delete
  41. It WORKS :)) THANKS SIVA SIR!!!

    ReplyDelete
  42. thanks for guiding i will never install sql server 2012 before this

    ReplyDelete
  43. thanks sivakumar its very useful

    ReplyDelete
  44. Those who are getting error-Wait on the Database Engine Recovery Handle Failed,shold try this. After long searching the internet I found the solution.Uninstall the previous installations of SQL Server(including registry files and remaining files) and install again.While installing you need to change the account name for database services to NT AUTHORITYNETWORK SERVICE and it will successfully installed without any errors.
    For detailed information with screenshot read this - http://www.superpctricks.com/2014/02/sql-install-error-database-engine-recovery-handle-failed.html

    ReplyDelete
  45. Hai sir,

    what are the OS and Hardware requirements for installing SQL Server 2012

    ReplyDelete
    Replies
    1. Hi Padmanabha,

      That depends on SQL Server Edition.... please refer this link for more info http://msdn.microsoft.com/en-us/library/ms143506.aspx

      Thanks
      Siva

      Delete
  46. hi sir
    Sql server2012 is not install in PC (windows-7 Ultimate&32-Bit Operating System )

    ReplyDelete
    Replies
    1. Hi Syed,

      That depends on SQL Server Edition.... please refer this link for more info http://msdn.microsoft.com/en-us/library/ms143506.aspx

      Hope, this may help you.

      Thanks
      Siva

      Delete
  47. Hi Siva

    Thanks for sharing

    Rgeards
    Raj

    ReplyDelete
  48. Very informative article.
    Thanks,

    Doron
    http://www.dFarber.com


    ReplyDelete
  49. Thanks.
    It was very clear.
    I really appreciate your effort of work.

    ReplyDelete
  50. After installation it is asking for the server name.I am unable to connect.WHAT IS THE SERVER NAME???

    ReplyDelete
  51. Hi there, I tried to install SQL Server 2012 but it gave me this unknown error. http://prntscr.com/39wz5p.

    Please help. Thanks!

    ReplyDelete
  52. http://www.youtube.com/watch?v=WTVLo9kvK3w

    You Can Also Watch the Video How to do step by step SQL Installation

    ReplyDelete
  53. Userful article ... Thanks

    ReplyDelete
  54. Very useful article...installed sql server successfully!
    Thanks!

    ReplyDelete
  55. Hi Siva

    Thank you.
    it is helpfull

    ReplyDelete
  56. Hi,
    During installation of SQL Server 2012 i got a error
    TITLE: Microsoft SQL Server 2012 Service Pack 1 Setup
    ------------------------------

    The following error has occurred:

    An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="x86",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x80070422.

    For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0xF45F6601%25401201%25401

    Please let me know how to resolve it
    32 bit OS and system is x86

    ReplyDelete
  57. Minimum hardware and software requirement are not foun on my system

    ReplyDelete
    Replies
    1. Hi,

      Please refer this link for more info http://msdn.microsoft.com/en-us/library/ms143506.aspx

      Hope, this may help you.

      Thanks
      Siva

      Delete
  58. thanku siva,,very usefull

    ReplyDelete
  59. thanku siva..your blog has made my installation easy

    ReplyDelete
  60. thank you man :D

    ReplyDelete
  61. hello,
    i have tried instaling sql sever 2012 windows 7 32 but the setup window will proceed to install Setup support files, the window will disappear but,, the next window never shows up...i have tried so many times since last 4 installing uninstalling freshly..eventhough i mnt able to do task completely.... can give some solutons....
    thanking you,,,,,
    regards,
    lavanya

    ReplyDelete
  62. SQ Server Reporting Services is automatically under NT Service\ReportServer account. In this page, we are not able to set password for this account. To harden the DB, we need to change SQL Server Reporting Services to another service account. I tried to change the service account directly from services.msc, but it will have problem to access to Reporting Engine after the change.

    1. Kindly advise the correct way to change the password for SQL Reporting service?
    2. How to know the default password for NT Service\ReportServer account?

    Thank you.
    CL

    ReplyDelete
    Replies
    1. Hi Choung Lee,

      You can change the settings in Reporting services configuration manager.

      Go to All Programs -> MS SQL Server 2012 -> Configuration Tools -> Reporting Services Configuration Manager.

      Select the Service Account from the left pane -> Select Use Another Account -> Provide the domain a/c.

      Restart your SQLServerReportingServices from services.msc and try to connect your report server.

      Let me know still if you have any issue.

      Thanks
      Siva





      Delete
  63. Hi Siva,

    I have extracted folder after downloading files from the link,
    I ran the setup file but it is showing the below error:

    "OS does not meet requirements for sql server 2012, and for windows 7 SP1 or later is required"

    My system config:
    Windows 7 Home basic
    64 Bit
    2.1Ghz
    3GB RAM

    I have gone through the system requirements page but i can able to findout the issue where it comes from,
    Please help me.

    Thanks in Advance

    ReplyDelete
  64. Thank You..This is what i needed!!!

    Though one question ...

    Does MS SQL SERVER 2012 work with SQL MANAGEMENT STUDIO 2010 and VISUAL STUDIO 2010 or will i need a higher version???

    ReplyDelete
  65. any good e-book for asp.net

    ReplyDelete
  66. Dear Sir,
    I installed sql server 2012 in windows 8 to restore my server 2008 r2 sql 2012 backup.while restoration i got an "error restore of database failed".Kindly advise to restore db.

    ReplyDelete
  67. Thanks a lot Shiva for detailed explaination

    ReplyDelete
  68. Thanks Shiva.. Your blog has made installation so easy for me.

    ReplyDelete
  69. Good Post,
    Thank u so much Shiva
    its help a lot.

    ReplyDelete
  70. During installation this problem occurs...
    plzz tell the solution...

    The following error has occurred:

    Unable to open Windows Installer file 'K:\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi'.

    Windows Installer error message: The system cannot open the device or file specified.
    .

    ReplyDelete
  71. thanks a lot siva for providing the instalation details it make to instal the sql server

    ReplyDelete
  72. You make the SQL world go around on batteries !.. thanks Siva for the illustration. I used this for my student in the SQL installation classes.

    ReplyDelete
  73. Thanks shiva !! Very good demo to install SQL

    ReplyDelete
  74. Thank you very much sive good information :)

    ReplyDelete
  75. Hi all I got struck at step 10 i.e) after installing setup files the window is automatically closing this is repeating for every time i try to install pls help me

    ReplyDelete
  76. These articles are greatly appreciated; It' really interesting and informative blog and everybody must visit this blog. Thanks for the information. Keep blogging.

    SQL Reporting Services

    ReplyDelete
  77. Hi Siva

    Thanks for the explanation. How to download the process?

    regards

    ReplyDelete
  78. Nice post...I look forward to reading more, and getting a more active part in the talks here, whilst picking up some knowledge as well..

    ReplyDelete
  79. sir,are the installation steps same for 64-bit

    ReplyDelete
  80. Hello,
    I am trying to install this for x64 windows 10. After product update (step 4), it is not going to the install files step. Installation ends abruptly, can u help me with this error?

    ReplyDelete
  81. thanks you siva!!!...you installation steps made me feel easy to install sql 2012

    ReplyDelete
  82. thankq you siva and very nice post

    ReplyDelete
  83. Good post,
    Siva... it is very useful information to us thank you

    ReplyDelete
  84. Keep up the good work , I read few posts on this web site and I conceive that your blog is very interesting and has sets of fantastic information.
    server installation uae

    ReplyDelete
  85. Thanks Siva... Really a Excellent article and made me helpful to Install in the first attempt itself....

    ReplyDelete
  86. Thank you for sharing such a useful information about SQL Server installation process. This may have solved thousands of people's trouble with installing SQL server.

    Best Regards,
    Crish Watson
    Pass Microsoft Certification Without Taking Exam

    ReplyDelete
  87. Thanks for your ideas regarding SQL Server installation.It is helpful for me to install SQL Server 2012 with out any difficulties.

    Regards
    Elijehober

    ReplyDelete
  88. Thank you so much for this information. It was a great help. :)

    Thanks & Best Regards
    Manju R

    ReplyDelete
  89. Such a wonderful blog post! It is a great tutorial only with images. Here is no confusion in any step. You described everything with easy method. Thanks for sharing.

    ReplyDelete
  90. Thanks Sivakumar. Very useful.

    ReplyDelete