Both GP 2010 and GP2013 are installed on my local computer. That machine is also the SQL server.
I created a new user (USER1) in GP2013 and gave him access to the Fabrikam company, which was database TWO01. The system database was named DYN131.
- USER1 was granted access to Fabrikam.
- USER1 was a power user
Whenever I tried to log in as USER1, I was greeted with this:
I was definitely typing in the correct user name and password. Finally, I went directly to the SQL server and blanked out the password. The blank password didn'’t work either.
I checked the SQL Server to make sure USER1 was listed as a Login to the server and was mapped to the both the TWO1 database and the DYN131database. No problems there. I then checked the DYN131 and TWO1 databases to confirm USER1 was a member of the DYNGRP database role for both databases.No problem there either.
Since I needed to change something, I selected USER1 and mapped him to the DYNGRP of the TWO database. The TWO database is the sample company for the GP2010 installation. That’s all I did; USER1 was not listed as a user for the TWO database.
Solved. Now, USER1 could log in to the sample company created in the GP2013 installation.
Until next post!