Can SQL Server 2008 Express exist with SQL Server 2000 on the same server?

Can SQL Server 2008 Express exist with SQL Server 2000 on the same server?

情场扛把子 发布于 2021-11-28 字数 1090 浏览 783 回复 1 原文

I'm wondering if anybody has had any experience in trying to install SQL Server 2008 Express along side with SQL Server 2000. We have a production server running 2000 which all of our current stuff is running on. However, something new is in the pipeline that uses SQL Server 2008 Express.

Hitting Google thus far has given me nothing concrete. There was an obvious no from a preview release of 2008 but nothing about RTM 2008.

I could try installing it but would like to find out as much as I can before doing so. I can see the 2008 install failing, eating 2000 in the process.

The alternative paths that I have include having the 2008 db be turned into a 2000 format (which I'd like to avoid as we only have a 5 connection licenses) and building a new server (we already have enough and it seems overkill). Redoing the 2008 DB is viable as it doesn't use any new whiz-bang features from 2008.

Virtualization can be an option as well, but it's not quite in our cultural yet.

Any insights here will be appreciated.

Keith

如果你对这篇文章有疑问,欢迎到本站 社区 发帖提问或使用手Q扫描下方二维码加群参与讨论,获取更多帮助。

扫码加入群聊

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

时光瘦了 2022-06-07 1 楼

yes you can, you have to make the 2008 version a named instance if the 2000 version is a default instance