Execute a script similar to the following as the system DBA. Uncomment lines as necessary.
CREATE DATABASE idm_warehouse GO --For SQL Server authentication: -- sp_addlogin user, password, defaultdb--For Windows authentication: -- sp_grantlogin <domain\user> --For SQL Server 2005: --CREATE LOGIN idm_warehouse WITH PASSWORD = ’idm_warehouse’, DEFAULT_DATABASE = idm_warehouse sp_addlogin ’idm_warehouse’, ’idm_warehouse’, ’idm_warehouse’ USE idm_warehouse GO --For SQL Server 2005 SP2 create a schema - not needed in other versions: --CREATE SCHEMA idm_warehouse --GO --For SQL Server 2005 SP2 use CREATE user instead of sp_grantdbaccess --CREATE USER idm_warehouse FOR LOGIN idm_warehouse with DEFAULT_SCHEMA = idm_warehouse sp_grantdbaccess ’idm_warehouse’ GO
To load the DDL, execute the following command:
osql -d idm_warehouse -U idm_warehouse -P idm_warehouse < create_warehouse.sqlserver