October 28, 2008 at 1:33 pm
ok, thanks
October 28, 2008 at 6:45 pm
Lowell (10/28/2008)
compatiblility in that case means it won't fail on install...it'll install the tools no problem.but as you've noticed it will not install everything. That is by design.
People are a bit confused i guess, because in SQL 2000, if you installed Enterprise or Standard on a NON-Server operating system, it automatically dummied itself down to a Development version instead of Enterprise or Standard.
SQL 2005 does not do that...repeating what Jeff said a couple of times already, if you want to have the db engine on a non-server operating system, whether xp or vista, you must install SQL 2005 Express or SQL 2005 Developer versions.
Heh..."dummied itself down to Development version"? Development version IS the Enterprise Edition. Only the fact that it'll run on a desktop and the licensing are different.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 28, 2008 at 9:09 pm
aw come on, you know what i mean...Dev is limited to a max of 10 connections, instead of limited only by memory in the full version, a couple of other small changes compared to to full server versions; all stuff to make sure you don't buy the 50 dollar versiona dn run an enterprise off of it.
Lowell
October 28, 2008 at 9:12 pm
Keep in mind that you may find that "compatibility" extends only to the client tools and main database engine components if you do NOT have "professional" (or in Vista's case - "business" or "Ultimate" editions). Not having the full authentication pieces available will get Reporting services to not be installed or not work if it does.
Home editions of either = trouble, at least for the other components.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
October 28, 2008 at 9:13 pm
Lowell (10/28/2008)
aw come on, you know what i mean...Dev is limited to a max of 10 connections, instead of limited only by memory in the full version, a couple of other small changes compared to to full server versions; all stuff to make sure you don't buy the 50 dollar versiona dn run an enterprise off of it.
You sure you're not thinking "ACCESS"? We did a test on a "Development Box"... 24 concurrent users... no problem.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply