|
|
You're in the
sql server reporting services
group:New Installation
sql server reporting services:
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?
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. [quoted text, click to view] "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". [quoted text, click to view] "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. [quoted text, click to view] "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 [quoted text, click to view] "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 > >> > >> > >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |