|
|
-
|
|
Kerberos manages the authentication method on most Windows hosted database server
systems I work on. It is a method of authenticating client and server entities.
If Windows Authentication is used, SQL Server exploits Kerberos via the Security
Support provider Interface(SSPI) T......
|
|
-
|
|
If attempting to add the Active Directory snap in to the Microsoft Management Console and you can’t see the Active Directory options in the Standalone snap ins – take the following steps:
1) Download the Administration Tools Pack – in my case it was the Windows 2003 Ad......
|
|
-
|
|
A user approached me with the error message:
Login failed for user 'mysqlaccount'. The user is not associated with a trusted
SQL Server connection. (Microsoft SQL Server, Error: 18452)
Login failed for user 'mysqlaccount'. The user is not associated with a trusted SQL
......
|
|
-
|
|
A login can be granted CONTROL SERVER rights,
USE mater
GO
CREATE LOGIN test WITH PASSWORD = ‘myPassword123’;
GO
GRANT CONTROL SERVER TO test;
CONTROL SERVER rights allows a login to do anything in SQL Server, but there is one subtle difference with sysadmin.
It is possible to exp......
|
|
-
|
|
There is a warning in the SQL Server Books Online – to stop using sp_password, as
in future editions, this procedure will cease to be used.
In effect, sp_password calls ALTER LOGIN.
To run ALTER LOGIN – an example is:
ALTER LOGIN jackvamvas WITH password =......
|
|
-
|
|
I’ve recently discovered a problem in implementing a corporate security policy. One of the policy requirements is that no logon account – can be assigned the sysadmin server role. (With a couple of exceptions)
As part of the infrastructure TDP SQL Client is used – DP – which......
|
|
-
|
|
A few things to remember when creating a new SQL Server 2008 installation.
-Unless requested the BUILTIN\Administrator logon account – which allowed OS level Local administrators to have sysadmin fixed server role by default - is not added by default to SQL Server 2008 installations
-Surfa......
|
|
-
|
|
I was doing a security audit on SQL server 2005 server, where I discovered an administrator had assigned the permission "sysadmin" to a logon.
He explained to me the reason, being that when they were on SQL Server 2000 it was involved to allow a logon read\execute rights on SQL Agent Jobs.
We've n......
|
|
-
|
|
SQL Server Security Policy allows a basis for good practise and regular audits. A SQL Server environment is characterised by various developers(internal), administrators (internal) and third party access.All these groups must be considered when creating a policy.
The list becomes the basis of a c......
|
|
-
|
|
I was using sp_detach_db to detach a database and then attempt to transfer with another DOS command. I was receiving a Access denied and couldn't figure why. Investigating closer revealed a change of permissions when using the sp_detach_db.
This was only in the situation of being a windows principa......
|
|