Showing posts with label win2003. Show all posts
Showing posts with label win2003. Show all posts

Friday, March 9, 2012

RS on Win2003 cannot connect to Analysis Service

I have RS installed on Win 2003 (not domain controller) and SQL server/AS on
a Win 2000 machine. I have no problem openning the report locally through IE
on the RS machine (Win 2003). However, I could not open the same report from
client machines (XP professional, Win 2000). The error message says "An error
has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'DataSourceName'.
(rsErrorOpeningConnection) Get Online Help
Database 'DatabaseName' does not exist. ".
If I pulish the same report to RS on a Win 2000 machines, I don't have any
problem to open the report from any of client machines. I guess it might
related to credentials not being passed correctly. What kind of configurate I
need on a Win 2003 machine.
Thanks.It is a security issue. IIS user on Win 2003 needs to be a member of OLAP
admins.
Regards,
Cem Demircioglu
"BBH" <BBH@.discussions.microsoft.com> wrote in message
news:13B92E7D-C230-4C94-94C2-65C9411FA1F0@.microsoft.com...
>I have RS installed on Win 2003 (not domain controller) and SQL server/AS
>on
> a Win 2000 machine. I have no problem openning the report locally through
> IE
> on the RS machine (Win 2003). However, I could not open the same report
> from
> client machines (XP professional, Win 2000). The error message says "An
> error
> has occurred during report processing. (rsProcessingAborted) Get Online
> Help
> Cannot create a connection to data source 'DataSourceName'.
> (rsErrorOpeningConnection) Get Online Help
> Database 'DatabaseName' does not exist. ".
> If I pulish the same report to RS on a Win 2000 machines, I don't have any
> problem to open the report from any of client machines. I guess it might
> related to credentials not being passed correctly. What kind of
> configurate I
> need on a Win 2003 machine.
> Thanks.
>|||Thanks fro your reply. Are you referring to the service account which starts
the IIS?
"Cem Demircioglu" wrote:
> It is a security issue. IIS user on Win 2003 needs to be a member of OLAP
> admins.
> Regards,
> Cem Demircioglu
>
> "BBH" <BBH@.discussions.microsoft.com> wrote in message
> news:13B92E7D-C230-4C94-94C2-65C9411FA1F0@.microsoft.com...
> >I have RS installed on Win 2003 (not domain controller) and SQL server/AS
> >on
> > a Win 2000 machine. I have no problem openning the report locally through
> > IE
> > on the RS machine (Win 2003). However, I could not open the same report
> > from
> > client machines (XP professional, Win 2000). The error message says "An
> > error
> > has occurred during report processing. (rsProcessingAborted) Get Online
> > Help
> > Cannot create a connection to data source 'DataSourceName'.
> > (rsErrorOpeningConnection) Get Online Help
> > Database 'DatabaseName' does not exist. ".
> >
> > If I pulish the same report to RS on a Win 2000 machines, I don't have any
> > problem to open the report from any of client machines. I guess it might
> > related to credentials not being passed correctly. What kind of
> > configurate I
> > need on a Win 2003 machine.
> >
> > Thanks.
> >
>
>|||I can't remember the account name but it is either IIS (IUSR*) or Report
Server account (NT Authority\Network Service). You can test it by granting
read access to everyone.
Analysis Manager > XYZ Cube > Database Roles > New ... > Membership:
Everyone
Use Windows NT integrated security on the server while creating the data
source.
Hope this helps.
Regards,
Cem Demircioglu
"BBH" <BBH@.discussions.microsoft.com> wrote in message
news:BB12FAB7-F3CE-42D8-8CD4-F3F707A0A0FF@.microsoft.com...
> Thanks fro your reply. Are you referring to the service account which
> starts
> the IIS?
> "Cem Demircioglu" wrote:
>> It is a security issue. IIS user on Win 2003 needs to be a member of OLAP
>> admins.
>> Regards,
>> Cem Demircioglu
>>
>> "BBH" <BBH@.discussions.microsoft.com> wrote in message
>> news:13B92E7D-C230-4C94-94C2-65C9411FA1F0@.microsoft.com...
>> >I have RS installed on Win 2003 (not domain controller) and SQL
>> >server/AS
>> >on
>> > a Win 2000 machine. I have no problem openning the report locally
>> > through
>> > IE
>> > on the RS machine (Win 2003). However, I could not open the same report
>> > from
>> > client machines (XP professional, Win 2000). The error message says "An
>> > error
>> > has occurred during report processing. (rsProcessingAborted) Get Online
>> > Help
>> > Cannot create a connection to data source 'DataSourceName'.
>> > (rsErrorOpeningConnection) Get Online Help
>> > Database 'DatabaseName' does not exist. ".
>> >
>> > If I pulish the same report to RS on a Win 2000 machines, I don't have
>> > any
>> > problem to open the report from any of client machines. I guess it
>> > might
>> > related to credentials not being passed correctly. What kind of
>> > configurate I
>> > need on a Win 2003 machine.
>> >
>> > Thanks.
>> >
>>

Wednesday, March 7, 2012

RS Install fails on Win2003

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.