[ # ] MS SQL Server Error: 4064. Cannot connect to local Server

/* Posted March 26th, 2008 at 2:45pm */
/* Filed under Programming */

Recenlty, I was working with SQL Server 2005, when I opened up SQL Server 2005 Management Studio and tried to connect to my local database server, I got the error above: “Cannot Connect to XXXX”

I looked inside the server name section and there was my computer name. I was at a loss for words? What the heck was going on? Well the solution if you ever get this probelm is to change your “Server Name” section and replace your computer name with:

“np:\\.\PIPE\MSSQL$MICROSOFT##SSEE\SQL\QUERY file://\\.\PIPE\MSSQL$MICROSOFT”

Give it a try, it solved my issue.