When you encounter errors when you try to access the SharePoint Sites from a Front End locally. This problem occurs because since Windows Server 2003 SP1, Windows includes a new security feature named loopback check functionality. By default, loopback check functionality is turned on in Windows Server 2003 SP1 and Windows 2008.
Ever since that time i have ever only heared people advise me to disable the loopback check entirely by using a registry setting called DisableLoopbackCheck. You can configure this at the following location.
Create a DWORD called DisableLoopbackCheck and set it’s value to 1
However, this does disable the entire function and thus reduces the security of the affected system. In some cases this might still be a valid way to circumvent the problem but Microsoft is offering a better solution that enable you to set exclusions for hostnames used on the server called BackConnectionHostNames.
The following registry entry is used to configure this
Create a multi-sting value BackConnectionHostNames that contains a list of hostnames.
For SharePoint this means that you need to enter the SharePoint sites host headers in this list, alternatively you may want to investigate configuring this via a script and or via Group Policy for manageability.
Note: This solution also solves the problem of connecting SQL Server management Studio to the local Database Server for management.