Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ammuhere
Starting Member
8 Posts |
 Posted - 2011-10-04 : 22:04:38
|
I installed SQL Server 2005 Enterprise Edition on Windows xp.This account exists in administrators role.But I can't connect to SQL Server database engine using either Windows authentication method or sql server authentication method and I receive this error message: 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 setttings 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:53).But im trying to connect to a local instance in my computer. Also i checked SQL SERVER 2005 surface area>> surface area configuration for services and connections >>which shows error >>No sql server 2005 componenets were found on the specified computer. Anyone can give clues on this issue. Do i need to install any components to make this work? I had selected all the options while installing.please help me on this.. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-05 : 06:22:33
|
| True. Besides, you can open services.msc (Start>Run>Services.msc) to see if you have SQL Server services installed. SQL Server database engine's service will be SQL Server (instance name). |
 |
|
|
ammuhere
Starting Member
8 Posts |
Posted - 2011-10-05 : 10:47:50
|
| Thank you for your replies. I had installed sql server 2005 standard edition and its working. |
|
|
|
|
|
|
SQL Server 2005 database engine login failed error