Re: SQL Server 2005 Evaluation - Analysis Services Connect OK / Database Engine Connect Not.

Try running through the brief connectivity tutorial in Books Online or at http://msdn2.microsoft.com/en-us/library/ms345318.aspx The Surface Area Configuration is there, but also some other issues that might be blocking you.
--
Rick Byham, MS
This posting is provided "AS IS" with no warranties, and confers no rights.

"anthony garcia" <acgarcia21@xxxxxxxxxxx> wrote in message news:YnMdh.3776$Jg.3058@xxxxxxxxxxx
Good evening,

I've been struggling with this for a few days. I was able to connect to both Analysis Services and the Database Engine of SQL Server 2005 when I first installed it. Just the other day, I started getting the error below. Now, I can't connect to my database engine. I've uninstalled and reinstalled from scratch and it's still not working. I know the evaluation period is not over.

* I searched around and saw a few entries about editing the Surface Area Configuration to allow remote connections. This is done.

Any ideas would be greatly appreciated?

TITLE: Connect to Server
------------------------------

Cannot connect to METAPHOR\ENDASOL.

------------------------------
ADDITIONAL INFORMATION:

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Regards,
Anthony



.

Loading