i need a help with this problem in sql server 2005 ,, please,, please

[necib2010]

Hello. I am getting the following error when trying to connect: "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) (.Net SqlClient Data Provider)" 1) I tried seeing what services are running and nothing with SQL Server is listed. 2) I ran the Surface Area Configuration and the following message immediately pops up: "No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)" What in blazes is going on? Thanks.

[Mycroft Holmes]

This tends to be a misleading, catch all error message. Assuming you actually have SQL installed and can see the database in SSMS then I would delete the credentials you are using and re create them. This may be cause by a restore from another server corrupting the user details.

Never underestimate the power of human stupidity RAH