Database Error Encountered This Script Cannot Continue

Issue:

When starting Advance Steel, the following error message is displayed:

Database connection errors

Failed to connect to the following databases:

C:\ProgramData\Autodesk\Advance Steel 20xx\INT\Steel\Data\AstorRules.mdf
C:\ProgramData\Autodesk\Advance Steel 20xx\INT\Steel\Data\AstorDetails.mdf
C:\ProgramData\Autodesk\Advance Steel 20xx\INT\Steel\Data\AstorBase.mdf
…

(A different language code might be shown instead of INT, like USA,DEU ...)

Causes:

The error message "Failed to connect to the following databases: ... " is generic, indicating only that AS cannot connect to one or several of its databases.
Advance Steel needs to connect to the SQL Server instance managing its databases, and then to open the databases.
Here is a list with different scenarios when the error message can be shown:

1. The connection to the database itself cannot be done

• The MDF database and its associated LDF file are incompatible;
• The database file is missing from the expected folder;
• The folder containing the database(s) is not fully accessible (Read & Write) by the user;
• The database file is marked as Read-Only;
• The version of the SQL database is higher than the installed SQL version.
• The database is corrupt / invalid.

2. The connection to the SQL Server / instance cannot be completed

• The SQL Server LocalDB is not installed.
• The SQL Server LocalDB installation or SQL instance is corrupted.
• Third-party application prevents connection to SQL Server (for example, Ad-Aware Web Companion (Lavasoft), Document Locator).
• The SQL Server is not accessible through network.
• The user cannot see the network SQL server instance (ports, firewall settings).
• The user does not have enough rights to connect to the SQL instance.

3. Error within " DatabaseConfiguration.XML " file

• The database path is incorrect or incomplete.
• The server name or instance name is incorrect.
• The communication port to the server machine / instance is incorrect.
• Typos.

4. Incomplete installation / Installation error

• Incomplete configuration of internal paths.

Solution:

To solve the issue, identify the scenario that causes the database connection error and apply the specific solution.

A. If the message appears right after install, see the reported folder path for database in the error message. If it is in the form of:

C:\ProgramData\Autodesk\Advance Steel Objects 20xx\Data\

Then use this dedicated article to investigate the installation:

• Database Connection error with Advance Steel Objects path while starting Advance Steel

B. If this error message appears while trying to place the Advance Steel databases on a shared location, start by following the steps indicated in this dedicated article:

• How to install the SQL databases for Advance Steel on a server to be shared with other users

C. To narrow down one or more possible causes of the error message, use the following workflow to verify the connection to SQL database:

• How to verify access to an Advance Steel SQL database

D. When the database is corrupt or invalid

Get the official version of the database.
As example, copy the corresponding database from a different installation / different computer.

E. When the application "Ad-Aware Web Companion" (Lavasoft) is installed on the machine, follow these steps:

1. Open the Task Manager by right-clicking the taskbar or pressing CTRL+SHIFT+ESC.
2. Find the process/service LavasoftTcpService and right-click -> End task.
3. Open Programs and Features with the Windows Control Panel.
4. Find the Web Companion application and uninstall it.
5. Navigate to the folder C:\Windows\System32 and C:\Windows\SysWOW64 and rename or delete these files:
   • LavasoftTcpService.dll
   • LavasoftTcpService64.dll

F. If this error message appears after copying the database(s) from another location (folder or machine), make sure that the LDF files have been deleted:

1. Go to the destination folder (where the database has been copied to).
2. Search for the LDF file corresponding to the copied database and delete it.

As example, if theAstorProfiles.MDF database is copied from another location:

• Go to the destination folder [C:]\ProgramData\Autodesk\Advance Steel [2019]\[INT]\Steel\Data\
• Delete the fileAstorProfiles_log.LDF

G. When databases are placed on local machine, verify the SQL Server LocalDB installation. Follow the steps indicated in this article:

• Investigating SQL Server LocalDB installation when working with Advance Steel product

If the database error message persists when starting Advance Steel product, contact Support and open a Technical support request for further investigations.

hugheswithromb.blogspot.com

Source: https://knowledge.autodesk.com/support/advance-steel/troubleshooting/caas/sfdcarticles/sfdcarticles/Database-connection-errors-when-starting-Advance-Steel.html

Share this post