Connect to another server?

I am developing on a 2005 SQL Server Developer edition and trying to connnect
to a 2005 SQL Server Standard edition.
I have set up an alias to the Standard machine on the Developer machine, using
an IP address and port 1433. But this server does not show up when Browsing for
Servers from the Developer machine. And, yes, I can ping from Developer to
Standard. The connection is a VPN.
Strangely, I can Browse for Servers from the Standard to Developer - but only
see 8.0 instances on the Developer, not the 9.0 instance on the Developer.
Are you not allowed to see other servers from Developer?
Thanks, Flomo
Niall,
Surface Area on the Developer machine was already set to use TCP/IP for remote
connections. And I can see the Developer machine from the Standard machine, but
only v8.0 instances.
Thanks, Flomo
In article <uXSlJzsbHHA.2088@.TK2MSFTNGP04.phx.gbl>, ei.2o@.naganalfdn says...
> Flomo,
> SQL Sever 2005 Surface Area Configuration for Express, Evaluation &
> Developer Editions allows local connections only by default. This can be
> changed under remote connections. This is is why you cannot see the SQL
> Servef 2005 developer edition from any other machine.
> It might also impact the aliasing.
> regards,
> Niall Flanagan.
> SQL Server MVP, Ireland.
> "Flomo Togba Kwele" <flomo@.community.nospam> wrote in message
> news:MPG.206fa1f2eaa2eb9f9896a4@.news.covad.net...
>
>
|||Hello Flomo,
Could you please refer this article to troubleshoot the connectivity issue?
827422How to troubleshoot connectivity issues in SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;827422
Although this article is about SQL 2000, it also applied for sql 2005.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||If you are using named instances, SQL Browser service must be enabled and
started.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Larry Marshall" <flomo@.community.nospam> wrote in message
news:MPG.207060e91e90042f989680@.news.giganews.com. ..[vbcol=seagreen]
> Niall,
> Surface Area on the Developer machine was already set to use TCP/IP for
> remote
> connections. And I can see the Developer machine from the Standard
> machine, but
> only v8.0 instances.
> Thanks, Flomo
> In article <uXSlJzsbHHA.2088@.TK2MSFTNGP04.phx.gbl>, ei.2o@.naganalfdn
> says...
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.