Remote database

In the SSRS 2000 readme file, under the heading "1.6
Requirements for hosting the report server database on a
remote SQL Server instance", it says that;
"If the remote SQL SErver instance runs as a domain user,
you must specify that same domain user account for the
report server connection"
Why is that? And what would happen if I choose to use
another Windows domain account with sufficient previliges
on the SQL Server isntance? I thought all that matters is
the permissions granted, and this requirement seems pretty
odd.
JoeI seem to remember some issues with setting the Kerberos SPN for SQL Server
when it's running as a domain account. That would result in an error when
creating subscriptions to reports. I don't remember whether that is still an
issue on current bits, I guess the simplest way to find out would be to try
it.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:532401c4740f$f80cdae0$a401280a@.phx.gbl...
> In the SSRS 2000 readme file, under the heading "1.6
> Requirements for hosting the report server database on a
> remote SQL Server instance", it says that;
> "If the remote SQL SErver instance runs as a domain user,
> you must specify that same domain user account for the
> report server connection"
> Why is that? And what would happen if I choose to use
> another Windows domain account with sufficient previliges
> on the SQL Server isntance? I thought all that matters is
> the permissions granted, and this requirement seems pretty
> odd.
> Joe|||Hi Tudor;
I have a smilar question.
When I install SSRS2000 with a remote SQL instance, I'd expect that all the
databases would go there. But the install insists that the sample database
AdventureWorks2000 be installed on the local SQL instance. This is annoying
because I don't plan to have any SQL instances on the RS server (I know I
still have to pay for the SQL licensing on that server, which is fine).
Why can't I choose to put the sample database on the remote SQL instance as
well?
Linchi
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
news:%234kWhtDdEHA.3420@.TK2MSFTNGP12.phx.gbl...
> I seem to remember some issues with setting the Kerberos SPN for SQL
Server
> when it's running as a domain account. That would result in an error when
> creating subscriptions to reports. I don't remember whether that is still
an
> issue on current bits, I guess the simplest way to find out would be to
try
> it.
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> news:532401c4740f$f80cdae0$a401280a@.phx.gbl...
> > In the SSRS 2000 readme file, under the heading "1.6
> > Requirements for hosting the report server database on a
> > remote SQL Server instance", it says that;
> >
> > "If the remote SQL SErver instance runs as a domain user,
> > you must specify that same domain user account for the
> > report server connection"
> >
> > Why is that? And what would happen if I choose to use
> > another Windows domain account with sufficient previliges
> > on the SQL Server isntance? I thought all that matters is
> > the permissions granted, and this requirement seems pretty
> > odd.
> >
> > Joe
>|||Yes, that is a limitation of the RS setup. The sample databases are attached
to SQL Server and that only works if the files on the same machine as SQL. A
workaround is to run setup for the sample DB on the box with SQL Server and
the rest of it on your RS box.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:OSpZIaMdEHA.3616@.TK2MSFTNGP10.phx.gbl...
> Hi Tudor;
> I have a smilar question.
> When I install SSRS2000 with a remote SQL instance, I'd expect that all
the
> databases would go there. But the install insists that the sample database
> AdventureWorks2000 be installed on the local SQL instance. This is
annoying
> because I don't plan to have any SQL instances on the RS server (I know I
> still have to pay for the SQL licensing on that server, which is fine).
> Why can't I choose to put the sample database on the remote SQL instance
as
> well?
> Linchi
> "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> news:%234kWhtDdEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > I seem to remember some issues with setting the Kerberos SPN for SQL
> Server
> > when it's running as a domain account. That would result in an error
when
> > creating subscriptions to reports. I don't remember whether that is
still
> an
> > issue on current bits, I guess the simplest way to find out would be to
> try
> > it.
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> > news:532401c4740f$f80cdae0$a401280a@.phx.gbl...
> > > In the SSRS 2000 readme file, under the heading "1.6
> > > Requirements for hosting the report server database on a
> > > remote SQL Server instance", it says that;
> > >
> > > "If the remote SQL SErver instance runs as a domain user,
> > > you must specify that same domain user account for the
> > > report server connection"
> > >
> > > Why is that? And what would happen if I choose to use
> > > another Windows domain account with sufficient previliges
> > > on the SQL Server isntance? I thought all that matters is
> > > the permissions granted, and this requirement seems pretty
> > > odd.
> > >
> > > Joe
> >
> >
>|||The AdventureWorks2000 database is attached ? Hmmm... I see all these csv
files in the ..\Samples\database folder, and that seems to indicate that the
database is created first, and then the data is loaded. This can be done on
a remote SQL instance as easily as it is done on a local instance. Am I
missing something?
Linchi
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
news:OOtbwgMdEHA.1384@.TK2MSFTNGP10.phx.gbl...
> Yes, that is a limitation of the RS setup. The sample databases are
attached
> to SQL Server and that only works if the files on the same machine as SQL.
A
> workaround is to run setup for the sample DB on the box with SQL Server
and
> the rest of it on your RS box.
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:OSpZIaMdEHA.3616@.TK2MSFTNGP10.phx.gbl...
> > Hi Tudor;
> >
> > I have a smilar question.
> >
> > When I install SSRS2000 with a remote SQL instance, I'd expect that all
> the
> > databases would go there. But the install insists that the sample
database
> > AdventureWorks2000 be installed on the local SQL instance. This is
> annoying
> > because I don't plan to have any SQL instances on the RS server (I know
I
> > still have to pay for the SQL licensing on that server, which is fine).
> >
> > Why can't I choose to put the sample database on the remote SQL instance
> as
> > well?
> >
> > Linchi
> >
> > "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> > news:%234kWhtDdEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > > I seem to remember some issues with setting the Kerberos SPN for SQL
> > Server
> > > when it's running as a domain account. That would result in an error
> when
> > > creating subscriptions to reports. I don't remember whether that is
> still
> > an
> > > issue on current bits, I guess the simplest way to find out would be
to
> > try
> > > it.
> > >
> > > --
> > > Tudor Trufinescu
> > > Dev Lead
> > > Sql Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> > > news:532401c4740f$f80cdae0$a401280a@.phx.gbl...
> > > > In the SSRS 2000 readme file, under the heading "1.6
> > > > Requirements for hosting the report server database on a
> > > > remote SQL Server instance", it says that;
> > > >
> > > > "If the remote SQL SErver instance runs as a domain user,
> > > > you must specify that same domain user account for the
> > > > report server connection"
> > > >
> > > > Why is that? And what would happen if I choose to use
> > > > another Windows domain account with sufficient previliges
> > > > on the SQL Server isntance? I thought all that matters is
> > > > the permissions granted, and this requirement seems pretty
> > > > odd.
> > > >
> > > > Joe
> > >
> > >
> >
> >
>