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)
match access-list 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)
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.
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 is the process of confirming a user or computer’s identity. The process normally consists of four steps: