Tuesday, September 3, 2013

43 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

43 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

 

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