开发者

Can't install Server tools with SSIS on top of Express Edition

开发者 https://www.devze.com 2022-12-29 05:23 出处:网络
I have a SQL Server Express edition with management studio and i\'m trying to use the enterprise disks (\"SQL Server 2005\" Enterprise Edition 32-bit Server Applications\") and I can\'t get it to give

I have a SQL Server Express edition with management studio and i'm trying to use the enterprise disks ("SQL Server 2005" Enterprise Edition 32-bit Server Applications") and I can't get it to give me the option of ins开发者_开发知识库talling the server components or a server instance. What am I missing?


You can't install the server tools for Enterprise edition because you need to actually install the server version. You can't add enterprise tools to the Express edition. You need a brand new installation of the full blown Enterprise edition.

If you want the server tools, you need to install the right version, meaning in your case, the Enterprise edition. I don't know if you can do it side-by-side as a new instance (and I'm not even sure if you can install it on a non-server version of Windows.)

Edit

I found the answer to the question of whether you can install it in a non-server version of Windows here.

End Edit

However, if you mean the CLIENT side tools, so that you can create SSIS packages for a SQL Server on another machine (meaning a true server), without having to have Enterprise edition on your development pc, see this article.

0

精彩评论

暂无评论...
验证码 换一张
取 消