Problem (Issue) Statement: | Why did the xPortalNet Comm Server Showed 'Cannot Open Database "XPNDB" Requested by the Login. The Login Failed' error message during the initialization of xPortalNet database | ||||||||||||||||||||||||||||||
Description: | When users launch xPortalNet Comm Service and Server to initialize a new xPortalNet database, the xPortalNet software showed the 'Cannot open database "XPNDB" requested by the login. The login failed' error message. | ||||||||||||||||||||||||||||||
Related Software: |
| ||||||||||||||||||||||||||||||
Related Hardware: | NIL | ||||||||||||||||||||||||||||||
System Application: | NIL | ||||||||||||||||||||||||||||||
Symptom and Finding: | After launching the xPortalNet Comm Service and xPortalNet Server to initialize new database, the xPortalNet Server showed an error message to indicate 'Cannot open database "XPNDB" requested by the login. The login failed.' as below.
| ||||||||||||||||||||||||||||||
Cause: | This issue is caused by an improper way of configuring or initializing a new database, which could be due to a few reasons as below:
| ||||||||||||||||||||||||||||||
Solution: |
. . Summary:
|
Info | ||
---|---|---|
| ||
Users can refer to How to Detach xPortalNet database from SQL Server for the complete procedures to detach xPortalNet database. |
To solve Database Initialization Failed error message to indicate "Please check the error log! [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
Step 1: Ensure that the SQL Server software does not register any of xPortalNet's databases under the Database folder. If any of the xPortalNet database software still exists under the Database folder, users are required to detach the database first in SQL Server.
Info | ||
---|---|---|
| ||
Users can refer to How to Detach xPortalNet database from SQL Server for the complete procedures to detach xPortalNet database. |
Step 2: Go to tool bar and right-click xPortalNet Comm Service icon. Click Stop.
Figure 4: Stopping xPortalNet Comm Service
Step 3: Go to C:\ProgramData\MicroEngine\xPortalNet v1 to delete the xPortalNet v1 folder.
Tip | ||
---|---|---|
| ||
Users can also choose to rename the folder to something like xPortalNet v1 (date) in order to keep the existing database. |
Step 4: Right-click the xPortalNet Comm Service icon and click Start to initialize a fresh database again.
Figure 5: Starting the xPortalNet Comm Service to Initialize a Fresh Database Again
Step 5: Run the xPortalNet Server application.
Step 6: The xPortal Comm Server Database Setting window will be shown. User must fill in the Server Name and Password before clicking Initialize Database.
Figure 6: xPortal Comm Server Database Setting Window
Tip | ||
---|---|---|
| ||
How do I know my Server Name and Password? Run the SQL Server Management Studio, refer to the Server Name and login Password in the Connect to Server window. |
Info | ||
---|---|---|
| ||
Please ensure that the password entered is able to connect to the SQL Server. |
Step 7: The xPortalNet Comm Server window indicating that the "Database Created Successfully!" message will be shown. Click OK.
Figure 8: Database Created Successfully Window
Common Issue:
- Incomplete / incorrect settings configuration in xPortal Comm Server Database window.
- Re-initializing new database on existing Server PC without properly removing or deleting existing database on SQL Server.
Date Documentation:
3/12/2018 (Rev 1.0)
...
Section | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||
|
.
...
.
Choices for confluence | ||
---|---|---|
|