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.
Related Posts
Related Stories
Designing and Building Organisms: Simple As Writing Code
(General Sciences) Synthetic biologist Drew Endy discusses the exponential growth in the field of bioengineering. He discusses how only recently have scientists been able to synthesize strands of DNA as a computer engineer would write code.Dugg 520 timesNew computer language enters a cell's "mind" & writes codes
(General Sciences) "This language is stepping into an unknown universe, when your computer starts building things for you..."Dugg 825 timesÜber-Tight Code: The Software Behind the Mars Phoenix Lander
(Programming) Software running -- with no process separation -- on a BAE Systems RAD6000 single board computer that's configured with one 33 MHz RISC CPU and 128 MB of RAM.Dugg 716 times
Subscribe via email
on 
on 
on 
on 
on 
on 
on 
on 
on 
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 aa”