Which version is best for me ?

Which version is best for me ?

• Julie Clark

  Is this a Windows SBS, then this is a known issue. If this is just a "test" and sandbox you can try setting the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion to a "valid" one. Perhaps somebody out there using right now a Windows 2003 Server box, sho can share his service pack level where the SQL 2k5 installs fine Currently I have no VPC running on hand to lookup.
  
  HTH, Jens Suessmeyer.
  
  ---
  http://www.sqlserver2005.de
  ---
  

• Miguenio

  Thanks for the help.

  Is it easy to upgrade from Express to Workgroup or Standard

  Will I retail all the Databases, User Accounts etc

  
  
  

• Pagey

  Thanks for all you help.

  I think Imight install Standard. Any ideas where I can pick up a 5 Cal version for a good price.

  Thanks

  
  
  

• FMorse

  Hi,

  this is a known issue, look at this thread here, this was solved by one of the Microsofties :-) (Second Page)
  
  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=244183&SiteID=1&PageID=1

  HTH, Jens Suessmeyer

  ---
  http://www.sqlserver2005.de
  ---

  
  

• Sathiyarajan

  YOu didn’t specify anyting about the workload on the machines, how big are the database, how are the proposed query actions (much inserts... / Selects), how many users will connect. If you see the requirements at a lower level you can sure choose the express edition. Although it doesn’t have any schedlung, you can schedule your scripts etc. with the Windows Scheduler to execute your prepared scripts. If you are not satisfied afterwards you can anyway change to a more richer edition.
  
  HTH, Jens Suessmeyer.
  
  ---
  http://www.sqlserver2005.de
  ---
  

• Ricco

  If you don’t care about software assurance and have no contract with any license vendor, you can buy that anywhere you want (ebay, other online shops, but make sure that you don’t get an illegal copy)
  
  HTH, jens Suessmeyer.
  
  ---
  http://www.sqlserver2005.de
  ---
  

• davegraeme

  Hi,
  
  I know this is a very plain answer to your question, but see the limitations of the editions here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
  
  Addition to the plain answer :-) --> Try to see if you can determine which version you need in order to fullfill your needs. In addition to the less features that the version below Enterprise Edition hold, there are some hardware issues that you keep in mind, if you think about choosing a workgroup or express edition.
  
  If you have any further issues, just raise a hand.
  
  HTH, Jens Suessmeyer.
  
  ---
  http://www.sqlserver2005.de
  ---

  
  

• TP Diffenbach

  Hi

  Thanks for your prompt help.

  I have already seen the comparison and I can't decide. I am torn between Express, Workgroup and Standard.

  Can do with a helping hand. I want to spend as little as possible however don't want to compromise on performance. I propbabl would like to run schedular so Epress might be out of question.

  And please don't high jack this thread. Thanks again.

  G,

  
  
  

• SiddharthK

  What kind of hardware you are planning to put this on It seems a lot of memory will be required if all of your users are accessing that many databases. You need to plan for memory utilization , if you put memory more than 4Gb you will need to purchase Win-2k3 Enterprise edition.

  How many CPUs Are you considering Processor license versus CALs

  I am also evaluating similar situation , currently I have multiple SQL servers for different applications , I am thinking of consolidating them on one box with 4-dual-Core CPUs and 16Gb memory with win2k3 Enterprise. I am not sure though if thats going to cause any issues in terms of network load and memory utilization . I am talking about 10 databases used by 10 applications with approx. 50-60 concrrent users . Any recommendations

  
  

• jd.conley

  Jens,

  Just downloaded SQL trial version onto a brand new Windows 2003 server with all the patches I can find. But still get an error when launching the download.

  Microsoft SQL Server 2005 Setup

  Your operating system does not meet Service Pack level requirements for this SQL Server release. Install service pack from Microsoft Download center http://go.microsoft.com/fwlink/ linkid=50380.

  Any idea what I need to do to get the 180day trial to run

  
  

• codputer

  Theoretically, yes. But I would rather do a backup first, normally only the binaries are exchanged, but I always do a deinstall / install to have everything in my hand.
  
  HTH; Jens Suessmeyer.
  
  ---
  http://www.sqlserver2005.de
  ---
  

• crazychemist

  This is a Windows Small Business Server 2003 server.
  
• Which version is best for me ?