How do I stop using the SA account with Great Plains
Posted on 2009-02-10
We have a dilemma with our installation of Microsoft Great Plains (Dynamics). We had a vendor do the entire installation. The setup is that the client is installed on a Windows Server 2008 Terminal Server and the database is installed on a different Windows 2008 Server running Microsoft SQL Server 2005. The vendor tells me that any of the Great Plains administrative tasks must be done with the SA login. For many reasons, I dont think that is a good idea. I created a SQL login that has full administrative rights over just the GP databases, but that did not work. Is there any way I can get away from using the SA login to do administrative tasks inside of GP?