Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can't connect to SSRS instance from SSMS Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2014 6:32 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 7:39 AM
Points: 62, Visits: 247
When trying to connect to my SSRS instance from my SSMS on my desktop machine using the servername\instance name format, i get the following error...

The username or password is not valid or you do not have permission to access this server. (Microsoft.SqlServer.Management.UI.RSClient)

I'm using windows authentication. i can view the ssrs web site and see and run the reports (and browse and modify site and folder settings because im in the group in the system administrator role).

I've restarted the ssrs service and rebooted my client. i can connect to other ssrs instances on other ssrs servers from my client.

why can't i connect? any help will be appreciated

thanks

Post #1597256
Posted Wednesday, October 8, 2014 7:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 1,197, Visits: 1,240
Does your login not have permissions? Is SSRS running under a service account? That would be the first things I'd check.

HTH,
Rob
Post #1623841
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse