Browse Blog Posts by Tags

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

SQL Server agent: Property pagersendsubjectonly is not available for alert system this property may not exist for this object or may not be retrievable due to insufficient access rights.

Do you see this error in your environment? Is it a frequently occuring issue? In the recent time in a 64 bit environment we started to get this alert generated and DBAs complaining sometimes are unable to view the SQLAgent jobs on that remote server....

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jan 5 2011
Filed under: Filed under: sql server, security, ssms, access, permissions, property, sql server agent, rights
Microsoft Windows RMS enables granular access control over sensitive data

This article that I wrote for the Midmarket Security Strategies and Tactics site at TechTarget focuses on the file access control possibilities of Windows Rights Management Services. Traditional NTFS file and folder permissions are effective for preventing unauthorized users from accessing data, but...

Posted to The Edge by tonybradley on Wed, Jun 3 2009
Filed under: Filed under: windows, RMS, Rights Management Services, file and folder, access, permissions
sp_replwriterovarbin - New SQL Server Injection-Based Attack Found

Another security vulnerability or rather call in the sense of security experts that " A zero day vulnerability has been reported in SQL Server "! Though its a not serious flaw or problematic loophole to worry but still its a security flaw in...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Dec 17 2008
Filed under: Filed under: sql server, security, replication, permissions, best practices, tsql, sp_repl, functional
SQL Server 2008 - Policy Based Management - usage of ##MS_PolicyEventProcessingLogin## under Security, Logins in Management Studio

While I was scrolling through the logins for a permission task, I found the login name such as ##MS_PolicyEventProcessingLogin## & ##MS_PolicySigningCertificate##, I was bit confused and perplexed to see what it is for? As usual searching in Books...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Oct 13 2008
Filed under: Filed under: sql server, security, login, team, permissions, sa, policy based framework, pbm
EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

Granting permissions to relevant account is a required criteria within the SQL Server databases management, for this even Reporting Services is not exceptional. As per the configuration by default the users connect to the report server by using their...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, May 27 2008
Filed under: Filed under: sql server, databases, security, permissions, sqlagent, reporting services, reportserver, reportservertempdb, rsexecrole
SQL Server 2005 - specific roles for replication agents

Whenever the replication is configured, a set of agent profiles is installed on the Distributor, thsi profile will have a set of parameters that are used each time an agent runs. In addition to this the replication provides a default profile for each...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Feb 22 2008
Filed under: Filed under: sql server, replication, permissions, best practices, roles, agent, publisher, beginners, distributor, subscriptions
Internal Tables in SQL Server 2005, what are they for?

By default SQL Server automatically creates the internal tables for Full-text search, XML indexes and Service broker. These are also created when a user query is written poorly that uses tempdb heavily. At they are called internal tables but do not contain...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Nov 2 2007
Filed under: Filed under: sql server, indexes, security, search, xml, permissions, table, full-text, internal tables
Need to grant permission to view stored procedure text

If you need to grant permissions to a login that only needs to view stored procedures (contents not just names of SP's). Further you may not want to grant that login with DB_OWNER or DB_DDLADMIN roles within that database, so how to achieve this task...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Sep 10 2007
Filed under: Filed under: sql server, security, update, permissions, stored procedure, schema, execute, view definition
xp_cmdshell: a call to 'CreateProcess' failed with error code: '5'

Problem: SQL Server 2005 error: xp_cmdshell: a call to 'CreateProcess' failed with error code: '5'. We get above error when trying to execute XP_CMDSHELL even though it has been enabled using Surface Area Configuration tool and the login...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, May 24 2007
Filed under: Filed under: sql server, databases, access, permissions, xp_cmdshell

Page 1 of 1 (9 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.