Not able connect to Reportserver and reports URL

Question

Not able connect to Reportserver and reports URL

rambilla4

SSCrazy Eights

Points: 8715
More actions
July 20, 2009 at 5:08 pm

#223714

Hi,
I have sql server reporting services 2005 configured long back From Report server configuration wizard, the Reportserver database is created with
Credential type: sql server credentials
User Account: sa
Password: xxxxxxx
Now I had browse the url http:/servername/reports and http:/servername/reportserver and its asking as below:
SQL Server Reporting services Logon
Usename
Password
Here I enterd the user name sa and with its password. But I'm getting Invalid username or password. But with the same sa and itds password I'm able to connect database engine.
and How can I connect to Reporting serverices from management studi using sa account?
Please help me
Thank You
Ram

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sarran.achari SSCrazy Points: 2226 More actions · Answer 1

Repoting Services Web logon credentials are differenct from DB engine credentials. You need to provide any user configured for Reporting SErvices. Also, check in brower-> tools->Internet options-> connections tab and chec kwehther localhost is included in the list of urls for "By pas poxy server".

Go to IISAdmin and ight click on the RepotSErver virtual directory and check the permissions on which user account it is configured

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 2

Thanks,

I check the following:

In IIS Manager:

ReportServer->RightClick->Permissions -> here the following accouts are there

Administrators,Creator Owner, SQLServer2005ReportingServicesWebServiceUser$Servername$MSSQLSERVER (Servername\SQLServer2005ReportingServicesWebServiceUser$Servername$MSSQLSERVER ), SQLServer2005ReportingServerUser$Servername$MSSQLSERVER (Servername\SQLServer2005ReportingServerUser$Servername$MSSQLSERVER), System, Users (Servername\Users)

So out of the above what should I use for the Username and password below:

Now I had browse the url http:/servername/reports and http:/servername/reportserver and its asking as below:

SQL Server Reporting services Logon

Usename

Password

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 3

rambilla4

SSCrazy Eights

Points: 8715

July 22, 2009 at 4:32 pm

#1028708

Could you please give me some info on this??

sarran.achari SSCrazy Points: 2226 More actions · Answer 4

You can give either of the accounts. Give administrator(machinename/administrator) and password. Try to bowse from InetMgr.

Also,ceate dummy website or virtual dir under iss and put a sample html page and try accessing it in the url. If still suername password is asked, then some prob with IIS/poxy config

RSage Mr or Mrs. 500 Points: 522 More actions · Answer 5

What OS are we operating on here? Is it an actual server or a workstation? If it's Win XP you might try to disable simple file sharing. View this Support article and see if it helps. It did me. I ran into the same issue.

http://support.microsoft.com/kb/307874