stsnider

Database Connection Files different between Catalog and Tool creation

Discussion created by stsnider on Nov 7, 2013
Latest reply on Nov 7, 2013 by mvolz47
ArcGIS Desktop 10.2 Advanced

I discovered that creating a database connection using â??Add Database Connectionâ?? under the Catalog window is slightly different from using the tool â??Create Database Connectionâ?? in ArcToolbox. When I compared *.sde files â?? one created using â??Add Database Connectionâ?? and another using â??Create Database Connectionâ??, they are different. Why should you care? Because a database connection file used as a registered database in ArcGIS Server needs to be created using the same method as the database connection file you use when publishing to ArcGIS Server. Otherwise, you will see a message when you go to publish a map service that your database is not registered with the server....when it is....but it is using a connection file that was created differently.

Maybe this difference is only realized when you have to use a port with your database server. If anyone uses a port to connect to their database server, please try this out and see if you get the same results.


Create Database Connection Tool
S E R V E R & d b v s r v , 1 2 3 4 I N S T A N C E B s d e : s q l s e r v e r : d b v s r v , 1 2 3 4 D B C L I E N T s q l s e r v e r 2 D B _ C O N N E C T I O N _ P R O P E R T I E S & d b v s r v , 1 2 3 4 D A T A B A S E E S R I D E V I S _ G E O D A T A B A S E t r u e ( A U T H E N T I C A T I O N _ M O D E D B M S U S E R G I S P A S S W O R D 8 [1] 0 .hD2dVPE12pPpbM7W1PtT0/4c+tgmf/hj7T9P6EzVFb50=* V E R S I O N s d e . D E F A U L T C O N N P R O P - R E V R e v 1 . 0


Add Database Connection in Catalog
S E R V E R d b v s r v I N S T A N C E @ s d e : s q l s e r v e r : d b v s r v , 1 2 3 4 D B C L I E N T s q l s e r v e r 2 D B _ C O N N E C T I O N _ P R O P E R T I E S $ d b v s r v , 1 2 3 4 D A T A B A S E E S R I D E V I S _ G E O D A T A B A S E t r u e ( A U T H E N T I C A T I O N _ M O D E D B M S U S E R G I S P A S S W O R D 8 [1] 0 .hOYAYZ+kPtUJhaO7G0B6VuZ6fkOo3RHxMTM7jiR9mac4=* V E R S I O N s d e . D E F A U L T C O N N P R O P - R E V R e v 1 . 0

Outcomes