MSDTC configuration problem

Hi.
My application needs to do distributed transaction on remote Sql server.My
application can be run from workstations(XP professional) or from SQL server
2000...
Limitations for this application are
Worksations wont be having SQL server installed.
I cannot give administrative rights on the SQL server 2000 system( i can
give administrative rights in the SQL server itself but not for the whole
server system)
I created a sample application which has a class for doing distributed
transactions which is derived from ServicedComponent. This application when
run on SQL server 2000 runs fine.It runs fine when worksation also has SQl
server.
But i tried to run this application from a worksation where SQL server is
not installed it doesnt work.Then i configured workstations MTC to point to
remote server and when i created workstaion's login on the server machine as
administrator then the application works...but if i remove the administrator
rights on the system it doesnt...I read in the article TO CONFIGURE MSDTC
needs administrative rights on the server as well as the client.But after
configuration is over i removed the administrative right and kept it as
Standard user or restricted user it doesnt work.But since Our system cannot
give administrative logins for all the clients this would not work.

> is there any other way to make this work!!
Hello,
Did you give the workstation login the appropriate permisssions in SQL
Server? Did you tried to use SQL account to login?
Thanks,
Mohamed Sharaf
MEA Developer Support Center
ITWorx on behalf Microsoft EMEA GTSC

MSDTC

Hi,

I am running SQl 7.0 (SP4) on Windows XP Professional (SP2). Whenever I try an insert/update type of activity, the System returns the following message :

Server: Msg 8501, Level 16, State 3, Line 2
MSDTC on server 'SERVER' is unavailable.

However, all the required services including MSDTC are running on the System.

Please help ASAP.

Thanks & Regards - Rajesh Pathak

It sounds like DTC is turned off on the other machine. Can you confirm that it is on and try again?

Thanks,
Sam Lester (MSFT)

|||Hello Sam,

Thanks for the prompt reply. As a matter of fact, trying any operation on the Server System which itself runs SQL 7.0 returns the MSDTC not running message. If it works on the Server System then I can try debugging problems on other Client Systems.

Kindly let me have probable resolution to this.

Thanks & Regards - Rajesh Pathak

MSDN Subscription SQL Server 2000

If we purchase a new MSDN Professional subscription, does it come with SQL Server 2000 developer license?Hi,

SQL Server is only not included in the MSDN Operation System and library subscriptions. For the rest a SQL Server Developer version is included, since now I am able to see 2005, 2000 and 6.5 in the download area.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Thanks a lot.