topic Trouble making direct connection to SQL server 2012 instance/database in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/trouble-making-direct-connection-to-sql-server/m-p/357944#M13776 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I am very new to ArcGIS for Server, but am working on setting up a basic enterprise system using Arc 10.1, IIS, and SQL Server 2012, where the SQL software is on a separate computer from the ArcGIS for Server and IIS software. I am having trouble making a direct connection to my SQL database from a remote client computer because I can't get access to the specific instance that has been established. When I make a database connection from ArcCatalog on a client computer, I am able to connect to SQL Server and gain access to the "ReportServer" and ReportServer TempDB" databases, but when I try to connect to the specific instance (e.g. &lt;servername\instancename&gt;) I get an error that it is unable to connect. When I check the "sdedc_SQL Server" file in the Temp folder, the log reads:</SPAN><BR /><BR /><SPAN>IDBInitialize::Initialize Failed</SPAN><BR /><SPAN>CAN"T OPEN INSTANCE: sde:sqlserver.</SPAN><BR /><SPAN>Spatial Engine Connection Failed (-409).</SPAN><BR /><SPAN>Cannot Get Access to Instance see:sqlserver</SPAN><BR /><BR /><SPAN>I <U>am<U> able to connect to the specific instance and the database of interest from within ArcCatalog on the computer that houses SQL Server 2012, suggesting that this is just a matter of setting the proper permissions for the instance. I have all the permissions set and ports open that I know of or could find info on, but no luck. Is anyone able to provide guidance on how to resolve this? Any suggestions are welcome.</U></U></SPAN><BR /><SPAN>Many thanks!</SPAN></BODY></HTML> Fri, 31 May 2013 15:54:51 GMT HenryGlick 2013-05-31T15:54:51Z Trouble making direct connection to SQL server 2012 instance/database https://community.esri.com/t5/arcgis-enterprise-questions/trouble-making-direct-connection-to-sql-server/m-p/357944#M13776 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I am very new to ArcGIS for Server, but am working on setting up a basic enterprise system using Arc 10.1, IIS, and SQL Server 2012, where the SQL software is on a separate computer from the ArcGIS for Server and IIS software. I am having trouble making a direct connection to my SQL database from a remote client computer because I can't get access to the specific instance that has been established. When I make a database connection from ArcCatalog on a client computer, I am able to connect to SQL Server and gain access to the "ReportServer" and ReportServer TempDB" databases, but when I try to connect to the specific instance (e.g. &lt;servername\instancename&gt;) I get an error that it is unable to connect. When I check the "sdedc_SQL Server" file in the Temp folder, the log reads:</SPAN><BR /><BR /><SPAN>IDBInitialize::Initialize Failed</SPAN><BR /><SPAN>CAN"T OPEN INSTANCE: sde:sqlserver.</SPAN><BR /><SPAN>Spatial Engine Connection Failed (-409).</SPAN><BR /><SPAN>Cannot Get Access to Instance see:sqlserver</SPAN><BR /><BR /><SPAN>I <U>am<U> able to connect to the specific instance and the database of interest from within ArcCatalog on the computer that houses SQL Server 2012, suggesting that this is just a matter of setting the proper permissions for the instance. I have all the permissions set and ports open that I know of or could find info on, but no luck. Is anyone able to provide guidance on how to resolve this? Any suggestions are welcome.</U></U></SPAN><BR /><SPAN>Many thanks!</SPAN></BODY></HTML> Fri, 31 May 2013 15:54:51 GMT https://community.esri.com/t5/arcgis-enterprise-questions/trouble-making-direct-connection-to-sql-server/m-p/357944#M13776 HenryGlick 2013-05-31T15:54:51Z Re: Trouble making direct connection to SQL server 2012 instance/database https://community.esri.com/t5/arcgis-enterprise-questions/trouble-making-direct-connection-to-sql-server/m-p/357945#M13777 <HTML><HEAD></HEAD><BODY><SPAN>Problem resolved.</SPAN><BR /><BR /><SPAN>After two days I figured out that there are two instances of SQL Server running on my data computer, and that the program was defaulting to an instance that I had not created a database in. After creating a database in the second instance, remote client connections worked fine.</SPAN></BODY></HTML> Fri, 31 May 2013 17:06:50 GMT https://community.esri.com/t5/arcgis-enterprise-questions/trouble-making-direct-connection-to-sql-server/m-p/357945#M13777 HenryGlick 2013-05-31T17:06:50Z