Cannot Connect to SQL

[TimHayes]

My situation:

Installed on my 64-bit Windows Server 2008 Server:
- SQL Server Express 2008 R2
- ArcSDE 10.1 for SQL
- ArcGIS Server 10.1 for Enterprise (Advanced)

Installed on my 32-bit Windows 7 Desktop:
- ArcGIS Desktop 10.1 for Advanced (ArcInfo)
- SQL Server 2008 R2 Client

In MS SQL Server Management Studio I have created the database. In addition, I already created the instance during installation.
There is no data in the database as of yet, but I did create it in studio. My Authentication is Windows (Operating System).

Problem:
From my desktop, in ArcCatalog, I go to Database Connections:
Database Platform: SQL Server
Instance: PGIS
Authentication Type: Operating System Authentication
Database: PGIS1

Connection Pop Up Box says: "Unable to connect to the database server to retrieve database list; please specify your server name, user name, and password info again. Failure to access the DBMS server."

Being new to SQL Server and ArcSDE, I think I might have missed something.

[JakeSkinner · Accepted solution]

1.  Check to make sure 'SQL Server Browser' is running within your services

2.  Go to Start > Programs > SQL Server > Configuration Tools > SQL Server Configuration Manager.  Expand SQL Server Network Configuration > Protocols for MSSQLSERVER.  Check to make sure Named Pipes and TCP/IP are both enabled.  Check the same for SQL Server Native Client Configuration within the Configuration Manager.

3.  By default, SQL Server communicates through port 1433.  Do you have this port open within your Firewall (if there is one)?

[TimHayes]

1.  Check to make sure 'SQL Server Browser' is running within your services

2.  Go to Start > Programs > SQL Server > Configuration Tools > SQL Server Configuration Manager.  Expand SQL Server Network Configuration > Protocols for MSSQLSERVER.  Check to make sure Named Pipes and TCP/IP are both enabled.  Check the same for SQL Server Native Client Configuration within the Configuration Manager.

3.  By default, SQL Server communicates through port 1433.  Do you have this port open within your Firewall (if there is one)?

I did #2 they are both enabled. How do I get to #3?

Also, in SQL Server Management Studio - Database Properties for PGIS - Permissions - Users/Roles; the white space is empty. I go to Search and it gives me the option of choosing guest or public. When I type in my <doman>/timothy.hayes it says it cannot locate the user. I then choose public, it accepts it, but then when I exit Studio, and re-open, pubic is gone and there is nothing in the previously mentioned white space.

[TimHayes]

I have ArcGIS Desktop loaded on my Server. I am able to connect to the SQL Server Database in ArcCatalog.

But, on the client side, my own PC, I cannot make the connection. I think it may have something to do with the SQL Server Native Client I installed. When I installed it on the client side, it did not give me an option to do any configuration. Now that I provided this info, any ideas on why I cannot connect from the Client side? but I can connect from the Server side using ArcCatalog.

[TimHayes]

I am now able to connect to my Enterprise SQL Server Express Database from the Client side in ArcCatalog. Here is how I did it:

On my Server, I opened SQL Server Configuration Manager, then under SQL Server Services I opened SQL Server Browser and Started it.

It appears that if SQL Server Browser is Stopped or otherwise disabled, you cannot connect from the Client Side.

All is well now.

Can I give myself a Point for finding the answer? 🙂

[VinceAngelo]

Shouldn't the check chould go to Jake for point #1 on Friday (4 posts ago)?

- V