Re: Microsoft scorecard and security

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Deepak,

I activated the event viewer and I saw that it is my final user who is
connected but the roles are not honored.
In order to activate roles, is there any particular manipulation to do ?
Into the scorecard docs, it is said that by default the all user role is
apply to any connection.

Enforce roles into the config of scorecard doesn't let me to specify
cumulative and multiple roles for example :
role1,Role0 => only role1 is applied even the user enters into the case of
Role0

Did you have any exeprience of that ?

rgds,

Reno


"Deepak Puri" <deepak_puri@xxxxxxxxxxxxxxx> a écrit dans le message de news:
Ou4R2YCNFHA.3960@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Reno,
>
> Only thing I can think of is to confirm that the restricted user account
> you are using to test is not a member of OLAP Admin. You could set up
> user audit on the OLAP server, to confirm which account is used by the
> scorecard:
>
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.
> mspx#EUAA
>>>
> Microsoft SQL Server 2000 Analysis Services Operations Guide
> ..
> Besides monitoring query activity, you might want to determine when
> users connect and disconnect from your server. To log connect and
> disconnect events in the Windows application log, edit the AuditEvents
> key in the registry (\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP
> Server\CurrentVersion) and change the default value from 0xd (13) to 0xf
> (15).
> ..
>>>
>
>
> - Deepak
>
> Deepak Puri
> Microsoft MVP - SQL Server
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!


.

Relevant Pages

  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Exception trying to import data from Excel .
    ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
    (microsoft.public.sqlserver.tools)