Error during deploy

Hi,
I am publishing my reports to a server and for 2 out of 7 reports I receive
the following error message:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was
thrown.
On my machine the reports worked fine.
The server does process the other reports correctly.
The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2.
These two failing reports don't seem to have anything special compared to
the others.
Any suggestions what might be causing this? (And how to solve it?)
Thanks a lot for your help,
Edgar
--
Message posted via http://www.sqlmonster.comCheck the log files for more details.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Edgar Walther via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:ee24db616d0849f59f74c0c0f1ef3f9d@.SQLMonster.com...
> Hi,
> I am publishing my reports to a server and for 2 out of 7 reports I
> receive
> the following error message:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was
> thrown.
> On my machine the reports worked fine.
> The server does process the other reports correctly.
> The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2.
> These two failing reports don't seem to have anything special compared to
> the others.
> Any suggestions what might be causing this? (And how to solve it?)
> Thanks a lot for your help,
> Edgar
> --
> Message posted via http://www.sqlmonster.com|||Where can I find these log files?
I've looked in the windows application event log for ReportingServices
events, but there were no events (except report server started).
Thanks,
Edgar
"Jeff A. Stucker" wrote:
> Check the log files for more details.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Edgar Walther via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
> news:ee24db616d0849f59f74c0c0f1ef3f9d@.SQLMonster.com...
> > Hi,
> >
> > I am publishing my reports to a server and for 2 out of 7 reports I
> > receive
> > the following error message:
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was
> > thrown.
> >
> > On my machine the reports worked fine.
> > The server does process the other reports correctly.
> > The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2.
> >
> > These two failing reports don't seem to have anything special compared to
> > the others.
> >
> > Any suggestions what might be causing this? (And how to solve it?)
> >
> > Thanks a lot for your help,
> >
> > Edgar
> >
> > --
> > Message posted via http://www.sqlmonster.com
>
>|||In a default installation, here:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Edgar" <Edgar@.discussions.microsoft.com> wrote in message
news:32D4111D-7B88-47A3-830D-257BF001587E@.microsoft.com...
> Where can I find these log files?
> I've looked in the windows application event log for ReportingServices
> events, but there were no events (except report server started).
> Thanks,
> Edgar
>
> "Jeff A. Stucker" wrote:
>> Check the log files for more details.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Edgar Walther via SQLMonster.com" <forum@.SQLMonster.com> wrote in
>> message
>> news:ee24db616d0849f59f74c0c0f1ef3f9d@.SQLMonster.com...
>> > Hi,
>> >
>> > I am publishing my reports to a server and for 2 out of 7 reports I
>> > receive
>> > the following error message:
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException
>> > was
>> > thrown.
>> >
>> > On my machine the reports worked fine.
>> > The server does process the other reports correctly.
>> > The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2.
>> >
>> > These two failing reports don't seem to have anything special compared
>> > to
>> > the others.
>> >
>> > Any suggestions what might be causing this? (And how to solve it?)
>> >
>> > Thanks a lot for your help,
>> >
>> > Edgar
>> >
>> > --
>> > Message posted via http://www.sqlmonster.com
>>sql

Error Count not obtain information about Windows NT group/user

We receive an error as the server attempts to create a publication. The user
has permissions on both the server as an administrator and as an sa. This
conflict should not occur. Can anyone help to explain this? It has been
suggested we go to SP4. There are concerns about firmware and blue screening
on the primary server at this time may preclude sp4 as an option.
Regards,
Jamie
Is there a possibility that when an Enterprise 2005 version of SQL encounters
a Standard version 2000, that this error pops up?
Regards,
Jamie
"thejamie" wrote:

> We receive an error as the server attempts to create a publication. The user
> has permissions on both the server as an administrator and as an sa. This
> conflict should not occur. Can anyone help to explain this? It has been
> suggested we go to SP4. There are concerns about firmware and blue screening
> on the primary server at this time may preclude sp4 as an option.
> --
> Regards,
> Jamie

Error Adding User

Hello, I have a problem with adding users to a database using sp_adduser.
The user I'm using is a member of db_owner but I receive the following error:
sp_adduser adam, adam, DEFAULT_USERS
Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
User does not have permission to perform this action
It only works when I log in as a System Administrator. However if I login as
the db_owner account which generates the above error and run the following:
exec sp_grantdbaccess adam
exec sp_addrolemember DEFAULT_USERS, adam
It works fine. The problem is that it is a piece of 3rd party software that
is trying to add the users and won't be easy to get them to change it as
sp_adduser should work. Also I don't want them logging in as System
Administrator when I could try and fix it. Any ideas?
One solution is to drop the user from the database, and then make its login
the owner of the database:
sp_dropuser 'the_user'
go
use the_database
go
sp_changedbowner 'the_login'
go
Linchi
"Adam Sankey" wrote:

> Hello, I have a problem with adding users to a database using sp_adduser.
> The user I'm using is a member of db_owner but I receive the following error:
> sp_adduser adam, adam, DEFAULT_USERS
> Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
> User does not have permission to perform this action
> It only works when I log in as a System Administrator. However if I login as
> the db_owner account which generates the above error and run the following:
> exec sp_grantdbaccess adam
> exec sp_addrolemember DEFAULT_USERS, adam
> It works fine. The problem is that it is a piece of 3rd party software that
> is trying to add the users and won't be easy to get them to change it as
> sp_adduser should work. Also I don't want them logging in as System
> Administrator when I could try and fix it. Any ideas?
>
|||Thanks very much that worked fine - I still don't understand why I had this
problem in the first place. Do you have an insight in to this?
Thanks again
Adam
"Linchi Shea" wrote:
[vbcol=seagreen]
> One solution is to drop the user from the database, and then make its login
> the owner of the database:
> sp_dropuser 'the_user'
> go
> use the_database
> go
> sp_changedbowner 'the_login'
> go
> Linchi
> "Adam Sankey" wrote:

Error Adding User

Hello, I have a problem with adding users to a database using sp_adduser.
The user I'm using is a member of db_owner but I receive the following error:
sp_adduser adam, adam, DEFAULT_USERS
Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
User does not have permission to perform this action
It only works when I log in as a System Administrator. However if I login as
the db_owner account which generates the above error and run the following:
exec sp_grantdbaccess adam
exec sp_addrolemember DEFAULT_USERS, adam
It works fine. The problem is that it is a piece of 3rd party software that
is trying to add the users and won't be easy to get them to change it as
sp_adduser should work. Also I don't want them logging in as System
Administrator when I could try and fix it. Any ideas?One solution is to drop the user from the database, and then make its login
the owner of the database:
sp_dropuser 'the_user'
go
use the_database
go
sp_changedbowner 'the_login'
go
Linchi
"Adam Sankey" wrote:
> Hello, I have a problem with adding users to a database using sp_adduser.
> The user I'm using is a member of db_owner but I receive the following error:
> sp_adduser adam, adam, DEFAULT_USERS
> Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
> User does not have permission to perform this action
> It only works when I log in as a System Administrator. However if I login as
> the db_owner account which generates the above error and run the following:
> exec sp_grantdbaccess adam
> exec sp_addrolemember DEFAULT_USERS, adam
> It works fine. The problem is that it is a piece of 3rd party software that
> is trying to add the users and won't be easy to get them to change it as
> sp_adduser should work. Also I don't want them logging in as System
> Administrator when I could try and fix it. Any ideas?
>|||Thanks very much that worked fine - I still don't understand why I had this
problem in the first place. Do you have an insight in to this?
Thanks again
Adam
"Linchi Shea" wrote:
> One solution is to drop the user from the database, and then make its login
> the owner of the database:
> sp_dropuser 'the_user'
> go
> use the_database
> go
> sp_changedbowner 'the_login'
> go
> Linchi
> "Adam Sankey" wrote:
> > Hello, I have a problem with adding users to a database using sp_adduser.
> > The user I'm using is a member of db_owner but I receive the following error:
> >
> > sp_adduser adam, adam, DEFAULT_USERS
> >
> > Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
> > User does not have permission to perform this action
> >
> > It only works when I log in as a System Administrator. However if I login as
> > the db_owner account which generates the above error and run the following:
> >
> > exec sp_grantdbaccess adam
> > exec sp_addrolemember DEFAULT_USERS, adam
> >
> > It works fine. The problem is that it is a piece of 3rd party software that
> > is trying to add the users and won't be easy to get them to change it as
> > sp_adduser should work. Also I don't want them logging in as System
> > Administrator when I could try and fix it. Any ideas?
> >

Error Adding User

Hello, I have a problem with adding users to a database using sp_adduser.
The user I'm using is a member of db_owner but I receive the following error
:
sp_adduser adam, adam, DEFAULT_USERS
Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
User does not have permission to perform this action
It only works when I log in as a System Administrator. However if I login as
the db_owner account which generates the above error and run the following:
exec sp_grantdbaccess adam
exec sp_addrolemember DEFAULT_USERS, adam
It works fine. The problem is that it is a piece of 3rd party software that
is trying to add the users and won't be easy to get them to change it as
sp_adduser should work. Also I don't want them logging in as System
Administrator when I could try and fix it. Any ideas?One solution is to drop the user from the database, and then make its login
the owner of the database:
sp_dropuser 'the_user'
go
use the_database
go
sp_changedbowner 'the_login'
go
Linchi
"Adam Sankey" wrote:

> Hello, I have a problem with adding users to a database using sp_adduser.
> The user I'm using is a member of db_owner but I receive the following err
or:
> sp_adduser adam, adam, DEFAULT_USERS
> Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
> User does not have permission to perform this action
> It only works when I log in as a System Administrator. However if I login
as
> the db_owner account which generates the above error and run the following
:
> exec sp_grantdbaccess adam
> exec sp_addrolemember DEFAULT_USERS, adam
> It works fine. The problem is that it is a piece of 3rd party software tha
t
> is trying to add the users and won't be easy to get them to change it as
> sp_adduser should work. Also I don't want them logging in as System
> Administrator when I could try and fix it. Any ideas?
>|||Thanks very much that worked fine - I still don't understand why I had this
problem in the first place. Do you have an insight in to this?
Thanks again
Adam
"Linchi Shea" wrote:
[vbcol=seagreen]
> One solution is to drop the user from the database, and then make its logi
n
> the owner of the database:
> sp_dropuser 'the_user'
> go
> use the_database
> go
> sp_changedbowner 'the_login'
> go
> Linchi
> "Adam Sankey" wrote:
>