Sign in
|
Join
|
Help
Home
Blogs
WordPress Blogs
Media
All Tags
»
property
(
RSS
)
MVP WordPress Blogs
Loading...
Tags
.NET
Advisories / Bulletins
ASP.NET
C#
Community
ConfigMgr 2007
Digital Media
Events
Exchange
General
General Security News
Media Center
Microsoft
News
Rants
Security
Sharepoint
SPPS03_Tips
SQL Server
System Center
Tools
VB
Vista
Windows 7
Windows Server
Browse Blog Posts by Tags
Showing related tags and posts for the
Blogs
application. See
all tags in the site
access
error
expiry
login
password
permissions
rights
security
sql server
sql server agent
sqlsmo
ssma
ssms
tsql
users
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
Property IsLocked is not available for Login '[x]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
One of my colleague has been getting following error when trying to open few logins properties to change their default databases using SSMS. TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. --...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Aug 22 2007
Filed under:
Filed under:
sql server
,
security
,
ssms
,
error
,
login
,
property
,
ssma
Error: Property MustChangePassword is not available for login
If you have stumbled with the error "Error: Property MustChangePassword is not available for login.." or same as the picture show below: To solve the issue either you have to take out the "enforce password policy" using SA privileges...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Aug 7 2007
Filed under:
Filed under:
sql server
,
ssms
,
users
,
login
,
password
,
property
,
sqlsmo
TSQL to find a login's properties such as password expiration?
declare @name nchar ( 100 ) SET @name = '<LoginName' SELECT LOGINPROPERTY ( @name , 'PasswordLastSetTime' ) AS PasswordLastSetTime , LOGINPROPERTY ( @name , 'IsExpired' ) AS IsExpiried , LOGINPROPERTY ( @name , 'IsLocked'...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Jul 23 2007
Filed under:
Filed under:
login
,
password
,
tsql
,
expiry
,
property
Page 1 of 1 (4 items)