Another Enterprise Manager Question

I used to do all my MSDE dev in MS Acc2K. As I was converting a friend to
developing SQL Dbs rather than Access mdb one, he discovered and downloaded
from the MS Site a util called client tools which turned out to be Enterprise
Manager.
Is this no longer available for download? If so can anyone point me to it?
I'm about to try out the web based item that I've just downloaded but I'm so
used to EM I'd prefer it if possible.
Regards,
Mr. Smith
The new SQL 2005 Express has some tools like that available. For MSDE 2K,
you'd have to either use EM off a SQL 2K CD, locate a third-party app, or
use an ASP/ASP.NET version.
"Mr. Smith" <MrSmith@.discussions.microsoft.com> wrote in message
news:8AAA465B-8043-4924-A13F-728968BDB246@.microsoft.com...
> I used to do all my MSDE dev in MS Acc2K. As I was converting a friend to
> developing SQL Dbs rather than Access mdb one, he discovered and
> downloaded
> from the MS Site a util called client tools which turned out to be
> Enterprise
> Manager.
> Is this no longer available for download? If so can anyone point me to
> it?
> I'm about to try out the web based item that I've just downloaded but I'm
> so
> used to EM I'd prefer it if possible.
> Regards,
> Mr. Smith
|||Thanks for that. I had a feeling. The Web based offering from MS is
useless, Acc2K has far better tools to admin MSDE than that. I've gotten
hold of EMS MS SQL Lite which is OK in the interim but I'm gonna have to get
hold on an SQL2K disc
Regs,
Mr. Smith
"Michael C#" wrote:

> The new SQL 2005 Express has some tools like that available. For MSDE 2K,
> you'd have to either use EM off a SQL 2K CD, locate a third-party app, or
> use an ASP/ASP.NET version.
> "Mr. Smith" <MrSmith@.discussions.microsoft.com> wrote in message
> news:8AAA465B-8043-4924-A13F-728968BDB246@.microsoft.com...
>
>

Anoter Alternative

There is another alternative ... if you are using MSCRM 3.0

follow this steps

1. Navigate to your report manager --> //<<Server Name>>/reports

2. Navigate to your datasource --> HOME > <<Datasource>>

3. At the top tab select Properties

4. Make sure that there is a user role call "NT AUTHORITY\NETWORK SERVICE" thus apply the appropiate roles for it

Vula....!!!!!

Another alternative to what?

Analysis Services service won't start

Can anyone point me in the right direction?

I haven't used SSAS in a few months and I went to start the service in SQL Server Configuration Manager and I get an error pop-up message:

The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.

However the event log has no useful info - just says the service started, then it stopped - no error related info. There are no logs generated in ..\MSSQL.1\. Every other service starts - database, SSIS, SSRS, Agent, Browser and FullText.

I'm running Sql Server 2005 (with SP1) on Win XP Pro (SP2). Any help appreciated!

Do you see anything in the System Event log?

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

|||

There were a few Information type events that said that Analysis Services started and it stopped, but no error or warning events.

I got impatient and uninstalled SSAS and re-installed and everything works now.

Analysis services connection from Data Source

Hello everybody.

I want to perform a Analysis Services Processing Task using a connection manager created from a Analysis Services data source. I create the data source using the Oledb provider for Analysis Services 9.0, and it works fine. Then I create a connection manager using the "New connection from data source" option, and it seems to create it ok.

The problem is that I can't then asign this connection to the Analysis Services processing task. I get the error:

"Connection Manager MyConectionManagerFromDataSource is not a Analysis Services Connection Manager"

However, if I create directly a connection manager using "New Analysis Services Connection" it works fine.

Is it at all possible to create a Analysis services connection from a Data Source to perform a Analysis Services Processing Task?

Thanks in advance,

Check the two Connection Manager that you have created. There must be some difference between them.

-Jamie

|||

Thanks Jamie.

I've been checking the connection strings, and there is a slight difference:

Analysis services connection manager:

Data Source=myserver;Initial Catalog=mycatalog;Provider=MSOLAP.3;Integrated Security=SSPI;Impersonation Level=Impersonate;

Connection manager from data source:
Provider=MSOLAP.3;Data Source=myserver;Integrated Security=SSPI;Initial Catalog=mycatalog;Impersonation Level=3

I've tried to change the Impersonation Level to Impersonate in the Data Source, but only integer values are alowed.

Also, in the connection manager type, I have MSOLAP90 for the AS connection manager, and OLEDB for the CM from Data source. I think this must be the issue, but I'm not able to change the connection manager type

Thanks again,