GE Manager always asks for SQL Authentication

Article:TECH158669  |  Created: 2011-04-22  |  Updated: 2011-08-22  |  Article URL http://www.symantec.com/docs/TECH158669
Article Type
Technical Solution


Issue



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


Environment



Any environment.


Cause



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.


Solution



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 http://www.symantec.com/docs/TECH158669


Terms of use for this information are found in Legal Notices