Viewing 15 posts - 6,136 through 6,150 (of 9,707 total)
Start here:
Enable SSL Encryption for SQL Server Instance
MSDN Blog on Encrypted Connections
You can also google "sql 2005 encrypted connection" (without the quotes) for more articles.
March 30, 2011 at 9:10 am
Using PC Anywhere doesn't necessarily mean there's a VPN or SSL tunnel set up. You might want to check on that to make sure connections really are already encrypted.
The...
March 30, 2011 at 6:13 am
Perry,
I appreciate the help you're trying to give me, but you're giving advice based on incorrect assumptions about my setup. This might be because I'm not stating it correctly. So,...
March 30, 2011 at 6:03 am
ALZDBA (3/29/2011)
Did you try dtcping and dtctester?
Hadn't heard of those tools until you told me about them. I'll check into them. Thanks for the link.
Did someone alter DNS settings, firewall...
March 30, 2011 at 5:47 am
Sorry it took so long. Had fires to put out.
SELECT srsf.DTConID, srsf.CNum,
CASE WHEN srsf.TransactionDate >= srsf.CycleStartDate AND srsf.TransactionDate <= srsf.CycleEndDate
AND pr1.DTConID IS NULL AND srsf.Status NOT...
March 30, 2011 at 5:00 am
Thanks, Perry, but MSDTC is running as a clustered resource (I thought I mentioned that in my first post, but upon re-reading, I apparently phrased the sentence in vague terms)....
March 29, 2011 at 12:46 pm
Alzdba, Thanks for the links. I've seen a few of them before, but the one on tracing is new and I might just have to do that.
March 29, 2011 at 12:03 pm
Perry Whittle (3/29/2011)
March 29, 2011 at 11:46 am
Rhox (3/29/2011)
Why should you use this command for?
Honestly, I wouldn't use this command. I can't think of one good reason why I would need it in any production environment I...
March 29, 2011 at 11:41 am
Further information (which just goes to prove that even informational messages in the logs can be helpful):
Application Log Informational Message
Event Source:MSSQL$ACP1
Event Category:(2)
Event ID:8562
Date:3/28/2011
Time:8:51:33 PM
User:N/A
Computer:XXXXXXXXXXXXXX
Description:
The connection has been lost with...
March 29, 2011 at 9:18 am
GilaMonster (3/29/2011)
Brandie Tarvin (3/29/2011)
The command being discussed has the effect of turning the database (temporarily) to SIMPLE mode because it throws out the transaction log backup
No it doesn't. It...
March 29, 2011 at 8:25 am
ALZDBA (3/29/2011)
Other Q may be:- is this only to a single node or does it happen with all nodes ?
Sometimes it's just the node that MSDTC is attached to. Sometimes,...
March 29, 2011 at 8:24 am
Rhox (3/29/2011)
And can we use this command on a mirrored db?Or do we need to take other actions to shrink the log-file of a mirrored db?
I'm curious where you got...
March 29, 2011 at 8:20 am
Tom.Thomson (3/29/2011)
Ray K (3/29/2011)
Peter Trast (3/28/2011)
'Spensive-- Ricky Ricardo
LUUUUUUUUUUUU-CYYYYYYYYYYYYY!!!
DIAMONDS
Sky
March 29, 2011 at 8:17 am
Viewing 15 posts - 6,136 through 6,150 (of 9,707 total)