Authorization windows - Invalid authorization specification

Hi, Experts.
Another problem with Reporting Services authentication:
We have a windows 2003 server + iis 6.0 +Reporting Setvices
whose reports access to a sql server windows 2003 (both are situated
in the same domain).
Since I must use stored credentials in order to create subscriptions
I've decided to put a user from domain windows in stored
authentication.
As the result I´ve obtain the following error:
Error al procesar el informe. (rsProcessingAborted) Obtener ayuda en
línea
No se puede crear una conexión al origen de datos Ventas.
(rsErrorOpeningConnection) Obtener ayuda en línea
Invalid authorization specification
The user I've chosen is the same that I use to design reports and to
access the sql server usually, so I don´t understand the cause of this
error.
Good. Seeing that it has not work I´ve changed the user to "sa" and
everything works fine.
The unique problem I have that according to the policy secuirty of the
company
it is forbidden to use the sa user in order to execute the reports.
Windows authentication is strongly recommended. Any idea?
Regards
Maciej KiewraHi, Experts.
The ServicePack is the real reason of my problem.
I´ve removed RS and I've installed it again (without applying service pack)
everything ok.
Then I've installed the servicepack and now "windows authentication" does not work.
I know that in the service pack 1 a new System Property has been add that
permits the windows authentication to be disabled, but this parameter is set
to true, so it is not a case.
It seems that Reporting Service is already very premature
Regards
Maciej Kiewra
mkiewra@.mail.fujitsu.es (Maciej Kiewra) wrote in message news:<bc86bf57.0504050912.36611411@.posting.google.com>...
> Hi, Experts.
>
> Another problem with Reporting Services authentication:
> We have a windows 2003 server + iis 6.0 +Reporting Setvices
> whose reports access to a sql server windows 2003 (both are situated
> in the same domain).
> Since I must use stored credentials in order to create subscriptions
> I've decided to put a user from domain windows in stored
> authentication.
> As the result I´ve obtain the following error:
> Error al procesar el informe. (rsProcessingAborted) Obtener ayuda en
> línea
> No se puede crear una conexión al origen de datos Ventas.
> (rsErrorOpeningConnection) Obtener ayuda en línea
> Invalid authorization specification
> The user I've chosen is the same that I use to design reports and to
> access the sql server usually, so I don´t understand the cause of this
> error.
> Good. Seeing that it has not work I´ve changed the user to "sa" and
> everything works fine.
> The unique problem I have that according to the policy secuirty of the
> company
> it is forbidden to use the sa user in order to execute the reports.
> Windows authentication is strongly recommended. Any idea?
> Regards
> Maciej Kiewrasql

Auditing changes to data

Hi Experts,
I want to audit the changes made to the data in the SQL
Server tables. How can I implement a audit mechanism?
Thanks,
Hari
Hi,
You will have to use either of below 2 options:-
1. Write Insert / Update and delete triggers on each tables
2. Enable profiler, You have to run the profiler all the time.
But I feel that your pupose can only be solved by writing custom triggers on
each tables.
Thanks
Hari
MCDBA
"Hari" <anonymous@.discussions.microsoft.com> wrote in message
news:278e01c47dd7$09469dc0$a401280a@.phx.gbl...
> Hi Experts,
> I want to audit the changes made to the data in the SQL
> Server tables. How can I implement a audit mechanism?
> Thanks,
> Hari
|||Hari
Create Audit Table with the same structure as real table . Create an
UPDATE/DELETE/INSERT trigger on real table and insert any changes into audit
table.
create trigger trigger_MyTable on MyTable after update
as
if @.@.ROWCOUNT = 0
return
insert MyAuditTable
select
i.ID
, d.MyColumn
, i.MyColumn
from
inserted i
join
deleted d on d.ID = o.Id
go
"Hari" <anonymous@.discussions.microsoft.com> wrote in message
news:278e01c47dd7$09469dc0$a401280a@.phx.gbl...
> Hi Experts,
> I want to audit the changes made to the data in the SQL
> Server tables. How can I implement a audit mechanism?
> Thanks,
> Hari
|||There are also third party tools which audit by reading the transaction
logs... Lumigent has such a tool (www.Lumigent.com.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hari" <anonymous@.discussions.microsoft.com> wrote in message
news:278e01c47dd7$09469dc0$a401280a@.phx.gbl...
> Hi Experts,
> I want to audit the changes made to the data in the SQL
> Server tables. How can I implement a audit mechanism?
> Thanks,
> Hari

Auditing changes to data

Hi Experts,
I want to audit the changes made to the data in the SQL
Server tables. How can I implement a audit mechanism?
Thanks,
HariHi,
You will have to use either of below 2 options:-
1. Write Insert / Update and delete triggers on each tables
2. Enable profiler, You have to run the profiler all the time.
But I feel that your pupose can only be solved by writing custom triggers on
each tables.
Thanks
Hari
MCDBA
"Hari" <anonymous@.discussions.microsoft.com> wrote in message
news:278e01c47dd7$09469dc0$a401280a@.phx.gbl...
> Hi Experts,
> I want to audit the changes made to the data in the SQL
> Server tables. How can I implement a audit mechanism?
> Thanks,
> Hari|||Hari
Create Audit Table with the same structure as real table . Create an
UPDATE/DELETE/INSERT trigger on real table and insert any changes into audit
table.
create trigger trigger_MyTable on MyTable after update
as
if @.@.ROWCOUNT = 0
return
insert MyAuditTable
select
i.ID
, d.MyColumn
, i.MyColumn
from
inserted i
join
deleted d on d.ID = o.Id
go
"Hari" <anonymous@.discussions.microsoft.com> wrote in message
news:278e01c47dd7$09469dc0$a401280a@.phx.gbl...
> Hi Experts,
> I want to audit the changes made to the data in the SQL
> Server tables. How can I implement a audit mechanism?
> Thanks,
> Hari|||There are also third party tools which audit by reading the transaction
logs... Lumigent has such a tool (www.Lumigent.com.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hari" <anonymous@.discussions.microsoft.com> wrote in message
news:278e01c47dd7$09469dc0$a401280a@.phx.gbl...
> Hi Experts,
> I want to audit the changes made to the data in the SQL
> Server tables. How can I implement a audit mechanism?
> Thanks,
> Hari

Auditing changes to data

Hi Experts,
I want to audit the changes made to the data in the SQL
Server tables. How can I implement a audit mechanism?
Thanks,
HariHi,
You will have to use either of below 2 options:-
1. Write Insert / Update and delete triggers on each tables
2. Enable profiler, You have to run the profiler all the time.
But I feel that your pupose can only be solved by writing custom triggers on
each tables.
Thanks
Hari
MCDBA
"Hari" <anonymous@.discussions.microsoft.com> wrote in message
news:278e01c47dd7$09469dc0$a401280a@.phx.gbl...
> Hi Experts,
> I want to audit the changes made to the data in the SQL
> Server tables. How can I implement a audit mechanism?
> Thanks,
> Hari|||Hari
Create Audit Table with the same structure as real table . Create an
UPDATE/DELETE/INSERT trigger on real table and insert any changes into audit
table.
create trigger trigger_MyTable on MyTable after update
as
if @.@.ROWCOUNT = 0
return
insert MyAuditTable
select
i.ID
, d.MyColumn
, i.MyColumn
from
inserted i
join
deleted d on d.ID = o.Id
go
"Hari" <anonymous@.discussions.microsoft.com> wrote in message
news:278e01c47dd7$09469dc0$a401280a@.phx.gbl...
> Hi Experts,
> I want to audit the changes made to the data in the SQL
> Server tables. How can I implement a audit mechanism?
> Thanks,
> Hari|||There are also third party tools which audit by reading the transaction
logs... Lumigent has such a tool (www.Lumigent.com.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hari" <anonymous@.discussions.microsoft.com> wrote in message
news:278e01c47dd7$09469dc0$a401280a@.phx.gbl...
> Hi Experts,
> I want to audit the changes made to the data in the SQL
> Server tables. How can I implement a audit mechanism?
> Thanks,
> Hari