connection to analysis

[squilibrium]

Hello

i've a report project(reporting 2000) with visual studio 2003.

i'm trying to create a data source to analysis server but i've some problems with authentication.
The server with analysis is under domain but not my pc. So i cannot use windows integrated.

In reporting web console, it's possible to create a data source and give it a specific windows credential. In visual studio report project i cannot find this way.

Can someone help me?

Thank you and sorry for my bad english

 

[xlbo]

Simply insert a new data source and set it up exactly as you want - the credentials are just part of the properties of the data source...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[squilibrium]

It's not so easy...
when u create a new data source u can choose between 2 kind of logon:

1:windows integrated
2:specifica username and password

1:i cannot use integrated because my pc isn't in domain

2:username and password are not considered like domain user credential.

When u have to connect to sql server is ok because sql server use mixed mode authentication but not Analysis server.

 

[xlbo]

2:username and password are not considered like domain user credential. ??????

How would you normally vonnect to it then? Why can you not just supply a username & password?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[squilibrium]

usually i use windows integrated authentication.

I supply username & password to connect to SQL SERVER (not ANALYSY SERVER) and only if sql server authentication is set to 'mixed mode'.

Analysis Server allow only windows authentication.
I made an experiment:
I created a new datasource on the server where analysis is installed.

1) I set windows integrated. 'Test connection OK'
2) I set WRONG username and password. 'Test connection OK'

Test connection ok setting an non-existent user

I tryed from another pc (in domain): 'Test connection OK'
My pc is NOT in domain: 'enable to authenticate the user'

 

[xlbo]

Would suggest that this is very little to do with SSRS and more to do with how your security is configured...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[jymm]

this is a bit out of my comfort zone, but if it is not on the domain - dont you have to configure a fair amount with anon access --- access to the IIS server, the DB & The analysis server included???

I agree - this is a security issue

 

[squilibrium]

i really don't know

Now i'm working on a pc on the domain but i really can't understand....

I've just seen that in Reporting Service web console , i can create a data source and specify that username and password had to be "used as windows creadential".
If i create the datasource from reporting i donìt have this option

thanks guys

 

[jymm]

well - when you come in from 'outside the domain' - I know that you have to tell IIS that the annonmous user is (usually folks have it disabled - or it is under iusr_servername). In SSRS at least you THEN you need to allow security to see ssrs... then the database server, then that db... opening it up to the annon access is not a way that I would do it... but that is just me.

in short - it may not be anal svcs or SSRS that is your security problem - it could be iis OR (more likely) sql.