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.
>

Regarding DataMining in SQL Server 2005 Analysis Services

Hi to all

I have a complex scenario , so first I want to ask out the feasibility of it . I think its better if I state the scenario and some one on this forum reply to it , I need to build an application (e.g credit card application , Loan Application etc ) that requires some approval from expert , what I firstly want is that I apply datamining on this data so that next time when I enter the data the result (approval or reject ) should be given by datamining tool , this I gather is poosible by using Analysis Services in SQL 2005 , but I also want the bases of that decision ( I mean the rules/some thing else that the Datamining created agaisnt the data entered ) , So can any one do any help on this , you can also reach me at razi_rais@.yahoo.com . its preety much urgent so your prompt response is higly appreciated.

Thanks and Regards

Razi Bin Rais

Moving to DM forum

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

|||

Data Mining definately has the ability to do this. Since you are apparently new at data mining I would recommend the Data Mining with SQL Server 2005 book and also using the Data Mining Addins for Office 2007 to get started in learning and exploring the tools.

Instructions for getting the preview build of the addins as well as eval editions of Office and SQLServer are here: http://blogs.msdn.com/jamiemac/archive/2006/12/29/try-out-the-data-mining-addins-for-office-2007-free-for-60-days.aspx

|||

Hi Jamie

Thanks for your feedback , I will certainly look into resources you specify . For now can you please amplify on two points

1) Is DM in SQL Server 2005 provides any way to get the rules out of it , on basics of which it makes decision. I mean through object model , or plain xml ... anything?

2) Can you give me simple example of application (step wise / demograpic / architecutal ) like say credit card application or loan approval application that has very simple schema and only have accept or reject option apart from simple personal details of customer that will be predicted by DM (After entering some sampel data ) , and if possible the above point 1 for it .

Thanks again

Razi

|||

This link might be helpful: http://www.sql-server-performance.com/ec_data_mining.asp

It includes an high-level example of a credit approval application utilizing data mining...

Frank

sql

Reg: ADOMD Connection With multi language support

I have a SQL Server AS 2005 Database with multi language support. Through Analysis Service browser if i change the language iam getting the selected language data.

In My web application by using ADOMD I need to fetch different languages data. How can get the different languages data?

In the Sql Server Reporting Sevice also i need get the different languages data.If any body knows about this can you please help me.

Regards

Hanu

Moving the thread to the more appropriate forum.|||

Try setting the Locale Identifier connection string property to the numeric identifier of the locale whose language you want to see. For instance, if you connect to the Adventure Works cube with Locale Identifier=1036 then you'll see the French translation of the cube.

HTH,

Chris