USER CAN'T CONNECT THE REPORTING SERVER (AD USERNAME) using SQL SERVER MANAGMENT STUDIO 2005

Normal
  0
  
  
  
  
  false
  false
  false
  
  EN-US
  X-NONE
  X-NONE
  
   
   
   
   
   
   
   
   
   
   
   
  
  
   
   
   
   
   
   
   
   
   
   
   
  
 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 


 /* Style Definitions */
 table.MsoNormalTable
        {mso-style-name:"Table Normal";
        mso-tstyle-rowband-size:0;
        mso-tstyle-colband-size:0;
        mso-style-noshow:yes;
        mso-style-priority:99;
        mso-style-qformat:yes;
        mso-style-parent:"";
        mso-padding-alt:0in 5.4pt 0in 5.4pt;
        mso-para-margin:0in;
        mso-para-margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:10.0pt;
        font-family:"Calibri","sans-serif";}



Dear Experts;
 
I have the following network configuration;
DOMAIN                                : (Win 2003, DHCP, DNS)
MEMBER SERVER              : (win 2003, SQL server 2005 SP2)

INSTANCE                                      : (mssqlserver)
AUTHONTICATION              : Windows Authentication
 
IEXPLORE
http://localhost/reports 
http://server/reports               (server and remote clients are working perfectly) 
http://localhost/reportserver
http://server/reportserver      (server and remote clients are working perfectly) 


@ MANAGMENT STUDIO

SERVER:
The database and reporting server are working perfectly
 
CLIENTS (REMOTE COMPUTER XP MACHINE)
ยท        Clients can connect the DATABASE ENGINE using Management Studio 2005 (Windows Authentication)
ยท        On the MANAGEMENT STUDIO 2005, the clients (remote machine) are not able to connected.
ยท        I have created appropriate user name created on the report manager.
 
The following error messages (windows authentication)


Cannot connect to -SQLSERVER.
------------------------------
ADDITIONAL INFORMATION:

The machine could not be found (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
SOME ONE HELP ME PLEASE !!!!!!

 
 
 
0
appwarez
8/6/2008 9:24:11 AM
๐Ÿ“ asp.net.ssrs
๐Ÿ“ƒ 4514 articles.
โญ 1 followers.

๐Ÿ’ฌ 2 Replies
๐Ÿ‘๏ธโ€๐Ÿ—จ๏ธ 1097 Views



Hi make sure the NETWORK SERVICE user has rights to your ReportManager folder inside reporting services.
 

Liam Mcmullen
0
liammcmullen
8/6/2008 10:59:44 AM

 Thanks a lot for you suggestion and user can connect the Database engine(from MANAGMENT STUIDO 2005) using their windows authontication as well as http://servername/reports and http://servername/reportserver the problem is they can cannot connect the REPORTING SERVER Using MANAGEMENT STUDIO getting the above said error.
0
appwarez
8/14/2008 5:54:29 AM
Reply: