Latest Contributions by MKF62

I figured it out and it has nothing to do with the function. It is because I was using "status" as my variable name. The word "status" must be some sort of reserved word because when I changed the variable name to something else ("myStatus" for instance), it started working.  Full script:     var map, myStatus;         require([         "esri/Map",         "esri/views/MapView",         "esri/layers/FeatureLayer",         "dojo/domReady!"       ],       function(         Map, MapView,         FeatureLayer       ) {         map = new Map({           basemap: "dark-gray"         });         var view = new MapView({           container: "viewDiv",           map: map,           center: [-77.069, 36.950],           zoom: 14         });         /********************          * Add feature layer          ********************/         // Carbon storage of trees in Warren Wilson College.         var popup = {           title: "{StateID}, Point {Point}, Patch {PatchNum}",           content: "<ul><li>Canopy Deciduous: {CnpyDecid}%</li>" +                   "<li>Canopy Coniferous: {CnpyConif}%</li>" +                   "<li>Bare Ground: {BareGround}%</li>" +                   "<li>Habitat Status: {OfficialQH:myStatus}</li></ul>"         };         var featureLayer = new FeatureLayer({           url: "https://xxx/MapServer/0",           outFields: ["*"],           popupTemplate: popup         });         map.add(featureLayer);         featureLayer.refreshInterval = 3;                 myStatus = function(value, key, data) {             var result = "";             switch (value) {               case 1:                 result = "Yes";                 break;               case 0:                 result = "No";                 break;                                       default:                    result = "Maybe";                     break;             };             return result;           };       });‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Alright, after much tinkering, I finally got it to work. It took two things: 1) I had to create the User through SQL Server Management Studio instead of using the various geoprocessing tools. I'm still not entirely sure why, but it worked. First (as db_owner) I created a new login (Security > Logins (right-click) > New Login > fill out username, password fields and check appropriate boxes. Then I created the user in the database of interest and created a schema by the same name and assigned it to the user (Database of interest > Security > Users (right click) > New User...  and Database of Interest > Security > Schemas (right-click) > New Schema...). Then I tested this connection in ArcCatalog. The user should connect but since it doesn't have any data privileges yet, it won't be able to see any data in the database. When I determined that connection was successful, I tested the connection in SSMS; again it should connect but you shouldn't be able to see any of your feature classes or tables since the user has no privileges yet. Next, I went to Catalog and added an "Editor" role. Steps to do this include creating a DB connection using my db_owner user (my windows authentication in this case), right-click the connection > Administration > Create and Manage Roles. Filled out with "Editor", GRANT, and the name of the user I just created in SSMS. I then went to each feature class and right clicked > Manage > Privileges > Add > "Editor". Then I selected all checkboxes for Select, Insert, Update, Delete. Clicked Ok and returned to SSMS where I connected as my db_owner account. Went to the database of interest > Security folder > Users > opened properties for my new user and made sure it looked like so (Securables and Extended Properties are empty): 2) In my python script, I removed "sde:sqlserver:" from my instance name and ran the process. This time it connected successfully to my database using my new, database-authenticated user.  import arcpy arcpy.CreateDatabaseConnection_management(out_folder_path='C:\Users\xxx\Desktop\GIS_Testing',                                           out_name='HBMTest.sde', database_platform='SQL_SERVER',                                           instance='myServerName',                                           account_authentication='DATABASE_AUTH', username='HabitatTestWriter',                                           password='xxx',                                           save_user_pass='SAVE_USERNAME', database='HBMTest') arcpy.env.workspace = r'C:\Users\xxx\Desktop\GIS_Testing\HBMTest.sde' featClasses = arcpy.ListFeatureClasses() tables = arcpy.ListTables() for fc in featClasses:     print fc ... View more