.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Policy based management : what rights do ##MS_PolicyTsqlExecutionLogin## need

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
Hi, In order to run Policies on scheduled basis, what permissions should I grant to ##MS_PolicyTsqlExecutionLogin## login? Problem is: When I evaluate the policies myself, they dont fail, but when I schedule them, they fail reporting ##MS_PolicyTsqlExecutionLogin## login doesn't have access to <> database. Any help please?

View Complete Post

More Related Resource Links

using policy based management to exclude database access

After reading information on the link http://www.mssqltips.com/tip.asp?tip=1492 I was wondering whether its possible to have a policy in place such that database A cannot make reference to objects in database_B, I am guessing that one would have a policy such that the contents of the objects must not be like %database_B.%   Let me know whether there is a better way to do this. Thanks.

Policy-Based Management and On Change - Prevent




I’m working on Policy-Based management feature and I’m keen to implement some of the features. I tried to setup a Policy for a “backup device” facet based on the condition that the name starts with bkd_. I tried to set the evaluation mode to “On Change – Prevent” but unfortunately I could not find the mode at all in the Policy Screen. I also made sure the “Nested Triggers” advanced Option is set to 1.


I went through this  link http://blogs.msdn.com/b/sqlpbm/archive/2009/04/13/policy-evaluation-modes.aspx and checked for the execution_mode in  msdb..sysp

SQL Server 2008 R2 Enhancements to Policy-Based Management


I'm reasearching enhancements which have been made to Policy-Based Management in SQL Server 2008 R2.  I"ve found several articles and posts on PBM in general, but nothing that explicitly describes what enhancements have been implemented in SQL 2008 R2 which are not available in SQL 2008.  Does anyone know of any white papers or articles which discuss this?

Policy based management missing evaluation modes


For some reason, I only get the on demand and on schedule evaluation modes with my instance of SQL server, what is even more suprising is the fact that i am following a step by step guide and the guide seems to have the on change log only evaluation mode.

Is this a bug or something ?

I am using SQL 2008 SP1 developer edition, I get the same issue even on my standard edition.

Resource File: Windows Media 9 Series Digital Rights Management


If you have an application that handles Windows Media content and you need an effective way to track content usage, Windows Media 9 Series now offers Digital Rights Management (DRM). It allows you to take advantage of the peer-to-peer distribution model and still redirect users back to your app once they have downloaded your content (prior to viewing).

MSDN Magazine May 2003

Bug Tracker: Build a Configurable Web-Based Bug Management Tool Using ADO.NET, XML, and XSLT


One of the most significant features of ADO.NET is its integration with XML. Developers can either use an ADO-like API to access the data or work directly with an XML representation of the data. This article demonstrates how both of these techniques can be used together to create Web applications that take advantage of XML standards such as XSLT. The example presented here is a bug tracking application built using C# and the.NET Framework. The development of the application covers several topics including data access using ADO.NET, the presentation of data using XSLT stylesheets, and the integration of ADO.NET with the .NET XML Framework.

Roy Margolis

MSDN Magazine July 2002

Information Rights Management (IRM): Event 5047

We get the folowing on our WFEs we don't have IRM set up and it is not configured in central admin, does anyone know how to sotp this?_______________________________________________________________________________________________________Information Rights Management (IRM): There was a problem when trying to find the enterprise Rights Management Services (RMS) server. There was no enterprise server registered. Additional Data Service Type: 1 Error value: 8004cf48

Monitoring Rights Management Services

Hi, I've a requirement to monitor AD RMS state,AD RMS cluster state and performance. Are there any .Net libraries that facilitate these monitoring capabilities. Similarly are there libraries to monitor RMS server,Client and RMS-enabled applications. Thanks, --Prasad

Information Management Policy - Expiration not working

I've defined a new policy for my list.
The policy has expiration enabled.
The expiration date is WarningDate (required list field - date and time) + 0 days and the expiration should trigger the custom workflow, which would send the warning, but is now only setting the status to Warned.
The workflow works fine when executed manually, but never seems to be actually executed by the item expiration.

I've also updated the "information management policy" job to run every 5 minutes, but it didn't help.
What as I missing?

Policy Management ensure a table name is in the index name

I am trying to write some policies to enforce our coding standards.  One of the standards we have is to prefix indexes with IX_<tablename>; the IX_ is easy to do with the index facet.  How do you access the tables name in the condition?
Thanx, Adam

How to create a condition and policy to deny access based on host name



With SQL Server 2008 Enterprise, can I prevent an Active Directory Account Login ( domain\user ) from connecting if its coming from a host_name?

What I really need to do is this:  


On SQL1, login mydomain\user1 is only allowed to login from servers APP2, APP3, and APP4.


If mydomain\user1, though it has a login on SQL1 attempts to connection any other hostname besides APP2, APP3 or APP4 I want to deny it access to SQL1.


Can anyone point me in the right direction for the correct condition(s) for a policy that would work?



Erik A. Grob, MCITP, MCDBA

SQL Server 2008 Management Studio - "Show policy health state for all nodes"

What does "Show policy health state for all nodes" option do in SQL Server 2008 under the Object Explorer?

Screen Shot

Fill Gridview Based On Rights


I have a master table that will hold the information for publications for my company.  Not all of the publications can veiwed by all users.  What I am trying to figure out is how can I load all of the publications that the user is allowed to see into one grid view table.  For example: If Mary logs in she will only be able to see Accounts publications; if Sally logs in she can see General and Legal publications and if John logs in he can see IT, Legal and General publications.

I figured out how to do it with separate gridview tables on a page based on the roles.  I would make a gridview viewable if the user was in that role.  But I would really like to put all of this in one gridview if that is possible.  Does anyone have any ideas as to how I can do this?

Issues with IRM Information Rights Management


I am doing some testing with IRM.  It works fine outside Sharepoint.

I created two Libraries in Sharepoint - one with IRM enabled, the other without.

When I open a Word document from Sharepoint, that was IRM-enabled before putting it in the either Library, IRM works fine.

When I open a Word document from the non-IRM-enabled Library, that did not have IRM-enabled before putting it in either Library, there is no IRM, as expected.

When I try to open a Word document from the IRM-enabled Library, and that document did not have IRM on it before uploading to Sharepoint, it fails with the error:

"The internet address 'http:/sp.domain.com/IT/RIghts Management Test/testdoc.doc" is not valid."

I have full rights in the Library.  There are no errors in any of the server Event Logs.

What does this mean?  How do I fix it?


Policy Management - Use of ExecuteSQL() for Index facet to define naming convention policy


I am trying to define an advanced policy involving use of executeSql() function and @@SchemaName, @@ObjectName parameters. It is related to non-clustered index naming convention and as such I am making use of 'Index' facet.  I have defined policies for tables and procedures and I have successfully used executesql with @@SchemaName and @@ObjectName parameters. However, when I run Index policy I get the following error;

TITLE: Microsoft SQL Server Management Studio

Exception encountered while executing policy 'CompanyName - Index - Naming Convention'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=PolicyEvaluationException&LinkId=20476


Must declare the scalar variable "@@SchemaName". (Microsoft SQL Server, Error: 137)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft&#

Information Management Policy & Disposition Workflow


I would like to set an information management policy that enbles expiration of documents in my document library. I then want this to kick off a disposition workflow that will then allow the owner of the content (i.e. the last person to modify the document, or creator if it has not been modified) to either delete the document or do nothing. This is all simple to do. My question is: When the disposition workflow kicks off, does it send an email to the document owner or does it simply ceate a task in the specified task list?


If it only creates a task, is it possible to notify the document owner that a task has been created? I don't want docment owners to have to have to keep checking the task list, I want an email sent to them whenever a document is about to expire. Is this possible?

Information Management Policy & Exempt from Policy flag


Hi all,


does anyone know why the "Information Management Policy" in MOSS sets a 'yes' flag (in the 'exempt from policy' column) on the document library automatically when the specific document expires? 


And more importantly is there a way of getting around this?


What I am trying to achieve is a periodic document review schedule without having to create custom workflows in Visual Studio, and preferably sticking with the out of the box approval workflow to ease the rollout of team sites from a site template.


I thought this could be accomplished by using the Information Management Policy on the DL, but I guess not if after the first review date arrives the document is then exempt from any following dates.





ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend