How to verify access to an Advance Steel SQL database

Autodesk Support

Oct 8, 2023

Products and versions covered

Issue:

Guidance on generic method to verify the connection and access to an Advance Steel SQL database.
 

Solution:

Follow these steps:
  • Install SQL Server Management Studio (SSMS) 2014 on the machine running Advance Steel product:
  • Open SSMS
  • Connect to the SQL Server instance hosting the Advance Steel databases. For the "Server name:" use:
    • When the database is placed on the local machine:
      • (LocalDB)\MSSQLLocalDB
    • When the database is placed on a server:
      • [Server_Name]\[Instance_Name]
  • Search for the database name in the Databases list
  • If it is not there, manually attach the database. Use this article as a reference:
  • Select the database name and expand its content to see the Tables list
  • Select any table, right-click on it and use Select Top 1000 Rows
As long as the content of one table is accessible, it means that the local machine is able to connect to the SQL Server instance and the SQL Server instance is able to access the database.
Advance Steel product should be able to connect to this database, considering that the connection details within DatabaseConfiguration.XML file are correct.
 

Products:

Advance Steel;

Versions:

2019; 2020; 2018;

Was this information helpful?

Need help? Ask the Autodesk Assistant!

The Assistant can help you find answers or contact an agent.

Ask the Assistant

What level of support do you have?

Different subscription plans provide distinct categories of support. Find out the level of support for your plan.

View levels of support