Re: Do SqlServer 2000 & SqlServer 2005 co-exist

Hello David,

I agree with Arnie that you shall not encounter conflicts or port confusion
from clients. You could install SQL 2005 or 2000 as a default instance and
the other version as a named instance. For default instance, the default
port is 1433. For named instance, it is dynamical but you could configure
it as fixed port.

Certainly you could install both SQL 2005 and 2000 as named instance. Also,
the ports of both instances are dynamical got and you could configure it as
fixed ones.

You could run SQL Server configuration manager to configure TCPIP protocals
of SQL 2005 instances. As for SQL 2000 instances, ususally you shall use
SQL 2000 server network utility.

Usually clients shall query server to get the dynamical port of named
instance, and then connect to that instance.

INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/kb/287932

If you do encounter issues when connecting to named instance of SQL Server,
you may want to configured a fixed port on server/cleint to test.

Please feel free to let's know if you have any further questions or
concerns. I look forward to your reply. Thank you!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
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.

.

Relevant Pages

  • Re: SSIS as part of scheduled job fails
    ... An SSIS package does not run when you call the SSIS package from a SQL ... Microsoft SQL Server Management Studio ... I ended up contacting Microsoft and opening a support case. ...
    (microsoft.public.sqlserver.dts)
  • Re: Cannot setup SQL Mail on SBS 2003
    ... Microsoft CSS Online Newsgroup Support ... Cannot setup SQL Mail on SBS 2003 ... The account you use to start the SQL Server service must be a domain ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Express Edition Network Deployment Error
    ... I have instructed my colleague to ask for a quotation of MS SQL Standard to solve our problem. ... There is a 25% Discount on SQL Server up to Sept this year. ... Because your mdf is located in a network share and our app accesses the mdf ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: hack using xp_cmdshell
    ... > Fortunately 14 years of SQL experience, and a little common sense, would ... > should run it on a different port and just have my developers connect to ... Tibor Karaszi, SQL Server MVP ... >> install SQL Server in Windows Only mode and then Switch down to Mixed ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Express Command Options
    ... You couldl use "disablenetworkconnections" swith in SQL Express setup ... If you want to change the port the server is listening, ... Dim MachineName As New String) ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
Loading