Showing posts with label versions. Show all posts
Showing posts with label versions. Show all posts

Monday, February 20, 2012

MSDTC across different Windows versions

Hi there.
I have a MS Distributed Transaction Coordinator qestion which doesnt involve
a clustered setup at all. I know this may not technically be the correct
forum but I've solved other MSDTC issues here before so I was hoping...!
Do you know whether any problems should be anticipated with distributed
transactions if a series of linked or remote servers were set up on machines
with different operating systems? I'm about to set up a system with 2
machines on Winows2003 and one on Windows NT => I just want to know whether
it's possible to get a distributed transaction to run ok across all 3
servers...
Any info would be appreciated!
The same protocols are used; however, technically, DTC did not come around
until Win2K. For NT 4, it was Option Pack and MTS. So, there could be some
compatibility issues there.
However, the SQL Server BEGIN DISTRIBUTED TRANSACTION is the same.
Best I can say is Test, Test, Test.
Sincerely,
Anthony Thomas

"len" <len@.discussions.microsoft.com> wrote in message
news:E31BBA8A-F9CA-4BB2-B286-29B1062030B6@.microsoft.com...
> Hi there.
> I have a MS Distributed Transaction Coordinator qestion which doesnt
involve
> a clustered setup at all. I know this may not technically be the correct
> forum but I've solved other MSDTC issues here before so I was hoping...!
> Do you know whether any problems should be anticipated with distributed
> transactions if a series of linked or remote servers were set up on
machines
> with different operating systems? I'm about to set up a system with 2
> machines on Winows2003 and one on Windows NT => I just want to know
whether
> it's possible to get a distributed transaction to run ok across all 3
> servers...
> Any info would be appreciated!
>

MSDN SQL 2005 versions

I'm a MSDN subscriber and recently installed SQL 2005 developer edition and
noticed it installed a version of visual studio. I'd prefer to install VS
pro edition seperate from SQL 2005. Should I install SQL 2005 Standard
version instead of developer edition and then install Visual Studio Pro
edition?
I couldn't find in the SQL 2005 developer edition install options where to
choose not to install the visual studio version.If you do not want the VS part to be installed, during installation, you can
opt out of installing the Business Intelligence Development Studio. But, you
can install this becuase it gives you access to SSIS, SQLCLR, Analysis
Services projects. Once you install the VS 2005 version, you can use either
of them to do your work.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"Scott" <sbailey@.mileslumber.com> wrote in message
news:%23Mc5DHY8FHA.4076@.tk2msftngp13.phx.gbl...
> I'm a MSDN subscriber and recently installed SQL 2005 developer edition
> and noticed it installed a version of visual studio. I'd prefer to install
> VS pro edition seperate from SQL 2005. Should I install SQL 2005 Standard
> version instead of developer edition and then install Visual Studio Pro
> edition?
> I couldn't find in the SQL 2005 developer edition install options where to
> choose not to install the visual studio version.
>|||"SriSamp" <ssampath@.sct.co.in> wrote in
news:ucxBvVY8FHA.3952@.TK2MSFTNGP12.phx.gbl:

> If you do not want the VS part to be installed, during installation,
> you can opt out of installing the Business Intelligence Development
> Studio. But, you can install this becuase it gives you access to SSIS,
> SQLCLR, Analysis Services projects.
Actually, I do not believe the VS isntalled with SQL Server gives you
access to the SQLCLR projects - I'm not 100% though.
Niels
****************************************
**********
* Niels Berglund
* http://staff.develop.com/nielsb
* nielsb@.no-spam.develop.com
* "A First Look at SQL Server 2005 for Developers"
* http://www.awprofessional.com/title/0321180593
****************************************
**********|||Niels Berglund <nielsb@.develop.com> wrote in
news:Xns9719520FAE996nielsbdevelopcom@.20
7.46.248.16:

> Actually, I do not believe the VS isntalled with SQL Server gives you
> access to the SQLCLR projects - I'm not 100% though.
I am. You cannot open SQLCLR projects with BIDS.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||Sorry about that. Since what SQL Server installs is anyways BI related, I
guess SQLCLR is not allowed.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"Ole Kristian Bangs" <olekristian.bangas@.masterminds.no> wrote in message
news:Xns971961B226E4Dolekristianbangaas@.
207.46.248.16...
> Niels Berglund <nielsb@.develop.com> wrote in
> news:Xns9719520FAE996nielsbdevelopcom@.20
7.46.248.16:
>
> I am. You cannot open SQLCLR projects with BIDS.
> --
> Ole Kristian Bangs
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||If I install VS 2005 1st, will SQL 2005 pick up on that and not install it's
VS version?
"SriSamp" <ssampath@.sct.co.in> wrote in message
news:ucxBvVY8FHA.3952@.TK2MSFTNGP12.phx.gbl...
> If you do not want the VS part to be installed, during installation, you
> can opt out of installing the Business Intelligence Development Studio.
> But, you can install this becuase it gives you access to SSIS, SQLCLR,
> Analysis Services projects. Once you install the VS 2005 version, you can
> use either of them to do your work.
> --
> HTH,
> SriSamp
> Email: srisamp@.gmail.com
> Blog: http://blogs.sqlxml.org/srinivassampath
> URL: http://www32.brinkster.com/srisamp
> "Scott" <sbailey@.mileslumber.com> wrote in message
> news:%23Mc5DHY8FHA.4076@.tk2msftngp13.phx.gbl...
>|||"Scott" <sbailey@.mileslumber.com> wrote in message
news:uCaM73d8FHA.2644@.TK2MSFTNGP10.phx.gbl...
> If I install VS 2005 1st, will SQL 2005 pick up on that and not install
> it's VS version?
>
Yes, and vice versa. Both products share the VS shell and just install
different components.
David