Trying to setup a Test environment for GP 20136

(0) Share

Report

Posted on by Community Member

We've setup a new test server for GP 2013. We've installed it on a Windows 2008 R2, SQL 2012 SP 1. We have restored the production databases onto the server. We are trying to run GP 2013 Utilities to setup the test companies. When we try to login with sa (a different password from from prod) we get "This login Failed. Attempt to login again or contact your system admin. Any thoughts of what we're missing?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Did you run the Capture Logins script on your production SQL instance to bring over user ID's? Read KB 878449 to get that script. You will also need to log into GP on the test server as 'sa' and then reset people's password. Passwords will not carry over to the new insance.

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report
Copy link

Link copied!

SQL 2012 installation doesn't enable Mixed Mode authentication by default. The installer has to make the selection. Perhaps this is your problem. Here's a link to an article on how to perform this step after installation.

sudeeptaganguly.wordpress.com/.../how-to-enable-sa-account-in-sql-server

Was this reply helpful? Yes No
Thomas Newcomb 1,810 on at

Like (0)

Report
Copy link

Link copied!

Hi Anettaj!

As Harry mentioned I would verify that Mixed Mode was enabled. I have ran across this multiple times where I have to install a new instance of SQL and Dynamics GP for testing purposes. The link that he had provided explains how to correct this issue if it is the issue.

If this does not resolve the issue please let us know!

~Thomas Newcomb

------------------------

Dynamics GP Support

------------------------

This posting is provided "AS IS" with no warranties, and confers no rights

Was this reply helpful? Yes No