Search Results: security

• 
  Installation Blocked in Windows Server 2003

  Yesterday, I assisted a client who was trying to install a thrid party app to use in Visual Studio. He was using RDP to log on to a remote machine running Windows Server 2003 and run the msi. Each time he tried, he received an error message telling him he

  Author:  ShawnHarrison     Date: 3/31/2010     Section: Blog

  tags : 2003, applications, Enhanced, network, security, Server, Windows
• 
  Applying Security to Calculated Measures

  Tired of not being able to secure your Calculate Measures through SSAS? One of the biggest issues facing Analysis Services Developers these days is applying security to calculated measures through roles. The problem is with the default behavior exhibited

  Author:  AdamJorgensen     Date: 2/21/2010     Section: Article

  tags : Calculated Measure, Security, SSIS
• 
  SSAS Data Security (Dimension and Cell Security)

  SSAS provides the way to secure analysis services database/cube data from unauthorized access. Analysis services provides secure access by creating object called "roles". This article will talk in detail about dimension and cell level security.

  Author:  sirfnet     Date: 1/10/2011     Section: Article

  tags : SSAS, SSAS Tutorial, Tutorial, Advanced Feature
• 
  SSAS Data Security (Dimension and Cell Security)

  SSAS provides the way to secure analysis services database/cube data from unauthorized access. Analysis services provides secure access by creating object called "roles". This article will talk in detail about dimension and cell level security.

  Author:  sirfnet     Date: 1/10/2011     Section: Article

  tags : SSAS, SSAS Tutorial, Tutorial, Advanced Feature
• 
  Testing Security in SSAS

  Security in SSAS is a simple yet powerful application of windows integrated security. MDX adds extra power to this by allowing us to conditionally apply security and allow or deny specific sets of data within more global parameters. The most common questi

  Author:  AdamJorgensen     Date: 2/20/2010     Section: Blog

  tags : Security, SSAS
• 
  Pull security info only from Cube backup file

  Hi everybody, I have a couple of SSAS db backups and i need to check the security roles of each of them. Is there any way i can pull just the security info from the (.abf) cube backup files without the whole restore of the cube catalogue. I know this soun

  Author:  asimshrestha     Date: 1/12/2012     Section: Forum

  tags : restore, roles, Security, ssas backup, xmla
• 
  SSRS governance

  Practical experience in managing the SSRS environment seems not to be shared. Governance and process around shared datasource creation. Managing security. Migration of objects from a report development environment to a production environment. General guid

  Author:  syale     Date: 3/9/2011     Section: Forum

  tags : attribute, format, governance, guidance, migration, SSRS, variable, xquery
• 
  Discover the power of Microsoft SQL Server with sql server business intelligence

  SQL 2005 or 2008, how do you configure security to allow a user to SELECT data from a table but not view the table definition?

  Author:  fvcdata2011     Date: 1/9/2012     Section: Article

  tags : sql Interview questions and answers, sql select statement, sql server error 18456, SQL Update Join
• 
  Show correct totals when using SSAS role security

  When using role security in SSAS, one point of confusion is when a person sees the grand total for a measure that includes the total of ALL members in the cube, even though the security has limited the members that person can see. To fix this, check the “

  Author:  jamserra     Date: 6/10/2011     Section: Blog

  tags : Security, SSAS
• 
  Implementing Security With SSAS

  Pragmatic Works just published a video on their YouTube channel put together by yours truly on implementing security in your SQL Server Analysis Services cube . The video covers implementing basic dimensional security, cell security, as well as an extende

  Author:  DustinRyan     Date: 10/17/2012     Section: Blog
• 
  SQL Lunch #26 Analysis Services Security

  Today at 12:30 EST I will be presenting for SQL Lunch on the topic of Analysis Services Security. Make sure to be there to learn how to create dynamic or table based security in SSAS. Speaker: Devin Knight Add To Outlook: Add To Calendar Date and Time: 8/

  Author:  DevinKnight     Date: 8/5/2010     Section: Blog

  tags : Presentations, SSAS
• 
  SalesForce Source from Task Factory

  Below I will show you how to use the SalesForce Source within your dataflow. As you will see below this is very easy to configure thanks to Task Factory. First things first you need to drag over the SalesForce Source into the dataflow. After that you will

  Author:  ChrisAlbrektson     Date: 6/30/2011     Section: Blog

  tags : Pragmatic Works, Sales Force, Sales Force Source, SalesForce, Task Factory
• 
  Setting up Security on sub sites in SharePoint 2010

  A lot of companies have several departments and want to limit the sub sites users can view. For example, the IT department should only see the IT sub site, but the HR department may need to be able to see all sub sites. To set up individual security for s

  Author:  MikeDavis     Date: 2/25/2011     Section: Blog

  tags : security, sharepoint
• 
  SSRS 2008 R2: Implementing Row-level Security

  When working at large organizations with several users, managing security using Windows or SQL authentication could be challenging. However, there are a couple of solutions that can be used to quickly and easily resolve the problem. First, you could follo

  Author:  PatrickLeBlanc     Date: 10/13/2011     Section: Blog
• 
  ssas Cube

  Hi there. Well, there is a lot to consider before creating a cube, depending on your needs. I would ask you this: 1) Refresh frequency that data will be refreshed? daily, hour? 2) How many records will be updated in each refresh? 3) Is there any security

  Author:  marcoadf     Date: 4/3/2012     Section: Forum

  tags : Design, Security
• 
  ssas Cube

  Hi there. Well, there is a lot to consider before creating a cube, depending on your needs. I would ask you this: 1) Refresh frequency that data will be refreshed? daily, hour? 2) How many records will be updated in each refresh? 3) Is there any security

  Author:  marcoadf     Date: 4/3/2012     Section: Forum

  tags : Design, Security
• 
  SSAS Understanding Multiple Security Roles

  In a previous article I showed how you can create dynamic security in SSAS. This is a great way to make all security table based using Active Directory accounts associated with the items that the user is allowed to see. If you decide that your security mo

  Author:  DevinKnight     Date: 12/28/2010     Section: Blog

  tags : SSAS
• 
  SSIS File Copy Failure

  Are you getting anything in the SQL error logging? Anything useful in the system application / security event logs on the server? It sounds like share permissions to me. I would suggest that you double-check your SSIS Proxy'd accounts rights on BOTH of th

  Author:  KeithHyer     Date: 1/5/2012     Section: Forum

  tags : file copy, file system, system.io
• 
  Use of Schemas in Data Warehouse Design - Need advice.

  That is awesome that you were able to attend Brian and Devin's SSAS workshop. I am sure it was very informative. As for your question and Devin/Brian's response... I would definitely do the same thing. It is actually pretty common to do that because secur

  Author:  briankmcdonald     Date: 11/29/2010     Section: Forum

  tags : Schema separation, datawarehouse
• 
  Sharepoint

  What are the advantages of integrating Sharepoint into SQL-Server Reporting Services? Are there costs associated? How is security handled? Do organizations run dual environments - SSRS & Sharepoint? What's the downside of using Sharepoint? Thanks, Jon

  Author:  TampaBayBI     Date: 4/6/2011     Section: Forum

  tags : license, Security, Sharepoint, ssrs2005
• 
  Security Extenction : Authorization

  Hi Friends, I have worked on security extenction for SSRS for Form Authentication. where SSRS alow us to athunticate user; but this time my requirement is bit diffrent.I have to use windows authentication to authenticate user (as default property of SSRS)

  Author:  pawandeep     Date: 3/19/2012     Section: Forum
• 
  Drillthrough not working with data level securtiy enabled in SSAS cube for a read user role

  I have a read user role in which the users are restricted to some of the attributes of a dimension. Created a drillthrough action in cube with some set of measures and dimensions (dimension or dimension attributes which has data level securtiy enabled are

  Author:  Vidyasagar     Date: 2/6/2012     Section: Forum

  tags : data level security, drillthrough action, ssas cube
• 
  Reports to Sharepoint

  You can setup SSRS to run in Native SharePoint mode so you can deploy reports to SharePoint. SSRS already lets you export to PDF so if you just create a basic report that way they already have that option. In regards to pulling data, when you deploy the r

  Author:  sqlchicken     Date: 8/11/2011     Section: Forum

  tags : PerformancePoint, Sharepoint
• 
  Problems with ReportBuilder Permissions

  The user of Report Builder doesn't have the correct role permissions. There are a few solutions, but the best solution in my mind is to create a new system user role. You can just assign the user to a System User or System Administrator role and they will

  Author:  laellocher     Date: 12/2/2009     Section: Forum

  tags : Permissions, Report Builder
• 
  Task Factory's Secure FTP Task

  Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugg

  Author:  briankmcdonald     Date: 9/3/2011     Section: Blog

  tags : Brian K McDonald, Secure FTP Task, task factory