简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

如何用SQL SERVER 2005连接SQL SERVER 2008

WBOY
Release： 2016-06-07 16:19:08
Original
1071 people have browsed it

原先使用sql server 2005数据库，后来由于工作需要升级为sql server 2008 开发版，升级过程很简单，基本没有什么问题 下面主要说说，如何使用sql server 2005 studio来连接sql server 2008，过程其实很简单，主要注意两点 1) sql server 2005 studio需要打sp

 　　原先使用sql server 2005数据库，后来由于工作需要升级为sql server 2008 开发版，升级过程很简单，基本没有什么问题

　　下面主要说说，如何使用sql server 2005 studio来连接sql server 2008，过程其实很简单，主要注意两点

　　1) sql server 2005 studio需要打sp4补丁

　　在关于里面看到management studio 版本号为9.00.50000;如果未打补丁，，提示“只能管理sql server 2000和2005数据库”

　　2)sql server 2008 如果安装在windows 2008上，要在防火墙里面增加运行程序通过。

　　3)sql server 2008 配置工具来配置tcp/IP协议需要启动。

　　主要1.2两点OK，基本都可以连接成功。第3点仅用于提醒;

　　如下图所示：

如何用SQL SERVER 2005连接SQL SERVER 2008 三联

Related labels：
server
source：php.cn
Previous article：在mysql中让数据库中数据成倍增长 Next article：MySQL的大小写问题
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to list data in a section by ID using while loop in PHP? I have a mysql table with these columns: series_id, series_color, product_name In the outp...
From 2023-11-17 20:03:03
0
1
290
How to make table cell values ​​hyperlinked in Dash? (Using Plotly, Dash, Pandas, etc.) I want to set the cell value under the "JobLink" column as a hyperlink. When I c...
From 2023-11-17 18:47:10
0
1
283
How to access $vuetify instance in setup function Is there a way to access $vuetify (and any other added globals) in the settings function? ...
From 2023-11-17 17:47:45
0
1
366
Best way to preload route data before accessing the route. Before rendering the page for a given route, I want to first get the necessary data synchr...
From 2023-11-17 14:54:42
0
2
379
Vue 3 and Vuetify 3 access SCSS/SASS variables in components I want to use predefined variables in my Vue3 component. <template><divclass=&quo...
From 2023-11-17 13:52:29
0
1
293
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！