Tuesday, September 3, 2013

7 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

7 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

 

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