Server 10.1 - Unable to connect to datasource

[DavidMaltby]

After installing ArcGIS Server SDS 10.1 I tried creating a datasource by using http://<server>/arcgissds/admin/datasources/createDatasource and filled in the fields with the appropriate data and get an error message:
{
  "error" :
  {
    "code" : 400,
    "message" : "",
    "details" : [
      "Unable to connect to datasource."
    ]
  }
}

Connecting to a different server with SQL Server 2008 r2.

ANY help would be MUCH appreciated!!

David R. Maltby II
IT Specialist
U.S. Geological Survey

[Anonymous User]

Hi David,

Can you check for the following.

1. SQL Server Browser Service is running
2. SQL Full-text Filter Launcher service is running
3. Shared Memory is enabled in the SQL Server Configuration Manager
4. Named Pipes is enabled in the SQL Server Configuration Manager
5. TCP/IP is enabled in the SQL Server Configuration Manager


Hope that helps,
Andrew

[DanGriffin]

This all checks out for me and I'm still unable to connect.  I have SQL Management Studio installed on the ArcGIS Server and I'm able to connect through that.  The only error message I get from ArcGIS is Unable to connect to datasource.  Not very helpful.

[AndrewPrice2]

Having the exact same issue...

[Anonymous User]

Andrew / Dan / David,

If you are still experiencing this issue, please contact Esri Support Services. We need more information about each configuration, as they may not be the same issue.

Thank you,
Andrew

[AlexeyTereshenkov]

Had the same problem. I made sure that what Andrew outlined is properly configured and used the machine name as SQL Server instance name.

Well, it might be a bit confusing, but "SQL Server instance" as outlined in the Help was my machine name when having default (non-named SQL Server instance) installation.

So, when I use "MSSQLServer" (this is what I get when running the

select @@SERVICENAME

as SQL query) in the Server field in the Create Data Source dialog box, I am getting this error message. But when I use localhost or real machine name (this is what I get when running the

select @@SERVERNAME

) it does gets created.

Test this to see if it works for you.

PS. If you are unable to connect to the database from the Database Connections in the Catalog window, consider installing SQL Server Native Client which is mentioned as a requirement for SDS installation.

[Kim_Ness__Sundeen]

I'm replying to the comment about being unable to connect a database to ArcGIS Server 10.1.  I'm having the same issue.

SOME BACKGROUND:  I'm the GIS Specialist for a smaller Natural Resources Department and have a background in GIS, but not in database management.  The IT Manager (also the main database administrator for our company) has Microsoft SQL Server 2008 R2 and ArcGIS Server 10.1 installed on a separate computer.  This separate computer serves as the company's server for all data.  I've installed ArcSDE 10.1 on my personal computer because I planned to manage all SDE databases within our department.  However, I'm having issues connecting to SQL Server to register the SDE databases with ArcGIS Server.

1) My 1st question is when I've already connected to an ArcSDE database and enabled it as a geodatabase, how do I then register this data with ArcGIS Server to get an interactive map to work?  Right now, I don't know where the ArcSDE database resides since I can't find it on my computer or through the Properties tab of the "Database connections" 

2) My second question is if my IT manager/main database manager is handling the ArcGIS Server, do I need to have him also manage the Microsoft SQL Server 2008 R2 for ArcSDE? The reason we went this route originally was because he was already using SQL Server to manage the the network and all company files.  He hasn't give me permission to access this SQL Server.  So, would it make more sense to simply install the SQL Server on my desktop to manage ArcSDE databases? Can I run SQL Server on my computer separately from the main SQL Server?

I'm sorry if these questions are confusing.  I appreciate any and all feedback from you.  Thanks.

Kim