Hi gang,
Heres the problem: When I try to run the setup for Reporting Services it
fails near the end, stating the following:
Product: Microsoft SQL Server 2000 Reporting Services Standard Edition --
Error 29581. SQL Setup failed to execute a command for server configuration.
The error was: Database 'ReportServerDB' does not exist. Check sysdatabases.
Refer to the Server error logs and setup logs for detailed error information.
SETUP:
Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the server
Im trying to install RS to. Im unsure which service pack this server is
running; it doesnt say anything just version 5.2 build 3790
Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is the
server that I want to store the data on.
I have tried a couple of different settings to connect to the database; I
tried using the NT Authority\ Network service, the local machine acct, and
lately the administrator acct, but I still get the same error.
I would be thankful for any suggestions..
Take care,
ChristianSetup uses the user running setup to create the databases, make sure this
use is a dbo on your sql server. For some reason the database is not being
created, one thing we have seen before is if there is no default location
for DB's then setup will fail, so check to see if there is a default
directory for new databases.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"farastray" <farastray@.discussions.microsoft.com> wrote in message
news:9AA86980-D98C-48A6-A58C-4EF5458F4381@.microsoft.com...
> Hi gang,
> Heres the problem: When I try to run the setup for Reporting Services it
> fails near the end, stating the following:
> Product: Microsoft SQL Server 2000 Reporting Services Standard Edition --
> Error 29581. SQL Setup failed to execute a command for server
> configuration.
> The error was: Database 'ReportServerDB' does not exist. Check
> sysdatabases.
> Refer to the Server error logs and setup logs for detailed error
> information.
> SETUP:
> Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the server
> Im trying to install RS to. Im unsure which service pack this server is
> running; it doesnt say anything just version 5.2 build 3790
> Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is the
> server that I want to store the data on.
> I have tried a couple of different settings to connect to the database; I
> tried using the NT Authority\ Network service, the local machine acct, and
> lately the administrator acct, but I still get the same error.
> I would be thankful for any suggestions..
> Take care,
> Christian|||Ok... still no luck.
I created a new user, gave him every single right you can possibly have, and
made him database owner of all databases.
I also went in under my database server's properties (in SQL Ent Mgr) and
specified a default database directory.
I tried loging in with different users, (both sql users, local/domain users)
but it is still giving me the same error: Database 'Report Server' does not
exist.
Does anyone else know how to solve this'
"Daniel Reib (MSFT)" wrote:
> Setup uses the user running setup to create the databases, make sure this
> use is a dbo on your sql server. For some reason the database is not being
> created, one thing we have seen before is if there is no default location
> for DB's then setup will fail, so check to see if there is a default
> directory for new databases.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "farastray" <farastray@.discussions.microsoft.com> wrote in message
> news:9AA86980-D98C-48A6-A58C-4EF5458F4381@.microsoft.com...
> > Hi gang,
> >
> > Heres the problem: When I try to run the setup for Reporting Services it
> > fails near the end, stating the following:
> >
> > Product: Microsoft SQL Server 2000 Reporting Services Standard Edition --
> > Error 29581. SQL Setup failed to execute a command for server
> > configuration.
> > The error was: Database 'ReportServerDB' does not exist. Check
> > sysdatabases.
> > Refer to the Server error logs and setup logs for detailed error
> > information.
> >
> > SETUP:
> >
> > Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the server
> > Im trying to install RS to. Im unsure which service pack this server is
> > running; it doesnt say anything just version 5.2 build 3790
> >
> > Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is the
> > server that I want to store the data on.
> >
> > I have tried a couple of different settings to connect to the database; I
> > tried using the NT Authority\ Network service, the local machine acct, and
> > lately the administrator acct, but I still get the same error.
> >
> > I would be thankful for any suggestions..
> >
> > Take care,
> >
> > Christian
>
>|||You say you tried logging in as different users. Do you mean you entered
these in one of the RS setup dialogs? If so then that is not correct.
Setup uses the user that is running setup to create the databases. That is
the currently logged in windows user. If you want to use SQL Auth during
setup there are some command line parameters that you can use to make setup
use SQL Auth during setup. Look in the template.ini file for the
RSSETUPACCOUNT and RSSETUPPASSWORD parameters.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"farastray" <farastray@.discussions.microsoft.com> wrote in message
news:4560E92E-792B-4BE4-A405-88037601CE37@.microsoft.com...
> Ok... still no luck.
> I created a new user, gave him every single right you can possibly have,
> and
> made him database owner of all databases.
> I also went in under my database server's properties (in SQL Ent Mgr) and
> specified a default database directory.
> I tried loging in with different users, (both sql users, local/domain
> users)
> but it is still giving me the same error: Database 'Report Server' does
> not
> exist.
> Does anyone else know how to solve this'
> "Daniel Reib (MSFT)" wrote:
>> Setup uses the user running setup to create the databases, make sure this
>> use is a dbo on your sql server. For some reason the database is not
>> being
>> created, one thing we have seen before is if there is no default location
>> for DB's then setup will fail, so check to see if there is a default
>> directory for new databases.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "farastray" <farastray@.discussions.microsoft.com> wrote in message
>> news:9AA86980-D98C-48A6-A58C-4EF5458F4381@.microsoft.com...
>> > Hi gang,
>> >
>> > Heres the problem: When I try to run the setup for Reporting Services
>> > it
>> > fails near the end, stating the following:
>> >
>> > Product: Microsoft SQL Server 2000 Reporting Services Standard
>> > Edition --
>> > Error 29581. SQL Setup failed to execute a command for server
>> > configuration.
>> > The error was: Database 'ReportServerDB' does not exist. Check
>> > sysdatabases.
>> > Refer to the Server error logs and setup logs for detailed error
>> > information.
>> >
>> > SETUP:
>> >
>> > Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the
>> > server
>> > Im trying to install RS to. Im unsure which service pack this server is
>> > running; it doesnt say anything just version 5.2 build 3790
>> >
>> > Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is
>> > the
>> > server that I want to store the data on.
>> >
>> > I have tried a couple of different settings to connect to the database;
>> > I
>> > tried using the NT Authority\ Network service, the local machine acct,
>> > and
>> > lately the administrator acct, but I still get the same error.
>> >
>> > I would be thankful for any suggestions..
>> >
>> > Take care,
>> >
>> > Christian
>>|||What I meant by different users is that I tried both different SQL users
(when using SQL authentiaction), as well as trying different domain users..
"Daniel Reib (MSFT)" wrote:
> You say you tried logging in as different users. Do you mean you entered
> these in one of the RS setup dialogs? If so then that is not correct.
> Setup uses the user that is running setup to create the databases. That is
> the currently logged in windows user. If you want to use SQL Auth during
> setup there are some command line parameters that you can use to make setup
> use SQL Auth during setup. Look in the template.ini file for the
> RSSETUPACCOUNT and RSSETUPPASSWORD parameters.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "farastray" <farastray@.discussions.microsoft.com> wrote in message
> news:4560E92E-792B-4BE4-A405-88037601CE37@.microsoft.com...
> > Ok... still no luck.
> >
> > I created a new user, gave him every single right you can possibly have,
> > and
> > made him database owner of all databases.
> >
> > I also went in under my database server's properties (in SQL Ent Mgr) and
> > specified a default database directory.
> >
> > I tried loging in with different users, (both sql users, local/domain
> > users)
> > but it is still giving me the same error: Database 'Report Server' does
> > not
> > exist.
> >
> > Does anyone else know how to solve this'
> >
> > "Daniel Reib (MSFT)" wrote:
> >
> >> Setup uses the user running setup to create the databases, make sure this
> >> use is a dbo on your sql server. For some reason the database is not
> >> being
> >> created, one thing we have seen before is if there is no default location
> >> for DB's then setup will fail, so check to see if there is a default
> >> directory for new databases.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "farastray" <farastray@.discussions.microsoft.com> wrote in message
> >> news:9AA86980-D98C-48A6-A58C-4EF5458F4381@.microsoft.com...
> >> > Hi gang,
> >> >
> >> > Heres the problem: When I try to run the setup for Reporting Services
> >> > it
> >> > fails near the end, stating the following:
> >> >
> >> > Product: Microsoft SQL Server 2000 Reporting Services Standard
> >> > Edition --
> >> > Error 29581. SQL Setup failed to execute a command for server
> >> > configuration.
> >> > The error was: Database 'ReportServerDB' does not exist. Check
> >> > sysdatabases.
> >> > Refer to the Server error logs and setup logs for detailed error
> >> > information.
> >> >
> >> > SETUP:
> >> >
> >> > Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the
> >> > server
> >> > Im trying to install RS to. Im unsure which service pack this server is
> >> > running; it doesnt say anything just version 5.2 build 3790
> >> >
> >> > Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is
> >> > the
> >> > server that I want to store the data on.
> >> >
> >> > I have tried a couple of different settings to connect to the database;
> >> > I
> >> > tried using the NT Authority\ Network service, the local machine acct,
> >> > and
> >> > lately the administrator acct, but I still get the same error.
> >> >
> >> > I would be thankful for any suggestions..
> >> >
> >> > Take care,
> >> >
> >> > Christian
> >>
> >>
> >>
>
>|||This maybe a silly question, but how do I pass in the commandline parameters?
I tried using setup.exe -RSSETUPACCOUNT="sa" and -RSSETUPPASSWORD="password"
in the command prompt, but it wont take the parameters.. I tried using single
quotes, space instead of =, and / instead of -.. What am I doing wrong?|||farastray wrote:
> This maybe a silly question, but how do I pass in the commandline parameters?
> I tried using setup.exe -RSSETUPACCOUNT="sa" and -RSSETUPPASSWORD="password"
> in the command prompt, but it wont take the parameters.. I tried using single
> quotes, space instead of =, and / instead of -.. What am I doing wrong?
Don't use anything but the property. msiexec uses PROPERTY=value
setup.exe RSSETUPACCOUNT=sa RSSETUPPASSWORD=password
Joachim.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment