GE Manager always asks for SQL Authentication

Article:TECH158669  |  Created: 2011-04-22  |  Updated: 2011-08-22  |  Article URL
Article Type
Technical Solution


When you try to open any reports in GE  manager, it always asks for SQL  authentication.


Any environment.


GE  Manager always uses 'Windows Authentication' as the default method to connect to GEMS database. If the logged-on windows user doesn't have enough privileges on the database, initial authentication fails. This causes GE-Manager to prompt for alternate authentication details.


Add the current windows user to SQL Logins and configure him with sys_admin privileges. Here is how you can do it -

  1. In SQL  Management Studio,  connect to the database server containing GEMS database.
  2. In the Object Explorer pane, expand the <server> -> Security
  3. Right click on 'Logins' under security
  4. Select 'New Login'
  5. Enter the Windows username by manually typing, or using the Search button to select the right user.
  6. Go to Server Roles, click on 'sysadmin'
  7. Click on 'OK'
  8. Close GE  Manager if its already open, and Try launching the GE  Manager again.

Article URL

Terms of use for this information are found in Legal Notices