Unable to Add a Database Server in ArcCatalog...

Discussion created by DJB on Dec 3, 2013
Latest reply on Jul 24, 2017 by Aake.M
I've installed an instance of SQL Server Express, successfully registered it and configured it.  No matter what I try, I am unable to connect to it through Add Database Server.  I can connect to it on the server side but not the client side.

SQL Server Browser is running...
SQL Server (<instance>) is running...

Shared Memory, Named Pipes and TCP/IP are all enabled.

Under Server Roles I have both "public" and "sysadmin" checked.

On the client side, the only way I can get Add Database Server to work is if I include a port number (i.e. myserver\<instance>,58524).  The problem that I run into is that the status of the database server in unknown (little white box on the server icon).  When I view my Database Server properties, my Status in unknown as well as my Class is unknown.  Without these two properties populated, I am unable to do anything with the database.

My server is running Windows Server 2008 R2 (64-bit) and ArcGIS Server 10.1.  As mentioned earlier, I'm using SQL Server 2008 R2 (Express).

Any assistance or suggestions would be greatly appreciated.

Thanks Everyone.