Plant 3D multi user SQL Server

[dwarrander]

Hello

We have an overseas delivery centre working on some minor modelling in plant 3D.  We are currently set up for windows authentication to access the models.

We would like the consultants to access the models using their own tenant windows login credentials.  

I have looked at running the application as different users with username/passwords pipes with no luck.  Is there any config files or anything like that in plant that would allow me to do this?

[alexlibrelon]

I can help you configure Plant 3D for multi-user access with an overseas delivery center using their own SQL Server login credentials. Here's a breakdown of the process:

1. Setting Up SQL Server Authentication:

• Enable SQL Server Authentication: On the SQL Server instance hosting your Plant 3D project database, you'll need to enable SQL Server authentication mode. This allows users to connect with usernames and passwords instead of relying solely on Windows authentication.
• Create User Accounts: In SQL Server Management Studio, create separate user accounts for each consultant at the overseas delivery center. Assign appropriate permissions to these accounts based on their access needs (read-only, modify, etc.).

2. Configuring Plant 3D Project:

• Plant 3D Project Setup Wizard: When initially setting up your Plant 3D project, or modifying an existing one, use the Project Setup Wizard. Choose the option to connect to a SQL Server database.
• Specify SQL Server Login Credentials: During the project setup, instead of using Windows authentication, provide the SQL Server login credentials (username and password) for the consultant accounts you created.

3. Client-Side Configuration (Optional):

• Connection String: If consultants are accessing Plant 3D from their own workstations, you might need to provide them with a connection string that includes the SQL Server address, database name, and the consultant's specific SQL Server login credentials. This connection string can be used within Plant 3D to establish the connection.

Important Considerations:

• Security: Enabling SQL Server authentication introduces a layer of complexity compared to Windows authentication. Ensure you implement strong password policies for consultant accounts and manage access permissions carefully.
• Network Connectivity: A stable and secure network connection between your local network and the overseas delivery center is crucial for smooth collaboration. Consider factors like bandwidth, latency, and potential firewalls that might need configuration.

Additional Resources:

• Making the Move from SQLite to Microsoft SQL Server ®: AutoCAD Plant 3D Database Configuration: https://m.youtube.com/watch?v=2sCCJhR4Qps
• Multi-user projects - Autodesk Community - AutoCAD Plant 3D: https://forums.autodesk.com/t5/autocad-plant-3d-forum/multi-user-projects/td-p/11803692

If you encounter any difficulties during the configuration process, it's recommended to consult the documentation for your specific version of SQL Server and Plant 3D.

By following these steps and considering the security implications, you should be able to enable multi-user access for your overseas delivery center with their own SQL Server login credentials.