SQL Server Coding Tips

21 Responses to “SQL Server Coding Tips”

Cherie Grubb Reply January 2, 2015 at 2:08 pm

Victoria –
Ever have an issue where a GP user’s password was changed in SQL Server Management Studio and then they couldn’t get into GP with that password. Then when you change the password from inside of GP they can’t access Sql Server management studio. To access SSMS we are using sql authentication

LikeLike
- Victoria Yudin Reply January 4, 2015 at 11:03 am
  
  Cherie,
  
  This is by design. When a user password is set up in the Dynamics GP application, the password is encrypted and can then only be used with the Dynamics GP application, which will be able to decrypt it. You will not be able to use that password anywhere else, as nothing else will have the decryption key. In addition, because of how Dynamics GP handles permissions, if you were able to use the same SQL user/password in SSMS, the user would have access to all database objects, which you may not always want. I would recommend setting up a different user ID directly in SQL for users that need to access to use SSMS. Typically I see this done using the active directory login.
  
  -Victoria
  
  LikeLike
  - Cherie Grubb Reply January 5, 2015 at 8:44 am
    
    Thanks Victoria. That’s what I thought. I’ve just started at this company and everywhere else I’ve worked when accessing SSMS I’ve used windows authentication.
    
    LikeLike
  - Cherie Grubb Reply January 14, 2015 at 1:03 pm
    
    Thanks for the help. We just created a new userid in sql like you suggested.
    
    LikeLike
Qadeer Ahmed Reply March 18, 2014 at 3:32 am

Splendid work by victoria, Awesome, hats off to you

LikeLike
sharmila Reply October 11, 2010 at 5:59 am

Hi Victoria

Awesome, thanks u so much for ur reply.

Please mark me for the future questions.

Many thanks indeed…….

LikeLike
sharmila Reply October 10, 2010 at 6:31 am

Hi Victoria

How to reset the password in GP 10.0 if the user is not logged off properly. When the administrator reset the password, message appears like “password has not been changed. The User is logged in”.

Do I have to reset password through Backend ‘ SQL Server’ and how it should be done. Please Explain……

Many Thanks

LikeLike
- Victoria Yudin Reply October 10, 2010 at 11:08 am
  
  Sharmila,
  
  I would recommend getting all users out of GP and running the following in SQL Server Management Studio:
  Delete DYNAMICS..SY00800 Delete DYNAMICS..SY00801 Delete DYNAMICS..ACTIVITY Delete TEMPDB..DEX_LOCK Delete TEMPDB..DEX_SESSION
  
  -Victoria
  
  LikeLike
  - Squared Reply July 22, 2011 at 3:13 pm
    
    I was trying to upgrade our GP development server to SP2 and when I ran Utilities, it told me that someone was logged in, However, I already ran the SP2 install and couldn’t log in to GP to kick them out. I found several solutions to remove a user stuck in GP, including a couple of KB from Microsoft, but yours is the one that did the trick.
    
    LikeLike