activex script jobs

Can anyone tell me why I get this error when trying to run a job on sql 2005
that is an activex script?
Error creating security descriptor for shared objects (reason: No mapping
between account names and security IDs was done). The
step failed.
I even tried credentials, proxy accounts etc. I might need to have a good
instruction sheet to explain how to properly set this up.
Please give more information about the owner of the job, agent service
account details and also the configuration (like OS/SP/Language/cluster?)
In SQL2005, Activex Script subsystem is executed in separate process context
and not anymore in SQLAgent process context.
This issue you are refering was known one in non-English locale and cluster
config in our Beta releases, but has been addressed in our RTM.
I am assuming you are using RTM version of SQL2005, please confirm. If you
are using pre-RTM version, upgrade to RTM and you should see this addressed
Thanks,
Gops Dwarak
"ECS" <ecs@.netset.com> wrote in message
news:OogfHMT$FHA.1256@.TK2MSFTNGP15.phx.gbl...
> Can anyone tell me why I get this error when trying to run a job on sql
2005
> that is an activex script?
> Error creating security descriptor for shared objects (reason: No mapping
> between account names and security IDs was done). The
> step failed.
>
> I even tried credentials, proxy accounts etc. I might need to have a good
> instruction sheet to explain how to properly set this up.
>
sql

activex script jobs

Can anyone tell me why I get this error when trying to run a job on sql 2005
that is an activex script?
Error creating security descriptor for shared objects (reason: No mapping
between account names and security IDs was done). The
step failed.
I even tried credentials, proxy accounts etc. I might need to have a good
instruction sheet to explain how to properly set this up.Please give more information about the owner of the job, agent service
account details and also the configuration (like OS/SP/Language/cluster?)
In SQL2005, Activex Script subsystem is executed in separate process context
and not anymore in SQLAgent process context.
This issue you are refering was known one in non-English locale and cluster
config in our Beta releases, but has been addressed in our RTM.
I am assuming you are using RTM version of SQL2005, please confirm. If you
are using pre-RTM version, upgrade to RTM and you should see this addressed
Thanks,
Gops Dwarak
"ECS" <ecs@.netset.com> wrote in message
news:OogfHMT$FHA.1256@.TK2MSFTNGP15.phx.gbl...
> Can anyone tell me why I get this error when trying to run a job on sql
2005
> that is an activex script?
> Error creating security descriptor for shared objects (reason: No mapping
> between account names and security IDs was done). The
> step failed.
>
> I even tried credentials, proxy accounts etc. I might need to have a good
> instruction sheet to explain how to properly set this up.
>

activex script jobs

Can anyone tell me why I get this error when trying to run a job on sql 2005
that is an activex script?
Error creating security descriptor for shared objects (reason: No mapping
between account names and security IDs was done). The
step failed.
I even tried credentials, proxy accounts etc. I might need to have a good
instruction sheet to explain how to properly set this up.Please give more information about the owner of the job, agent service
account details and also the configuration (like OS/SP/Language/cluster?)
In SQL2005, Activex Script subsystem is executed in separate process context
and not anymore in SQLAgent process context.
This issue you are refering was known one in non-English locale and cluster
config in our Beta releases, but has been addressed in our RTM.
I am assuming you are using RTM version of SQL2005, please confirm. If you
are using pre-RTM version, upgrade to RTM and you should see this addressed
Thanks,
Gops Dwarak
"ECS" <ecs@.netset.com> wrote in message
news:OogfHMT$FHA.1256@.TK2MSFTNGP15.phx.gbl...
> Can anyone tell me why I get this error when trying to run a job on sql
2005
> that is an activex script?
> Error creating security descriptor for shared objects (reason: No mapping
> between account names and security IDs was done). The
> step failed.
>
> I even tried credentials, proxy accounts etc. I might need to have a good
> instruction sheet to explain how to properly set this up.
>

ActiveDirectory Group Security

Hi all

What i want to do - Execute a Stored Procedure when a user log on that is in aActiveDirectory Group.

I want to create a storedprocedure that will be executed when a windows user log on that is part of a specific ADGroup.

I was able to create the ADGroup and add it to logins. I was able to create the procedure with the ADGroup as owner.

The problem is when the user log on, he is not seen as part of the group that has rights on the DB.

Please help

From your description, I am assuming that you are having trouble to access a database (different than master) where your SP resides, correct?

If this is the case, probably what happened is that the AD group in that DB doesn’t have access to it. This is typically the case when users are created implicitly. You can try the following:

USE [<db_name>]

go

GRANT CONNECT TO [<ADGroup_name>]

go

BTW. If you only want the AD group to be able to execute the SP, you don’t need to make them owners, granting EXECUTE on the SP should be sufficient.

I hope this information helps, let us know if this solved your problem.

- Raul Garcia

SDE/T

SQL Server ENgine

active x control

My computer said; your current security settings prohibit
running active x controls on this page. As a result this
page my not show right. Thank YouThis is a SQL Server newsgroup so it's not really the best
place to post this message. If you are using Internet
Explorer, you may want to post ot the newsgroups for
Internet Explorer issues.
It's not clear what exactly your question is but in Internet
Explorer, the settings for this can be accessed by right
clicking on Internet Explorer, select properties. Go to the
Security tab, select the security zone context you are
operating in when receiving the message and then select
Custom Level.
-Sue
On Fri, 28 May 2004 11:28:32 -0700, "Vicki"
<anonymous@.discussions.microsoft.com> wrote:

>My computer said; your current security settings prohibit
>running active x controls on this page. As a result this
>page my not show right. Thank You

Active Directory Conversion

We are updating an NT domain to Active Directory.
All of our security group within RS are based on local (machine groups)
which contain domain groups as members. So we are pretty comfortable with
the conversion path required there.
We understand how we can change the Data Base Agent and Remote Execution
Agents using rsconfig (-c and -e switches).
The ReportServer Service runs as NT Authority\Network Service and as such
needs no change.
Is there anything else we are missing which must be touched to get to AD?
thanks in advance,
dlrDennis,
My company recently migrated all the users from an NT domain to an AD domain
and since we have been unable to setup new email subscriptions through RS.
Our work around has been to login to the old domain and create the
subscriptions. It seems that the account RS uses does not have permissions to
read the TGGAU attribute on the user account that was used to create and to
process the e-mail subscriptions. Until our RS server is migrated over to the
new AD domain I don't know of a solution to this issue. You can find out more
about it below...hope this helps...
http://support.microsoft.com/default.aspx?scid=kb;en-us;842423
Regards,
Ben Sullins
"Dennis Redfield" wrote:
> We are updating an NT domain to Active Directory.
> All of our security group within RS are based on local (machine groups)
> which contain domain groups as members. So we are pretty comfortable with
> the conversion path required there.
> We understand how we can change the Data Base Agent and Remote Execution
> Agents using rsconfig (-c and -e switches).
> The ReportServer Service runs as NT Authority\Network Service and as such
> needs no change.
> Is there anything else we are missing which must be touched to get to AD?
>
> thanks in advance,
> dlr
>
>|||thanx
"Ben Sullins" <BenSullins@.discussions.microsoft.com> wrote in message
news:5471A631-EA2F-4661-843B-2374D548F7A5@.microsoft.com...
> Dennis,
> My company recently migrated all the users from an NT domain to an AD
domain
> and since we have been unable to setup new email subscriptions through RS.
> Our work around has been to login to the old domain and create the
> subscriptions. It seems that the account RS uses does not have permissions
to
> read the TGGAU attribute on the user account that was used to create and
to
> process the e-mail subscriptions. Until our RS server is migrated over to
the
> new AD domain I don't know of a solution to this issue. You can find out
more
> about it below...hope this helps...
> http://support.microsoft.com/default.aspx?scid=kb;en-us;842423
> Regards,
> Ben Sullins
> "Dennis Redfield" wrote:
> > We are updating an NT domain to Active Directory.
> > All of our security group within RS are based on local (machine groups)
> > which contain domain groups as members. So we are pretty comfortable
with
> > the conversion path required there.
> > We understand how we can change the Data Base Agent and Remote Execution
> > Agents using rsconfig (-c and -e switches).
> > The ReportServer Service runs as NT Authority\Network Service and as
such
> > needs no change.
> >
> > Is there anything else we are missing which must be touched to get to
AD?
> >
> >
> > thanks in advance,
> >
> > dlr
> >
> >
> >
> >

Activation/Security/Dynamic SQL Question

I will have a variety of different types of work that will come into my Service Broker queue and I'll likely have a stored procedure or two for each of the different types of work (ie. move order header, move items, move payment, etc.) What is required to be done in each of these steps may vary by the subsidiary and type of order coming in. My plan is to use exclusively stored procedures but to execute them dynamically using sp_executesql. I think I should use sp_executesql because that way I can have a config file (in xml) that I can store what stored procedures need to be called for which unit of work/order type/subsidiary. If I do this I should be able to easily configure each type of work to be done in a config file and let Service Broker handle the execution dynamically. As long as I keep the parameters the same for each of the stored procedures (I'm thinking maybe 4 or 5 parameters) and passing them to each of the stored procedures, this approach will allow me to dynamically configure Service Broker to do what it is supposed to do. I can pull what needs to be done out of the message that comes in with an XQuery expression on the config file. I know that I will have to configure my user (activation user) to be able to run sp_executesql and the security may be complex (especially since I'm using certificates). I can not use trusted databases. Are there any other considerations I should think about?

Gary

You should be able to execute dynamic SQL as well as impersonate database principals (using the 'EXECUTE AS' statement or clause) to call message type handlers from the activation stored procedure. If you stay within the database, your database does not have to be trustworthy.

Hope that helps,
Rushi

accidentally deleted BUILTIN\Administrators group in Security tab

How can I recreate the BUILTIN\Administrators group that I had deleted
accidentally? My Slqserver 2K is in mixed mode.
Thanks
BillU don't have to as long as sql service and sql agent accounts have appropriate rights however you can do this fform EM --> logins and just add the user Builtin\Administrators

accidentally deleted BUILTIN\Administrators group in Security tab

How can I recreate the BUILTIN\Administrators group that I had deleted
accidentally? My Slqserver 2K is in mixed mode.
Thanks
BillU don't have to as long as sql service and sql agent accounts have appropria
te rights however you can do this fform EM --> logins and just add the user
Builtin\Administrators

Accessing SQL Server with Integrated Security from VPN

The title above should be a KB article. I have looked far and wide for a
definitive answer to this question and I have not found a definitive answer.
I have a non-domain computer accessing a domain using VPN. The Domain user
account being used for VPN has administrative priviledges on a SQL server.
Can I use Enterprise Manager to administer the SQL Server from that
non-domain computer using intergrated security? If so how?
Thanks,
David Rogers
Hi David,
So, you should be able to VPN into your corporate network from a machine
at home, that is not part of the domain.
The VPN should challenge you for domain authentication. So, you should be
forced to login to your company domain.
Now, that you've validated your credentials, you could use Terminal Server
or Remote Desktop to your SQL Server,
and it would be as if you're sitting at the console.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||That is helpful. I'm still looking for more. Is there a way to use integrated
security for a connection in this scenario (the question applies to
application connection strings as well as administration tools)?
Looking around, I found a reference to being able to use integrated security
with VPN if the client computer was a member of the same domain OR if the
same login name and password was used on the client. I've had no luck with
the latter.
Thank you!
David
"Kevin McDonnell [MSFT]" wrote:

> Hi David,
> So, you should be able to VPN into your corporate network from a machine
> at home, that is not part of the domain.
> The VPN should challenge you for domain authentication. So, you should be
> forced to login to your company domain.
> Now, that you've validated your credentials, you could use Terminal Server
> or Remote Desktop to your SQL Server,
> and it would be as if you're sitting at the console.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
|||Previous Post:
Is there a way to use integrated
security for a connection in this scenario (the question applies to
application connection strings as well as administration tools)?
-- Integrated Security relies on :
1. user has logged into the domain and been authenticated. (it's the user
not the machine that matters)
2. user has not logged into the domain but his username & password EXACTLY
match
the username and password on the server. Also only works with Named Pipes.
This was
commonly referred to as "workgroup security".
Looking around, I found a reference to being able to use integrated
security
with VPN if the client computer was a member of the same domain OR if the
same login name and password was used on the client. I've had no luck with
the latter.
-- Try this outside of the VPN scenario. Put a SQL Server and client
machine in a workgroup.
Set the Security Audit logging to log successful and failed logins.
Duplicate the username & password on the client and server.
Test with Trusted Connections using Named Pipes.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Accessing SQL Server 2005 via Scheduled Task

I have a strange problem that I think deals with security on SQL 2005.
I have a scheduled task that runs on a Windows 2000 machine. It calls
a vb script which creates a connection to SQL Server.

We migrated a database from SQL 2000 to 2005 which is on a different
box. I changed the connection in the vb script to use the new sql
server. The original connection to SQL 2000 used the 'sa' account
coded into the connection string , which we don't want to use on the
new server, so I changed the connection string in the script to use
the below login information.

Const strConnection = "Provider=SQLOLEDB;Data
Source=SQLServer;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=database;

I created a domain user and gave it dbo rights on the new database on
SQL 2005 as well as administrative rights on the local machine and the
network. The task runs fine for a while and then it will fail to
start. I have looked in the event log as well as the SQL log and have
not found anything else that ran when my task failed. Once it has
failed, if I manually run the vb script on the 2000 machine, it runs
just fine, but the schedule won't work. If I change the name of the
user that is running the scheduled task, it will begin working again.
I have run the profiler on SQL 2005 and watched the scheduled task
login as the correct user and update the database. There is no
pattern to when the scheduled task will stop running. This has been
happening for a few days now.

This script and scheduled task worked fine for over a year on the
machine when it logged into SQL 2000 and nothing else has changed,
which makes me think it is related to the SQL 2005 server. Any ideas?Hi

"Myster Edd" <mysteredd@.gmail.comwrote in message
news:1179861414.783713.3260@.z24g2000prd.googlegrou ps.com...

Quote:

Originally Posted by

>I have a strange problem that I think deals with security on SQL 2005.
I have a scheduled task that runs on a Windows 2000 machine. It calls
a vb script which creates a connection to SQL Server.
>
We migrated a database from SQL 2000 to 2005 which is on a different
box. I changed the connection in the vb script to use the new sql
server. The original connection to SQL 2000 used the 'sa' account
coded into the connection string , which we don't want to use on the
new server, so I changed the connection string in the script to use
the below login information.
>
Const strConnection = "Provider=SQLOLEDB;Data
Source=SQLServer;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=database;
>
I created a domain user and gave it dbo rights on the new database on
SQL 2005 as well as administrative rights on the local machine and the
network. The task runs fine for a while and then it will fail to
start. I have looked in the event log as well as the SQL log and have
not found anything else that ran when my task failed. Once it has
failed, if I manually run the vb script on the 2000 machine, it runs
just fine, but the schedule won't work. If I change the name of the
user that is running the scheduled task, it will begin working again.
I have run the profiler on SQL 2005 and watched the scheduled task
login as the correct user and update the database. There is no
pattern to when the scheduled task will stop running. This has been
happening for a few days now.
>
This script and scheduled task worked fine for over a year on the
machine when it logged into SQL 2000 and nothing else has changed,
which makes me think it is related to the SQL 2005 server. Any ideas?
>

I assume that the task worked fine when you profiled it on the SQL 2005
server? Have you run a server side trace to trap this being run when it
fails?
How often does this task run?
As this sounds like a windows scheduled task are you using SQL Express?
Have you installed any service packs on the SQL Server (SELECT @.@.VERSION)?
Does the schedule run on a different machine to the server?
Do you run AV or IDS software on the database server?

John

Accessing Reports/Databases across 2 domains

I have architecture related question -
I have 2 databases on 2 domains and security doesn't permit me to co-mingle
the data. I'll be generating 2 different reports for same request.
Question is - Do I need SQL server with reporting services installed on
each domain?
Current proposed solution is -
Domain AAA will have SQL server with RSS
Domain BBB will have SQL server with RSS
Sharepoint web parts (on BBB side) will access report from AAA and BBB.
(Domain BBB has 1 port open to allow web traffic).
If trusted SQL server connection is made available to RSS on BBB side, then
I think we don't need server with RSS on domain AAA. is this right? If so,
How can I access databases from RSS across domains?
Sounds interesing right? Please help me ....Sonali,
RSS is only needed to host the report definition which in turn collects
the data required. Provided the data connections are set up with
appropriate logins to the databases on each domain from the RS server,
you should be able to run from one RS server.
Your issue will be if your security policies totally prevent any access
between the domains.
Chris
Sonali wrote:
> I have architecture related question -
> I have 2 databases on 2 domains and security doesn't permit me to
> co-mingle the data. I'll be generating 2 different reports for same
> request.
> Question is - Do I need SQL server with reporting services installed
> on each domain?
> Current proposed solution is -
> Domain AAA will have SQL server with RSS
> Domain BBB will have SQL server with RSS
> Sharepoint web parts (on BBB side) will access report from AAA and
> BBB. (Domain BBB has 1 port open to allow web traffic).
> If trusted SQL server connection is made available to RSS on BBB
> side, then I think we don't need server with RSS on domain AAA. is
> this right? If so, How can I access databases from RSS across domains?
> Sounds interesing right? Please help me ....

Accessing Reports

My host provides access to Report Manager and Report Server with the same
login and password for my SQL Server. For obvious security reasons, I do
not want to pass these out to my client to access their reports. My host
has mentioned consuming the report and using the "credentials" properties to
pass the login info to the Report Server.
I have not learned enough about .NET to understand how to do this, as I am
still use classic ASP for many applications, so this is Greek to me. I was
hoping
this would be easy to do and if someone could point me in the right
direction.
Thanks so much,
BrianWhat your host is suggesting is very difficult to do. It requires creating
a separate web page that gets a report using SOAP and streams back the
report HTML (and, separately, the images, because the browser will ask for
them separately).
Direct URL access to the ReportServer is the easiest way to handle it, and
yes, it's a good idea to have a different user name and password for that
operation.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"mistybrian" <mistybrian@.discussions.microsoft.com> wrote in message
news:6596972D-86B6-47EB-8B73-535D5BAB50BD@.microsoft.com...
> My host provides access to Report Manager and Report Server with the same
> login and password for my SQL Server. For obvious security reasons, I do
> not want to pass these out to my client to access their reports. My host
> has mentioned consuming the report and using the "credentials" properties
> to
> pass the login info to the Report Server.
> I have not learned enough about .NET to understand how to do this, as I am
> still use classic ASP for many applications, so this is Greek to me. I
> was
> hoping
> this would be easy to do and if someone could point me in the right
> direction.
> Thanks so much,
> Brian
>|||Thanks for that information, Jeff. I hoped there would be a simple solution,
but I suppose my host is assuming that everyone is a .NET developer and could
do this with ease.
Thanks,
Brian
"Jeff A. Stucker" wrote:
> What your host is suggesting is very difficult to do. It requires creating
> a separate web page that gets a report using SOAP and streams back the
> report HTML (and, separately, the images, because the browser will ask for
> them separately).
> Direct URL access to the ReportServer is the easiest way to handle it, and
> yes, it's a good idea to have a different user name and password for that
> operation.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "mistybrian" <mistybrian@.discussions.microsoft.com> wrote in message
> news:6596972D-86B6-47EB-8B73-535D5BAB50BD@.microsoft.com...
> > My host provides access to Report Manager and Report Server with the same
> > login and password for my SQL Server. For obvious security reasons, I do
> > not want to pass these out to my client to access their reports. My host
> > has mentioned consuming the report and using the "credentials" properties
> > to
> > pass the login info to the Report Server.
> >
> > I have not learned enough about .NET to understand how to do this, as I am
> > still use classic ASP for many applications, so this is Greek to me. I
> > was
> > hoping
> > this would be easy to do and if someone could point me in the right
> > direction.
> >
> > Thanks so much,
> >
> > Brian
> >
> >
>
>

Accessing ReportManager with FormsAuthentication

Hi,
I am trying to implement a custom security extension using the Forms Auth
example provided by Microsoft. When i type in http://localhost/ReportServer,
I can see the Logon.aspx page. But when i type in http://localhost/Reports/,
I get a parser error saying
----
Parser Error
Description: An error occurred during the parsing of a resource required to
service this request. Please review the following specific parse error
details and modify your source file appropriately.
Parser Error Message: Could not load type
'Microsoft.Samples.ReportingServices.CustomSecurity.UILogon'.
Source Error:
Line 1: <%@. Page language="c#" Codebehind="UILogon.aspx.cs"
AutoEventWireup="false"
Inherits="Microsoft.Samples.ReportingServices.CustomSecurity.UILogon" %>
Line 2: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
Line 3: <HTML>
Source File: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\Pages\UILogon.aspx Line: 1
-----
Seems like it might have something to do wht permissions on the dll...Did
anyone have this problem? Or any ideas why this is happening?I have the same problem. Any luck with it?
"Aparna" wrote:
> Hi,
> I am trying to implement a custom security extension using the Forms Auth
> example provided by Microsoft. When i type in http://localhost/ReportServer,
> I can see the Logon.aspx page. But when i type in http://localhost/Reports/,
> I get a parser error saying:
> ----
> Parser Error
> Description: An error occurred during the parsing of a resource required to
> service this request. Please review the following specific parse error
> details and modify your source file appropriately.
> Parser Error Message: Could not load type
> 'Microsoft.Samples.ReportingServices.CustomSecurity.UILogon'.
> Source Error:
> Line 1: <%@. Page language="c#" Codebehind="UILogon.aspx.cs"
> AutoEventWireup="false"
> Inherits="Microsoft.Samples.ReportingServices.CustomSecurity.UILogon" %>
> Line 2: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> Line 3: <HTML>
> Source File: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\Pages\UILogon.aspx Line: 1
> -----
> Seems like it might have something to do wht permissions on the dll...Did
> anyone have this problem? Or any ideas why this is happening?|||Yeah, i later realized that I accidentally changed the wrong config file i.e.
I gave the 'My Computer' code group 'Full Trust' in the rssrvpolicy.config
file, in stead of the 'rsmgrpolicy.config' file... Everything worked like a
charm after that.. Hope that helps you....
"Minas Papageorgiou" wrote:
> I have the same problem. Any luck with it?
> "Aparna" wrote:
> > Hi,
> > I am trying to implement a custom security extension using the Forms Auth
> > example provided by Microsoft. When i type in http://localhost/ReportServer,
> > I can see the Logon.aspx page. But when i type in http://localhost/Reports/,
> > I get a parser error saying:
> > ----
> > Parser Error
> > Description: An error occurred during the parsing of a resource required to
> > service this request. Please review the following specific parse error
> > details and modify your source file appropriately.
> > Parser Error Message: Could not load type
> > 'Microsoft.Samples.ReportingServices.CustomSecurity.UILogon'.
> > Source Error:
> > Line 1: <%@. Page language="c#" Codebehind="UILogon.aspx.cs"
> > AutoEventWireup="false"
> > Inherits="Microsoft.Samples.ReportingServices.CustomSecurity.UILogon" %>
> > Line 2: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > Line 3: <HTML>
> >
> > Source File: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportManager\Pages\UILogon.aspx Line: 1
> > -----
> > Seems like it might have something to do wht permissions on the dll...Did
> > anyone have this problem? Or any ideas why this is happening?|||Are you using Enterprise Edition of SQL'
"Aparna" wrote:
> Yeah, i later realized that I accidentally changed the wrong config file i.e.
> I gave the 'My Computer' code group 'Full Trust' in the rssrvpolicy.config
> file, in stead of the 'rsmgrpolicy.config' file... Everything worked like a
> charm after that.. Hope that helps you....
> "Minas Papageorgiou" wrote:
> > I have the same problem. Any luck with it?
> >
> > "Aparna" wrote:
> >
> > > Hi,
> > > I am trying to implement a custom security extension using the Forms Auth
> > > example provided by Microsoft. When i type in http://localhost/ReportServer,
> > > I can see the Logon.aspx page. But when i type in http://localhost/Reports/,
> > > I get a parser error saying:
> > > ----
> > > Parser Error
> > > Description: An error occurred during the parsing of a resource required to
> > > service this request. Please review the following specific parse error
> > > details and modify your source file appropriately.
> > > Parser Error Message: Could not load type
> > > 'Microsoft.Samples.ReportingServices.CustomSecurity.UILogon'.
> > > Source Error:
> > > Line 1: <%@. Page language="c#" Codebehind="UILogon.aspx.cs"
> > > AutoEventWireup="false"
> > > Inherits="Microsoft.Samples.ReportingServices.CustomSecurity.UILogon" %>
> > > Line 2: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > > Line 3: <HTML>
> > >
> > > Source File: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > Services\ReportManager\Pages\UILogon.aspx Line: 1
> > > -----
> > > Seems like it might have something to do wht permissions on the dll...Did
> > > anyone have this problem? Or any ideas why this is happening?|||Developer's Edition
"Minas Papageorgiou" wrote:
> Are you using Enterprise Edition of SQL'
>
> "Aparna" wrote:
> > Yeah, i later realized that I accidentally changed the wrong config file i.e.
> > I gave the 'My Computer' code group 'Full Trust' in the rssrvpolicy.config
> > file, in stead of the 'rsmgrpolicy.config' file... Everything worked like a
> > charm after that.. Hope that helps you....
> >
> > "Minas Papageorgiou" wrote:
> >
> > > I have the same problem. Any luck with it?
> > >
> > > "Aparna" wrote:
> > >
> > > > Hi,
> > > > I am trying to implement a custom security extension using the Forms Auth
> > > > example provided by Microsoft. When i type in http://localhost/ReportServer,
> > > > I can see the Logon.aspx page. But when i type in http://localhost/Reports/,
> > > > I get a parser error saying:
> > > > ----
> > > > Parser Error
> > > > Description: An error occurred during the parsing of a resource required to
> > > > service this request. Please review the following specific parse error
> > > > details and modify your source file appropriately.
> > > > Parser Error Message: Could not load type
> > > > 'Microsoft.Samples.ReportingServices.CustomSecurity.UILogon'.
> > > > Source Error:
> > > > Line 1: <%@. Page language="c#" Codebehind="UILogon.aspx.cs"
> > > > AutoEventWireup="false"
> > > > Inherits="Microsoft.Samples.ReportingServices.CustomSecurity.UILogon" %>
> > > > Line 2: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > > > Line 3: <HTML>
> > > >
> > > > Source File: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > > Services\ReportManager\Pages\UILogon.aspx Line: 1
> > > > -----
> > > > Seems like it might have something to do wht permissions on the dll...Did
> > > > anyone have this problem? Or any ideas why this is happening?|||Do not use localhost as url path. U can try giving your machine name and
check if that works.
Under C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer:
open the web.config file.
Under appSettings tag change url path like:
<add key="ReportServer"
value="</add>">http://ApplicationServerName.YOurCompanyName.com/ReportServer"></add>
<add key="ReportServerExternalUrl"
value="</add>">http://ApplicationServerName.YOurCompanyName.com/ReportServer"></add>
Under C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager:
Open RSWebApplication.config:
Under Configuration tag:
<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://ApplicationServerName.YOurCompanyName.com/ReportServer</ReportServerUrl>
</UI>
I had the same issue.
Im assuming that you are using Form Authentication Code as in:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
Good luck!
Rajesh
"Minas Papageorgiou" wrote:
> Are you using Enterprise Edition of SQL'
>
> "Aparna" wrote:
> > Yeah, i later realized that I accidentally changed the wrong config file i.e.
> > I gave the 'My Computer' code group 'Full Trust' in the rssrvpolicy.config
> > file, in stead of the 'rsmgrpolicy.config' file... Everything worked like a
> > charm after that.. Hope that helps you....
> >
> > "Minas Papageorgiou" wrote:
> >
> > > I have the same problem. Any luck with it?
> > >
> > > "Aparna" wrote:
> > >
> > > > Hi,
> > > > I am trying to implement a custom security extension using the Forms Auth
> > > > example provided by Microsoft. When i type in http://localhost/ReportServer,
> > > > I can see the Logon.aspx page. But when i type in http://localhost/Reports/,
> > > > I get a parser error saying:
> > > > ----
> > > > Parser Error
> > > > Description: An error occurred during the parsing of a resource required to
> > > > service this request. Please review the following specific parse error
> > > > details and modify your source file appropriately.
> > > > Parser Error Message: Could not load type
> > > > 'Microsoft.Samples.ReportingServices.CustomSecurity.UILogon'.
> > > > Source Error:
> > > > Line 1: <%@. Page language="c#" Codebehind="UILogon.aspx.cs"
> > > > AutoEventWireup="false"
> > > > Inherits="Microsoft.Samples.ReportingServices.CustomSecurity.UILogon" %>
> > > > Line 2: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > > > Line 3: <HTML>
> > > >
> > > > Source File: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > > Services\ReportManager\Pages\UILogon.aspx Line: 1
> > > > -----
> > > > Seems like it might have something to do wht permissions on the dll...Did
> > > > anyone have this problem? Or any ideas why this is happening?|||I too am trying to use the security extenstions as explained here
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true
I am using SQL Server Standard edition but when I try to login to the sample
login form "UILogon.aspx" I get the error:
This operation is not supported in this edition of Reporting Services
(rsOperationNotSupported)
Are there different versions of Reporting Services or is the version taken
from the SQL Server edition?
Can't I use forms authentication with SQL Server Standard edition?
Please and thank you.
Greg
"Aparna" wrote:
> Hi,
> I am trying to implement a custom security extension using the Forms Auth
> example provided by Microsoft. When i type in http://localhost/ReportServer,
> I can see the Logon.aspx page. But when i type in http://localhost/Reports/,
> I get a parser error saying:
> ----
> Parser Error
> Description: An error occurred during the parsing of a resource required to
> service this request. Please review the following specific parse error
> details and modify your source file appropriately.
> Parser Error Message: Could not load type
> 'Microsoft.Samples.ReportingServices.CustomSecurity.UILogon'.
> Source Error:
> Line 1: <%@. Page language="c#" Codebehind="UILogon.aspx.cs"
> AutoEventWireup="false"
> Inherits="Microsoft.Samples.ReportingServices.CustomSecurity.UILogon" %>
> Line 2: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> Line 3: <HTML>
> Source File: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\Pages\UILogon.aspx Line: 1
> -----
> Seems like it might have something to do wht permissions on the dll...Did
> anyone have this problem? Or any ideas why this is happening?|||You need to use RS Enterprise edition for custom security extensions to
work.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_72jq.asp
"Greg Allan" <GregAllan@.discussions.microsoft.com> wrote in message
news:0C739298-5CD2-410D-8955-36A2B4B976DF@.microsoft.com...
>I too am trying to use the security extenstions as explained here:
> http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true
> I am using SQL Server Standard edition but when I try to login to the
> sample
> login form "UILogon.aspx" I get the error:
> This operation is not supported in this edition of Reporting Services
> (rsOperationNotSupported)
> Are there different versions of Reporting Services or is the version taken
> from the SQL Server edition?
> Can't I use forms authentication with SQL Server Standard edition?
> Please and thank you.
> Greg
>
> "Aparna" wrote:
>> Hi,
>> I am trying to implement a custom security extension using the Forms Auth
>> example provided by Microsoft. When i type in
>> http://localhost/ReportServer,
>> I can see the Logon.aspx page. But when i type in
>> http://localhost/Reports/,
>> I get a parser error saying:
>> ----
>> Parser Error
>> Description: An error occurred during the parsing of a resource required
>> to
>> service this request. Please review the following specific parse error
>> details and modify your source file appropriately.
>> Parser Error Message: Could not load type
>> 'Microsoft.Samples.ReportingServices.CustomSecurity.UILogon'.
>> Source Error:
>> Line 1: <%@. Page language="c#" Codebehind="UILogon.aspx.cs"
>> AutoEventWireup="false"
>> Inherits="Microsoft.Samples.ReportingServices.CustomSecurity.UILogon" %>
>> Line 2: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>> Line 3: <HTML>
>> Source File: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportManager\Pages\UILogon.aspx Line: 1
>> -----
>> Seems like it might have something to do wht permissions on the dll...Did
>> anyone have this problem? Or any ideas why this is happening?