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.
As an addition to what Asrujit wrote, if attempting to install a Personal ArcSDE a.k.a. Desktop Geodatatabase a.k.a. ArcSDE Personal Server, than you may wish to have a look at the detailed "installation" instructions I posted here: