这两天有朋友在问这个问题,所以我将它发布在此

一,连接本地的SQL Server 2000、2005、2008的多个实例

这种很简单直接通过机器名加实例名就可以了,比如Raymond\MSSQL2000,Raymond\MSSQL2008等等,其中Raymond是我的机器名,MSSQL2000和MSSQL2008是我的数据库的实例名。

二,连接远程服务器上的SQL Server 2000、2005、2008的多个实例

由于有多个实例运行,它们占用的端口是不同,对于默认占用1433端口的实例,可以直接通过连接而不添加端口号:


如果不是默认实例,可以添加端口号:




如上图所示:

10.60.201.87\MSSQL2005,30453,10.60.201.87服务器IP,MSSQL2005是实例名,30453是端口号。端口号可以在配置管理器中查看和设置:


info Last modified by Raymond at 6 years ago * This page is subject to Site terms.

More from Kontext

visibility 14249
thumb_up 0
access_time 6 years ago

SQL Server Compact 4.0 (CE 4.0) is a free SQL Server embedded database ideal for building standalone and occasionally connected applications for mobile devices, desktops, Web clients and others. In one of my projects, I used it as the database for logging errors, which assumes the errors will onl...

open_in_new SQL Server

visibility 689
thumb_up 0
access_time 7 years ago

SQL Server provides a batch of great features to build robust, high-performance and scalable data solutions. ...

open_in_new SQL Server

visibility 1178
thumb_up 0
access_time 7 years ago

Serial: An Introduction to SQL Server Features Case Scenario In the previous articles of this serial, I’ve introduced how to use SQL Server as database for online transaction proces...

open_in_new SQL Server

visibility 4467
thumb_up 1
access_time 7 years ago

Serial: An Introduction to SQL Server Features Case Scenario For this ETL project, the requirements are listed below: Sales data will be pushed to specified shared fold...

open_in_new SQL Server

info About author

comment Comments (0)

comment Add comment

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

No comments yet.

Dark theme mode

Dark theme mode is available on Kontext.

Learn more arrow_forward

Kontext Column

Created for everyone to publish data, programming and cloud related articles. Follow three steps to create your columns.


Learn more arrow_forward