SQL Server Permission granted - No access to database SDE

Discussion created by mbly29 on Feb 27, 2013
Latest reply on Jun 27, 2013 by danielri
Hi Folks,

I have recently added a new user to our SQL based SDE environment. The user is set up as all others have been through SQL management studio with same access and permission settings.

However on the user machine I cannot access the database through ArcCatalog when trying to set up a new database connection. I should not have to do this in the first place as the users are set with OSA for access to the data. Users are linked to certain roles, and the role has been granted privilege to the database.

Data in the mxd is set to pull from a certain version of the SDE, however of course when I open their project all the data sources are broken and non repairable with no access to the database from that machine?

Any thoughts as to why this would be occurring?