I have a SQL Server 7 running on NT 4.0 (not by choice). Last night at about 10:00 pm a scheduled DTS package failed. It has been running hourly for months without any problems. Suddenly I'm getting an error "Server could not load DCOM."
Has anyone else experienced this, and if so, how did you fix it?