I am running SQL Server 2k version 8.00 on one pc (A) on a lan,
and SQL Server 2005 Developer Edition version 9.0 on another (B).
I can see the 2k server on A from Management Studio on B
but I can't see the 2005 server from Enterprise Manager on A.
Is this a limitation or have I just done something wrong?
(I previously tried using SQL Express on B and got the same result
so I uninstalled that and installed Developer Edition instead).
Thanks in advance.
Peter CroftSQL Server 2000 Enterprise Manager cannot work with SQL Server 2005. It
doesn't understand SQL Server 2005 features like XML data types, etc. You
can connect to SQL Server 2005 using SQL Server 2000 Query Analyzer, or you
can use Management Studio to connect to both versions.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter Croft" <peter_croft@.textandvideo.co.uk> wrote in message
news:OXBbLXcgHHA.4980@.TK2MSFTNGP02.phx.gbl...
>I am running SQL Server 2k version 8.00 on one pc (A) on a lan,
> and SQL Server 2005 Developer Edition version 9.0 on another (B).
> I can see the 2k server on A from Management Studio on B
> but I can't see the 2005 server from Enterprise Manager on A.
> Is this a limitation or have I just done something wrong?
> (I previously tried using SQL Express on B and got the same result
> so I uninstalled that and installed Developer Edition instead).
> Thanks in advance.
> Peter Croft
>
Showing posts with label lan. Show all posts
Showing posts with label lan. Show all posts
Thursday, February 16, 2012
Cannot see SQL Express 2005 from SQL Server 2k
I am running SQL Server 2k version 8.00 on one pc (A) on a lan, and SQL
Express 2005 version 9.0
on another (B). I can see the 2k server on A from Management Studio Express
on B but not the other way round.
Is this a limitation or have I just done something wrong?
Thanks in advance.
Peter CroftIIRC SQL Server Express' tools are limited in functionality. I just tried it
here in the lab and I can't connect to any external servers.
Ah, why not just plop down the $39.95 and get the Developer Edition. Its
tools are unlimited.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Peter Croft" <peter_croft@.textandvideo.co.uk> wrote in message
news:%23AJdQuHeHHA.2188@.TK2MSFTNGP04.phx.gbl...
>I am running SQL Server 2k version 8.00 on one pc (A) on a lan, and SQL
>Express 2005 version 9.0
> on another (B). I can see the 2k server on A from Management Studio
> Express on B but not the other way round.
> Is this a limitation or have I just done something wrong?
> Thanks in advance.
> Peter Croft
>|||Thank you, I guess I'll do that. What surprises me is that I can see "out"
but not "in".
Peter
"William (Bill) Vaughn" <billvaRemoveThis@.betav.com> wrote in message
news:uHRaexIeHHA.4996@.TK2MSFTNGP03.phx.gbl...
> IIRC SQL Server Express' tools are limited in functionality. I just tried
> it here in the lab and I can't connect to any external servers.
> Ah, why not just plop down the $39.95 and get the Developer Edition. Its
> tools are unlimited.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ----
---
> "Peter Croft" <peter_croft@.textandvideo.co.uk> wrote in message
> news:%23AJdQuHeHHA.2188@.TK2MSFTNGP04.phx.gbl...
>
Express 2005 version 9.0
on another (B). I can see the 2k server on A from Management Studio Express
on B but not the other way round.
Is this a limitation or have I just done something wrong?
Thanks in advance.
Peter CroftIIRC SQL Server Express' tools are limited in functionality. I just tried it
here in the lab and I can't connect to any external servers.
Ah, why not just plop down the $39.95 and get the Developer Edition. Its
tools are unlimited.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Peter Croft" <peter_croft@.textandvideo.co.uk> wrote in message
news:%23AJdQuHeHHA.2188@.TK2MSFTNGP04.phx.gbl...
>I am running SQL Server 2k version 8.00 on one pc (A) on a lan, and SQL
>Express 2005 version 9.0
> on another (B). I can see the 2k server on A from Management Studio
> Express on B but not the other way round.
> Is this a limitation or have I just done something wrong?
> Thanks in advance.
> Peter Croft
>|||Thank you, I guess I'll do that. What surprises me is that I can see "out"
but not "in".
Peter
"William (Bill) Vaughn" <billvaRemoveThis@.betav.com> wrote in message
news:uHRaexIeHHA.4996@.TK2MSFTNGP03.phx.gbl...
> IIRC SQL Server Express' tools are limited in functionality. I just tried
> it here in the lab and I can't connect to any external servers.
> Ah, why not just plop down the $39.95 and get the Developer Edition. Its
> tools are unlimited.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ----
---
> "Peter Croft" <peter_croft@.textandvideo.co.uk> wrote in message
> news:%23AJdQuHeHHA.2188@.TK2MSFTNGP04.phx.gbl...
>
Subscribe to:
Posts (Atom)