Connect to remote RS in SSMS

Connect to remote RS in SSMS

• poppy33611

  Yes, it's local admin on both server and client machine.
  

• Calumm

  Another thing to try is to change the Authentication Type to Digest in Management Studio when logging in from the remote machine.  Type in your windows credentials and see if you get the same error.

  -Lukasz

  ---
  This posting is provided "AS IS" with no warranties, and confers no rights.
  

  
  
  

• LuisLopezCarrete

  No, fine with me to use url.
  

• Amjith

  I found followings in the log file, any hint By the way, got same error when try to connect with basic authentication. Thanks.

  2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 2 2148074254

  2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 1 0

  2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 301 0 0

  2005-12-30 14:15:55 172.20.193.76 GET /reportsdr/home.aspx - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 302 0 0

  
  

• jmweekes

  Glad to see it worked for you.
  
  Can you provide the IIS logs for when you try to connect using just server\instance in the SSMS connection dialog.  I'm curious to know why you can't connect to RS with management studio.
  
  Thanks,
  -Lukasz
  
  ---
  This posting is provided "AS IS" with no warranties, and confers no rights.
  
  
  
  

• phoenix.8848.cn

  Yes, I can access the report server in a web browser from same remote computer where I tried to connect RS in SSMS. Replacing server name with RS url doesn't work either, got same 401 error.
  

• Mahvish

  Very strange.. Since it is a 401 error, maybe you could look in the %windir%\system32\LogFiles\W3SVC1 for the latest log file to see what request is being denied.
  
  

• Adam Cogan

  Worked with report server url, thanks for the help.
  

• Anilesh

  Looks like you're passing the Report Manager virutal directory. You need to pass the report server virtual directory. 

  By default these are:

  Report Manager: http://localhost/reports

  Report Server: http://localhost/reportserver

  -Lukasz

  ---
  This posting is provided "AS IS" with no warranties, and confers no rights.
  

  
  
  

• Philipp S Khlupin

  Odd - You're logged in on as the same user on both computers   Are both computers in the same domain

  Can you access the report server in a web browser from the remote computer

  If you can, try this:

  in the SSMS connection dialog.  Replace machine\instance in the server textbox with the URL to your report server, e.g. http://yourserver/reportserver.

  Does that work

  -Lukasz

  ---
  This posting is provided "AS IS" with no warranties, and confers no rights.
  

  
  
  

• Agnes Pedoche

  Did you ever find out why you couldn't just us the servername in SSMS I am having this same problem.

  Thanks,

  Bryan

  
  

• SelimD

  Is the user in the Administrators group on the box
  
  
• Connect to remote RS in SSMS