Dead Connection Detection DCD Cisco ASA

No Comments
Feb, 04, 2013
Angelo Schalley
Cisco, MS SQL, MySQL, Networking, security

sh runn timeout (check default timeout settings)

access-list oracle-1521 permit tcp host 10.26.x.x host 10.25.x.x (or make the access-list specific for a certain protocol)

class-map oracle-1521
match access-list oracle-1521
exit

policy-map global_policy
class oracle-1521
set connection timeout tcp 0:0:0 reset (setting no timeout for the specific access-list, DCD will determine with probes if the session needs to be torn down)

Allow Domain Admin to Login to SQLServer & have full Access

For some reason when SQLServer 2008 was installed/setup, admins were not added. Therefore when trying to login via SQL Management Studio, an error was obtained:

Login failed for user “username”. (Microsoft SQL Server, Error: 18456)

I also didn’t know the “sa” password which would have let me login. I also didn’t have access to another admin account to test logging in under their account.

No Comments
Jan, 09, 2013
Angelo Schalley
Active Directory, MS SQL, security, Windows-Microsoft

Microsoft SQL Server offers administrators two choices of performing user authentication: Windows authentication mode and mixed authentication mode. Making the proper choice affects both the security and maintenance of your organization’s databases.
Authentication Basics
Authentication is the process of confirming a user or computer’s identity. The process normally consists of four steps:

Dead Connection Detection DCD Cisco ASA

Dead Connection Detection DCD Cisco ASA

Allow Domain Admin to Login to SQLServer & have full Access

SQL authentication – mixed vs windows

Categories