Unable to connect to SQL2005 database engine | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Unable to connect to SQL2005 database engine

Hi <br />I have installed SQl2005 on my desktop.I did not have any sql instances installed before.<br />After installing when i tried to login uning windows authentication .it gives me the error:<br />Please help as i am having hard time trying to login .<br /><br /><br />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) (Microsoft SQL Server, Error: 2)<br /><br /><br />The installed instance details are below:<br />Microsoft SQL Server Management Studio 9.00.1399.00<br />Microsoft Analysis Services Client Tools 2005.090.1399.00<br />Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-215<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /><br />Microsoft MSXML 2.6 3.0 4.0 6.0 <br />Microsoft Internet Explorer 6.0.2900.2180<br />Microsoft .NET Framework 2.0.50727.42<br />Operating System 5.1.2600
What version of sql server you installed? How you are trying to connect? Open the Surface Area Configuration (SAC) and change the setting to allow remote remote connections and see…. MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

When I tried to open the SAC i got the following message : "No SQL Server 2005 components were found on the specified computer.
Either no components are installed or you are not administrator on this this computer." I have displyed the version of the installation above.Again i have installed this on windows xp proffessional on my laptop.
thanks

I am not sure you can install Regular SQL SERVER 2005 EE on XP and I believe you can install trial version of EE…
Are you sure your installation successful, check your setup file and also check services in computer management for sql server 2005 services… http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx
Check the following article…
http://support.microsoft.com/kb/328306
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

They are client tools what you have installed. The error is default that no server components are installed.
As suggested in KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 you have configure on the SQL Server. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>