DPE Error running on report Server

We created a DPE to pull data off a Web Service to be used as a datasource in
the reports we create. We created and added the code group to the
rssrvpolicy.config and rsmgrpolicy.config files. Also added the extension
name to the Data section of the RSReportServer.config file. The report works
correctly in debug designer mode but we receive the following error when
trying to run the report through the report manager or report server.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'NewDataset'. (rsErrorExecutingCommand)
Get Online Help
Request for the permission of type
System.Security.Permissions.EnvironmentPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.Check the documentation about how to deploy a similar DPE.
[WebService Data Processing Extension]
http://www.rdlcomponents.com/DTE/default.aspx
Thanks
Jerry
"Deb Taylor" wrote:
> We created a DPE to pull data off a Web Service to be used as a datasource in
> the reports we create. We created and added the code group to the
> rssrvpolicy.config and rsmgrpolicy.config files. Also added the extension
> name to the Data section of the RSReportServer.config file. The report works
> correctly in debug designer mode but we receive the following error when
> trying to run the report through the report manager or report server.
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'NewDataset'. (rsErrorExecutingCommand)
> Get Online Help
> Request for the permission of type
> System.Security.Permissions.EnvironmentPermission, mscorlib,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
>

DPE Error on Report Server

We have created a DPE that returns data from a Web Services and uses it as
the datasource in the reports. We have changed the config files and added
the code group also added the name to the data section of the
rsreportserver.config file. We have strong named the dll and added it to the
GAC. The report runs fine in debug designer mode but will not run through
the report server or report manager. We get the following error.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
An attempt has been made to use a data extension 'ISIS WS Data' that is not
registered for this report server. (rsDataExtensionNotFound) Get Online HelpCheck the documentation about how to deploy a similar DPE.
[WebService Data Processing Extension]
http://www.rdlcomponents.com/DTE/default.aspx
Thanks
Jerry
"Deb Taylor" wrote:
> We have created a DPE that returns data from a Web Services and uses it as
> the datasource in the reports. We have changed the config files and added
> the code group also added the name to the data section of the
> rsreportserver.config file. We have strong named the dll and added it to the
> GAC. The report runs fine in debug designer mode but will not run through
> the report server or report manager. We get the following error.
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> An attempt has been made to use a data extension 'ISIS WS Data' that is not
> registered for this report server. (rsDataExtensionNotFound) Get Online Help
>|||I did all that I'm now getting a 401 unauthorized error.
"Jerry" wrote:
> Check the documentation about how to deploy a similar DPE.
> [WebService Data Processing Extension]
> http://www.rdlcomponents.com/DTE/default.aspx
> Thanks
> Jerry
> "Deb Taylor" wrote:
> > We have created a DPE that returns data from a Web Services and uses it as
> > the datasource in the reports. We have changed the config files and added
> > the code group also added the name to the data section of the
> > rsreportserver.config file. We have strong named the dll and added it to the
> > GAC. The report runs fine in debug designer mode but will not run through
> > the report server or report manager. We get the following error.
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > An attempt has been made to use a data extension 'ISIS WS Data' that is not
> > registered for this report server. (rsDataExtensionNotFound) Get Online Help
> >|||Generally this error message means you need to log on (enter a valid user ID
and password) somewhere first. If you have just entered these and then
immediately see a 401 error, it means that one or both of your user ID and
password were invalid for whatever reason (entered incorrectly, user ID
suspended etc.).
Jerry
--
[Call a WebService from SQL Server 2000]
www.rdlcomponents.com
"Deb Taylor" wrote:
> I did all that I'm now getting a 401 unauthorized error.
> "Jerry" wrote:
> > Check the documentation about how to deploy a similar DPE.
> >
> > [WebService Data Processing Extension]
> > http://www.rdlcomponents.com/DTE/default.aspx
> >
> > Thanks
> > Jerry
> >
> > "Deb Taylor" wrote:
> >
> > > We have created a DPE that returns data from a Web Services and uses it as
> > > the datasource in the reports. We have changed the config files and added
> > > the code group also added the name to the data section of the
> > > rsreportserver.config file. We have strong named the dll and added it to the
> > > GAC. The report runs fine in debug designer mode but will not run through
> > > the report server or report manager. We get the following error.
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > An attempt has been made to use a data extension 'ISIS WS Data' that is not
> > > registered for this report server. (rsDataExtensionNotFound) Get Online Help
> > >

downloading database to local mdf file, sql dumb on SMSE

Hi,

I'm trying to work on a database when I'm not connected. I can't figure out how to get a local copy of a database.mdf that I created on the server, onto my hard drive, using SQL Management Studio Express. Does anyone have any suggestions? I'd be forever in your debt. Thanks

Hi,

You can backup/restore database or your detach/attach database.

Use sp_detach_db procedure and sp_attach_db procedure to achieve this.

For more information, check

http://msdn2.microsoft.com/en-us/library/ms188031.aspx
http://msdn2.microsoft.com/en-us/library/aa259611(SQL.80).aspx

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!

downgrade SQL2005 to SQL2k - Unicode ANSI issue

Hello,

I created a script with database publishing wizard to convert a SS2005
db into a SS2k db. The script has schema and data and looks very good.
When I try to start the created script in SS2k-Query analyzer, I get an
error like (in german)

Server: Nachr.-Nr. 105, Schweregrad 15, Status 1, Zeile 2
?ffnendes Anführungszeichen vor der Zeichenfolge '????
'.
It meens - translated from german- 'opening quote before string
<blabla>'

In the sript it stops at this line:
EXEC dbo.sp_addextendedproperty @.name=N'GUID', @.value=N'????

In the script many lines before I have many other GUIDs which QA
doesn't complain, so it's an Unicode/ANSI-issue I guess. What to do
now?

thanks
candide_sh(candide_sh@.yahoo.de) writes:

Quote:

Originally Posted by

I created a script with database publishing wizard to convert a SS2005
db into a SS2k db. The script has schema and data and looks very good.
When I try to start the created script in SS2k-Query analyzer, I get an
error like (in german)
>
Server: Nachr.-Nr. 105, Schweregrad 15, Status 1, Zeile 2
ffnendes Anfhrungszeichen vor der Zeichenfolge '??
'.
It meens - translated from german- 'opening quote before string
><blabla>'
>
In the sript it stops at this line:
EXEC dbo.sp_addextendedproperty @.name=N'GUID', @.value=N'??
>
In the script many lines before I have many other GUIDs which QA
doesn't complain, so it's an Unicode/ANSI-issue I guess. What to do
now?

"Database publishing wizard" I will have to admit that this tool is unknown
to me. Do you mean the scripting wizard in Management Studio, or do you mean
a third-party tool?

In any case, the Open File dialog in QA has a File Format combo where you
can specify Unicode format. Normally QA (as many other Windows) tools
determines whether a file is Unicode or not by looking for a byte-order
mark in the beginning of the file. But some tools do not generate a byte-
order mark.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||DB Pub Wizard comes from SS2005, from Microsoft SQLServer2005 website
(search for feature pack)
I guess it creates a script file (myscript.sql) but doesn't create this
file in UNICODE. I searched and played around in SS2005, but I think I
can't influence the behaviour of DB Pub Wizard (writing only ANSI) from
SS2005.

Remember I open QA in SS2000 to start this script. Thanks for your
hint, I found the dialog box in QA and changed the file format to
Unicode, but no success.

--
candide_sh

On 26 Jan., 14:36, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

(candide...@.yahoo.de) writes:

Quote:

Originally Posted by

I created a script with database publishing wizard to convert a SS2005
db into a SS2k db. The script has schema and data and looks very good.
When I try to start the created script in SS2k-Query analyzer, I get an
error like (in german)

>

Quote:

Originally Posted by

Server: Nachr.-Nr. 105, Schweregrad 15, Status 1, Zeile 2
ffnendes Anfhrungszeichen vor der Zeichenfolge '??
'.
It meens - translated from german- 'opening quote before string
<blabla>'

>

Quote:

Originally Posted by

In the sript it stops at this line:
EXEC dbo.sp_addextendedproperty @.name=N'GUID', @.value=N'??

>

Quote:

Originally Posted by

In the script many lines before I have many other GUIDs which QA
doesn't complain, so it's an Unicode/ANSI-issue I guess. What to do
now?"Database publishing wizard" I will have to admit that this tool isunknown

to me. Do you mean the scripting wizard in Management Studio, or do you mean
a third-party tool?
>
In any case, the Open File dialog in QA has a File Format combo where you
can specify Unicode format. Normally QA (as many other Windows) tools
determines whether a file is Unicode or not by looking for a byte-order
mark in the beginning of the file. But some tools do not generate a byte-
order mark.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Zitierten Text ausblenden -- Zitierten Text anzeigen -

|||(candide_sh@.yahoo.de) writes:

Quote:

Originally Posted by

DB Pub Wizard comes from SS2005, from Microsoft SQLServer2005 website
(search for feature pack)
I guess it creates a script file (myscript.sql) but doesn't create this
file in UNICODE. I searched and played around in SS2005, but I think I
can't influence the behaviour of DB Pub Wizard (writing only ANSI) from
SS2005.
>
Remember I open QA in SS2000 to start this script. Thanks for your
hint, I found the dialog box in QA and changed the file format to
Unicode, but no success.

I downloaded the DB Publish Wizard, and it does indeed generate a Unicode
file. I had created this table on SQL 2005:

CREATE TABLE utlndsk(a nvarchar(234) NOT NULL)
go
INSERT utlndsk(a) VALUES (nchar(8080) + nchar(324))

and I was able to insert that data successfully on SQL 2000 through
Query Analyzer.

Maybe there is some special catch with extended properties. (I never
use them myself, so I did not play with one.)

What is in that extended property on SQL 2005?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||hello Erland

the GUID-value was created by the upsizing wizard of MS-Access2003 and
I really don't know what for it is. But the conservative way is to not
touch the values created by this wizard. As the script generated by DB
Pub wizard crashed at only this one GUID-value (others worked fine) I
commented this line out and manually copy/pasted this value. Well
done...

On 26 Jan., 23:42, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

(candide...@.yahoo.de) writes:

Quote:

Originally Posted by

DB Pub Wizard comes from SS2005, from Microsoft SQLServer2005 website
(search for feature pack)
I guess it creates a script file (myscript.sql) but doesn't create this
file in UNICODE. I searched and played around in SS2005, but I think I
can't influence the behaviour of DB Pub Wizard (writing only ANSI) from
SS2005.

>

Quote:

Originally Posted by

Remember I open QA in SS2000 to start this script. Thanks for your
hint, I found the dialog box in QA and changed the file format to
Unicode, but no success.I downloaded the DB Publish Wizard, and it doesindeed generate a Unicode

file. I had created this table on SQL 2005:
>
CREATE TABLE utlndsk(a nvarchar(234) NOT NULL)
go
INSERT utlndsk(a) VALUES (nchar(8080) + nchar(324))
>
and I was able to insert that data successfully on SQL 2000 through
Query Analyzer.
>
Maybe there is some special catch with extended properties. (I never
use them myself, so I did not play with one.)
>
What is in that extended property on SQL 2005?
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Doubt in Index

Hi EverB,

I have created a table say T1 with 5 columns (col1.....col5).
I have created an index on col4 and col5.

iam executing a select query say.

select col1,col2,col3 from t1 where col1 =0;

In the above query i hav not used the columns for which i hav created the index.My ques is-

Does the index really works when u execute the above query?

Any answer please.......
It wuld be better if u culd suggest some sites for this.

Thanks and Regds,
Arunno, for that query, the index is ignored

a good tutorial is Optimizing your MySQL Application (http://www.sitepoint.com/print/optimizing-mysql-application) even if you're using something other than mysql

dotnet 3.5 runtime for synchronisation of sql server

Hi,

I downloaded orcas and created an application which also has sql server synchronisation, now if i wish to run it on another m/c, where can i get the runtime for 3.5, I searched but could not find it.

Thanks

arnab

It is available form here: http://www.microsoft.com/downloads/details.aspx?FamilyID=75fef59f-1b5e-49bc-a21a-9ef4f34de6fc&DisplayLang=en and here http://www.microsoft.com/downloads/details.aspx?FamilyId=E3715E6F-E123-428B-8A0F-028AFB9E0322&displaylang=en

Don't send subscription if no data on report

I am fairly new to Reporting Services. That said I have created a
report that runs daily and via a subscription sends the report as
email. This works fine day in and day out, however some days there is
no data for the report. On the days when the report contains no data I
don't want a blank report sent to the subscribers, I prefer that they
get nothing. Is this out of the box functionality and I'm just not
finding it or is it coding I need to do? Much thanks to anyone willing
to point me in the right direction.
Amy Slankard
aslankard@.alumni.cofc.eduI don't think that functionality is built in but my way of handling it
is to include something in the subscription query that returns an
empty query if there is no data in the report. Nothing bad happens if
the subscription query returns no subscribers, just nothing gets sent.
It means including some form of the actual report query in the
subscription query so depending on how complex things are that may or
may not be a very practical or efficient way to go. My situation needs
some fairly heavy preprocessing that runs using the SQL Server Agent
in the early morning which among other things, sets a bit flag in a
table to say whether or not there is any data to report. My report
that runs some time later then includes that flag in its subscription
query.
Cheers
Ross
On 30 Mar 2005 06:50:27 -0800, "aslankard@.alumni.cofc.edu"
<amy.slankard@.gmail.com> wrote:
>I am fairly new to Reporting Services. That said I have created a
>report that runs daily and via a subscription sends the report as
>email. This works fine day in and day out, however some days there is
>no data for the report. On the days when the report contains no data I
>don't want a blank report sent to the subscribers, I prefer that they
>get nothing. Is this out of the box functionality and I'm just not
>finding it or is it coding I need to do? Much thanks to anyone willing
>to point me in the right direction.
>Amy Slankard
>aslankard@.alumni.cofc.edu

Don't get Service Broker to Work

Hi,

I'm not able to get Service Broker to work. I've created the following sample and would excpect to get some data from "PreisanfrageQueue" or "PreisanfrageRequestorQueue". But both they are emtpy.

What do I do wrong?

Regards,

Manfred

create message type Preisanfrage
validation = well_formed_xml;

create message type PreisanfrageAntwort
validation = well_formed_xml;

create contract PreisanfrageContract
(
Preisanfrage sent by initiator,
PreisanfrageAntwort sent by target
);

create queue PreisanfrageRequestorQueue with
status=on;

create queue PreisanfrageQueue;

create service PreisanfrageRequestorService
on queue PreisanfrageRequestorQueue ( PreisanfrageContract );

create service PreisanfrageService
on queue PreisanfrageQueue (PreisanfrageContract );

create table debug_table;
create table debug_table (id int primary key identity(1,1), msg varchar(100));

create procedure PreisanfrageAction
as
declare @.conversation uniqueidentifier
declare @.msg nvarchar(max)
declare @.msgType nvarchar(256)
declare @.answer xml;

insert into debug_table(msg) values('1');

;receive top(1)
@.conversation = conversation_handle,
@.msg = message_body,
@.msgType = message_type_name
from PreisanfrageQueue;

insert into debug_table(msg) values('2');

-- Preisanfrage bearbeiten

set @.answer = '<preis>1</preis>';
;send on conversation @.conversation
message type PreisanfrageAntwort (@.answer);

end conversation @.conversation;

insert into debug_table(msg) values('3');

alter queue PreisanfrageQueue
with
status=on,
activation (
status=on,
PROCEDURE_NAME = PreisanfrageAction,
max_queue_readers = 100,
EXECUTE AS OWNER
);

-- Dialog starten

declare @.conversation uniqueidentifier;

begin dialog conversation @.conversation
from service [PreisanfrageRequestorService]
to service 'PreisanfrageService'
on contract [PreisanfrageContract];

declare @.request xml;

set @.request = '<?xml version="1.0" encoding="UTF-8"?><Preisanfrage xmlns="4711101'">http://www.xyz.at/samples/Preisanfrage"><KundenId>4711</KundenId><ProduktId>10</ProduktId><Anzahl>1</Anzahl></Preisanfrage>';

;send on conversation @.conversation
message type Preisanfrage ( @.request );

receive * from PreisanfrageQueue;

receive * from PreisanfrageRequestorQueue;

select * from debug_table

1. Please double check you have created the master key in this database.

create master key

encryption by password='asdfasdf'

2. query the system table to check the message’s transmission status.

select * from sys.transmission_queue

3. Don’t use

receive * from PreisanfrageQueue;

receive * from PreisanfrageRequestorQueue;

To check the queue's messenger, because this will remove the message from

the queue and but the conversation open

|||

Hi,

thanks - it was the missing master key.

Did I get it right, that thouse activation procedures are polling the queue ?
If yes - is there a way to use some kind of notification so that the activation procedure is just called every time when a message is enqueued ?

Best whishes,
Manfred

|||You did it correctly, but your messages are getting taken off as soon as you put them on there, through your receive * statements. You should try to receive one at a time and do something with those records.

Domain User privilege for connecting SQL server 2000

Hi,

My server administrator has created a few users as domain user privilege for connecting SQL server from my application. However it faild to connect, and

with Domain Admin privilege, my app is running ok.

I asked admin person to upgrade domain user privilege to connect SQL server,

but he couldn't do this for security reason, and told it should work with domain user.

Is it true for domain user to connect SQL server without any problem?

Do I need to add the user, domain user, into Logins of Security inside SQL server Enterprise Manager?

Or inside users of my database section of SQL server EManager?

Thanks,

dixon

You have to create a login in SQL Server 2000 that corresponds to the domain user. Look at sp_grantlogin:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ga-gz_8dri.asp

Thanks
Laurentiu

Domain Security Groups unable to Browse Report Folders

I am user SQL/RS 2005 on a 2003 Server on a 2000 domain and I have created a
domain security group and added a user to it. I then went into the security
tab of reporting services Home and added the group with the role of Browser.
I then added the same group to a child folder in the same manor. The user
can NOT see any folders or objects to browse and doesn't get the My Reports
folder showing either. If I add one of the builting groups (ssuch as
builtin\users) to the Home folder, all users can see and browse that folder.
The only references I have found say that domain groups should automatically
be enabled when RS is installed. I have had this problem from the beginning.
I even tried adding the user to a local group and adding the local group to
the Home folder and had no luck. If I add the same user explecitly to the
Home and sub-folders, everything works fine.
Does anyone have any idea what might be wrong in my configuration?
I tallked to a colleague who has SAL/RS Dev Edition on an XP machine
attached to a 2003 domain and he has the exact same problem.
This is very frustrating because it is a maintenance nightmare for the site
security.
I did check and the Default Web Site and the Reports and the Report Server
site are set to Windows Authentication and not to allow anonymous access.
Any help will be greatly appreciated.Are you specifying the domain name before the group name? Like
MYDOMAIN\MYGROUPNAME.
"qIjDraco" wrote:
> I am user SQL/RS 2005 on a 2003 Server on a 2000 domain and I have created a
> domain security group and added a user to it. I then went into the security
> tab of reporting services Home and added the group with the role of Browser.
> I then added the same group to a child folder in the same manor. The user
> can NOT see any folders or objects to browse and doesn't get the My Reports
> folder showing either. If I add one of the builting groups (ssuch as
> builtin\users) to the Home folder, all users can see and browse that folder.
> The only references I have found say that domain groups should automatically
> be enabled when RS is installed. I have had this problem from the beginning.
> I even tried adding the user to a local group and adding the local group to
> the Home folder and had no luck. If I add the same user explecitly to the
> Home and sub-folders, everything works fine.
> Does anyone have any idea what might be wrong in my configuration?
> I tallked to a colleague who has SAL/RS Dev Edition on an XP machine
> attached to a 2003 domain and he has the exact same problem.
> This is very frustrating because it is a maintenance nightmare for the site
> security.
> I did check and the Default Web Site and the Reports and the Report Server
> site are set to Windows Authentication and not to allow anonymous access.
> Any help will be greatly appreciated.
>|||What I do is have a local group that I add domain groups and individual
domain users. I have never had to do anything other than add them to the
proper role. It is possible to force a subdirectory from inheriting from the
above directory. Perhaps you have done this?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"qIjDraco" <qIjDraco@.discussions.microsoft.com> wrote in message
news:42C60E14-438A-4D5A-AFB4-698D2DD736A3@.microsoft.com...
>I am user SQL/RS 2005 on a 2003 Server on a 2000 domain and I have created
>a
> domain security group and added a user to it. I then went into the
> security
> tab of reporting services Home and added the group with the role of
> Browser.
> I then added the same group to a child folder in the same manor. The user
> can NOT see any folders or objects to browse and doesn't get the My
> Reports
> folder showing either. If I add one of the builting groups (ssuch as
> builtin\users) to the Home folder, all users can see and browse that
> folder.
> The only references I have found say that domain groups should
> automatically
> be enabled when RS is installed. I have had this problem from the
> beginning.
> I even tried adding the user to a local group and adding the local group
> to
> the Home folder and had no luck. If I add the same user explecitly to the
> Home and sub-folders, everything works fine.
> Does anyone have any idea what might be wrong in my configuration?
> I tallked to a colleague who has SAL/RS Dev Edition on an XP machine
> attached to a 2003 domain and he has the exact same problem.
> This is very frustrating because it is a maintenance nightmare for the
> site
> security.
> I did check and the Default Web Site and the Reports and the Report Server
> site are set to Windows Authentication and not to allow anonymous access.
> Any help will be greatly appreciated.
>|||I tryied using a local group and tried adding my domain users and had no luck
there too.
Is there any special user id / previledges you are running your SQL and RS
services under?
Mine are as follows:
SQL Server: Local System
SQL Server Active Directory Helper: Network Service
SQL Server Agent: Local System
SQL Server Analysis Services: {domain account setup for SQL}
SQL Server Browser: {domain account setup for SQL}
SQL Server FullText Search: Local System
SQL Server Integration Services: Network Service
SQL Server Reporting Services: {domain account setup for SQL}
SQL Server VSS Writer: Local System
qIjDraco
"Bruce L-C [MVP]" wrote:
> What I do is have a local group that I add domain groups and individual
> domain users. I have never had to do anything other than add them to the
> proper role. It is possible to force a subdirectory from inheriting from the
> above directory. Perhaps you have done this?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services|||Yes, I did specify the domain name before the group name. That is why I am
so confused.
qIjDraco
"SteveIrwin" wrote:
> Are you specifying the domain name before the group name? Like
> MYDOMAIN\MYGROUPNAME.
>|||Did you find the solution because I have the same problem.
Thanks--
Nelson Vega Marrero
Las Vegas Nevada
Tech Result
"qIjDraco" wrote:
> I tryied using a local group and tried adding my domain users and had no luck
> there too.
> Is there any special user id / previledges you are running your SQL and RS
> services under?
> Mine are as follows:
> SQL Server: Local System
> SQL Server Active Directory Helper: Network Service
> SQL Server Agent: Local System
> SQL Server Analysis Services: {domain account setup for SQL}
> SQL Server Browser: {domain account setup for SQL}
> SQL Server FullText Search: Local System
> SQL Server Integration Services: Network Service
> SQL Server Reporting Services: {domain account setup for SQL}
> SQL Server VSS Writer: Local System
> qIjDraco
> "Bruce L-C [MVP]" wrote:
> > What I do is have a local group that I add domain groups and individual
> > domain users. I have never had to do anything other than add them to the
> > proper role. It is possible to force a subdirectory from inheriting from the
> > above directory. Perhaps you have done this?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
>|||Did you find the solution because I have the same problem and I do not know
what should I do in oder to fix that.
I'm thinking maybe the RS does not work online with the Active Directory and
once it copy the group it never do it again but I'm not sure
Please anyhelp
--
Nelson Vega Marrero
Las Vegas Nevada
Tech Result
"qIjDraco" wrote:
> I am user SQL/RS 2005 on a 2003 Server on a 2000 domain and I have created a
> domain security group and added a user to it. I then went into the security
> tab of reporting services Home and added the group with the role of Browser.
> I then added the same group to a child folder in the same manor. The user
> can NOT see any folders or objects to browse and doesn't get the My Reports
> folder showing either. If I add one of the builting groups (ssuch as
> builtin\users) to the Home folder, all users can see and browse that folder.
> The only references I have found say that domain groups should automatically
> be enabled when RS is installed. I have had this problem from the beginning.
> I even tried adding the user to a local group and adding the local group to
> the Home folder and had no luck. If I add the same user explecitly to the
> Home and sub-folders, everything works fine.
> Does anyone have any idea what might be wrong in my configuration?
> I tallked to a colleague who has SAL/RS Dev Edition on an XP machine
> attached to a 2003 domain and he has the exact same problem.
> This is very frustrating because it is a maintenance nightmare for the site
> security.
> I did check and the Default Web Site and the Reports and the Report Server
> site are set to Windows Authentication and not to allow anonymous access.
> Any help will be greatly appreciated.
>|||Unfortunately I haven't found the solution yet. I tried chaning the ID
reporting services and SQL were running under, but no change in behavior.
qIjDraco
"Nelson Vega" wrote:
> Did you find the solution because I have the same problem and I do not know
> what should I do in oder to fix that.|||Did you contact microsoft ?
--
Nelson Vega Marrero
Las Vegas Nevada
Tech Result
"qIjDraco" wrote:
> Unfortunately I haven't found the solution yet. I tried chaning the ID
> reporting services and SQL were running under, but no change in behavior.
> qIjDraco
> "Nelson Vega" wrote:
> > Did you find the solution because I have the same problem and I do not know
> > what should I do in oder to fix that.
>|||Did you contact Microsoft about the problem?
--
Nelson Vega Marrero
Las Vegas Nevada
Tech Result
"qIjDraco" wrote:
> Unfortunately I haven't found the solution yet. I tried chaning the ID
> reporting services and SQL were running under, but no change in behavior.
> qIjDraco
> "Nelson Vega" wrote:
> > Did you find the solution because I have the same problem and I do not know
> > what should I do in oder to fix that.
>|||I finally got past this problem. I changed my services to running as shown
below. Now I create a domain security group and add the appropriate users to
it. Then I create a local group on the SQL machine and add the domain group
as the only member of the local group. I then give the local group the
appropriate permission to each folder on the web site (browser, content
manager, admin, etc.). RS properly checks and shows the folders it should to
each user.
Services run as "Network Service":
SQL Server Active Directory Helper
SQL Server Integration Services
Services run as "Local System":
SQL Server FullText Search
SQL Server VSS Writer
Services run as a domain admin ID that I created just for the SQL services:
SQL Server
SQL Server Agent
SQL Server Analysis Services
SQL Server Browser
SQL Server Reporting Services
I think my problem was that some of the services initially installed with
the wrong type of "Log On As" user. Everything seems to be working just fine
for me now.
qIj Draco
--
"Nelson Vega" wrote:
> Did you find the solution because I have the same problem.|||I tried to implement the solutions listed in this thread to no avail.
I have been trying to get my Domain Security Groups to work with SRS for
over a week. The only thing that seems to work is adding the domain user to
the root (home) folder and managing sub-folders with groups. This is a huge
pain when you have 100's of users.
One interesting observation is when I add a test user to our domain and then
add them to the ReportingGroup on our domain, this test-user is allowed to
access what I set forth with groups, without adding them specifically to
reporting services as an individual user. Could some attribute in Active
Directory, that we place on regular users, be blocking the SRS server from
utilizing these regaulr domain users?
I am not an AD expert, nor am I really a network admin, I am just trying to
use tools defined by Microsoft to manage a Microsoft product. This is a
critical issue for us, do you think that if I burn a support ticket they
would be able to resolve this issue? It seems I am not the only one with this
problem!
"Bruce L-C [MVP]" wrote:
> What I do is have a local group that I add domain groups and individual
> domain users. I have never had to do anything other than add them to the
> proper role. It is possible to force a subdirectory from inheriting from the
> above directory. Perhaps you have done this?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "qIjDraco" <qIjDraco@.discussions.microsoft.com> wrote in message
> news:42C60E14-438A-4D5A-AFB4-698D2DD736A3@.microsoft.com...
> >I am user SQL/RS 2005 on a 2003 Server on a 2000 domain and I have created
> >a
> > domain security group and added a user to it. I then went into the
> > security
> > tab of reporting services Home and added the group with the role of
> > Browser.
> > I then added the same group to a child folder in the same manor. The user
> > can NOT see any folders or objects to browse and doesn't get the My
> > Reports
> > folder showing either. If I add one of the builting groups (ssuch as
> > builtin\users) to the Home folder, all users can see and browse that
> > folder.
> >
> > The only references I have found say that domain groups should
> > automatically
> > be enabled when RS is installed. I have had this problem from the
> > beginning.
> > I even tried adding the user to a local group and adding the local group
> > to
> > the Home folder and had no luck. If I add the same user explecitly to the
> > Home and sub-folders, everything works fine.
> >
> > Does anyone have any idea what might be wrong in my configuration?
> >
> > I tallked to a colleague who has SAL/RS Dev Edition on an XP machine
> > attached to a 2003 domain and he has the exact same problem.
> >
> > This is very frustrating because it is a maintenance nightmare for the
> > site
> > security.
> >
> > I did check and the Default Web Site and the Reports and the Report Server
> > site are set to Windows Authentication and not to allow anonymous access.
> >
> > Any help will be greatly appreciated.
> >
>
>

Domain group members cannot connect [SQL Server 2k5 Workgroup Ed.]

We have a brand new out-of-the-box SQL Server 2005 Workgroup Edition install
.
We are using Windows Authentication, and have created SQL logins for about
40 different groups on our domain. We've given those logins the appropriate
permissions on the databases they're supposed to be able to access.
The problem is that when users try to connect to the SQL server, they cannot
connect. An error 18456 is thrown, and logged in the Application event log
stating "Login failed for user OURDOMAIN\theuser" (example values). The
user is properly a member of group added as a login to SQL Server, and we've
confirmed that there are not conflicting permissions that would deny those
users access via another route.
This is only a problem for domain-based groups. If we create a local group
on the SQL server machine, through Computer Management -> Local Users and
Groups, then make the same users a member of THAT group, and finally then
follow the same process to add that local group to SQL Server Logins and set
the database privileges, it works!!
Our group memberships change frequently, and are used for a lot more than
just SQL server permissions. So, using local groups and maintaining
membership in both places is not really feasible. Any ideas why a local
machine group containing domain user accounts would work fine, but a domain
group containing the same accounts would not?
Thanks in advance.
~JimIs the server that SQL is on joined to the domain?
Jim Kilmer wrote:
> We have a brand new out-of-the-box SQL Server 2005 Workgroup Edition insta
ll.
> We are using Windows Authentication, and have created SQL logins for about
> 40 different groups on our domain. We've given those logins the appropria
te
> permissions on the databases they're supposed to be able to access.
> The problem is that when users try to connect to the SQL server, they cann
ot
> connect. An error 18456 is thrown, and logged in the Application event lo
g
> stating "Login failed for user OURDOMAIN\theuser" (example values). The
> user is properly a member of group added as a login to SQL Server, and we'
ve
> confirmed that there are not conflicting permissions that would deny those
> users access via another route.
> This is only a problem for domain-based groups. If we create a local grou
p
> on the SQL server machine, through Computer Management -> Local Users and
> Groups, then make the same users a member of THAT group, and finally the
n
> follow the same process to add that local group to SQL Server Logins and s
et
> the database privileges, it works!!
> Our group memberships change frequently, and are used for a lot more than
> just SQL server permissions. So, using local groups and maintaining
> membership in both places is not really feasible. Any ideas why a local
> machine group containing domain user accounts would work fine, but a domai
n
> group containing the same accounts would not?
> Thanks in advance.
> ~Jim

Domain Group Members and Database Roles

Greetings...
I have a SQL2005 Express database where I have created 3 user defined
database roles, granted those db roles all the required permissions on the
required db objects, and made a few (Domain\Group) groups login members of
those database roles. The 3 roles are for high, medium, and low rights.
When a user logins with Windows NT authority, I can determine their identity
with
SUSER_SNAME(), but how can I easily determine what role or roles the user,
not the group, belongs to? The user would not have a principal_id, but the
group does. There's got to be a way to know what role the USER is in, isn't
there?
DaveHi
Try
sys.database_role_members catalog view
"DGardner" <DGardner@.discussions.microsoft.com> wrote in message
news:2BE1DB54-0A86-4CF8-A916-0666AD0790AF@.microsoft.com...
> Greetings...
> I have a SQL2005 Express database where I have created 3 user defined
> database roles, granted those db roles all the required permissions on the
> required db objects, and made a few (Domain\Group) groups login members of
> those database roles. The 3 roles are for high, medium, and low rights.
> When a user logins with Windows NT authority, I can determine their
> identity
> with
> SUSER_SNAME(), but how can I easily determine what role or roles the user,
> not the group, belongs to? The user would not have a principal_id, but the
> group does. There's got to be a way to know what role the USER is in,
> isn't
> there?
> Dave|||Uri,
that view is not too informative... I finally got this query to work for
what I want:
Select name as Roles
From sys.database_principals
Where type='R' And is_fixed_role=0 And principal_id<>0
But I wouldn't call this 'easy' or intuitive...
Dave
"Uri Dimant" wrote:

> Hi
> Try
> sys.database_role_members catalog view
>
> "DGardner" <DGardner@.discussions.microsoft.com> wrote in message
> news:2BE1DB54-0A86-4CF8-A916-0666AD0790AF@.microsoft.com...
>
>|||Hi Dave.
Try with the IS_MEMBER function
Regards
Antonio Soto
Solid Quality Learning
http://www.sqlu.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"DGardner" <DGardner@.discussions.microsoft.com> escribi en el mensaje
news:2BE1DB54-0A86-4CF8-A916-0666AD0790AF@.microsoft.com...
> Greetings...
> I have a SQL2005 Express database where I have created 3 user defined
> database roles, granted those db roles all the required permissions on the
> required db objects, and made a few (Domain\Group) groups login members of
> those database roles. The 3 roles are for high, medium, and low rights.
> When a user logins with Windows NT authority, I can determine their
> identity
> with
> SUSER_SNAME(), but how can I easily determine what role or roles the user,
> not the group, belongs to? The user would not have a principal_id, but the
> group does. There's got to be a way to know what role the USER is in,
> isn't
> there?
> Dave|||Antonio,
Sorry... IS_MEMBER() doesn't work either. Although the group is assigned to
the role, the individual user who is a member of the group is not, and so
IS_MEMBER() returns 0 every time. It looks like the query I constructed is
the only way to get the info I want.
Dave
"Antonio Soto" wrote:

> Hi Dave.
> Try with the IS_MEMBER function
> Regards
> --
> Antonio Soto
> Solid Quality Learning
> http://www.sqlu.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "DGardner" <DGardner@.discussions.microsoft.com> escribió en el mensaje
> news:2BE1DB54-0A86-4CF8-A916-0666AD0790AF@.microsoft.com...
>
>