在Xp3上安装,颇费周折,贴出来,希望兄弟们再装时,省点劲。除非必要,建议逐步淘汰XP平台。
首先,我的文档所在的目录文件夹不能修改,如修改,必须将其还原,否则会影响安装;
其次,sqlserver2008 express与sqlserver2005 express不能并存,原系统中如果安装了2005express,必须卸载(卸载microsoft sqlserver 2005和mse)-看来,将2005与2008作严格区分是有必要(即,2.0与3.0进行区分);
最后,如果没有安装过rm管理,需先下载这个补丁文件windowsxp-kb968930-x86-chs.exe。
然后,基本就可以按照下面步骤(以英文版本为例,中文的下载相关语种文件,安装相同)一步步安装了。
1. Download SQL Server 2008 Express with Tools
• | Download SQL Express 2008 with Tools from (219 MB) from http://go.microsoft.com/?linkid=9394725 |
• | SQL Server 2008 Express requires .NET Framework 3.5 SP1, if your server does not have .NET Framework 3.5 SP1 you will need to download .NET Framework 3.5 SP1 and install it on your server. You can download .NET Framework 3.5 SP1 from http://go.microsoft.com/fwlink/?LinkId=120550 |
• | SQL Server 2008 Express requires Windows Installer 4.5, if your server does not have Windows Installer 4.5 you will need to download Windows Installer 4.5 and install it on your server. You can download Windows Installer 4.5 from http://go.microsoft.com/fwlink/?LinkId=123422 |
• | SQL Server 2008 Express requires Windows PowerShell 1.0, if your server does not have Windows PowerShell 1.0 you will need to download Windows PowerShell 1.0 and install it on your server. You can download Windows PowerShell 1.0 from http://go.microsoft.com/fwlink/?LinkId=120552 |
2. Install SQL 2008 Express
1. | Run SQLEXPRWT_x86_ENU.EXE (or SQLEXPRWT_x64_ENU) to install SQL 2008 Express. |
2. | At the "SQL Server Installation Center", choose "System Configuration Checker" to make sure you are ready to install SQL 2008 Express |
3. | Click to view. |
4. | When the "System Configuration Checker" has validated that you are ready to install SQL 2008 Express, return to the "SQL Server Installation Center" and click on Installation. |
5. | Click to view. |
6. | Select "New SQL Server stand-alone installation or add features to an existing installation" |
7. | Click to view. |
8. | A setup support check will run. Make sure there are no errors or warnings, press OK. |
9. | The "SQL Server 2008" Setup will now appear, on the Product Key page, click Next. |
10. | Check the box "I accept the license terms" and click Next. |
11. | Click "Install" to install the Setup Support Files. |
12. | When the Setup Support Files install is complete, click Next. |
13. | You will now be in the "Feature Selection" page. Select "Database Engine Services" and "Management Tools - Basic" and then click Next. |
14. | In the "Instance Configuration" page, specify SQLExpress in both the "Named instance" and "Instance ID" fields. |
15. | Click to view. |
16. | Click Next twice. |
17. | You will now be in the "Server Configuration" page. Change the SQL Server Database Engine's Account Name to "NT AUTHORITY\SYSTEM" and SQL Server Browser's Startup Type to Automatic, then click Next. |
18. | Click to view. |
19. | On the Database Engine Configuration page, enable Mixed Mode |
20. | Enter and confirm a password for the Built in SQL server system administration account (note this is the user sa). |
21. | Before you can continue, you will need to specify the group(s) that you want to have unrestricted access to SQL Server. Click "Add..." and select the group(s). It is recommended that you at least add Administrators and the "Current User" (Service Account). |
22. | When you are done here, click Next three times, and then click Install. |
23. | When the installer completes, click Next and then Close. |
3. Enable Protocols
Now that SQL 2008 Express is installed, we need to enable the Network options (because for some reason SQL Express has these disabled by default).
1. | In the Start Menu, open Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Surface Area Configuration |
2. | In the Surface Area Configuration utility, click the link "SQL Server Configuration Manager" |
3. | Expand "SQL Server Network Configuration" and select Protocols. |
4. | Enable TCP/IP and enable Named Pipes |
5. | Right click on the TCPIP, select Properties, and enable the server's IP address too. |
6. | Close the SQL Server Configuration Manager. |
4. Add Firewall Exceptions
If you have a software firewall installed on your server, you will need to add exceptions for the SQL Server and SQL Browser services.
If you are using Windows Firewall, do the following:
• | In your Control Panel, open the Windows Firewall applet. |
• | Go to the Exceptions tab. |
• | Click Add Program |
• | Browse to and select "C:\Program Files\Microsoft SQL Server\MSSQL.10\MSSQL\Binn\sqlservr.exe" |
• | Click OK. |
• | Click Add Program |
• | Browse to and select "C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe" |
• | Click OK and then click OK again. |
If you are using a third-party software firewall, you will need to follow their instructions to add exceptions to sqlservr.exe and sqlbrowser.exe.
5. Restart the Services or Reboot the Server
When you have completed all of these steps, you will need to restart the SQL Server and SQL Browser services to complete the process.
附,Visual Studio 2010 Express 激活方法
在北京,截止本文发出(2010.5.1)还不能激活Visual Studio 2010 Express,因为中文网页没有相应的密钥获取过程,本文介绍如何激活Visual C# 2010 Express。
1、打开Visual C# 2010 Express,选择Help->Regester Product,然后选择Obtain a registration key online。
2、如果要求登陆,请使用Windows Live ID登陆。
3、将会有一个填写个人信息的表格网页,先不填写,看到地址栏中最后的&lcid=2052了吗?这里表示语言的ID,把这个去掉,然后按下Enter,转到英文页面。
4、填写个人信息
5、点击最下面的Continue按钮
6、打开了一个网页,将会弹出Visual C# 2010 Express的密钥。
7、回到Visual C# 2010 Express的激活窗口中,输入刚才的密钥,完成激活。
Visual C++/Baisc/Web Developer 2010 Express以此类推。
例子:
http://cid-7e110fce58ec01c6.skydrive.live.com/self.aspx/.Pub
lic/%e6%bf%80%e6%b4%bb%20Visual%20Studio%202010%20Express.pp
tx/
发表评论
-
client profile introduction(客户端概要介绍)
2010-05-04 11:19 1286Introducing .NET Framework 3. ... -
Mef architecture overview
2010-04-05 02:53 0MEF的设计可以分为三个不同的层次。容器层,这是用户能获得大多 ... -
用vs2008和NUnit进行程序自测
2010-04-04 20:47 1258“在进行单元测试之前需要弄清楚被测试代码实现的功能和相应的逻辑 ... -
.Net Framework各版本(3)-ASP.NET 3.5 Extensions CTP Preview Released 2007.12.09
2010-04-04 02:40 1353这是以前的文章,放在这里方便使用。原文链接:http://we ... -
.Net Framework各版本(2)-vs2010添加引用页和CLR side-by-side的变化
2010-04-02 01:15 3441VS 2010,从RC1版本我们可 ... -
.Net Framework各版本(1)
2010-04-01 00:13 2583微软,作为全球最有效 ... -
ZT,一篇好文
2010-03-13 18:10 649绪:一篇好文,故转贴 ... -
NET2005,如何打开Net2008的项目
2009-06-09 17:34 1010可以按以下步骤,就可以在VS2005中打开VS2008建立的项 ...
相关推荐
xp3文件提取器.xp3文件提取器.xp3文件提取器.xp3文件提取器.xp3文件提取器.
在XP3原装版中提取的IIS5.1的安装文件,经测试可以在FAT32 及 NTFS格式的系统盘中安装IIS5.1
能够对大多数xp3文件进行解包,选择exe和xp3文件路径后,点击解包即可
内含xp3拆包工具、操作说明,适用于非专业人士
patch.xp3
ExtractData XP3等 游戏文件 数据提取ExtractData XP3等 游戏文件 数据提取
patch2.xp3
产品概述:介绍 产品概述:介绍 产品概述:介绍 产品概述:介绍 XP3 -16 系列一体机的基本特点、规格尺寸安装等。 系列一体机的基本特点、规格尺寸安装等。 系列一体机的基本特点、规格尺寸安装等。 系列一体机的...
iis xp3安装包,本人亲测!可安装。...不过由于我的是ghost 不知道是少什么,IIS 安装后运行出现:IIS Server Application Error。 如果你的IIS安装后也出现,请运行压缩包中的IIS.bat,一边输入一边测试!
evimage1080.xp3
bgimage1080.xp3
在百度找下载地址了,百度了一下Windows XP SP3 IIS6.0下载,找到很多结果,可惜有很多下载地址是不能用的,刚好看到有很多朋友都在找Windows XP SP3 IIS6.0下载地址,就把我好不容易找到的一个能用的Windows XP SP3...
xp3 vol最新最全的KEY,绝对能用,
(琪琪模拟器)在手机上玩.xp3的游戏 可以在安卓上面运行.xp3的游戏。
IIS for XP3,自己收集的IIS,可能会需要原始安装盘.
fgimage1080.xp3
此版本可用于系统为微软xp的xp3版本 iis5.0 xp3
Windows XP3自带蓝牙驱动安装包 在安装驱动时,请在电脑上插上你的蓝牙适配器,以便系统读取驱动信息.
data.xp3
XP3桌面IE图标.对于安装了XP3桌面没有IE图标的。这是一个真正的IE图标。具有属性功能