Dumb question: How do I view a report?

I have SSRS installed, but when I try to navigate to it via IE, I'm prompted
for my username and password even though I'm using Windows integrated
security for SQL Server. What do I need to do to create/access reports?Never mind. I'd typed in http://localhost/ReportServices$SQLSERVER2005 when
I was prompted for a username and password. I should've typed in
http://localhost/Reports$SQLSERVER2005/Pages/ReportViewer.aspx ...
As I said, it's a dumb question ... hahaha.
"AlBruAn" wrote:
> I have SSRS installed, but when I try to navigate to it via IE, I'm prompted
> for my username and password even though I'm using Windows integrated
> security for SQL Server. What do I need to do to create/access reports?|||On Apr 9, 1:22 pm, AlBruAn <albr...@.hotmail.com.(donotspam)> wrote:
> I have SSRS installed, but when I try to navigate to it via IE, I'm prompted
> for my username and password even though I'm using Windows integrated
> security for SQL Server. What do I need to do to create/access reports?
If you are using a browser other than IE, this may occur. If not, then
you will want to check the Directory Security (for the Reports and
ReportServer virtual directories). You do this via: Right-click My
Computer -> Select Manage -> Navigate to Services and Applications ->
Internet Information Services -> Web Sites -> Default Web Site. Then,
right-click Reports (or ReportServer) and select Properties -> select
the Directory Security tab -> select the Edit button just below
'Anonymous access and authentication control' and check to see if you
have either 'Anonymous access' selected or 'Integrated Windows
Authentication.' If anonymous is selected, most likely SSRS will not
allow you to avoid providing authentication (if it allows navigation
to the URL at all). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

DTSRUN password and username

Hello,
I run DTSRUN command in SP on many copmuters.
No problem with local server parameter but how can i use constant of the /U and /P parameters not to write username and password every time. could this be taken from the local server itself?
Thx
InonliYou can use /E to use integrated security.|||Originally posted by nigelrivett
You can use /E to use integrated security.

thank you very much
and maybe you know this
i have active x script inside the DTS that do
cnADODB.Open "Driver={SQL Server};Server=212.179.64.215;UserName=sa;Password =Ropin1970;Database=SoftAd"
i want to change the ip to local but it not let me
any idea?|||Have you tried Server=(local)

I usually put the server in a glabal variable and use that in the script.
If you are loading from an SP then you can use dtsrun to set it to @.@.servername.

Thanks for your sa password :).|||Originally posted by nigelrivett
Have you tried Server=(local)

I usually put the server in a glabal variable and use that in the script.
If you are loading from an SP then you can use dtsrun to set it to @.@.servername.

Thanks for your sa password :).
not working with server = (local)
the problem with global variable that i use many servers (by the way they have other passwords for sa...) and cant run it with /A as have mssql97... not 2000|||In that case see
http://www.nigelrivett.net/sp_oacreateLoadDTSpackage.html

To load the package and set global variables before running.|||Originally posted by nigelrivett
In that case see
http://www.nigelrivett.net/sp_oacreateLoadDTSpackage.html

To load the package and set global variables before running.

thank you a lot this will help me also in other thing!