Issues creating a geodatabase with ArcGIS Desktop v10.1 / SDE v10.0 on SQL Svr 2008R2

[JamesFox1]

Never did a SQL Server GDB install/configure (Oracle guy here..) and need a we bit of assistance.

We have ArcGIS desktop 10.1 on a client and a SQL Server 2008 R2 database on a remote machine.  We are trying to create an enterprise geodatabase on that SQL server database.  On this client, we also installed SDE 10.0 (box is 32 bit) , but have not run the post install because in 10.1 desktop you should be able to connect to the database, right click and "enable" the geodatabase and it should do the post-install for you.  We have a pvrc file for Arc Server Enterprise Advanced 10.1, which (the new provisioning file format that replaces the older ecp files) We were told this file should be good for SDE as well - however when connecting to the database and right click "enabling" it as well as going into ArcGIS Admin to "authorize" it, it doesn't seem to recognize this file for some reason. 

I am able to connect to the SQL Server database using ArcCatalog from Desktop v10.1, but when I import a feature class, I get a message that the login and schema name do not match.  I went out and created a schema of the same name of the login I used to connect however the same thing happens.

I am a little lost here. Is the pvrc file wrong/ Will I need to run SDE post install (since it is 10.0 amd that still has the post install applet and not the enabling function) Really need help in sorting this out since IT admin functions are beaurocratically bound here and it is very disadvantagous to just try random steps for these types of tasks, thanks.


-Jim

[AsrujitSengupta]

James,

The ECP files are still used to authorize/create new sde geodatabase. rather prvc files cannot be used to create new sde geodatabases 10.1 onwards.

To download a ECP file, use below link:
https://customers.esri.com/index.cfm?event=pub.ecpAuthorizations

While filling out the form to download the ECP file, you'll require the ECP #. You can verify that from the ESRI Customer Care Portal.

[AsrujitSengupta]

Regarding the "login and schema name do not match" issue that you are facing....unlike in  Oracle....in SQL Server we have to manually make the "Default Schema" same as the "Username", unless the user is a 'sysadmin' as that would automattically take the "dbo" schema.

Open SQL Server Management Studio--> Connect to the Instance--> Expand Security--> Expand Logins--> R-Click on the Username--> User Mapping--> Select the correct database--> Make sure the "Default Schema" is exactly same as the "Username".

This should solve that issue.

Regards,

[VinceAngelo]

I don't see the point in installing new ArcSDE 10.0 application server software with an
ArcSDE 10.1 geodatabase instance -- you can't use the two of them together.

While a supported (64-bit) configuration would be desirable, ArcGIS doesn't install binary
dependencies within SQL-Server like it does within Oracle, so you may survive (though
not thrive) in a 32-bit environment.

- V

[JamesFox1]

Hi Vince,

I think you have it backwards. We have ArcDesktop 10.1 and ArcSDE 10.0, both on the client machine.

thanks,

-Jim

[VinceAngelo]

You can't create a 10.0 enterprise geodatabase with 10.1 Desktop, and you can't create a 10.1
geodatabase with a 10.0 'sdesetup', so one of those two products is irrelevant to the problem
description.

You can access 10.0 GDBs from 10.1 Desktop, and SP4 and higher 10.0 tools can recognize
10.1 ArcSDE GDBs, but your question is about creation, hence my confusion.

- V

[JamesFox1]

The explicit schema mapping to the user resolved the feature class importing issue, thanks. I am probably access the database in a single user mode so we may have to return to the SDE post-install issue when we are at a point where multiple users need to concurrently hit this database.

Thanks all,

-Jim

[PaulKroseman]

I had the same issue with pvrc file in 10.1. See: http://forums.arcgis.com/threads/60046-Create-ArcSDE-keycodes-file-10.1

You can't use 10.1 Desktop tools to create 10.0 SDE geodatabase. You would need to run the 10.0 SDE post-installation steps to create the geodatabases. I would use 10.1 SDE unless there is a specific bug which would prevent you from using it.