System Prompts Login Database Failure

Publication Date:  2012-07-27 Views:  120 Downloads:  0
Issue Description
On Windows, when the VSM database is initialized, a message is displayed indicating login database failure.
Alarm Information
None.
Handling Process
Step 1     Check whether the database is started. If not, start it manually.

1.         Double-click the database icon on the taskbar of Windows. The SQL Server Service Manager window is displayed.

2.         Check whether the database server is started.

If Start/Continue is grayed out, it indicates that the database is already started. Otherwise, click Start/Continue to start the database server.

                                Step 2     Check for and rectify the alias of the database server.

1.         Click Start and then choose Programs > Microsoft SQL Server > Client Network Utility. On the Alias tab page, view the alias of the database server.

The Server alias should be VSMDBServer.

2.         Initialize the database again.

If the message indicating login database failure is displayed again, the ODBC data source may not be configured or configured incorrectly.

                                Step 3     Check for and restore the configuration of the ODBC data source.

1.         Choose Control Panel > Administrative Tools > Data Sources (ODBC).



2.         On the System DSN tab page, view the configuration of VSMDBServer.

l           If VSMDBServer already exists, select VSMDBServer and then click Configure to view the configuration items.

l           If VSMDBServer does not exist, click Add to add VSMDBServer.

Adding the VSMDBServer is considered as an example.

3.         On the System DSN tab page, click Add. In the Create New Data Source dialog box that is displayed, select SQL Server.



4.         Click Finish. In the Microsoft SQL Server Configuration dialog box displayed, enter the following information:



5.         Click Next. In the Microsoft SQL Server Configuration dialog box displayed, set the parameters as follows:

l           Select the With Windows NT authentication using the network login ID. and Connect to SQL Server to obtain default setting for the additional configuration options. check boxes.

l           In the Login ID field, enter the database user name sa. The Password is null. If a password is set, enter the password.



6.         Click Next. In the dialog box displayed, select Change the default database to: and then select master from the drop-down list.

7.         Click Next. In the dialog box displayed, the default settings are recommended.



8.         Click Finish. Then, ODBC Microsoft SQL Setup is displayed.



9.         Click Test Data Source.... Then, observe the information displayed on the screen. If TEST COMPLETED SUCCESSFULLY! is displayed, the VSM application and the database server are connected.

10.      Initialize the database again.

Root Cause
The possible causes that result in the database login failure are as follows:
l           The alias of the database server is set incorrectly or is not set.
l           The ODBC data source is configured incorrectly or is not configured.
l           The database is not started.
Suggestions
None.

END