I prefer to use a Domain account for the ARSystem database - theoretically it provides more security than a local SQL Server account, and I normally disable the sa account as soon as SQL Server is installed. This may be paranoia from the days of SQL Server 2000 on Windows Server 2000 with no firewalls, but I'd rather err in the direction of more secure as long as it does not cause other problems. This might be an issue if your active directory services are shaky, but if you are running Exchange for your mail, they had better not be. I am convinced that it is more secure than using a local SQL Server account, unless the AR server is on the same box as the SQL Server and it is restricted to local connections only.
If you use the domain account, remember to add it to your SQL Server instance Security Logins and give it a dbcreator role. You will probably have to make it a member of the local administrator group on the AR server as well (NOT on the SQL Server if it is on a separate box). Then log in to the domain with that account from the AR server console to run the installation; it will create the AR service with this domain user, something that versions of the installer before 7.x had problems with. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Friday, September 26, 2008 2:34 PM To: [email protected] Subject: Installing the AR SQL database question... ** When you set up the SQL database for the ARServer is it better to use one of SA or Domain Account or an impersonated account when you do the setup? Will either one work equally well or will there be issues? I read through chapter 6 of the "Installing the AR System with Micrsoft SQL Server". Thank you. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
