| Author |
Topic |
|
jschraer
Starting Member
5 Posts |
 Posted - 2007-04-15 : 14:14:15
|
| New to SQL. Why does SQL Server Business Intelligence Development Studio prompt me for a user id and password whenever I try to deploy a report. I cannot get report manager to come up in IE 7. I'm using Vista Home Premium.Any help would be appreciated. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-15 : 14:18:05
|
| Does your account have proper permission in RS? What did you get in ie when connect to RS site? |
 |
|
|
jschraer
Starting Member
5 Posts |
Posted - 2007-04-15 : 14:30:20
|
Using http://localhost/reports$SQLEXPRESS I get IE7 error of 404.0Server Error in Application "Default Web Site"--------------------------------------------------------------------------------HTTP Error 404.0 - Not FoundDescription: The resource you are looking for has been removed, had its name changed, or is temporarily unavailable. Error Code: 0x80070002 Notification: MapRequestHandler Module: IIS Web Core Requested URL: http://localhost:80/reports$SQLEXPRESS Physical Path: C:\inetpub\wwwroot\reports$SQLEXPRESS Logon User: Anonymous Logon Method: Anonymous Handler: StaticFile Most likely causes: The directory or file specified does not exist on the Web server. The URL contains a typographical error. A custom filter or module, such as URLScan, restricts access to the file. What you can try: Create the content on the Web server. Review the browser URL. Create a tracing rule to track failed requests for this HTTP status code and see which module is calling SetStatus. For more information about creating a tracing rule for failed requests, click here. More Information... This error means that the file or directory does not exist on the server. Create the file or directory and try the request again. quote:
Originally posted by rmiao
Does your account have proper permission in RS? What did you get in ie when connect to RS site?
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-15 : 17:39:33
|
| Try this: go to RS web directory and browser default htm file. What do you get? |
|
|
|
jschraer
Starting Member
5 Posts |
Posted - 2007-04-15 : 18:11:10
|
Went into IIS Manager and found %systemdrive%\inetpub\wwwroot.I'm quite new to this, so excuse me if I'm not looking in the right areas. quote:
Originally posted by rmiao
Try this: go to RS web directory and browser default htm file. What do you get?
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-16 : 16:27:12
|
| Did you see reports and/or reportserver under web sites in IIS manager? |
|
|
|
jschraer
Starting Member
5 Posts |
Posted - 2007-04-16 : 21:45:26
|
Not just the wwwroot. Tried reinstalling SQL Server Express and it tells me that IIS is not running or installed?quote:
Originally posted by rmiao
Did you see reports and/or reportserver under web sites in IIS manager?
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-17 : 16:35:11
|
| Did you see World Wide Web Publishing Service in services applet? Is it running? |
|
|
|
jschraer
Starting Member
5 Posts |
Posted - 2007-04-17 : 20:30:30
|
No and no.quote:
Originally posted by rmiao
Did you see World Wide Web Publishing Service in services applet? Is it running?
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-18 : 15:34:16
|
| Should install RS on machine that has web server running. |
|
|
|
|
SQL Server 2005 Express and SQL Server Business In