Hello all,
I have set up a Map3D 2014 R2 Electric Industry model on SQL Server 2008 R2. All works as expected when I login with a user that is db_owner in SQL. When I set up a user for public/db_datareader I can login to the IDM with Map3D but it will not render the objects. Here is my overview:
There are two results in the end:
- A user cannot connect to the SQL IDM unless they are a db_owner.
- A user with SQL read-only permission can connect with DX (AutoCAD Utility Design 2014 E1), but the read-only is ignored and all data is written to SQL IDM when merging.
Here is what I have tested:
Create a new SQL User, Set Server Roles to public and User Mapping as follows (Danville is the IDM DB): (Image 1 and 2)
With these settings we can get through selecting our IDM to connect to in Map3D and immediately get this: (Image 3)
- Changing the default schema has no effect on the outcome.
- Setting MAPSYS to db_owner or db_datareader has no effect on the outcome, I don’t think MAPSYS really matters to what we are trying to accomplish. Do you agree?
- Setting the Danville DB to db_owner always works.
- Creating the SQL User or using a windows login both have the same results.
- With the same user setup you can connect in DX, but all data is written back on a merge, it ignore the db_readonly.
- Logging into SQL Server Management studio with these credentials will allow read, but not write, as expected.
I appreciate any insight the community has on this!
Jeremiah