Tag Archives: System

MDGP 2013 Feature of the Day: Alternative/Modified Forms and Reports

Microsoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The tenth feature they’ve announced is some enhancements to the Alternative/Modified Forms and Reports window.

This feature covers several enhancements to the window to improve usability.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , | 1 Comment

How To Recreate SQL Objects Using PSTL

As well as rebuilding a corrupt GL00105, the Toolkit within the Professional Services Tools Library (PSTL) can be used to recreate SQL objects such as SQL Indexes or the Dex stored procedures.

Continue reading

Posted in Dynamics, GP, Microsoft, Professional Services Tools Library | Tagged , , , , , , , | 3 Comments

How To Rebuild GL00105 Using PSTL

A while ago I posted a script that could be used to fix a corrupt Account Index Master (GL00105). However, the Toolkit within the Professional Services Tools Library (PSTL) can be used to do the same thing without resorting to a custom script.

Continue reading

Posted in Dynamics, GP, Microsoft, Professional Services Tools Library | Tagged , , , , , , , | 2 Comments

Custom Splash in Microsoft Dynamics GP

One of the undocumented features of Microsoft Dynamics GP is the ability to use a custom splash screen.

The standard splash screen displayed by Microsoft Dynamics GP 2010;

Microsoft Dynamics GP 2010 Splash

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , | 5 Comments

Home Screen Connect Error – Server Error in ‘/lus’ Application.’

A client testing Microsoft Dynamics GP 2010 R2 prior to going live rang to say they were getting a runtime error when logging in. I dialled in and checked the home screen and couldn’t see any problem with the dynsa home screen so asked for a screenshot showing the error;

The screenshot they sent showed the below error message;

Home Screen Connect Error - Server Error in '/lus' Application.'

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , | 2 Comments

Automate Login To Microsoft Dynamics GP 10

Microsoft Dynamics GPClients who have upgraded to Microsoft Dynamics GP 2010 can use the new remember user and password functionality, but what about those who have not yet upgraded?

Well, in Microsoft Dynamics GP 10, and before, you can use a login macro to automate the login process. A macro can be created by pressing Alt + F8 on the login screen and following the normal login process before pressing Alt + F8 again to stop recording. Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , | 3 Comments

Microsoft Dynamics GP: One Key To Rule Them All

Microsoft Dynamics GPIn Microsoft Dynamics GP, one key to rule them all: the F1 key;

Microsoft Dynamics GP: The Most Important Key - F1

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , | 1 Comment

Resetting the dynsa password

Microsoft DynamicsI was working on a client’s system the other day and discovered that no-one knew the dynsa password. Bearing in mind my minor crusade to get clients to stop giving the SQL sa password to the GP administrator, instead giving them the dynsa password, I needed to reset the password.

In theory this should be possible from the User Security window (Microsoft Dynamics GP menu >> Tools >> Setup >> System >> User). However. after changing the password I was unable to log into Microsoft Dynamics GP with the dynsa user.

In the end the solution is to remove the password using the SQL Server Management Studio. Next time dynsa logs in the following message will be displayed and force the password to be changed;

Blank passwords are not allowed. Do you want to change your password now?

Posted in Dynamics, GP, Microsoft | Tagged , , | Leave a comment

To sa, or not to sa? That is the question.

Microsoft DynamicsActually, that’s not the question at all; as a general rule of thum, the sa user should not be used by anyone within Microsoft Dynamics GP. The sa user is the SQL System Administrator user whereas Dynamics GP has it’s own System Administrator user; dynsa.

So, what is the difference between these two system admins? Well, to start with, sa is the SQL Server database administator and, as such, has access too all databases, including non-Dynamics databases, on the SQL Server instance. Instead dynsa should be used as it is the GP database administrator and only has access to the GP databases.

While sa is needed for initial system instllation and configuration, and for some third party add-on administration, it should not be used for day-to-day administration of Dynamics GP. As dynsa is a database owner it can be used for most security and maintenance tasks within GP and, like sa, is granted the Poweruser role automatically.

I have to admit, this is more “do as I say, than as I do” because we have been slightly lax in getting this message out to clients. This is something I fully intend to put right this year as I travel around client sites doing upgrades to Microsoft Dynamics GP 2010; in some cases this may lead to entertaining discussions with various Heads of Finance or Directors of Finance or Resources. However, I think in all cases the clinching argument is that using dynsa instead of sa minimises the possibility of tampering with non-GP databases should the password be accidentally leaked.

Posted in Dynamics, GP, Microsoft | Tagged , , | Leave a comment

How To Speed Up Logging Into GP

Microsoft DynamicsA couple of weeks ago, I explained how to fix a corrupt menu where a separator item could not be added.

One thing I forgot to mention in that post is that clearing down the Menu Master, which is then rebuilt when logging into Dynamics GP again, is that this cleardown will speed up the logging in process as GP will have fewer entries which it needs to check your user has access to. This is something we schedule in whenever we are doing an upgrade (or if users off off for a Reconcile or Check Links to be run).

Posted in Dynamics, GP, Microsoft | Tagged , | Leave a comment