Installation of SQL server 2012

Installation of SQL server 2012

I am providing the step-by-step instructions in this article on how to install SQL server 2012 with a Single Instance on a windows server 2012.

·        Run setup.exe

·        Click on Installation

      

·        Click on New SQL server stand alone or add feature to an existing installation

·        Rule check in progress will start, Click OK once done

         

·        Enter the product key, click Next

·        Accept the License agreement, click next

·        Install setup files will start

        

·        Setup support rules will start, click next

          

·        Select SQL server feature installation, Click next

          

·        Select the Instance Features as you required, Change the directory of the Features if required,Select the Management tools on botom to open the SQL in management studio. click next

              

·        Click next

·        Select Named Instance, If you want to create Instance or else select Default Instance, click next

          

·        Disk space requirements checks starts, Click next

·        Once the credentials provided, click next

·        Click on ADD current user and check the Data Directories, click next

             

·        Click next on Error reporting

·        Click next on installation configuration Rules

·        Click Install

·         Click Close once the installation done.
       

How to open SQL:

·        Go to Search->type->SQL

               

·        Click On SQL server Management studio

·        Open a POP up with server name and Instance, click Connect

·        You can able to connect the Instance.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

How to Add Shared Feature in SQL 2012

How to Add Shared Feature in SQL 2012

We face difficulty many times, when we want to add the shared feature in SQL 2012 related to SharePoint. the features that we normally add related to SharePoint is Reporting services, Integration services etc..In this article I am giving details on how to add  the Shared features.

·        Go to SQL 2012 binary, double Click on Setup.EXE

·        Process will start

·        Click on Installation->select “new SQL server stand alone installation or add features to an existing installation”

·        Rule check in progress starts, click OK,Ignore the below Error

·        Click on next

·        Click Next once Check done

·        If you want to add features to Instance select "add features to existing instance", If you want to add on Default instance, select "Perform new installation of SQL server 2012"

·        Click on next and Choose product Key

·        Click on next

·        Accept the Terms and conditions and click next

·        This is where we need to choose the SQL server feature installation, Click next

·        Choose the feature that you want to add and click next

·        Process starts, click on next

·        Drive space requirements shows, click on next

·        Provide the Account details and next

·        Click on next

·        Installation configuration rules, click on next

·        Ready to install, Click on install

·        Installation progress starts

·        Click Close once the feature added.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

How To Remove of Shared Feature in SQL 2012

How To Remove of Shared Feature in SQL 2012

We face issue many times, when we want to remove the shared feature in SQL 2012 related to SharePoint. the features that we normally install related to SharePoint is Reporting services, Integration services etc..In this article I am giving details on how to remove the Shared features.

·        Go to control panel of the server    

·        Select the Microsoft SQL server 2012(64Bit),Right click on that

·        Click on Uninstall or change a program

·        Click On Remove

     

·        The process will start and Rule check in progress starts

·        Click OK once the check in progress completes

·        If want to remove the Total Instance, Choose Instance and click Next.

·        If only Shared Features, Choose Remove Shared Features only, click next

·        Here, you need to select Which feature you want to remove. I choose Integration services, Click Next

·        Click next

·        A screen will appear with the Confirmation, Click on Remove

·        Remove of feature will start

·        Once Done, Click on close. the feature get removed

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Operations started by an earlier run of the farm configuration wizard are still in progress

Operations started by an earlier run of the farm configuration wizard are still in progress

“Operations started by an earlier run of the Farm Configuration Wizard are still in progress. You must wait for those operations to complete before running the wizard again. You can monitor the status of these operations by looking at the “Farm Configuration Wizard” timer job on the Timer Job Status page in the Monitoring section of Central Administration.”

                (Or)

If we click on “Launch the Farm configuration wizard” in central administration will see the error                               

                 

Cause: This issue will occur some times when we try to open the central administration after running the PSConfig.exe completes. The reason behind this is After the PSConfig completes, still  there are some tasks that are running. We can wait for some time or we can close the existing browser and open Central admin in another browser to work. If still not work, then follow the below steps to avoid the error.

Solution:

If you want to avoid the error message you will need to delete the Job Definition for the Farm Configuration Wizard.

1.    Go to – Central Administration > Monitoring > Review Job Definitions

2.    Find the “Farm configuration wizard” job definition

3.    Click on the job, you can see the below screen. Delete the job by clicking on delete option   

        

4.    Do IISRESET if required

5.    Once delete the job you can see the Wizard page and you should see the  farm configuration wizard

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Trend Micro Antivirus Installation for SharePoint 2013

Trend Micro Antivirus Installation for SharePoint 2013

As I mentioned in my previous article, Trend Micro supports the SharePoint 2013.see the details of which Antivirus supports SharePoint in below.

http://expertsharepoint.blogspot.de/2014/03/antivirus-for-sharepoint.html

I am giving the detailed installation steps for the trend micro PP for SharePoint. can get the PP(portal protect) from the below site.

http://www.trendmicro.com/us/enterprise/network-web-messaging-security/portalprotect-microsoft-Sharepoint/index.html#sthash.vWya9ZuZ.dpuf

Installation Steps:

1.   Ensure that the PP downloaded properly

               

2.   Double click on the PP and wait for the extraction to complete

           

3.   Click on Next

4.   Accept the Terms in License agreement 

5.   Choose the installation as depends on your farm, If it’s a Standalone server, choose the first, If it’s a farm environment(SP servers are more than 1) choose option 2. I am choosing as standalone server

               

6.   Click next

7.   Provide the Activation code(License code) as got from Trend Micro. Once provided Click on next

                           

8.   We see a warning, ignore this message and proceed with “Ok”

               

9.   Select Install to local servers and click next

             

10. Choose the path as you required, if you want ,you can specify the different path where files need to store, click next

                

11.   Choose the Port number and select SSL if you have configured SSL. Click Next

                 

                           

12.       Select the SharePoint SQL server and provided the details of SQL server, Username and password. click on next

Note: The user name that you select, recommends Farm Admin account and have DB creator and DB owner permissions.

              

13.       Click on Next once provided all the details

14.       Select Use Local server Administrator Group, Click on Next

Note: the Account your using for the installation must be in Local server Administrator group                  

15.If you want to get the updates Directly from Internet Choose the Proxy server and provide the details, If you are willing to get the Updated from other central Trend micro server, not required to choose the option. I select None in this. Click on next once selected the option                              

                 

16.       Select NO,I don’t want to participate(depends on your choice)click on next

                  

17.       Select Register Portal protect agent to control manager server if you have central Trend micro server and get updates from there.

                   

18.       Choose Connect using HTTPS, if you’re using SSL in your farm, click next

Note: Web Server Authentication is not necessary

19.       Specify SMTP settings if you  have PP central server. Configuration of a SMTP-Server at this point is only necessary if no central TMCM-Server is available in your network. Click Next

               

20.       Click Install

         

21.       The installation will start

            22.   Click on Next once Installation done

                      

  23.   Click Finish to complete the installation

Post-Installation Steps

Trend Micro is successfully installed in SP server, now we need to connect to trend micro with SharePoint to Monitor. Follow the below steps to achieve this.

1.   Go to programs->portal protect management console

       

2.   Logon with local Administrator Account,Enable Two Way Communication Port Forwarding                                

                         

3.   Enable Two Way Communication Port Forwarding

                                                 i.    Open menu “Administration>Control Manager Settings”

                                                ii.    Enable option „Enable two-way communication port forwarding“

                                               iii.    Enter IP address “IP address”

                                              iv.    Enter “16373” as “Port”

                                               v.    Save configuration with button “Update Settings”

SharePoint settings:

The SP settings also must enable for antivirus to monitor. Follow the below steps to do so.

1.   Central Administration->Security->Manage antivirus settings

      

2.   The options should be enabled as per requirements.

 Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!