Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-14 : 08:42:15
|
| Keith writes "We're running SQL7 on a web server using a middle tier to interrogate the database. Everything has been working perfectly. However, since our hosting company applied SQL7 Patch ReleaseID=35066 (late Dec 2001) we have a problem. The error message on the returned .asp pages is:"MSDTC on server 'MAIN' is unavailable" All settings/configurations on the server have been checked, double checked and rechecked and all appear OK. MSDTC is running OK on server. Everything appears to be pointed correctly.We can only assume that something in this patch has caused a problem. Does anyone have any suggestions? .... pleeeez!!RegardsKeith" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-14 : 12:52:55
|
| Here are a couple of things to check:Check the 'remote proc tran' configuration option. If it is 1 set it to 0.Change the Service startup accounts for DTC to match the MSSQLServer account.Check the Event logs, are there any other errors related to this?HTH-Chad |
 |
|
|
Argyle
Yak Posting Veteran
53 Posts |
Posted - 2002-01-15 : 19:40:10
|
| Make sure that the MSDTC service is started on all servers involved in transactions and not just the database server./Argyle |
|
|
|
|
|
|
MSDTC on server 'MAIN' is unavailable