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").

113 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
  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. Fantastic article ! You havemade some very astute statements and I appreciate the the effort you have put into your writing. Its clear that you know what you are writing about. I am excited to read more of your sites content.
    http://www.sqlservermasters.com/

    ReplyDelete
  15. Thank you so much

    ReplyDelete
  16. 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
  17. Thank U very much for the step by step installation process.

    ReplyDelete
  18. 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
  19. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! Its always nice when you can not only be informed, but also entertained! Im sure you had fun writing this article.
    Hadoop training

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

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

    -Aparna
    Theosoft

    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. It really really helps thanks geek...

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

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

    ReplyDelete
  36. 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
  37. Dear Mr. Siva,

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

    ReplyDelete
  38. 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
  39. 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
  40. It WORKS :)) THANKS SIVA SIR!!!

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

    ReplyDelete
  42. 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
  43. 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
  44. 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
  45. Very informative article.
    Thanks,

    Doron
    http://www.dFarber.com


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

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

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

    Please help. Thanks!

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

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

    ReplyDelete
  50. Userful article ... Thanks

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

    ReplyDelete
  52. Hi Siva

    Thank you.
    it is helpfull

    ReplyDelete
  53. 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
  54. 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
  55. thanku siva,,very usefull

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

    ReplyDelete
  57. thank you man :D

    ReplyDelete
  58. 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
  59. 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