when attempting to setup the DTC security settings in the Component Services console, i get this error:
"An error occurred attempting to recover from a previous error. DTC may not work correctly."
Also, the event viewer logs this:
"MSDTC encountered an error (HR=0x80000171) while attempting to establish a secure connection with system"
It is using the network service as the DTC logon account. I have tried the local service, local admin, domain admin; same issue.
I have given the network service full permissions to the msdtc log file.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.