AD USERS CAN'T CONNECT REPORTING SERVER USING MANA

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

AD USERS CAN'T CONNECT REPORTING SERVER USING MANA

Author

Topic

appwarez
Starting Member

3 Posts

Posted - 2008-08-06 : 05:48:51

Hi experts;

I have the following network configuration;

Domain (running on 2003 services are DHCP, DNS)
Member Server (win 2003, running SQL server 2005 SP2)

Authontication;

Windows Authontication

ON THE SERVER

http://localhost/reports
htpp://localhost/reportserver are working perfectly

CAN connect the Database as well as Reporting server using Managment studio

ON THE CLIENT MACHINE

http://server/reports Partially dispalying the menu c
http://server/reportserver Users are insufficient for performing this operation. (rsAccessDenied)

MANAGMENT STUDIO
The users are able to connect the Database Engine using Windows Authontication but
On the reporting service users are not able to connected (windows authontication)and the follwoing error messages;

------------------------------
TITLE: Connect to Server
------------------------------

Cannot connect to -SQLSERVER.

------------------------------
ADDITIONAL INFORMATION:

The machine could not be found (Microsoft.SqlServer.Management.UI.RSClient)

------------------------------
BUTTONS:

OK
------------------------------

Is there any one help me out please.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-06 : 23:06:25

Did you grant proper permission to users in RS?

appwarez
Starting Member

3 Posts

Posted - 2008-08-08 : 01:38:24

Hi,
Thanks a lot for the response and presume that i have setup the permission for Reporting Server user permission, though could you bit explain to me what are and where given the access to the AD users inorder to access the Reporting Server pls.

Regards,
Victims

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-09 : 00:57:30

Take look at 'Tutorial: Setting Permissions in Reporting Services' in books online.

hitesh6221
Starting Member

28 Posts

Posted - 2008-08-09 : 04:18:17

In AD you have to give SQL Reporting Server(Server Name) right to that user with administrator it will come by default

Regards,
Hitesh Soni

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources