cancel
Showing results for 
Search instead for 
Did you mean: 

SSO with AD to DB

Former Member
0 Kudos

Hi Tim,

I have question regarding SSO to database (MSSQL).

I read most of posts here but no solution found. I configure SSO to infoview from your white paper and this works with no problem.

To enable SSO to database:

- in CMC => "Cache security context (required for SSO to database)" in enabled

- in krb5.ini => "forwardable = true" in entered

- we created SPN => MSSQLSvc/MSCompName.domain.com:1434 BOXISSO (boxisso is "kerberos user")

- in desiger => "use SSO when refreshing reports at view time"

In infoview I gen an error "Login failed to for user NT AUTHORITY/ANONYMOUS LOGON..."

On database are users authenticated with user boxisso or with their ad names? (what are privileges on mssql side needed?)

Thank you for reply!

Regards,

Gregor

Accepted Solutions (0)

Answers (1)

Answers (1)

BasicTek
Active Contributor
0 Kudos

Is the SIA running under a delegated service account (delegation to any service enabled)? Is the SQL DB integrated with AD? and enabled for kerberos? You should verify the latter with Microsoft.

Also try enabling this on the servers (reporting and SQL) http://support.microsoft.com/kb/262177

Regards,

Tim

Former Member
0 Kudos

Problem solved!

SPN for MSSQL server was wrong.

Regards,

Gregor