Browse by Tags

SQL Server 2008 - Policy Based Management - usage of ##MS_PolicyEventProcessingLogin## under Security, Logins in Management Studio

Published 13 October 8 2:31 AM | SqlServer-QA.net

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...

Filed under: sql server, security, login, team, permissions, sa, policy based framework, pbm

Disable SA account on a live SQL Server2005 instance, any drawbacks?

Published 13 August 7 4:3 AM | SSQA.net

Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more...

Filed under: sql server, management, microsoft, security, windows, login, sa, disable, authentication, mixed

Error message when you install SQL Server 2005: "Cannot alter the login 'sa', because it does not exist or you do not have permission"

Published 12 June 7 12:36 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications Error message when you install SQL Server 2005: "Cannot alter the login 'sa', because it does not exist or you do...

Filed under: sql server, security, login, kba, permission, sa