Having bounced AR servers back and forth between different db's hosted on different instances of a SQL Server, all you need to change in the ar.cfg is the instance name:
Sybase-Server-Name: SQLSERVER\TESTSERVER The SQL Server client on the AR Server looks up the server and port in the registry under \LastConnect\SQLSERVER\TESTSERVER If you have never connected to that SQL Server before from the AR Server in question (and this is a good test anyway), open the SQL Server Management Studio and log in to the new instance that you want to use for ARS with the account that the AR Service will use to connect to it (Windows auth or SQL Server auth); you should be using the same Db-user: account for the dbo in both ARSystem db's, or you will have to change that as well. It's magic (when it works) ;~) Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Thursday, March 31, 2011 2:25 PM To: [email protected] Subject: Re: ar.cfg setting for custom MS SQL port? Juan, When I ran the install I needed the special port #, but after the install happened the config does not need the port...it uses the SQL Client to connect whereas the install uses JDBC to connect....so you should find that even on that custom port, an existing server will connect without a port in the ar.cfg. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Juan Ingles Sent: Thursday, March 31, 2011 12:49 PM To: [email protected] Subject: ar.cfg setting for custom MS SQL port? I'm not having any luck finding the ar.cfg parameter to specify my non-standard MS SQL Server port. You can specify the port in the installer, of course, but I need to change an existing server so I need the config name. Anyone know the magic word? Thanks, Juan Ingles ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
