SQL MS RS - Access Denied

[SQLScholar]

hey all,

I have a user who uses SQL Reporting services 2008.

All is fine, i have given him access to the SQL server (admin) and i have granted him the SQL RS admin privs via the RS website.

However he cannot connect to SQL RS via management studio??
He gets access denied.

Any ideas?

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[bburnell]

Have you made sure they have rights to it through management studio and not just through the SSRS interface? Just a thought!
~Brett

--------------------------
Web/.net Programmer & DBA
Central PA

 

[SQLScholar]

Yeah on the Database they are admin.

The only thing i can think of is local rights to the server?

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[bburnell]

Are you trying to connect outside of the server? I can't connect to mine from my desktop, but I can when I am actually on the server (not on my account either). Try that first (with their username/pass combination). If that works, it's a connection to the server issue.

--------------------------
Web/.net Programmer & DBA
Central PA