1、操作系统安装2003+SP1(如果SP1不能安装,请在网上查询,倒入一个注册表文件即可)
2、SQL Server2005安装
3、建立数据库NCDB,以下SQL适当修改路径
USE master;
go
IF DB_ID (N'NCDB') IS NOT NULL
DROP DATABASE [NCDB];
go
CREATE DATABASE [NCDB]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_DATA01]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_DATA02]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_DATA03]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_INDEX01]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_INDEX02]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_INDEX03]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data01', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_data01_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA01]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data02', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_data02_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA02]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data03', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_data03_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA03]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index01', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_index01_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX01]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index02', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_index02_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX02]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index03', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_index03_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX03]
Go
4、安装NC程序,执行每个文件夹下的ncsetup.bat
5、配置
(1)数据源:NC和iufo分别配置,NC的数据源名称可以任意,数据库一般为NCDB,iufo名称必须为iufo(必须小写)
(2)Portal:建议不要使用80端口,默认冲突
(3)部署:生成EJB,客户端
6、启动中间件
7、访问,默认用户为root[@more@]
2、SQL Server2005安装
3、建立数据库NCDB,以下SQL适当修改路径
USE master;
go
IF DB_ID (N'NCDB') IS NOT NULL
DROP DATABASE [NCDB];
go
CREATE DATABASE [NCDB]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_DATA01]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_DATA02]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_DATA03]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_INDEX01]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_INDEX02]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_INDEX03]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data01', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_data01_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA01]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data02', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_data02_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA02]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data03', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_data03_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA03]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index01', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_index01_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX01]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index02', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_index02_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX02]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index03', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_index03_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX03]
Go
4、安装NC程序,执行每个文件夹下的ncsetup.bat
5、配置
(1)数据源:NC和iufo分别配置,NC的数据源名称可以任意,数据库一般为NCDB,iufo名称必须为iufo(必须小写)
(2)Portal:建议不要使用80端口,默认冲突
(3)部署:生成EJB,客户端
6、启动中间件
7、访问,默认用户为root[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31213/viewspace-1008213/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31213/viewspace-1008213/