+ Reply to Thread
Results 1 to 2 of 2

Thread: Cannot Connect to Database Server Failed to connect to Database Server

  1. #1
    ehsan paki
    Join Date
    May 2011
    Posts
    20
    Points
    0
    Answers Provided
    0


    0

    Default Cannot Connect to Database Server Failed to connect to Database Server

    hello
    i installed ArcSDE 10 Enterprise and sql server express 2008 R2 on my laptop.i have installed ArcSDE post installation and after installing successfully , i got details shown below

    Service - esri_sde
    port no. 5151/tcp
    sde username - sa
    sde password - 1026
    database name - road
    instance name : PC-EHSAN
    Servername: PC-EHSAN


    i want to make a ArcSDE geodatabase but when i want to "add database server" , i encounter with below error :

    "Cannot Connect to Database Server Failed to connect to Database Server "


    so i checked and enabled the following issues:

    SQL Server instance is allowed remote connections.
    SQL Server Browser Service is enabled.
    TCP/IP in SQL Server Configuration Manager is enabled.
    ArcSDE service (esri_sde) is enabled.
    firewall is configured to allow sql server access (with 1433 tcp port).

    But still i encounter with mentioned error...what should i do ? please help me...
    i saw in esri website that " the Windows domain account should be added into the SQL Server instance" .i do not know how can i do it ?and also is it necessary?because i installed all the software on my laptop...

    please help
    thanks

  2. #2
    Shannon S.
    Join Date
    Oct 2009
    Posts
    70
    Points
    77
    Answers Provided
    9


    0

    Default Re: Cannot Connect to Database Server Failed to connect to Database Server

    By running the SQL Server Post-Installer you will have already created a geodatabase (stored in the roads database). So when you connect in ArcCatalog you should make a Database Connection. In the Catalog Tree, open the Database Connections folder & double-click 'Add Database Connection'. In the Database Connection dialog enter in the connection parameters:

    Server - PC-EHSAN
    Instance - 5151
    database name - road
    & username & password.

    Alternately you can make a direct connection using this syntax:
    Server - PC-EHSAN
    Instance - sde:sqlserver:PC-EHSAN
    database name - road

    The Database Servers node in ArcCatalog is specifically for managing Workgroup or Desktop geodatabases (ArcSDE for SQL Server Express licensed through ArcGIS Server Workgroup, or ArcGIS Desktop). You have ArcSDE Enterprise so you'd use the Post-Installer to create geodatabases and make Database Connections to those geodatabases.

    -Shannon

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts