Regarding install analysis service

Hi Guys,
I am new in analysis service. I just installed analysis service in my
personal computer that has a sql server enterprise installed. When I opened
analysis manager and try to open the server in the left pane, I got error
that no register sql server or it is not in the olap group(roughly, I cannot
remember clearly), then server icon because red(closed). it seems like I
couldn't connect to database server. But it is same server and of cause I
have already register this server. What is wrong with this? Thanks.
it would help if 'clearly' and not 'roughly' took the time to post the full
error and in return we will 'clearly' answer your question!
It sounds to me the user account you are logged on as isn't in the OlapAdmin
group. Add your logged on account to this group and it should do the trick.
Immy
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:75B81FA5-1CEC-4815-A597-95BBCA829BDB@.microsoft.com...
> Hi Guys,
> I am new in analysis service. I just installed analysis service in my
> personal computer that has a sql server enterprise installed. When I
> opened
> analysis manager and try to open the server in the left pane, I got error
> that no register sql server or it is not in the olap group(roughly, I
> cannot
> remember clearly), then server icon because red(closed). it seems like I
> couldn't connect to database server. But it is same server and of cause I
> have already register this server. What is wrong with this? Thanks.
>
|||You will get this behavior if you are trying to run an earlier version of
Analysis Services 2000 on Win XP Pro. If this is the case, you need to
upgrade both SQL Server 2000 and As 2000 to SP4. Search the MSKB for
details.
John G.
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:75B81FA5-1CEC-4815-A597-95BBCA829BDB@.microsoft.com...
> Hi Guys,
> I am new in analysis service. I just installed analysis service in my
> personal computer that has a sql server enterprise installed. When I
> opened
> analysis manager and try to open the server in the left pane, I got error
> that no register sql server or it is not in the olap group(roughly, I
> cannot
> remember clearly), then server icon because red(closed). it seems like I
> couldn't connect to database server. But it is same server and of cause I
> have already register this server. What is wrong with this? Thanks.
>

Reg:MSDE installation

Hi All
I am trying to install MDSE SP 4 for BCM V2 and get the message setup failed
to configure server.This is what the confsgvr.out states
An error occurred while attempting to start the service (1460)
SQL Server configuration failed.
I have already tried renaming the SQL folder and reinstall still the same
issue .Also did download and install ISS Script.Any ideas ?Thanks in advance
for your time and effort
With Regards
Raul Thomas
hi Raul,
Raul wrote:
> Hi All
> I am trying to install MDSE SP 4 for BCM V2 and get the message setup
> failed to configure server.This is what the confsgvr.out states
> An error occurred while attempting to start the service (1460)
> SQL Server configuration failed.
> I have already tried renaming the SQL folder and reinstall still the
> same issue .Also did download and install ISS Script.Any ideas
> ?Thanks in advance for your time and effort
if the machine is "clean" and no leftover are present at OS level and/or
registry level
(http://support.microsoft.com/default...99&Product=sql),
the problem can be related, on WinXP sp2, to MDAC stack corruption... you
can not fix it by reinstalling MDAC as no package exists for 2.8.1 level,
but you can fix it as described in
http://www.macropool.com/en/download/mdac_xp_sp2.html
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for the update.Will the same and keep you updated
With Regards
Raul Thomas
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:40q4a5F1be76uU1@.individual.net...
> hi Raul,
> Raul wrote:
> if the machine is "clean" and no leftover are present at OS level and/or
> registry level
> (http://support.microsoft.com/default...99&Product=sql),
> the problem can be related, on WinXP sp2, to MDAC stack corruption... you
> can not fix it by reinstalling MDAC as no package exists for 2.8.1 level,
> but you can fix it as described in
> http://www.macropool.com/en/download/mdac_xp_sp2.html
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||You might check your computer hostname is all uppercase rather than a mix of
upper and lower case characters...worked for me.
"Raul" <v_2rath@.hotmail.com> wrote in message
news:%23rIP2OdBGHA.3064@.TK2MSFTNGP10.phx.gbl...
> Thanks for the update.Will the same and keep you updated
> --
> With Regards
> Raul Thomas
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:40q4a5F1be76uU1@.individual.net...
>

reg. Installation

Hi all,
I have sql 2000 client installed, with msde and sp 3a.
I am trying to install sql reporting beta version. The
installation abruptly terminates stating 'The setup need
sql server 8 or above with sp 3 installed'. Can anyone
help me in this issue asap.
regards,
Sivi.You have to have an installed instance of SQL Server 2000 (non-MSDE) in
order to install Reporting Services.
Look at the following link:
http://www.microsoft.com/sql/reporting/howtobuy/faq.asp
Rand
This posting is provided "as is" with no warranties and confers no rights.

Reference to Data.System.SqlServerCe in VS2005 does not install CE 2.0 to Emulator/PDA

We have a Compact Framework 1.1 application that uses Sql Server CE 2.0. In VS2003, a reference to System.Data.SqlServerCe causes the Sql Server CE dlls and Query Analyzer to install to the Emulator or PDA.

I am currently converting the application to Compact Framework 2.0, but we are not upgrading to Sql Server Mobile (yet). However, the reference to System.Data.SqlServerCe, in VS 2005, no longer causes Sql Server CE to install to the PDA/Emulator.

There is a difference in the build outputs between VS2003 & VS2005. In 2003, System_SR_enu.cab, sqlce.wce4.x86.cab & sqlce.dev.wce4.x86.cab are copied & lanuched. In 2005, only System_SR_enu.cab is copied... no launch.

Any ideas? Reinstall VS2005?

Reinstalling VS2005 resolved this issue.|||

Glad that things are working from your end. Thanks for using SQL Mobile.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation