FMTFMT

SQL Server Archives - FMT

Search Archive
GP Login Error: “The login failed. Attempt to login again or contact your system administrator”
Implementing a new Dynamics GP environment or migrating an existing GP to new servers it's not an easy task. So I think it's safe to say, we've all encountered our fair share of complications when doing so. In this blog, we will go over a GP Login Error of not being able to login with SQL sa credentials, and exactly how to resolve it.  We will start with an overall understanding of the GP Login Error by visiting Microsoft Support and reviewing the following suggestions: Confirm password information for sa. Check Data Source configuration for GP client (ODBC). Check versioning for GP. If a service pack is available, consider installing it. Review permissions for the smDex_Max_Char stored procedure. To put this in practice, we took an example of a recent case, where a client was migrating databases associated with GP to a new SQL server. After the databases were migrated, the system administrator was […]
Optimizing SQL Server Files and File-Groups Made Easy
Recently I had the opportunity to work with a client on a very large Web Application; the database for this application was composed of hundreds of tables, indexes, file-groups, and files; including a dozen partition-functions and as many partition-schemes, spanning both clustered and non-clustered indexes. The client was requesting to improve performance in their database as they moved this massive application to Azure Services. In order to accomplish this, I had to complete three of the following tasks: Move all clustered indexes into fewer file-groups, with a minimal number of files in each group. With a current configuration of 150+ file-groups the client was looking for a better management strategy, which aligned the number of file-groups with their Azure hardware. Clean up the file and file-group naming conventions and make recommendations on best practices. Over the years many developers have created new SQL file-groups, with no clear convention in mind, […]
©
2021
 FMT Consultants, LLC.
|
Privacy Policy
X
FMT

Contact Us

X
FMT

Newsletter Sign-up

menu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram