how to controll user access in comercial deployment?

Hello,
We have used SSAS and SSRS to develop a BI reporting suite for our data
warehouse and would like to deploy this into our customer base, but at the
same time protect our investment.
How do we control or limit the number of users that can use our cubes and
reports? We would like to control user numbers by a licence arrangement -
either concurrent or named - but fear once a user has our developments
installed they only need to increase their MS licences and away they go...
Any help and advice appreciated.
StephenYou could do the following for named users.
1. Have your own routine that authorizes. Put the user names into a table.
Then somewhere else have the total number allowed encrypted.
2. In your reports (or even better in stored procedures) use the User!UserID
global parameter and verify the user. You could do this in a custom assembly
too. You could put a nag message on each report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephen Lonsdale" <StephenLonsdale@.discussions.microsoft.com> wrote in
message news:4AE7D682-F6D1-4E60-8641-03EC900EA69D@.microsoft.com...
> Hello,
> We have used SSAS and SSRS to develop a BI reporting suite for our data
> warehouse and would like to deploy this into our customer base, but at the
> same time protect our investment.
> How do we control or limit the number of users that can use our cubes and
> reports? We would like to control user numbers by a licence arrangement -
> either concurrent or named - but fear once a user has our developments
> installed they only need to increase their MS licences and away they go...
> Any help and advice appreciated.
> Stephen

How to connect Analysis Services to Netezza?

HI,

Netezza is ODBC compliant data warehousing applicance. There seems no way to connect SSAS to Netezza as SSAS does not support ODBC data sources.

Has any body ever tried it? Please provide any feedback, comments etc.

Thanks

Saeed

SSAS will allow you to connect through .Net providers or OLEDB providers, so you have 2 choices

1) ODBC .Net Provider http://www.microsoft.com/downloads/details.aspx?familyid=6ccd8427-1017-4f33-a062-d165078e32b1&displaylang=en

2) There is an "OLEDB Provider for ODBC", this used to be part of MDAC, I know it was in MDAC 2.7, but I have not used it since then. I think MDAC is currently at 2.8 SP1 http://www.microsoft.com/downloads/details.aspx?familyid=78CAC895-EFC2-4F8E-A9E0-3A1AFBD5922E&displaylang=en

Also from what I can see there appears to be atleast one 3rd party company offering OLEDB to ODBC "bridge" drivers.

sql

How to configure SSAS 2005 for use with Excel

Using Excel I can connect to SSAS on localhost, but when I try to do the same from another computer, I can't connect to the server.

What can I configure to allow this connection ?

I already disactivated the firewall and I added a role to the cube that I want to use. But the connection error occures when listing the cube present on the server. I don't know what I can change now....

Thanks for your help.

hello,

Try downloading the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider from the below link and try connecting it . It worked for me .

http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en

Check the Content in Microsoft SQL Server 2000 PivotTable Services for details

regards

varadaraj

How to configure SSAS 2005 for use with Excel

Using Excel I can connect to SSAS on localhost, but when I try to do the same from another computer, I can't connect to the server.

What can I configure to allow this connection ?

I already disactivated the firewall and I added a role to the cube that I want to use. But the connection error occures when listing the cube present on the server. I don't know what I can change now....

Thanks for your help.

hello,

Try downloading the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider from the below link and try connecting it . It worked for me .

http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en

Check the Content in Microsoft SQL Server 2000 PivotTable Services for details

regards

varadaraj