Tuesday, September 3, 2013

84 Install SQL Server 2012 SP1 on Windows 2008R2

 

Environment

Windows Server 2008R2

 

Prerequisite

Enable dot Net 3.5 Features.  If we don’t enable Dot Net 3.5, we would get the below error during the installation of the SQL Server.

image

To enable dotnet 3.5, we can enable at ad ”Application Server” role.

image

Install dot Net framework 4. This is to work around the below error during the installation . The application can be download from here .

Microsoft .NET Framework 4.0 installation has failed with exit code 1.

Error writing to file: DTEParseMgd.dll.  Verify that you have access to that directory.

image

image

image

Installation SQL Server 2012

image

image

image

image

image

The warming message is due to the firewall rule. We would add the new rule later.

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

Configure the Port number

This change require bounce the SQL Server.

image

Add firewall rule

netsh advfirewall firewall add rule name="ICMP Allow Incoming V4 Echo Request by WORKGROUP" protocol=icmpv4:8,any dir=in action=allow
 
netsh advfirewall firewall add rule name="SQLServer" dir=in action=allow protocol=TCP localport=7001 

 

Reference

http://blogs.technet.com/b/ilikesql_by_dandyman/archive/2011/08/10/firewall-configurations-for-sql-server.aspx

84 comments:

  1. Dot Net is similar to java which is software development platform that is highly secured and can run in any operating system.
    DOT NET Training in Chennai|.net training in chennai | FITA Training





    ReplyDelete
  2. The strategy you posted was nice. The people who want to shift their career to the IT sector then it is the right option to go with the ethical hacking course.
    Ethical hacking course in Chennai | Ethical hacking training in chennai

    ReplyDelete
  3. Updating with the latest technology and implementing it is the only way to survive in our niche. Thanks for making me this article. You have done a great job by sharing this content in here. Keep writing article like this.
    SAS Training in Chennai | SAS Course in Chennai

    ReplyDelete
  4. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    Python Training in Chennai | Python Course in Chennai

    ReplyDelete
  5. Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    cloud computing training in chennai | cloud computing courses in chennai

    ReplyDelete
  6. Thanks for creating this guide step by step. It was useful to install the SQL Server easily and configure.

    ReplyDelete
  7. Updating with the latest technology and implementing it is the only way to survive in our niche. Thanks for making me this article.
    Node JS training in chennai | Node JS training institute in chennai

    ReplyDelete
  8. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.
    dot-net training in chennai

    ReplyDelete
  9. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from Dot Net Training in Chennai. or learn thru ASP.NET Essential Training Online . Nowadays Dot Net has tons of job opportunities on various vertical industry.

    ReplyDelete
  10. I have read your blog,..its really amazing to read with informative content.keep sharing.

    Electrical Project Center in Chennai | Best Electrical projects in Velachery

    ReplyDelete
  11. Thanks for your detailed guidance to install sql server 2012. Keep share more.

    Dot Net Training in Chennai
    Dot Net Course in Chennai

    ReplyDelete
  12. Thank you for provided this blog. it has showed many useful information.
    java coaching classes in bangalore

    ReplyDelete
  13. Here, i have learned how to install sql server on windows. Excellent information. Thanks for your wonderful topic.
    SQL Server Developer Training in Bangalore

    ReplyDelete
  14. Hy Admin,
    I like the way you are explanining things. Good and very informative post. Thanks for sharing with us.

    Salesforce Developer Course in Bangalore | Salesforce Developer Training in Bangalore | Salesforce Training in Bangalore

    ReplyDelete
  15. Drive your career into Big data Analytics with the assistance of TIB Academy's Hadoop Course in Bangalore. Get classroom training and online training dependent on both weekdays and ends of the week dependent on your availability.

    ReplyDelete
  16. Awesome post. Really you are shared very informative concept... Thank you for sharing. Keep on updating...

    Best Graphics Designing Training Academy in Kanchipuram

    ReplyDelete
  17. Thanks for sharing this niche useful informative post to our knowledge...
    Best java Training Academy in Kanchipuram

    ReplyDelete
  18. This information is very useful and innovative..I gained more knowledge from this.Thanks for the nice information its very useful to read your blog...
    Best web designing Training Institute in in Kanchipuram

    ReplyDelete
  19. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site
    Best dotnet Training Institute in Kanchipuram

    ReplyDelete
  20. thank you for such a great article with us. hope it will be much useful for us. please keep on updating..
    Best software testing Training Institute in Kanchipuram

    ReplyDelete
  21. Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us.
    Best dally erp 9 Training Institute in Kanchipuram

    ReplyDelete
  22. Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    Best web Designing Training Training Institute in Kanchipuram

    ReplyDelete
  23. Wonderful article.It is to define the concepts very well.Clearly explain the information.It has more valuable information for encourage me to achieve my career goal.
    Best JAVA and J2EE Training Institute in Kanchipuram

    ReplyDelete
  24. Wonderful blog… You provided very interesting information here. I feel happy to read this post. I hope that you will write many posts like this… Thanks for sharing and Keep updating…..No:1 Software Testing Training Academy in Kanchipuram

    ReplyDelete
  25. Wow!! What a interesting blog..Thanks The information which you provided is very much useful and easy to learn as well...keep rocking and updating... looking further..
    Best CCNA Training Institute in Kanchipuram

    ReplyDelete
  26. Nice post. I study something more challenging on completely different blogs everyday.
    Best JAVA and J2EE Course Training Institute in kanchipuram|

    ReplyDelete
  27. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Best Graphic Designing Course Training Institute in kanchipuram|

    ReplyDelete
  28. Hi, I am really happy to found such a helpful and fascinating post that is written in well manner. Thanks for sharing such an informative post.
    Best Python Course Training Institute in kanchipuram|

    ReplyDelete
  29. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    Best Advanced Amazon Web Services Course Training Institute in kanchipuram|

    ReplyDelete
  30. I would like to thank you for your nicely written post, its informative and your writing style encouraged me to read it till end. Thanks
    Best Graphic Designing Course Training Institute in kanchipuram|

    ReplyDelete
  31. Excellent Blog very imperative good content, this blog is useful to beginners.
    Best Selenium Automation Course Training Institute in kanchipuram|

    ReplyDelete
  32. This blog is great.This information is very useful for me.Thanks for sharing your Ideas.Keep updating.Regards,
    Best Hardware and Networking Course Training Institute in kanchipuram|

    ReplyDelete
  33. I think this is an informative post and it is very useful and knowledgeable. I really enjoyed reading this post. thank you!
    Best Python Course Training Institute in kanchipuram|

    ReplyDelete
  34. Thank you so much for sharing. Keep updating your blog. It will very useful to the many users.
    Best Graphic Designing Course Training Institute in kanchipuram|

    ReplyDelete
  35. Nice blog.Your blog is really useful for me. Thanks for sharing this informative blog.
    Best Graphic Designing Course Training Institute in kanchipuram|

    ReplyDelete
  36. REALLY VERY EXCELLENT INFORMATION. I AM VERY GLAD TO SEE YOUR BLOG FOR THIS INFORMATION. THANKS FOR SHARING. KEEP UPDATING.
    Best Hardware and Networking Course Training Institute in kanchipuram|

    ReplyDelete
  37. This post was quite awesome and interesting to read. Congrats for your work. Thanks a lot for providing this with us. Keep on updating this with us regularly:
    Best Selenium Automation Course Training Institute in kanchipuram|

    ReplyDelete
  38. The best thing is that your blog really informative thanks for your great information
    Best tally erp 9 Course Training Institute in kanchipuram|

    ReplyDelete
  39. Awesome Blog with informative concept. Really I feel happy to see this useful blog, Thanks for sharing such a nice blog...
    Best Linux Certification Course Training Institute in kanchipuram|

    ReplyDelete
  40. Great post.Thanks for one marvelous posting! I enjoyed reading it;The information was very useful.Keep the good work going on!!
    Best Graphic Designing Course Training Institute in kanchipuram|

    ReplyDelete
  41. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Best UIPath Robotic Process Automation Course Training Institute in kanchipuram|

    ReplyDelete
  42. Nice and good blog. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating....No:1 Selenium Automation Training Academy in Kanchipuram

    ReplyDelete
  43. The information you have here is really useful to make my knowledge good. It is truly supportive for us and I have accumulated some essential data from this blog.
    Best JAVA and J2EE Course Training Institute in kanchipuram|

    ReplyDelete
  44. Your Blog is really awesome with helpful post..keep updating such an excellent post with us..
    Best CCNA Course Training Institute in kanchipuram|

    ReplyDelete
  45. This is really a great post. Thank you for taking time to provide us some of the useful and exclusive information with us. Keep on blogging!!
    Best CCNA Course Training Institute in kanchipuram|

    ReplyDelete
  46. Great blog.you put Good stuff.All the topics were explained briefly.so quickly understand for me.I am waiting for your next fantastic blog.Thanks for sharing.
    Best Tally erp9 Course Training Institute in kanchipuram|

    ReplyDelete
  47. Nice..You have clearly explained about it ...Its very useful for me to know about new things..Keep on blogging..
    Best JAVA and J2EE Course Training Institute in kanchipuram|

    ReplyDelete
  48. Hi, am a big follower of your blog. I am really happy to found such a helpful and fascinating post that is written in well manner. Thanks for sharing such an informative post. keep update your blog.
    Best CCNA Course Training Institute in kanchipuram|

    ReplyDelete
  49. Great post.Thanks for one marvelous posting! I enjoyed reading it;The information was very useful.
    Best Best Web Designing and Development Course Training Institute in kanchipuram|

    ReplyDelete
  50. great doing. and i happy to visit your blog to know about this wonderful information. thanks for sharing. keep updating.
    Best Best Web Designing and Development Course Training Institute in kanchipuram|

    ReplyDelete
  51. Your info is really amazing with impressive content..Excellent blog with informative concept. Really I feel happy to see this useful blog, Thanks for sharing such a nice blog..
    Best Python Course Training Institute in kanchipuram|

    ReplyDelete
  52. Very impressive and informative blog.. thanks for sharing your valuable information.. it is very useful and easy to learn as well... keep rocking and updating... looking further..
    Best Tally Erp9.0 Course Training Institute in kanchipuram|

    ReplyDelete
  53. Quite Interesting post!!! Thanks for posting such a useful post. I wish to read your upcoming post to enhance my skill set, keep blogging.
    Best Web Technologies Course Training Institute in kanchipuram|

    ReplyDelete
  54. Useful information and kindly keep update such a nice blog. Thanks for sharing......No:1 CCNA Training Academy in Kanchipuram

    ReplyDelete
  55. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information, this is useful to me…
    Best Linux Certification Course Training Institute in kanchipuram|

    ReplyDelete
  56. Quite Interesting post!!! Thanks for posting such a useful post. I wish to read your upcoming post to enhance my skill set, keep blogging.
    Best Web Technologies Course Training Institute in kanchipuram|

    ReplyDelete
  57. Nice Post! It is really interesting to read from the beginning & I would like to share your blog to my circles, keep your blog as updated.
    Best Tally ERP 9 Course Training Institute in kanchipuram|

    ReplyDelete
  58. Interesting post! This is really helpful for me. I like it! Thanks for sharing!
    Best Graphic Designing Course Training Institute in kanchipuram|

    ReplyDelete
  59. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me
    Best PCB Training Course Training Institute in kanchipuram|

    ReplyDelete
  60. This is excellent information. It is amazing and wonderful to

    visit your site.Thanks for sharing this information, this is useful

    to me…no:1selenium automation training

    institute in kanchipuram.

    ReplyDelete
  61. your blog contain very useful information. Really hereafter I am very big follower of your blog..
    Best MATLAB Course Training Institute in kanchipuram|

    ReplyDelete
  62. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information, this is useful to me…no:1
    HP QTP / UFT Automation training institute in kanchipuram.

    ReplyDelete
  63. Great post....Thank you for posting the great content……I found it quiet interesting, hopefully you will keep posting such blogs…Keep updating your creative and awesome blog.
    Best Tally Erp9 Course Training Institute in kanchipuram|

    ReplyDelete
  64. Wonderful!! this is really one of the most beneficial blogs

    I’ve ever browsed on this subject. I am very glad to read

    such a great blog and thank you for sharing this good

    info with us.Keep posting stuff like this..no.1 AWS Training institute in

    kanchipuram

    ReplyDelete
  65. The best thing is that your blog really informative thanks for your great information! I have got some important suggestions from it.
    Best Printed Circuit Board (PCB) Course Training Institute in kanchipuram|

    ReplyDelete
  66. The information you have deliver here is really useful to make my knowledge good. Thanks for your heavenly post.
    Best Best Web Designing and Development Course Training Institute in kanchipuram|

    ReplyDelete
  67. Interesting post! This is really helpful for me. I like it! Thanks for sharing!
    Best Tally erp9 Course Training Institute in kanchipuram|

    ReplyDelete
  68. Interesting post! This is really helpful for me. I like it! Thanks for sharing!
    Best Tally erp9 Course Training Institute in kanchipuram|

    ReplyDelete
  69. Your post explain everything in detail and it was very interesting to read. Thank you sharing.
    Best Tally Erp9 Course Training Institute in kanchipuram|

    ReplyDelete
  70. I am read your post was very interesting good valid information
    keep sharing more information...
    Best Tally Erp9 Course Training Institute in kanchipuram|

    ReplyDelete
  71. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information, this is useful to me…
    Best Tally Erp9 Course Training Institute in kanchipuram|

    ReplyDelete
  72. Really it was an awesome information...very interesting to read..You have provided an nice blog....Thanks for sharing..
    Best JAVA / J2EE / J2ME Course Training Institute in kanchipuram|

    ReplyDelete
  73. Excellent post. I have read your blog it's very interesting and informative. Keep sharing.
    Best JAVA / J2EE / J2ME Course Training Institute in kanchipuram|

    ReplyDelete
  74. Nice post.. Really you are done a wonderful job. Thanks for sharing such wonderful information with us. Please keep on updating...
    Best C & C++ Course Training Institute in kanchipuram|

    ReplyDelete
  75. Very nice post here and thanks for it .I always like and such a super blog of these post.Excellent and very cool idea and great blog of different kinds of the valuable information's.
    Best Tally Erp 9.0 Course Training Institute in kanchipuram|

    ReplyDelete
  76. This is really impressive post, I am inspired with your post, do post more blogs like this, I am waiting for your blogs.
    Best Tally Erp 9.0 Course Training Institute in kanchipuram|

    ReplyDelete
  77. Interesting post!!! Thanks for posting such a useful information. I wish to read your upcoming post to enhance my skill set and keep blogging.
    Best Tally Erp 9.0 Course Training Institute in kanchipuram|

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates