SQLSERVER\NAMEDINSTANCE worked like a charm -- it was indeed all I needed. Any sufficiently simplified Technology will seem like Magic!
Thanks everyone! Juan Ingles On Thu, Mar 31, 2011 at 12:55 PM, strauss <[email protected]> wrote: > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
