Registering ArcSDE database with ArcGIS Server at 10.1

[MattSimmons]

I've got Server 10.1 Prerelease up and running, and ArcSDE 10.1 up and running on Oracle 11g.  I've got Desktop 10.1 up and I'm trying to publish a service, but apparently I need to register the data with Server first. 
In Server Manager, I'm trying to do this by clicking Site -> Data Stores -> Register Database.  I browse to the local connection  *.sde file for that instance, click Import and I get a window that says

EDIT_PANE

and nothing else...... what the?

[DennisGeasan]

For SQL Server users who might find this thread - as noted above, if the ArcGIS Server machine is different from the SQL Server machine hosting the SDE Geodatabase, you have to install the 64 bit "Microsoft SQL Server 2008 R2 Native Client" on the ArcGIS Server machine.  One indication of this need is if you get the following error when trying to add a Data Store with ArcCatalog and ArcCatalog is not installed on the ArcGIS Server machine.

[ATTACH=CONFIG]18669[/ATTACH]

Dennis Geasan
GIS Technologies

[TysonHaverkort]

I'm seeing this same error on Windows 2008 R2 x64 when connecting to SQL Server 2008R2.  The part that concerns me is that I can go through the process of adding the database to the data store via ArcCatalog, and the sde connection is added.  I can also verify the connection from ArcCatalog.  When I log into Server Manager, I can see the entry in the data store, but it shows as unverified.  When I attempt to verify in SM, I get the red exclaimation mark.  I do have ArcGIS for Desktop and ArcGIS for Server running on the same machine.  Perhaps this indicates that the 32bit client is found, but the 64bit SQL Server client is not installed (correctly)?  I'm guessing that even though the data store entry validates ok in Catalog, it's not really valid, as show in the SM?

[HusseinNasser]

Hello, I solved the problem following these steps:
1) installing both the 64 and 32 bit version of the oracle client
2) placing the 64 bit path before the 32 bit path in the path system variable
3) creating a system variable TNS_ADMIN that points to the folder containing the tnsnames.ora file.

Finally I had to restart the ArcGIS Server process.

Ale

I had it all fixed, the only problem is that I forgot to restart ArcGIS Server service.  So the steps that worked for me are as follows

1) installing 64 bit version of the oracle client
2) Restart the ArcGIS for Server service.