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...
>

No comments:

Post a Comment