150
Dear All,
I have a DynamicsGP site which are not to use SQL2005 userid 'sa' in the ODBC connection setting.
Can i create a new userid (let said 'gp_sa' ) in the ODBC setting after all the initial database (Dyanmics, TWO) created.
If yes, what is the privallage permission i need to set in SQL2005 ? Btw, i also not allow grant the same 'sa' privilege to 'gp_sa'
Please advice, Thanks.
rgds
Jas
*This post is locked for comments
Hi
Remember that any valid user id and password can be used when setting up ODBC. However, as a GP user will have an encrypted password, you will need to use a different login. A final point about ODBC settings is that logging in to test the connection is optional and you can get away with not using a login at all.
See this post about the reason for the encryption:
As for using another user such as 'sa_gp', some ISV products might still need the user ID to be 'sa' for installation tasks, rather than actually check SQL permissions. Most of the Microsoft products should have already been updated to use SQL permissions.
You don't want to change the Database Owner databases. This should be DYNSA for the system to work correctly.
You can convert an existing GP user to sysadmin to allow them similar rights to 'sa', but as they have an encrypted password you could only use it from within Dynamics and Dynamics Utilities.
Have a look at Mariano's post for more information.
http://dynamicsgpblogster.blogspot.com/2009/04/microsoft-dynamics-gp-10-poweruser-role.html
You can always use the Support Debugging Tool for SQL access to the databases via the SQL Execute window.
[Edit] Another idea for a site which has an existing SQL server where they don't want you to have full access, is to have a separate instance of SQL server for Dynamics. This gives independence. You can have different service packs, different sort orders and be able to restart the service as needed. And you can't mess with the databases from their existing systems.
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi David,
I have the same issue with Jas, our story is similar.
In addition - I know in some of our procedure like installation utilities we have to login as 'sa' how will this affect if we are only allowed to use 'sa_gp'? The client is persistent after I have told them all the reasons...they said we should not use 'sa' because there are other databases in our sql that we should not have access to. Is this an option? thanks
Dear David
Due to the client I.T group policy that i'm not allow to use 'sa' userid when configure the ODBC setting at client workstation. They have created a new sql userid called 'sa_gp' but i donot sure what permission should i grant to Dynamics, TWO databases for 'sa_gp'. is it safe enough if i grant db_owner, public and 'sa_gp' under Dyngrp group ?
Please advice. Thanks
regrds
Jas
Hi Jason
The user name and password used in the ODBC setting is ONLY to test the connection or bring in default setting values from the server. Connecting to test is optional and any user can be used.
The password entered is not stored afterwards, so use of 'sa' is safe.
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,432
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
