Page Comparison

...

1. Check if the database instance is running.
   • In the default configuration the BMS Server uses a local instance of MS SQL Server named NETX_SERVER_SQL
   • Go to Windows Services and check if the service named SQL Server (NETX_SERVER_SQL) is running.
   • If the service is running proceed with step 5.
2. Check the service startup type
   • In the Windows Services, locate the service named SQL Server (NETX_SERVER_SQL) and open its properties.
   • Set the start type to automatically and click OK.
3. Start the database service
   • In the Windows Services, locate the service named SQL Server (NETX_SERVER_SQL).
   • Start the service.
   • If the service started successfully, proceed with step 5.
4. Check the Windows Event Logs
   • If the database service failed to start check the Windows Event Log for specific log entries.

5. Check BMS Server connection parameters in BMS Studio / Server / System configuration. Be sure to know what you are doing if you deviate from default values.

   Default values are as follows:

   Configuration parameter	Default value
   SYS / Use historical database

    checked

   	checked
   XDB / Enable DSN

   : not

   	not checked
   XDB / Use integrated security

   :

   	not checked
   XDB / Database user

   : 

   	sa
   XDB / Database password

   : 

   	netxnetx_123456
   XDB / Database host name

   : 

   . (a dot)

   .

   XDB / Database port

   : 

   	(empty)
   XDB / Use default instance

   : not

   	not checked
   XDB / Database instance name

   : 

   	NETX_SERVER_SQL
   XDB / Database DSN

   :

   	NETX_SERVER_DSN
   XDB / Connection timeout

   :

   	300
   XDB / Command timeout

   :

   	60
   XDB / Max data age

   :

   	0
   XDB / Auto-purge near-full database

   : 

   checked

   
   

6. Check the BMS System Messages or the System Log File for error messages. See also XDB_ENGINE; Connect to SysDatabase failed.

7. Try to access the database through the command line and se NETX_<workspace-name> as database name.

   Code Block
   C:\Users\username>sqlcmd -S .\NETX_SERVER_SQL -U sa -P netxnetx_123456 1> USE NETX_Workspace1 2> go Changed database context to 'NETX_Workspace1'. 1> quit C:\Users\username>

   
   
   
   

8. In case the sa login fails try to enable the sa user login

   Code Block
   C:\Users\username>sqlcmd -S .\NETX_SERVER_SQL 1> use NETX_Workspace1 2> go Changed database context to 'NETX_Workspace1'. 1> ALTER LOGIN [sa] ENABLE 2> GO 1> quit C:\Users\username>

   
   

9. To reset the sa user's password follow this article: How can I change the database password?

If the problem cannot be solved by these steps, please provide a detailed description of the symptoms, the support file and a detailed description of the symptoms, and if applicable the output of command line access to the database.