New Installation

Windows 2003 Advanced Server
SQL Server 2K sp3a
There was an existing reporting services database on the SQL Server
Instance. Tried to perform an new install of Reporting Services and point to
this existing database, ReportServer DB. Installation was successful.
However, RS would not activate becuase it thought I was adding to a WEB Farm.
To acivate I needed to run rsactivate from the active RS Server, there was
none. Decided to remove the databases and RS and start clean. Now, everytime
I try to install RS its trying to point to a database that does not exist and
the installation fails. Can anyone help?
ThanksWhat do you mean it tries to point to a DB that doesn't exist? During setup
you can specify a DB that does not exist, it should then create that DB.
What error are you getting?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
> Windows 2003 Advanced Server
> SQL Server 2K sp3a
> There was an existing reporting services database on the SQL Server
> Instance. Tried to perform an new install of Reporting Services and point
> to
> this existing database, ReportServer DB. Installation was successful.
> However, RS would not activate becuase it thought I was adding to a WEB
> Farm.
> To acivate I needed to run rsactivate from the active RS Server, there was
> none. Decided to remove the databases and RS and start clean. Now,
> everytime
> I try to install RS its trying to point to a database that does not exist
> and
> the installation fails. Can anyone help?
> Thanks|||I know its suppose to create the database if it does not exist. The error is
"Database ReportServer does not exist".
"Daniel Reib [MSFT]" wrote:
> What do you mean it tries to point to a DB that doesn't exist? During setup
> you can specify a DB that does not exist, it should then create that DB.
> What error are you getting?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
> > Windows 2003 Advanced Server
> > SQL Server 2K sp3a
> >
> > There was an existing reporting services database on the SQL Server
> > Instance. Tried to perform an new install of Reporting Services and point
> > to
> > this existing database, ReportServer DB. Installation was successful.
> > However, RS would not activate becuase it thought I was adding to a WEB
> > Farm.
> > To acivate I needed to run rsactivate from the active RS Server, there was
> > none. Decided to remove the databases and RS and start clean. Now,
> > everytime
> > I try to install RS its trying to point to a database that does not exist
> > and
> > the installation fails. Can anyone help?
> >
> > Thanks
>
>|||At what point in setup do you get this? Have you tried changing the DB
name?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:A8598F84-FDBF-49E5-BB2B-24CFA774A7C7@.microsoft.com...
>I know its suppose to create the database if it does not exist. The error
>is
> "Database ReportServer does not exist".
> "Daniel Reib [MSFT]" wrote:
>> What do you mean it tries to point to a DB that doesn't exist? During
>> setup
>> you can specify a DB that does not exist, it should then create that DB.
>> What error are you getting?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "FredG" <FredG@.discussions.microsoft.com> wrote in message
>> news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
>> > Windows 2003 Advanced Server
>> > SQL Server 2K sp3a
>> >
>> > There was an existing reporting services database on the SQL Server
>> > Instance. Tried to perform an new install of Reporting Services and
>> > point
>> > to
>> > this existing database, ReportServer DB. Installation was successful.
>> > However, RS would not activate becuase it thought I was adding to a WEB
>> > Farm.
>> > To acivate I needed to run rsactivate from the active RS Server, there
>> > was
>> > none. Decided to remove the databases and RS and start clean. Now,
>> > everytime
>> > I try to install RS its trying to point to a database that does not
>> > exist
>> > and
>> > the installation fails. Can anyone help?
>> >
>> > Thanks
>>|||Hello Daniel,
After I have completed all the setup questions then selected next. The
installation was running fine then it bombed out with that message. I was
able to track down the log file located in the C:\Progam Files\Microsoft SQL
Server\80\RS Setup Bootstrap\Log directory. I noticed that the account RS
setup was trying to use to create the database was DOMAIN\SERVER_NAME$, (I
believe this occured becuase I was running the Windows service under NT
AUTHORITY\NETWORK SERVICE). Once I added this account to SQL server and
granted CREATE DATABASE it worked fine. I have done other installs of RS and
never ran into this problem.
Thanks
"Daniel Reib [MSFT]" wrote:
> At what point in setup do you get this? Have you tried changing the DB
> name?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:A8598F84-FDBF-49E5-BB2B-24CFA774A7C7@.microsoft.com...
> >I know its suppose to create the database if it does not exist. The error
> >is
> > "Database ReportServer does not exist".
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> What do you mean it tries to point to a DB that doesn't exist? During
> >> setup
> >> you can specify a DB that does not exist, it should then create that DB.
> >> What error are you getting?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> >> news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
> >> > Windows 2003 Advanced Server
> >> > SQL Server 2K sp3a
> >> >
> >> > There was an existing reporting services database on the SQL Server
> >> > Instance. Tried to perform an new install of Reporting Services and
> >> > point
> >> > to
> >> > this existing database, ReportServer DB. Installation was successful.
> >> > However, RS would not activate becuase it thought I was adding to a WEB
> >> > Farm.
> >> > To acivate I needed to run rsactivate from the active RS Server, there
> >> > was
> >> > none. Decided to remove the databases and RS and start clean. Now,
> >> > everytime
> >> > I try to install RS its trying to point to a database that does not
> >> > exist
> >> > and
> >> > the installation fails. Can anyone help?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>