Express (Distributed operating systems), v8.0 > Secure applications and their environment > Authenticate users > Select a registry or repository > Manage realms in a federated repository > Virtual member manager > Troubleshoot and Support > Support issues and limitations > Database issues and limitations
The setupIdMgrDBTables command fails for the Microsoft SQL Server
We must update the table space in the database schema before you can issue the setupIdMgrDBTables command for the Microsoft SQL Server.
About this task
Complete the following steps to update the table space in the database schema:
Procedure
- Open a command window.
- Change to the WAS_HOME/etc/wim/setup directory.
- Enter the following commands to set the environment variable and to set the table space owner:
set SCHEMA_LOCATION=WAS_HOME/etc/wim/setup set DBOWNER=dbo- Run WAS_HOME/bin/ws_ant.bat -buildfile filterbuild.xml.
- Check the WAS_HOME/etc/wim/setup/database/sqlserver/schema.sql ddl file to see if the table spaces are updated correctly. Also, check the schema.sql files under the following property extension and entry mapping directories:
WAS_HOME/etc/wim/setup/lookaside/sqlserver/schema.sql WAS_HOME/etc/wim/setup/federation/sqlserver/schema.sql
Parent topic: Database issues and limitations