Make RS the default website in RS 2005

When installing RS 2000 I did not have to do anything to have RS be the
default website for the server. For instance, I could put in http://myserver
and it would re-direct to http://myserver/Reports/Pages/Folder.aspx
I have gone into IIS Manager attempting to set the default appropriately but
I always end up with security violations and report manager does not come
up.
What are the steps I need to take to have RS 2005 to act the same way as RS
2000 as far as being the default website.
Thanks,
BruceBruce,
For the moment I am trying to keep my RS2005 RTM install as vanilla as
possible, so I haven't tried this.
Go to the RS Configuration tool.
Select the Report Manager Virtual Directory option in the left pane.
Click New.
Delete Reports from the Virtual Directory.
Click OK.
Click Apply.
I think that is likely to do what you want. As I say, I haven't tried
it.
Andrew Watt
MVP - InfoPath
On Mon, 31 Oct 2005 14:15:44 -0600, "Bruce L-C [MVP]"
<brucelc@.newsgroup.nospam> wrote:
>When installing RS 2000 I did not have to do anything to have RS be the
>default website for the server. For instance, I could put in http://myserver
>and it would re-direct to http://myserver/Reports/Pages/Folder.aspx
>I have gone into IIS Manager attempting to set the default appropriately but
>I always end up with security violations and report manager does not come
>up.
>What are the steps I need to take to have RS 2005 to act the same way as RS
>2000 as far as being the default website.
>Thanks,
>Bruce|||Nope. Nice try though. I tried this and first, you couldn't have it blank,
so I put / and then I could click OK and it failed and left it as it was.
Besides, what I want is the same way it works in 2000. If you go to just the
servername it redirects to reports. So you can either specify the full path
or just the server name. I think it will turn out to be a straight IIS
configuration issue.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:opjfm1d25ve92cef6322fc7jrbtcm0qfh2@.4ax.com...
> Bruce,
> For the moment I am trying to keep my RS2005 RTM install as vanilla as
> possible, so I haven't tried this.
> Go to the RS Configuration tool.
> Select the Report Manager Virtual Directory option in the left pane.
> Click New.
> Delete Reports from the Virtual Directory.
> Click OK.
> Click Apply.
> I think that is likely to do what you want. As I say, I haven't tried
> it.
> Andrew Watt
> MVP - InfoPath
> On Mon, 31 Oct 2005 14:15:44 -0600, "Bruce L-C [MVP]"
> <brucelc@.newsgroup.nospam> wrote:
>>When installing RS 2000 I did not have to do anything to have RS be the
>>default website for the server. For instance, I could put in
>>http://myserver
>>and it would re-direct to http://myserver/Reports/Pages/Folder.aspx
>>I have gone into IIS Manager attempting to set the default appropriately
>>but
>>I always end up with security violations and report manager does not come
>>up.
>>What are the steps I need to take to have RS 2005 to act the same way as
>>RS
>>2000 as far as being the default website.
>>Thanks,
>>Bruce
>|||If you have deleted your "default" website from IIS then you'll have to
modify the IIS meta database to make another website the "default". Works
the same way in 2000 and I was hoping they would do away with this CRAZY
requirement. As long as the web has the default IP address of the box....
Here are the steps sent to me from Microsoft Support (it's a recap of what
they had me do):
1. Backed up you IIS Metabase.
2. Downloaded the MetaEdit utility.
232068 HOW TO: Download, Install, and Remove the IIS MetaEdit 2.2 Utility
<http://support.microsoft.com/?id=232068>
3. Shutdown IIS and all its related services via â'iisreset /stopâ'.
4. Shutdown all MMC IIS related tools so nothing be accessing the metabase.
5. Verified that IIS was shutdown by browsing to a few of the sites it served.
6. Started MetaEdit. Expanded the outline control on the left side to locate
the
W3SVC entry and then located current default web site ID.
8. Changed it back to a 1.
9. Changed the AppRoot values on the right hand side for each of the VDIRS
under
the default web site.
10. Exited MetaEdit and restarted IIS.
In addition you can refer to the following article:
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
"Bruce L-C [MVP]" wrote:
> Nope. Nice try though. I tried this and first, you couldn't have it blank,
> so I put / and then I could click OK and it failed and left it as it was.
> Besides, what I want is the same way it works in 2000. If you go to just the
> servername it redirects to reports. So you can either specify the full path
> or just the server name. I think it will turn out to be a straight IIS
> configuration issue.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
> news:opjfm1d25ve92cef6322fc7jrbtcm0qfh2@.4ax.com...
> > Bruce,
> >
> > For the moment I am trying to keep my RS2005 RTM install as vanilla as
> > possible, so I haven't tried this.
> >
> > Go to the RS Configuration tool.
> >
> > Select the Report Manager Virtual Directory option in the left pane.
> >
> > Click New.
> >
> > Delete Reports from the Virtual Directory.
> >
> > Click OK.
> >
> > Click Apply.
> >
> > I think that is likely to do what you want. As I say, I haven't tried
> > it.
> >
> > Andrew Watt
> > MVP - InfoPath
> >
> > On Mon, 31 Oct 2005 14:15:44 -0600, "Bruce L-C [MVP]"
> > <brucelc@.newsgroup.nospam> wrote:
> >
> >>When installing RS 2000 I did not have to do anything to have RS be the
> >>default website for the server. For instance, I could put in
> >>http://myserver
> >>and it would re-direct to http://myserver/Reports/Pages/Folder.aspx
> >>
> >>I have gone into IIS Manager attempting to set the default appropriately
> >>but
> >>I always end up with security violations and report manager does not come
> >>up.
> >>
> >>What are the steps I need to take to have RS 2005 to act the same way as
> >>RS
> >>2000 as far as being the default website.
> >>
> >>Thanks,
> >>
> >>Bruce
> >
>
>

Make changes to a production database!

Hello faculties,
We've a production database that is being used by one of our clients
as a backend for his website. The database size is around 1GB.

Recently we added some tables to our local database which is a
replica of the production database. Now we need to apply the same
changes at the production one aslo.

I've no clue about what steps should i implement.

Please guide me!

Thanks in advance
Debian

*** Sent via Developersdex http://www.developersdex.com ***The ideal solution is that you take the scripts which you used to make
the changes in test from your source control system and simply run them
against the production database. For a large number of .sql files (or a
large number of target servers/databases), this can be automated using
osql.exe in batch files, or perhaps a script in your preferred
scripting language.

However, if you made the changes in some non-repeatable way (such as
using Enterprise Manager), then you would need another solution. One
possibility is to use a database compare tool of some sort to generate
a script for you, but you might still need to make other site-specific
changes such as updating data or creating new logins. So whatever you
do for now, it would be a good idea to plan on working with scripts in
a source control system in the future.

Simon|||Build a TSQL script to perform the upgrade and then test it out.

If you didn't save your change scripts when you did your own upgrade
then you'll have to re-create them (and remember to save the scripts
next time!). Enterprise Manager can help with this (right-click the
database, select All Tasks > Generate Script).

To script the data you can use this proc:
http://vyaskn.tripod.com/code.htm#inserts

or, if the data is particularly large you may find it easier to dump it
to a file and use BCP to perform the load.

It may help to drop or disable some constraints and indexes for the
duration of the upgrade - that's assuming the relevant tables aren't in
use at the time.

Also, you may want to check out some of the diff and synchronization
utlilities, such as:
http://www.red-gate.com/sql/summary.htm

Hope this helps.

--
David Portas
SQL Server MVP
--|||debian mojo (debian_mojo@.yahoo.com) writes:
> Hello faculties,
> We've a production database that is being used by one of our clients
> as a backend for his website. The database size is around 1GB.
> Recently we added some tables to our local database which is a
> replica of the production database. Now we need to apply the same
> changes at the production one aslo.
> I've no clue about what steps should i implement.

In addition to what Simon and David said, I just like to underscore
that whatever you do, first run your upgrade scripts in a test environment.
Don't deploy until production, until everything is working OK in test.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Make a folder available to everyone

What would be the easiest way to make all the reports in a
RS folder available to everybody who can access the Report
Server website, whether or not they have NT accounts?
JoeThere is not an easy and supported way to do this. You could turn on
anonymous access and give rights to the anonymous user, but then you
essentially have no security in your system. You could also look into
writing a custom auth dll that would provide such access, however this is
not trivial.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:7b1701c476ab$b6cb52c0$a501280a@.phx.gbl...
> What would be the easiest way to make all the reports in a
> RS folder available to everybody who can access the Report
> Server website, whether or not they have NT accounts?
> Joe|||Any guidance on msdn library on how to write one of these custom auth dll's?
"Daniel Reib [MSFT]" wrote:
> There is not an easy and supported way to do this. You could turn on
> anonymous access and give rights to the anonymous user, but then you
> essentially have no security in your system. You could also look into
> writing a custom auth dll that would provide such access, however this is
> not trivial.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> news:7b1701c476ab$b6cb52c0$a501280a@.phx.gbl...
> > What would be the easiest way to make all the reports in a
> > RS folder available to everybody who can access the Report
> > Server website, whether or not they have NT accounts?
> >
> > Joe
>
>|||Try this link.
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Parker" <BrianParker@.discussions.microsoft.com> wrote in message
news:E0A776B4-029B-4070-A5BA-F6821F264F11@.microsoft.com...
> Any guidance on msdn library on how to write one of these custom auth
dll's?
> "Daniel Reib [MSFT]" wrote:
> > There is not an easy and supported way to do this. You could turn on
> > anonymous access and give rights to the anonymous user, but then you
> > essentially have no security in your system. You could also look into
> > writing a custom auth dll that would provide such access, however this
is
> > not trivial.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> > news:7b1701c476ab$b6cb52c0$a501280a@.phx.gbl...
> > > What would be the easiest way to make all the reports in a
> > > RS folder available to everybody who can access the Report
> > > Server website, whether or not they have NT accounts?
> > >
> > > Joe
> >
> >
> >