MSX server in SQL 2005  
Author Message
herbslc





PostPosted: Tue May 23 03:13:01 CDT 2006 Top

SQL Server >> MSX server in SQL 2005

I currently have a master server in SQL2000 and I have now have a couple of
new SQL2005 installs on different servers. I wish to make these new servers
target servers. So my question is - can a Master SQL2000 sever, target a
SQL2005 server?

Thanks
Wendy

SQL Server220  
 
 
Phill





PostPosted: Tue May 23 03:13:01 CDT 2006 Top

SQL Server >> MSX server in SQL 2005 Wendy

Did you discover anything on this?

I'm in a similar situation where we'll probably have a mixture of SQL 2005
and SQL 2000 server due to vendors not upgrading to SQL 2005.

Would dearly love to know if there is any compatibility between versions for
the MSX/TSX setup.

--

Thanks
Phill




> I currently have a master server in SQL2000 and I have now have a couple of
> new SQL2005 installs on different servers. I wish to make these new servers
> target servers. So my question is - can a Master SQL2000 sever, target a
> SQL2005 server?
>
> Thanks
> Wendy
 
 
Woo





PostPosted: Tue May 23 03:43:02 CDT 2006 Top

SQL Server >> MSX server in SQL 2005 Hi Phill,

I did not get any reponses but I found this article, so it looks like you
cannot setup a SQL2000 as a master server to connect to SQL2005 target
servers. Something we are considering is installing a named instance of
SQL2005 on our SQL2000 master server, to create a MSX 2005 server. Havent
tried it yet though!

http://msdn2.microsoft.com/en-us/ms188926.aspx

Cheers
Wendy






> Wendy
>
> Did you discover anything on this?
>
> I'm in a similar situation where we'll probably have a mixture of SQL 2005
> and SQL 2000 server due to vendors not upgrading to SQL 2005.
>
> Would dearly love to know if there is any compatibility between versions for
> the MSX/TSX setup.
>
> --
>
> Thanks
> Phill
>
>

>
> > I currently have a master server in SQL2000 and I have now have a couple of
> > new SQL2005 installs on different servers. I wish to make these new servers
> > target servers. So my question is - can a Master SQL2000 sever, target a
> > SQL2005 server?
> >
> > Thanks
> > Wendy
 
 
Phill





PostPosted: Tue May 23 05:15:02 CDT 2006 Top

SQL Server >> MSX server in SQL 2005 Please let me know how you get on with that solution.

I've tried setting up a SQL 2005 MSX but get version errors when I try and
enlist SQL 2000 TSX's


--

Thanks
Phill




> Hi Phill,
>
> I did not get any reponses but I found this article, so it looks like you
> cannot setup a SQL2000 as a master server to connect to SQL2005 target
> servers. Something we are considering is installing a named instance of
> SQL2005 on our SQL2000 master server, to create a MSX 2005 server. Havent
> tried it yet though!
>
> http://msdn2.microsoft.com/en-us/ms188926.aspx
>
> Cheers
> Wendy
>
>
>
>

>
> > Wendy
> >
> > Did you discover anything on this?
> >
> > I'm in a similar situation where we'll probably have a mixture of SQL 2005
> > and SQL 2000 server due to vendors not upgrading to SQL 2005.
> >
> > Would dearly love to know if there is any compatibility between versions for
> > the MSX/TSX setup.
> >
> > --
> >
> > Thanks
> > Phill
> >
> >

> >
> > > I currently have a master server in SQL2000 and I have now have a couple of
> > > new SQL2005 installs on different servers. I wish to make these new servers
> > > target servers. So my question is - can a Master SQL2000 sever, target a
> > > SQL2005 server?
> > >
> > > Thanks
> > > Wendy