Groups | Blog | Home
all groups > sql server (microsoft) > november 2005 >

sql server (microsoft) : SQL Express on Windows 2000 Pro



rlg
11/14/2005 11:01:28 AM
Good day,

I was just reading the minimum requirements for the SQL Server 2005
versions and was floored to discover that SQL Express will not run on
Windows 2000 Professional
(http://www.microsoft.com/sql/editions/express/sysreqs.mspx). Could
this be a typo?!?!?

SQL Server 2005 Workgroup and Standard are both supported on Windows
2000 Professional, so this appears to be a commercial (rather than
technical) decision.

Our products run only on Windows. However, we cannot use the most
current Microsoft development tool to build a solution that will run on
all current versions of Windows! Does Microsoft expect ISVs to help
them force Windows upgrades on users? We won't be the ones telling our
customers that their 3 year old PCs need to be upgraded...

A couple of things make this situation even more annoying. Windows
2000 Professional IS a supported development platform for Visual Studio
2005. And Windows 2000 Professional WAS a supported deployment
platform for SQL Express beta 2. I know it was a beta program, but it
did include a Go Live license for SQL Express, so some customers would
have already had SQL Express running on 2000 Pro. And we based our
tentative product plans around the capabilities we saw in the beta!

I'd like to know where Microsoft's vision on this lies. What database
system is recommended for developers of widely distributed, standalone,
packaged applications?

This is the first time I've made a forum/newsgroup post while hoping I
have it all wrong!

Thanks...
GCeaser NO[at]SPAM aol.com
11/15/2005 5:46:40 PM
Well,

All I can tell you is that I was able to install the Visual Studio
Express Web Developer edition on a Windows 2000 Pro box and it worked.
I did try to install SQL Express without the VSE Web Developer and
received errors about the MSVCR80.dll not being installed on the
machine. Installing VS appears to resolve that. I am not recommending
this just telling you a way you can get SQL Express 2005 installed on
Win 2000 pro box.

I hope this helps.
George
Joe Montana
11/17/2005 6:26:49 AM
Interestingly for the 2005 Standard Edition it includes for Operating
System: Windows XP with SP 2 or later

http://www.microsoft.com/sql/editions/standard/sysreqs.mspx

I wonder if they're referring to installing the workstation components only
and NOT the database engine/instance itself...?

Maybe I'll try it today :)

--
Bill Blakey


[quoted text, click to view]

AddThis Social Bookmark Button