Either a connection cannot be made to the .\sql2005 server, or Analysis Services is not running

I get this error when trying to deploy a Analysis Services Project. I don't have the cube defined yet. I did have sql 2000 and sql 2005 installed on the same machine at one point, but I've since uninstalled them both and reinstalled only sql 2005.

Error 1 Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the '.' server. Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the '.' server. Either a connection cannot be made to the .\sql2005 server, or Analysis Services is not running on the computer specified. Errors in the metadata manager. An error occurred when loading the Tbl PM Project dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\mbn_gargle.0.db\Tbl PM Project.4.dim.xml'. File system error: The following error occurred while writing to the file 'MSSQLServerOLAPService': The event log file is full. . Errors in the metadata manager. An error occurred when loading the MBN Gargle cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\mbn_gargle.0.db\MBN Gargle.15.cub.xml'. File system error: The following error occurred while writing to the file 'MSSQLServerOLAPService': The event log file is full. . 0 0

The problem is actually because it is trying to access a named instance ".\sql2005", which no longer exists. I can see that from this message,

"Either a connection cannot be made to the .\sql2005 server, or Analysis Services is not running on the computer specified."

This happens on brand new projects.

I saw other threads on this subject and the resolutions didn't work. I tried installing the msi file listed on the sql server 2005 packages install (listed on another thread, sorry I don't have the file name handy) but it didn't work.

How do I get around this bug and have SQL look at the only sql instance on the machine, the localhost? The browser service is turned on.

Bob

Check your BI Dev studio project settings. Looks like your project is still trying to deploy to the .\sql2005 instance.

Right click on your project node select "Properties". Click on the "Deployment" node on the left and see what is the value for the Server property. Change it to the "localhost".

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

EIS reporting tool for Analysis Server

Is there a good EIS reporting tool for Analysis Services somebody
recommended me to check out - Microsoft Open EIS Builder not sure where
we can get information on this product.
Please advise good EIS solutions on top of Analysis Services
Thanks
Karen
Karen,
My website lists many of the front-end options for AS.
www.johnkeeley.com
Regards,
John
|||karenmiddleol@.yahoo.com wrote:

> Please advise good EIS solutions on top of Analysis Services
Karen,
you wanna look here:
http://www.mosha.com/msolap/util.htm
regards
frank

EIS reporting tool for Analysis Server

Is there a good EIS reporting tool for Analysis Services somebody
recommended me to check out - Microsoft Open EIS Builder not sure where
we can get information on this product.
Please advise good EIS solutions on top of Analysis Services
Thanks
KarenKaren,
My website lists many of the front-end options for AS.
www.johnkeeley.com
Regards,
John|||karenmiddleol@.yahoo.com wrote:

> Please advise good EIS solutions on top of Analysis Services
Karen,
you wanna look here:
http://www.mosha.com/msolap/util.htm
regards
frank

Edition Question for Analysis Services

Hi All

I come with Oracle background and we are planning to use SQL Server 2000 Analysis Services for OLAP.

Brief background on our app: The largest of our fact tables has about 500,000 rows per month. We plan to store three years worth of data. We will have other smaller cubes that we will have to build in addition to this. The source data will come from Oracle tables.

I am struggling to decide between the two SQL Server editions (Standard and Enterprise). I'm highlighting the things that I need some help with in order to make the decision:

Memory Limitation
------
Standard Edition only supports up to 2GB. Considering relatively large cube size (is it?), is this a limitation in our case?

Calcualted Cells (only in Enterprise Edition)
------
I didn't fully understand this one in the documentation, not having spent a lot of time. We do have a number of calculations such as the Revenue/Expense, Margin calculations, etc. Is this an important feature that I should consider?

Partitions:
----
I doubt that we will be partitioning across multiple servers (may not need distributed partioning, linked cubes). However, within a single database/instance, do I have the option to partition the cube (does it help to do so for cube manageability) if I went with Standard Edition? Also, given the large fact tables, I may want to incrementally add monthly data to the cube. Would it help to partition the cube in this case and, do I need Enterprise Edition for this?

HTTP Internet Support: (Enterprise Edition only)
-------
I would think that the HTTP access is applicable to intranet applications (ours is one). Does this support in Enterprise Edition automatically means that the data is available for analysis over the web? What tool would I use to access the data (other than the third party tools such as Crystal Analysis, Brio, etc)? I am trying to see what this means and how this relates to my decision on Std Vs Enterprise Editions.

I really appreciate any input you may have on this.

Thanks in advance
Murthy JarugumilliI would suggest to adopt Enterprise Edition as you already know the limitaitons of Standard edition.

In general Standard edition is used as a database server for a small workgroup or department.