Environment
Group Policy Administrator 5.x
Group Policy Administrator 6.x
Group Policy Administrator 6.x
Situation
Clicking the repository server node causes the Connect to SQL Server dialog window to appear.
Admin accounts have been added via the Add Repository User wizard and they have corresponding accounts listed in SQL Enterprise Manager under Microsoft SQL Servers | SQL Server Group | (local) (Windows NT) | Security | Logins.
Error: Cannot generate SSPI context
Admin accounts have been added via the Add Repository User wizard and they have corresponding accounts listed in SQL Enterprise Manager under Microsoft SQL Servers | SQL Server Group | (local) (Windows NT) | Security | Logins.
Error: Cannot generate SSPI context
Resolution
To resolve this issue, run cliconfg on the console workstation experiencing this error and move Named Pipes from the bottom of the Enabled protocols by order list to the top. Close and reopen the NetIQ Group Policy Administrator console before attempting to reconnect.
Cause
Named pipes are not the first protocol for SQL connections.