SQL Server security settings for Windows users

[lwilsonFQ5EE]

We just installed SQL server 2019 and am using Plant 3D 2022.  I am able to create a project using my SQL admin account but cannot access the same project using my Windows account.  What do I need to do in SQL to get this to work for all the users?  I am pretty sure it is a permission issue since P3D gives me "Failed to load Project file" and "Failed to load Cache" and "Login failed for user".  I am not familiar with SQL user settings and could use a little guidance for the access.

[h_eger]

Dear @lwilsonFQ5EE ,

Please make sure to set the "Windows Authentication" when setting up the Plant 3D project and not to set up the project as SQL Admin.

[lwilsonFQ5EE]

Yes I have set the project up that way but the issue is the SQL Server may not have the correct security groups or users.  I have added the users that are on the P3D project as sysadmins for now just because I am not sure how to set up SQL.  This way , at least they are able to access the project at this time.

[h_eger · Accepted solution]

First set up the rights and rules for the user group in the SQL server!
Then set up the project in Plant 3D!

[MTINGLE]

I have the same issue.  I am setting up a new instance of Plant 3D 2020 and SQL Server 2019. I'm trying to understand how Plant 3D communicates with the SQL Server and what credentials it uses.

When creating a new project can I use "SQL Auth" and a single "service account" to connect to SQL while setting up the project and then does Plant 3D use these credentials while Reading and Writing to the database regardless of the user who is running Plant 3D.

or ...

Do I have to use "Windows Auth" and create a SQL user account for each Windows user on the project who will be using Plant 3D.   Does each Windows user have to have a SQL account? This option sounds like a very labor intensive method.

Thanks

[jabowabo]

You can grant 'Connect SQL' permission to any Active Directory group (such as 'Domain Users' or whatever).

[MTINGLE]

Thanks for the reply.  So I need to create an AD group and place all of the project team members who need access to Plant 3D in it and then give that group access in SQL?  I would assume that the group would need read/write/mod to be able to work.

[jabowabo]

---

@MTINGLE wrote:

Thanks for the reply.  So I need to create an AD group and place all of the project team members who need access to Plant 3D in it and then give that group access in SQL?  I would assume that the group would need read/write/mod to be able to work.

---

I don't remember the exact settings - I set ours up years ago. The only thing I see assigned in SSMS is 'Connect SQL'. That is checked for a group that contains all our users.