WSS使用SQL SERVER数据库

浪上飞郑

 我们知道,WSS是免费的,当然,其后台也是用免费的MSDE.

能用SQL SERVER吗?这样可以使用超过2G的数据库

下面是我在网上找到的,但没看明白,高手指教:

为WSS配置SQL Server引擎                         

   默认情况下安装Windows Sharepoint Services会自动为你安装Windows Microsoft SQL Server 2000 Desktop Engin(WMSDE), 虽然在WMSDE不限制你使用2GB的存储器和10个数据库的连接,但是还很多的其它限制,比如:WMSDE只支持支持微软签名的表模式(Table Schemas),很关键的一点是不支持搜索功能,如果你需要WSS为你提供搜索引擎(在为企业部署WSS的时候,你应该规划平台的整体性能,避免在后期的时候发现规划不能满足实际需要,这点很重要),那么就必须安装SQL Server 2000 SP3(因为在Windows 2003中SQL Server 2000必需打SP3补丁才能正常运行).

 

     然后马上开始,首先去网上搜索相关资料,很失望,一直没有找到很有用的信息,相关的回答都是"Upgrading the Databases from WMSDE to SQL Server"没有任何详细说明(我后面的实践证明这句话能起到的帮助实在太小了),没有办法只好自己摸索了,下面我将描述我的实验过程,目前写的时候还有些问题不是很清楚,所以我将会有后续连载,确保此问题得到叫完整的解决,也算是为有需要的朋友提供帮助吧,如果可以的话.

pgrading the Databases to SQL Server on the Same Computer
If you want to continue using a single server for Windows SharePoint Services, you can simply upgrade your database instance from WMSDE to SQL Server. Because this process requires your sites to be offline while the databases are upgraded, it is recommended that you perform these steps at a time when usage of your sites is generally low, and also that you notify users that their sites will be offline for a time.

Note  Before you upgrade your databases, it is a good idea to back them up. If you have the SQL Server client tools installed on your server or on another server, you can use them to back up a WMSDE database. Otherwise, stop WMSDE and make a copy of the database files before installing SQL Server.
1.Install SQL Server and upgrade your databases
2.Run the SQL Server 2000 SP2 Setup program, and on the Autorun panel, click SQL Server 2000 Components.
3.Click Install Database Server, and then on the Welcome panel, click Next.
4.In the Computer Name box, select Local computer, and then click Next.
5.In the Installation Selection pane, select Upgrade, remove, or add components to an existing instance of SQL Server, and then click Next.（在此步骤中"对现有SQL Server实例进行升级﹑删除或添加事例选项为灰）
6.In the Instance Name pane, clear the Default check box, and then in the Instance name box, select SHAREPOINT, and click Next.
7.In the Existing Installation pane, verify that Upgrade is selected, and then click Next.
8.In the Upgrade pane, verify that the Yes, upgrade my programs check box is selected, and then click Next.
9. In the Licensing Options pane, select your licensing options, and then click Next.
10.In the Select Components pane, click Server Components, and then select the Full-text Search check box if you want to enable full-text searching.
11.In the left pane, select the Management Tools check box and in the right pane, select the Enterprise Manager and Query Analyzer check boxes.
12.Select any other components you want, and then click Next.
In the Start Copying Files pane, click Next, and then click Finish.
After the upgrade to SQL Server 2000 is complete, your SharePoint sites should work as usual.