Change or remove the Central Administration Web site port number in SharePoint

During the SharePoint Foundation Installation, the Central Administration Web application is established on a PORT that you have assigned or randomly assigned port if you don’t select.

You can change this Web site port number or delete the port number complete from Central Administration Web application Server.

Follow the steps if you want to change the port number 80, means when you launch you Web application you no need to specify the port number for ex:- http://oracleracexpert.com

1. Open “SharePoint 2013 Management Shell” as Administrator

2. Run below command

PS C:\Users\svc-sharepoint> stsadm -o setadminport -port 80

You should receive the message “Operation completed successfully”

3. Reset IIS using below command

C :\> iisreset

4. Now you should be able to launch your Central Administration Web application without port number i.e http://Application_Server_Name

Regards,
Satishbabu Gunukula
http://www.sqlserver-expert.com

Remove SharePoint Central Administration Web Application

If you deleting a Application server or Central Administration Web application from Server Farm in SharePoint 2013 follow the below simple steps.

Removing the Central Admin Web application  is very similar as Configure SharePoint Central Administration Web Application

1. Start “SharePoint Products Configuration Wizard”  on the server where you want to Delete the Central Administration

Select the option

·         Do not disconnect from this server farm – Choose this option, If you want to delete only Central Administration Web application from server farm

·         Disconnect from this server farm- Choose this option, if you want to disconnect this server from farm

2.  Select “Yes, I want to remove the web site from this machine” , Click Next

3.  In this screen you should be able to see the Database Server Configuration Settings, Click Next

4. It will remove the Central Administration information from registry and also removes the web application .You should see “Configuration Successful” message once the configuration Wizard removed the Central Administration Web application, click Finish.

Regards,
Satishbabu Gunukula
http://www.sqlserver-expert.com

Error While enabling NetFx3 during SQLServer 2012 Installation

Users may receive below error during SQLServer 2012 installation.

Error while enabling Windows Feature :NetFx3, Error Code : -2146498298 , Please try enabling Wndows feature : NetFx2 from Windows management tools and then run setup again. For more information on how to enable windows freature, see http://go.microsoft.com/fwlink/?linkid=227143
 

Users will see this error if they don’t install/enable ".Net Framework 3.5" before installing SQLServer 2012.

Follow below steps to enable .Net Framework 3.5 on Windows Server 8 or Windows Server 2012

1. Server Manager -->  Manage --> Click “Add Roles and Features" --> Next
2. On “Installation Type”, Select “Role-based or feature-based installation” -->Next
3. On “Server Selection”, Select the server on which you want to install from the list --> Next
4. On “Server Roles”, Select new roles if you need
5. On “Features” Page, select “.Net Framework 3.5 Features” --> Next--> Install

You can use above steps to add any new roles/Features in Windows Server 8 or Windows Server 2012 environment.

You can also add Roles and Features using command line

C:\>dism /online /enable-feature /featurename:NetFx3 /source:E:\sources\sxs

Where E drive is the windows media mount.

Regards,
Satishbabu Gunukula
http://www.sqlserver-expert.com

Error: 26 - Error Locating Server/ Instance Specified in SQLServer

Recently I have experienced the following error message when connecting to SQLServer

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 26 – Error Locating Server/ Instance Specified) (Microsoft SQL Server)

Cause 1: If SQLServer is not allowing remote connections.

Possible solution1:

1. Microsoft Management Studio, Right Click Database Server and go to properties
2. On Security Page, under Server Authentication select “SQL Server and Windows Authentication mode” and click OK
3. Restart SQLServer Service

In case of SQLServer 2005, follow below steps to enable remote connections

1. Click on Startup, go to Program files and Select Microsoft SQL Server 2005--> Configuration tools--> SQL Server Surface Area Configuration

2. Click on “Surface Area Configuration for Services and Connections -->  SQL Server Browser--> Select “Automatic” for Startup type and Apply

Cause 2: TCP Port 1433 or UDP Port 1434 ports are not in Firewall exceptions

Possible solution2: Add exception to allow port TCP Port 1433 and UDP Port 1434 or Turn off Firewall rules

Regards
Satishbabu Gunukula
http://www.sqlserver-expert.com

Free Visual Studio video Tutorials

You will learn how to work with Visual Studio 2005, add-ins to perform testing, Team System, Deployment and other tasks.

1. Intro to Unit Testing with Team System

2. Intro to Testing Web Applications with Team System

3. Intro to Load Testing Web Applications with Team System

4. Intro to Manual Testing with Team System

5. Intro to Managing and Running Tests with Team System

6. Measuring the Business Value of AJAX

7. Code Coverage of Automated Tests

8. Custom Extraction Rules and Coded Web Tests

9. Effects of Caching

10. Load Test Agent

11. Effects of ViewState

12. Integrate Defect Tracking with Testing

13. Create My Own Bug Work Item

14. Write Code More Quickly with Unit Tests

15. Practice Test-Driven Development

16. Load Test a Web Application

17. Tune Web Application Performance with Profiling

18. Set Up Distributed Load Testing for High Volume Tests

19. Enforce Coding Standards with Code Analysis

20. Use Generic Tests

21. Publish and Analyze Test Results

22. Discover Application Changes Prior to Deployment

23. Implement Continuous Integration with Team Foundation

24. Automate Testing using Team Build

25. Deploy a Web Application during a Team Build

26. Run Unit Tests against a Deployed Database

27. Enable Code Coverage and Profiling in Production Applications

28. Web Deployment Projects

29. Web Application Projects & Web Deployment Projects

I hope these videos are helpful to you .

Regards
Satishbabu Gunukula
http://www.sqlserver-expert.com