I had to re-install my SQL Server 2005 product in my Windows XP Pro.
I could create an external server connection successfully (through Management Studio) but not a local one.
Server Type: Database Engine
Server Name: (local)
Authentication: Windows Authorization
User Name: FABIO\Fabio (filled automatically and "gray-blocked" , as far as any modification concerned)
I get the following error message:
Cannot connect to (local)
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)