虽然2000是很老很老的数据库版本,但是在之前企业的mrp和erp运用中,sql2000也是独当一面的。可以说sql2000是处于信息化系统蓬勃发展的时代。考勤,门禁,工资,MRP,ERP都曾经以它作为数据管理。并且从2000年持续到201x年左右。
前一个成功的版本是SQL7。然后是2000,再就是2005,2008,2012。可以说2000是非常重要的版本,其主要特点是满足足够规模数据的管理,而且!它能适合几百兆内存的硬件系统。
现如今,sql2000仍然可以服务以工控机,POS机等不以复杂任务,硬件性能不突出的电脑系统使用。
它可以安装的系统以win2k,win2k3,xp,win7系统匹配。
版本的选择
如上图所示,有个人版,针对单机系统运用,如xp上面的单独一个运用;
标准版和企业版:针对服务器的多用户运用;
开发版:开发调试程序时临时使用,连接数受限。
![image-20241002203307818](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002203307818.png)
如下安装过程我们以开发版为准
![image-20241002210055190](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002210055190.png)
在win7系统中,如果直接点中间这个菜单,它会无法启动安装程序。
我们进入目录:DEVELOPER\X86\SETUP\ 中去找到SETUPSQL.EXE双击运行。
![image-20241002210230131](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002210230131.png)
![image-20241002210428998](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002210428998.png)
![image-20241002210507147](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002210507147.png)
![image-20241002210831628](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002210831628.png)
![image-20241002210920652](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002210920652.png)
![image-20241002211000877](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002211000877.png)
![image-20241002211159932](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002211159932.png)
![image-20241002211234043](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002211234043.png)
![image-20241002211335224](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002211335224.png)
![image-20241002211647596](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002211647596.png)
![image-20241002211735055](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002211735055.png)
![image-20241002215356681](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002215356681.png)
![image-20241002215436580](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002215436580.png)
![image-20241002215600294](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002215600294.png)
![image-20241002215637153](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002215637153.png)
![image-20241002221750391](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002221750391.png)
![image-20241002222008778](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002222008778.png)
![image-20241002222145175](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002222145175.png)
最后需要打上sp4补丁
如果不打此补丁,则在局域网无法使用IP+端口方式访问;
当然如果通过路由器对外部进行了映射,外部也是无法通过公网IP+端口方式进行访问。
当然本机连接是可以的。用127和localhost或者”.”应该可以的。
![image-20241002223113981](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002223113981.png)
这只是自解压:然后我们手工进入到解压缩目录C:\SQL2KSP4\setup.bat,执行:
![image-20241002225020769](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002225020769.png)
![image-20241002225048249](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002225048249.png)
![image-20241002225113178](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002225113178.png)
![image-20241002225246205](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002225246205.png)
![image-20241002225354363](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002225354363.png)
![image-20241002225424677](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002225424677.png)
![image-20241002225609974](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002225609974.png)
开始安装:
![image-20241002225643119](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002225925841.png)
![image-20241002225954146](/wp-content/uploads/2025/02/D3E8B4103B17CDF85263AB1D9B882CDB/image-20241002225954146.png)