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
 Transact-SQL (2005)
 Unable to connect SSRS through SSMS using windows

Author  Topic 

sanjnep
Posting Yak Master

191 Posts

Posted - 2009-04-27 : 12:37:44
I am trying to connect SSRS by SSMS with windows authentication on remote server but I am getting following error
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
I am able to connect remotely using basic authetication through SSMS. Is there any place to look why am I unable to connect with windows authentication?
Thanks
Sanjeev

svicky9
Posting Yak Master

232 Posts

Posted - 2009-04-27 : 12:43:24
Does the SQL SERver allow Windows Authenticationn? Right Click server properties--> security

http://www.sqlserver007.com
Go to Top of Page

sanjnep
Posting Yak Master

191 Posts

Posted - 2009-04-27 : 13:00:28
Yes for SQL server there is mixed mode but I am not sure how to look on SSRS.
Thanks
Go to Top of Page
   

- Advertisement -