Server Explorer won't connect to the database… | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Server Explorer won’t connect to the database…

Hi all,[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />In previous attempts to solve other problems with stored procedures,<br />its likely that I have messed things up with the connection that the Visual Studio .NET’s Server Explorer uses to connect to the data base.<br /><br />First, if someone knows how does the Server Explorer connect to the SQL Server, it would me more than helpfull.<br />Second, I’ve reviewed some of those KBAs about potential causes for the error im getting..<br /><font color="red">[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied</font id="red"><br />(try to copy/paste the error as is to Google’s search and reach the KB Article – usually 1st search result)<br />Any helpfull suggestions are welcomed.<br />Maybe someone could simplify or narrow up causes for that error.<br /><br />Thanks,<br />eBilyboy
Following up this problem…<br />I read <a href=’"http://support.microsoft.com/kb/289573/"’ target=’_blank’ title=’"http://support.microsoft.com/kb/289573/"’>this KBA</a><br />and solved the problem by deleting an alias name for my SQL Server,<br />using <b>cliconfg</b> utility.<br />Well im not that expert, but it worked for me although I didn’t understand WHY!<br />Not to mention that deleting that alias name may have other effects elsewhere!<br />I hope it doesn’t [<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />]
]]>