Latest Contributions by JakeSkinner

Hi Vasilii, I was able to get your script to execute successfully and was able to connect without error.  I would not recommend using your workaround of renaming the Default version owner to DBO.  This will not change who owns all the geodatabase metadata, and this could potentially cause problems down the road. The previously offered solution to change the version name was due to the former SDE admin originally altering the name. I would try deleting the geodatabase and re-executing your script.  Or, simply run the 'Create Enterprise Geodatabase' tool from ArcToolbox. ... View more

When you created the Enterprise Geodatabase, did you create it with an SDE owned schema?  Can you post the python script you used to create the Enterprise Geodatabase? ... View more

Hi Rudy, After your right-click on your feature class that has a relationship class, and then you right-click on the geodatabase to paste the data into, you should receive a dialog similar to the following: [ATTACH=CONFIG]17595[/ATTACH] You can see that by copying/pasting the feature class will also copy the relationship class, the other table/feature class participating within the relationship class, and any domains. What do you receive after you right-click > Paste? ... View more

Go to your Security folder, not under your database, but under the instance.  Then expand Logins.  Is your windows account listed there?  If it is, right-click on it > Properties > Server Roles.  Is 'sysadmin' and 'public' checked?  If it is, you won't have to add your windows account to the database.  The 'sysadmin' role gives your account administrative privileges over the entire instance (including all databases). If your windows account is not listed under Logins, right-click on the Logins folder > New Login.  Click the Search button and make sure 'From this location' is pointing to your network, and not the current server.  You should then be able to add your login, and then grant it 'sysadmin' under Roles at the top left. ... View more

You can double-check to make sure your window's account has the correct permissions by right-clicking on the database in Management Studio > Properties > Permissions.  Select your windows account and choose the 'Effective' tab. Your database connection dialog should look like: [ATTACH=CONFIG]17554[/ATTACH] ... View more

If you are the sa, then you have connect privileges.  Is PGIS the name of the server where SQL Server is installed? ... View more

Hi Timothy, 1.  Does your window's account have 'Connect' privileges to the database? 2.  Do you know if this is a named instance for SQL Server?  If it is, you will want to change the instance to, for example: <server name>\PGIS ... View more

Hi Gabe, Try overwriting the raster dataset using the Copy Raster tool.  For example, take a small raster and execute the Copy Raster tool.  Specify the output to be the raster dataset that failed to load within the File Geodatabase.  After it's copied, go ahead and delete the raster dataset within the File Geodatabase. ... View more

Can you attach a sample of your text file? ... View more

Hi Kevin, "for sc in arcpy.ListFields(lyr)"  will return a field object.  Try specifying the 'name' property for this object.  Ex: for de in searchfile.readlines():     if '--' in de:         fc=de.split('--')         for lyr in arcpy.mapping.ListLayers(mxd):             if lyr.name==fc[1].split('\n')[0]:                 print lyr.name,type(lyr)                 for sc in arcpy.ListFields(lyr):                     if not sc.name in searchfile.readlines():                         print sc.name ... View more