How can I change the database password?

MS SQL Server: assuming the instance and user name to be NETX_SERVER_SQL and sa, respectively, do:

1. Open a command window, cmd.exe, and enter following command

   osql -S .\NETX_SERVER_SQL -E

2. On the osql prompt enter

   1>sp_password NULL, 'new password', 'sa'
   2>go
   1>exit

3. Make sure you also change the password in your BMS workspace (BMS Studio / Server / System Configuration / XDB Parameters / Database password).

Related articles

• Page:
  XDB_ENGINE; Connect to SysDatabase failed. (NETx BMS Server 2.0)

  • bms-server
  • error-message-description
  • database
• Page:
  XDB Status OFFLINE -- What Can I Do? (NETx BMS Server 2.0)

  • database
  • server
• Page:
  What kind of MS SQL Server license do I need? (NETx BMS Server 2.0)

  • bms-server
  • database
  • sql
• Page:
  Manual installation of the SQL Server instance (NETx BMS Server 2.0)

  • database
  • bms-server
• Page:
  Is there a maximum database size? (NETx BMS Server 2.0)

  • bms-server
  • database
  • space
  • sql