Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-10 : 08:52:01
|
| Bill Watkins writes "I've spent most of the day reading everything I can get my hands on referencing SQL Server, but am still a little confused.We will be implementing a small Datawarehouse facility for internal use only. My PC (Dell4400 512m memory/40gig HD) is currently running Win2000Pro, where I would like to stay. I will be the only user of the DataWarehouse.I understand that SQL Server Personal Edition will run on Win2000Pro, but can't be bought, as it's bundled with SQL Standard Edition. The confusing issue is that everywhere I look, SQL Standard will only run with 2000 Server. Is this correct?If I install SQL Standard on my PC, will the bundled Personal Edition allow me to maintain Win2000Pro as my O/S and utilize the majority of capabilities of SQL ?Thanking you in advance. Best Regards, Bill Watkins" |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2002-04-10 : 09:13:48
|
| I believe that Personal Edition does not have any databases when installed on Win9x (It only has connectivity). Win2kPro should be ok to run everything (databases, jobs, SQLMail, DTS, ...). I'm currently using SQL2k on Win2kPro to do dev stuff and then I move the dev stuff up to our Nt4Server/SQL2kStandard server.As far as licensing I'm not really too sure but I would bet that SQL Personal only supports 1 user for its license.DanielSQL Server DBA |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-10 : 14:29:17
|
| On the SQL 2000 Standard Edition CD, it will reject you if you try to install Standard Edition on Win2K Pro, as you say. But there should be an option to install Personal Edition on Win2K Pro from the Standard Edition CD. Then you should be in good shape. I ran this sort of configuration under SQL 7 on Win2K Pro. When I went to SQL 2000, I actually bought my own personal copy of SQL 2000 Developers Edition because I'm a contractor and wanted my own copy. I'm running that on WinXP Pro.I don't know about licensing issues, but I believe there is a 5-concurrent-user bottleneck/throttle on Personal Edition. But as long as you're using it for development and not production, you should be fine.------------------------GENERAL-ly speaking...Edited by - AjarnMark on 04/10/2002 14:30:44 |
|
|
|
|
|
|
|
|
SQL Server Personal Edtion/Windows 2000 PRO