how not to SA account in Great Plains use management : California Dynamics GP Partner information

Free SMS Alerts (5000+ Subscribers) SMS 'ON wwwAyeshawebBlogspotcom' to 09870807070 or Click here to subscribe

Dynamics GP Partner California notes: how not to SA account in Great Plains Management use

If you use Microsoft Dynamics GP (formerly of ERP, MRP and accounting application is as Great Plains Software Dynamics GP and eEnterprise known) implemented in your business and your internal IT security is very tight, you can this question: Is it possible for GP administrator is not on the MS SQL Server system administrator account (sa). This is very big concern, especially when the same SQL Server 2008, 2005 or 2000 is hosting multiple DB applications: Dynamics GP, wages database, Microsoft CRM, and others. If this is the case, you will not be able Dynamics GP administrator simply open a new query in SQL Server Management Studio and select the select statement to run all your employees salaries codes. In this small publication we would like the simple solution and Highlights: 1 DYNSA account in Great Plains. This account is what you need – it’s Dynamics system administrator, such as Great Plains Software Dynamics for Microsoft SQL Server platform back in 1990th Designed. Many of the readers here probably get away with the decision to take this idea and be happy, but for the rest of us – we want you to come by checking and troubleshooting procedures and understand the architecture

2 DYNSA in SQL Server upgrade transformations. If you use Great Plains long time, then you should know that you could possibly organization in its history came across the following update: Microsoft SQL Server 6.5 to 7.0, then to MS SQL Server 7.0 2000 , then from MS SQL Server 2000 to 2005 and then from MS SQL Server 2005 to 2008. We encourage you to check is DYNSA login is still a member of the following server roles: dbcreator public security admin

3 DYNSA in test or new companies, creating and restoring backups. If your MS SQL Server Management Studio are set out in 2005 or MS SQL Server Enterprise Manager 2000, sa-use account, and if you use this tool to back up and restore databases, then when you restore the DB to be database owner sa account last automatically. In the day-to-day hustle and bustle of modern life or IT Director in Dynamics GP domestic support under the pressure, you may not immediately recognize the problem of steps DYNSA users from the wings – your Dynamics GP system and its databases continue as expected, but from that moment, you have to use SA as Dynamics GP Administrator. To resurrect DYNSA you need first run sp_helpdb understand who reset current owner of the dynamics and businesses DBSM and then you need title to DYNSA by this statement: sp_changedbowner ‘DYNSA’

4 Last tip. In Microsoft SQL Server 2005 DYNSA is not required in the DB-user list, since it is DBO or database owner. But for older versions of MS SQL server: 2000, 7.0 and 6.5, this restriction may not be forced. So if you also error message in the current sp_changedbowner ‘DYNSA “script, open DB in SQL Management Studio, expand the DB -> Security -> delete users and DYNSA by users list, if there is then run sp_changedbowner.” . DYNSA ‘

5th at this point should be able to use DYNSA account in the same capacity as SA

6 If you have concerns or suggestions, please call us at 1 – 866-528-0577, help@albaspectrum.com

About the Author

Andrew Karasev, Alba Spectrum, help@albaspectrum.com 1-866-528-0577, http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information Portal: http://www.pegasplanet.com We serve the USA and Canada nationwide from our Dynamics GP Call Center: California, Illinois, New York, Florida, Minnesota

 

 src=http://i.ytimg.com/vi/9D6EskxOEgw/default.jpg

Training: www.icttrainingen . nl Volg de Training MS SQL Server 2008 Implementation and Maintenance (Exam 70-432) on online ons innovatieve empty concept online learning: www.icttrainingen.nl Icttrainingen.nl – Online ICT Training en voor de ICT kennisdeling professional. www.icttrainingen.nl

Free SMS Alerts (5000+ Subscribers) SMS 'ON wwwAyeshawebBlogspotcom' to 09870807070 or Click here to subscribe