|
|
Browse by Tags
All Tags » sql server » login (RSS)
Showing page 1 of 2 (14 total posts)
-
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 Online (2008) and on web doesn't get much information on this login properties, also this ...
-
How to find all the owners of entities contained in a specified schema?
USE <database_name>;
GO
SELECT 'OBJECT' AS entity_type
,USER_NAME(OBJECTPROPERTY(object_id, 'OwnerId')) AS owner_name
,name
FROM sys.objects WHERE SCHEMA_NAME(schema_id) = '<schema_name>'
UNION
SELECT 'TYPE' AS entity_type
...
-
When configuring log shipping on a highly transactional environment (with SQL Clustering setup), we were hit by above error. All the Logins and their privileges are intact within the primary and standby servers along with Local server policies & group policies.
Initial thought of the error brings up permissions issue while copying the file ...
-
SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins that exist on a server at a specific point in time script the logins along with password. I'm not sure how many DBA are aware of this Stored Procedure and it is described in KB article 246133. Though it talks about SQL ...
-
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.------------------------------ADDITIONAL INFORMATION:Cannot show requested dialog. ...
-
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 keen on applying ''disabling SA account''!
I was confronted by a Database developer that ...
-
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 or if you are the database owner then delete and re-create the user, with the “enforce password ...
-
As you may be aware using SQL 2005 version you can set PASSWORD EXPIRY policy that can apply the same complexity and expiration policies used in Windows Server 2003 operating system to passwords used inside SQL Server. This functionality depends on the NetValidatePasswordPolicy API, which is only available in Windows Server 2003 and later ...
-
Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications
How to transfer logins and passwords between instances of SQL Serverhttp://support.microsoft.com/kb/246133/en-US
-
The following query will get you the information to find out the groups that contain user login token on that server principal:
SELECT name, usage, type FROM sys.login_token
ORDER BY usage, type, name
go
To find any Windows principal in the token that has an entry in SQL Server server_principals view ...
1
|
|
|