Accessing Delivery Extension UI WebControls

hi,
We are developing a custom web application that will interact with the
Reporting Services web service (instead of using the ReportManager). I need
to manage subscriptions from my custom web app just like ReportManager does.
I would like to programmatically access the web controls located in each
extension dll (e-mail, fileshare, or my own custom dlls) used to gather
information from the client instead of having to write new ones. I know the
ReportManager accesses these objects (for example, the
PrinterDeliveryUIProvider in the printer delivery sample), so there must be a
way to do this. (Reflection?)
I couldn't find any helpful documentation (might have missed something), and
wondered if anyone knew how the best way to go about this.
Thanks,
MattThe Report Manager obtains the list of the registered UI controls from the
<DeliveryUI> element in the RSWebApplication.config file. Then, it proceeds
by loading dynamically the user control presumably by calling LoadControl().
Since the UI controls implement ISubscriptionBaseUIUserControl the Report
Manager knows how to manipulate them in a standard fashion.
You may find my custom Web Service delivery extension (included in the book
source code) useful to understand how the UI controls work.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"mshumaker" <mshumaker@.discussions.microsoft.com> wrote in message
news:14595C36-8130-481F-8DC9-7C356DF66314@.microsoft.com...
> hi,
> We are developing a custom web application that will interact with the
> Reporting Services web service (instead of using the ReportManager). I
need
> to manage subscriptions from my custom web app just like ReportManager
does.
> I would like to programmatically access the web controls located in each
> extension dll (e-mail, fileshare, or my own custom dlls) used to gather
> information from the client instead of having to write new ones. I know
the
> ReportManager accesses these objects (for example, the
> PrinterDeliveryUIProvider in the printer delivery sample), so there must
be a
> way to do this. (Reflection?)
> I couldn't find any helpful documentation (might have missed something),
and
> wondered if anyone knew how the best way to go about this.
> Thanks,
> Matt|||Ah, that would be the link I was looking for. I focused on obtaining the
info straight from the ReportServer and didn't think of using my own config
file. And after the time I've already spent with the config files while
getting my custom delivery extension to work...
I will also look into the LoadControl() method.
Thanks for your help.
Matt
"Teo Lachev [MVP]" wrote:
> The Report Manager obtains the list of the registered UI controls from the
> <DeliveryUI> element in the RSWebApplication.config file. Then, it proceeds
> by loading dynamically the user control presumably by calling LoadControl().
> Since the UI controls implement ISubscriptionBaseUIUserControl the Report
> Manager knows how to manipulate them in a standard fashion.
> You may find my custom Web Service delivery extension (included in the book
> source code) useful to understand how the UI controls work.
> --
> Hope this helps.
>|||LoadControl() won't work - it loads a UserControl where a control used for a
delivery extension UI is a WebControl.
I'll look into this more - maybe try loading it with reflection.
"mshumaker" wrote:
> Ah, that would be the link I was looking for. I focused on obtaining the
> info straight from the ReportServer and didn't think of using my own config
> file. And after the time I've already spent with the config files while
> getting my custom delivery extension to work...
> I will also look into the LoadControl() method.
> Thanks for your help.
> Matt
>
> "Teo Lachev [MVP]" wrote:
> > The Report Manager obtains the list of the registered UI controls from the
> > <DeliveryUI> element in the RSWebApplication.config file. Then, it proceeds
> > by loading dynamically the user control presumably by calling LoadControl().
> > Since the UI controls implement ISubscriptionBaseUIUserControl the Report
> > Manager knows how to manipulate them in a standard fashion.
> >
> > You may find my custom Web Service delivery extension (included in the book
> > source code) useful to understand how the UI controls work.
> >
> > --
> > Hope this helps.
> >
>|||My bad :-)
Than, it is probably dynamically loading the assembly using Load or LoadFrom
and adding the control to a placeholder, e.g.
PlaceHolder1.Controls.Add(ctrl);
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"mshumaker" <mshumaker@.discussions.microsoft.com> wrote in message
news:01BF60A4-B199-4A2C-B494-5741ADAD650E@.microsoft.com...
> LoadControl() won't work - it loads a UserControl where a control used for
a
> delivery extension UI is a WebControl.
> I'll look into this more - maybe try loading it with reflection.
> "mshumaker" wrote:
> >
> > Ah, that would be the link I was looking for. I focused on obtaining
the
> > info straight from the ReportServer and didn't think of using my own
config
> > file. And after the time I've already spent with the config files while
> > getting my custom delivery extension to work...
> >
> > I will also look into the LoadControl() method.
> >
> > Thanks for your help.
> > Matt
> >
> >
> > "Teo Lachev [MVP]" wrote:
> >
> > > The Report Manager obtains the list of the registered UI controls from
the
> > > <DeliveryUI> element in the RSWebApplication.config file. Then, it
proceeds
> > > by loading dynamically the user control presumably by calling
LoadControl().
> > > Since the UI controls implement ISubscriptionBaseUIUserControl the
Report
> > > Manager knows how to manipulate them in a standard fashion.
> > >
> > > You may find my custom Web Service delivery extension (included in the
book
> > > source code) useful to understand how the UI controls work.
> > >
> > > --
> > > Hope this helps.
> > >
> >

Accessing columns using fully qualified name from a Join

1) I'm connecting to SQLServer2000 using Microsoft SQL Server 2000 Driver for
JDBC, Service Pack 2, Version 2.2.0037
2) The query I'm executing is:
select * from employees, dept, city where dept.dpid=employees.dept and " +
"employees.cityofresidence=city.cid order by dept.dpid, empid
3) city and dept tables have a field called 'name'
4) rs.getString("name") gives dept.name (city.name if city appears before
dept in the FROM clause of the query)
5) rs.getString("city.name") throws exception - 'Invalid column name'
How can I use the fully qualified column name to retrieve correct values
irrespective of the order of the appearance of the table names in the FROM
clause of the query
Note: rs.getString(int col_num) always retrieves correct values.
praskam wrote:

> 1) I'm connecting to SQLServer2000 using Microsoft SQL Server 2000 Driver for
> JDBC, Service Pack 2, Version 2.2.0037
> 2) The query I'm executing is:
> select * from employees, dept, city where dept.dpid=employees.dept and " +
> "employees.cityofresidence=city.cid order by dept.dpid, empid
> 3) city and dept tables have a field called 'name'
> 4) rs.getString("name") gives dept.name (city.name if city appears before
> dept in the FROM clause of the query)
That is correct, per JDBC spec.

> 5) rs.getString("city.name") throws exception - 'Invalid column name'
The data/metadata that come back from the DBMS do not contain any reference to the
table from which a column came.

> How can I use the fully qualified column name to retrieve correct values
> irrespective of the order of the appearance of the table names in the FROM
> clause of the query.
You can't. Unless you explicitly define a label for each column in the SQL.
That would involve replacing "select *" with select t1.col1 'table1.col1', t1.col2 'table1.col2' ...
t2.col1 'table2.col1' etc. from table1 t1, table2 t2 etc.
Note that you can use any string for a column label. Using "table1.col1" would suit your
request, but you could tailor it as you see fit.
Joe Weinstein at BEA

> Note: rs.getString(int col_num) always retrieves correct values.
As expected, and is the most reliable.
>

Accessing ASPNETDB from outside web application

Hi there,

I have a slight problem. I have a web service running on my server. In this, I need to access values in User's profiles. The problem is of course, that Profile, ProfileCommon, ProfileBase, etc... are not available to me here.

What can I do?

Is using an SQL command best? If so, could someone post an example SQL command - I am getting confused by how to structure the command, since I need Membership data like UserName, and Profile data (an object serialized as binary in the Profile).

Kind regards,

kreid

Hi Kreid,

To share the ASPNETDB to another application, you will need to attach the database to an instance of SQL Server. Then change the connection string of both applications to point to that database.

|||

Hi Kevin,

I'm having the sampe problem even though I have my ASPNETDB in an SQL-server. After thoroughly checking the interfaces, and forums, there is apparently no way to access the Profile from a console application. Certainly, I can do a LINQ query and get the Profile properties string and values string from the ASPNETDB, but then parse them myself etc.? There must be a better way? Any tips/examples out there?

Thanks!

Richard

|||

The Solution:

http://blogs.msdn.com/msdnts/archive/2006/12/16/asp-net-2-0-membership-role-management-out-of-asp-net-context.aspx

Accessing Analysis Services 2005 from MS Excel using HTTP from Windows 2000 Server

Hye Friends,
I have installed and configured SQL Server 2005 Analysis Services and MS Office 2000 with the latest Service Packs on Windows 2000 Server. I am able to connect to my Analysis Services from MS Excel using the following URl in Excel ...
http://<ip address>/olap/msmdpump.dll ("olap" being my Virtual Directory)
I was wondering whether I would be able to connect to the same service without using the fully qualified path with only IP-Address... i.e... using only
http://<ip address>
I have been able to implement the above in Windows 2003 Server, but having problems doing the same in Windows 2000 Server. Can anyone help?
Thanks in Advance

How were you able to do so in Windows 2003? I've tried using IIS 6.0 to redirect, but without success.

Accessing a web service using clr in SQL 2005

I need to access a billing webservice from SQL. I createde a new c# class project and made a web refrence to the web service "ProdBilling".

Here is the code of my assembly

using System.Data;
using Microsoft.SqlServer.Server;
using System.Data.SqlTypes;
namespace PaymentProc
{
public class PaymentProc
{
[Microsoft.SqlServer.Server.SqlProcedure]
public static void ChargeCard(int account, int amount)
{
string Response;
ProdBilling.Service serv = new ProdBilling.Service();
Response = serv.ChargeCard(account, amount);
SqlContext.Pipe.Send(Response);
}
}
}

I then ran WSDL

wsdl /oaymentProc.cs /naymentProc http://ProdWeb1/PaymentProc/PaymentProc.asmx

Then compliled

csc /target:library PaymentProc.cs

and added the assembly
CREATE ASSEMBLY PaymentProc from 'D:\ProdCode\PaymentProc.dll' WITH
PERMISSION_SET = UNSAFE

I cannot figure out how to refrence the chargecard method

I have tried

CREATE PROCEDURE PaymentProc
@.Account int,
@.Amount int
AS
EXTERNAL NAME PaymentProc.[PaymentProc.PaymentProc].ChargeCard

It seems wsdl.exe put all this serialization code

namespace PaymentProc {
using System.Diagnostics;
using System.Web.Services;
using System.ComponentModel;
using System.Web.Services.Protocols;
using System;
using System.Xml.Serialization;

///
[System.CodeDom.Compiler.GeneratedCodeAttribute("wsdl", "2.0.50727.42")]
[System.Diagnostics.DebuggerStepThroughAttribute()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Web.Services.WebServiceBindingAttribute(Name="ServiceSoap", Namespace="http://ProdWeb1/PaymentProc")]
public partial class PaymentProc : System.Web.Services.Protocols.SoapHttpClientProtocol {

private System.Threading.SendOrPostCallback ChargeCardOperationCompleted;

///
public PaymentProc()
{
this.Url = "http://ProdWeb1/PaymentProc/PaymentProc.asmx";
}

///
public event ChargeCardCompletedEventHandler ChargeCardCompleted;

///
[System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://ProdWeb1/PaymentProc/ChargeCard", RequestNamespace="http://ProdWeb1/PaymentProc", ResponseNamespace="http://ProdWeb1/PaymentProc", Use=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
public string ChargeCard(int account, int amount) {
object[] results = this.Invoke("ChargeCard", new object[] {
account,
amount});
return ((string)(results[0]));
}
.................

When I run

CREATE PROCEDURE PaymentProc
@.Account int,
@.Amount int
AS
EXTERNAL NAME PaymentProc.[PaymentProc.PaymentProc].ChargeCard

I get error

Method, property or field 'ChargeCard' of class 'PaymentProc.PaymentProc' in assembly 'PaymentProc' is not static.

Any ideas? This seemsed so straitforward in the beginning.

Change your ChargeCard CLR method (the one you are marking as a proc) to some other name, and then change the CREATE PROCEDURE statement to use that changed name. That should hopefully do it.

Niels
|||

I think my problem originates from the fact that you cannot complie an assembly using a web refrence using csc. I redesigned my assembly with a web refrence to http://ProdWeb1/PaymentProc/PaymentProc.asmx called ProdBilling which I can test operation ChargeCard successfully.

using System;

using System.Collections.Generic;

using System.Text;

namespace PayProcAssembly

{

public class PaymentProcessing

{

[Microsoft.SqlServer.Server.SqlProcedure]

public static string ChargeCard(int Account, float Amount)

{

ProdBilling.PayProcessing serv = new ProdBilling.PayProcessing();

string result = serv.ChargeCard(Account, Amount);

SqlContext.Pipe.Send(result);

}

}

}

When I run

csc /target:library PaymentProcessing.cs

I get

Error: The type or namespace name 'ProdBilling could not be found (are you missing a using directive or an assembly reference?)

I was told I needed to create a proxy using WSDL.exe but it seems when I ran

wsdl /o PaymentProc.cs /n PaymentProc http://ProdWeb1/PaymentProc/PaymentProc.asmx

It messed up my code. I cant even find the web refrence anymore. Is this correct that I have to use wsdl or is there an easier way?

Accessing a web service using clr in SQL 2005

I need to access a billing webservice from SQL. I createde a new c# class project and made a web refrence to the web service "ProdBilling".

Here is the code of my assembly

using System.Data;
using Microsoft.SqlServer.Server;
using System.Data.SqlTypes;
namespace PaymentProc
{
public class PaymentProc
{
[Microsoft.SqlServer.Server.SqlProcedure]
public static void ChargeCard(int account, int amount)
{
string Response;
ProdBilling.Service serv = new ProdBilling.Service();
Response = serv.ChargeCard(account, amount);
SqlContext.Pipe.Send(Response);
}
}
}

I then ran WSDL

wsdl /oaymentProc.cs /naymentProc http://ProdWeb1/PaymentProc/PaymentProc.asmx

Then compliled

csc /target:library PaymentProc.cs

and added the assembly
CREATE ASSEMBLY PaymentProc from 'D:\ProdCode\PaymentProc.dll' WITH
PERMISSION_SET = UNSAFE

I cannot figure out how to refrence the chargecard method

I have tried

CREATE PROCEDURE PaymentProc
@.Account int,
@.Amount int
AS
EXTERNAL NAME PaymentProc.[PaymentProc.PaymentProc].ChargeCard

It seems wsdl.exe put all this serialization code

namespace PaymentProc {
using System.Diagnostics;
using System.Web.Services;
using System.ComponentModel;
using System.Web.Services.Protocols;
using System;
using System.Xml.Serialization;

///
[System.CodeDom.Compiler.GeneratedCodeAttribute("wsdl", "2.0.50727.42")]
[System.Diagnostics.DebuggerStepThroughAttribute()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Web.Services.WebServiceBindingAttribute(Name="ServiceSoap", Namespace="http://ProdWeb1/PaymentProc")]
public partial class PaymentProc : System.Web.Services.Protocols.SoapHttpClientProtocol {

private System.Threading.SendOrPostCallback ChargeCardOperationCompleted;

///
public PaymentProc()
{
this.Url = "http://ProdWeb1/PaymentProc/PaymentProc.asmx";
}

///
public event ChargeCardCompletedEventHandler ChargeCardCompleted;

///
[System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://ProdWeb1/PaymentProc/ChargeCard", RequestNamespace="http://ProdWeb1/PaymentProc", ResponseNamespace="http://ProdWeb1/PaymentProc", Use=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
public string ChargeCard(int account, int amount) {
object[] results = this.Invoke("ChargeCard", new object[] {
account,
amount});
return ((string)(results[0]));
}
.................

When I run

CREATE PROCEDURE PaymentProc
@.Account int,
@.Amount int
AS
EXTERNAL NAME PaymentProc.[PaymentProc.PaymentProc].ChargeCard

I get error

Method, property or field 'ChargeCard' of class 'PaymentProc.PaymentProc' in assembly 'PaymentProc' is not static.

Any ideas? This seemsed so straitforward in the beginning.

Change your ChargeCard CLR method (the one you are marking as a proc) to some other name, and then change the CREATE PROCEDURE statement to use that changed name. That should hopefully do it.

Niels
|||

I think my problem originates from the fact that you cannot complie an assembly using a web refrence using csc. I redesigned my assembly with a web refrence to http://ProdWeb1/PaymentProc/PaymentProc.asmx called ProdBilling which I can test operation ChargeCard successfully.

using System;

using System.Collections.Generic;

using System.Text;

namespace PayProcAssembly

{

public class PaymentProcessing

{

[Microsoft.SqlServer.Server.SqlProcedure]

public static string ChargeCard(int Account, float Amount)

{

ProdBilling.PayProcessing serv = new ProdBilling.PayProcessing();

string result = serv.ChargeCard(Account, Amount);

SqlContext.Pipe.Send(result);

}

}

}

When I run

csc /target:library PaymentProcessing.cs

I get

Error: The type or namespace name 'ProdBilling could not be found (are you missing a using directive or an assembly reference?)

I was told I needed to create a proxy using WSDL.exe but it seems when I ran

wsdl /o PaymentProc.cs /n PaymentProc http://ProdWeb1/PaymentProc/PaymentProc.asmx

It messed up my code. I cant even find the web refrence anymore. Is this correct that I have to use wsdl or is there an easier way?

Access to SQL Server via WCF works only part time

We have 2 databases ( Guider and Talker ) and we have a WCF service that is logged in with a domain identity.

In our SQL Server we have the service ID added to the Data Server Logins and both Guider and Talker are given access to the user.

When we access Guider we have no problems getting data.

When we access Talker we have a login failure:

Cannot open database 'Talker' requested by the login. The login failed.

Login failed for user 'Acorn\CommunicationServices'.

The thing that gets me is that the user is created at the Server level, in both Databases, and at the server level both databases are checked for the user. master has been set as the default database for the user.

Basically, as far as I can see Talker and Guider are configured identically! So I cannot figure out why I cannot login to the second database!

Is there a specific setting I'm missing somewhere to grant login access to the user? I'm using

Management Studio Express to manage the database.

My guess here is that the default database defined for the login that fails (Acorn\CommunicationServices) is not configured properly. Another possibility may be a typo when specifying the DB name in the client.

One test you can try to verify if the principal can really access the DB is:

*Connect as a sysadmin

* run “EXECUTE AS LOGIN = ‘login_name’ “ to impersonate the principal

* USE [Talker]

I hope this helps,

-Raul Garcia

SDE/T

SQL Server Engine

Access to SQL Server via WCF works only part time

We have 2 databases ( Guider and Talker ) and we have a WCF service that is logged in with a domain identity.

In our SQL Server we have the service ID added to the Data Server Logins and both Guider and Talker are given access to the user.

When we access Guider we have no problems getting data.

When we access Talker we have a login failure:

Cannot open database 'Talker' requested by the login. The login failed.

Login failed for user 'Acorn\CommunicationServices'.

The thing that gets me is that the user is created at the Server level, in both Databases, and at the server level both databases are checked for the user. master has been set as the default database for the user.

Basically, as far as I can see Talker and Guider are configured identically! So I cannot figure out why I cannot login to the second database!

Is there a specific setting I'm missing somewhere to grant login access to the user? I'm using

Management Studio Express to manage the database.

My guess here is that the default database defined for the login that fails (Acorn\CommunicationServices) is not configured properly. Another possibility may be a typo when specifying the DB name in the client.

One test you can try to verify if the principal can really access the DB is:

*Connect as a sysadmin

* run “EXECUTE AS LOGIN = ‘login_name’ “ to impersonate the principal

* USE [Talker]

I hope this helps,

-Raul Garcia

SDE/T

SQL Server Engine

Access to SQL Server System Logs

I'm a developer and mostly develop Service Broker applications for my company. I do have logging for my application but unforseen errors will normally show up in the SQL Server System Logs. What would be a good way to give a developer access to read the SQL Server logs without giving away the keys to kingdom. Would that be through xp_readerrorlog or is there a better way of accomplishing this?Hi,

no this is the most common way to do this.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Access Reporting Web Service from a remote computer

I just installed SQL Server 2005 and reporting services in my home
computer (XP). From a different computer in my basement connected via
peer to peer network I am able to connect to SQL Server installed in
the computer upstairs byusing a SQL Server login.
I have installed only the client components of SQL Server 2005 in my
computer at the basement. I am now trying to add a web reference to
the reporting services web services from my computer in the basement
by typing in
URL:http:/servername/reportserver/reportservice2005.asmx?wsdl
but I get the following error...
"The page cannot be displayed
The page you are looking for is currently unavailable. The Web site
might be experiencing technical difficulties, or you may need to
adjust your browser settings. "
What am I doing wrong? I am new to this so it is very likely that I am
doing something wrong.
I am able to access page when I paste the same URL in my computer
upstairs where I instaled the reporting services.
My main objective is to try and call the RS web services from the
computer in the basement.
My question is what do I need to do so that I can add web references
of reporting services from a remote computer?
Any help in this reagrd will be greatly appreciated. Any links
pertaining to this will also be very helpful.
ThanksHey why dont you write some asp.net code using web services. I dont know why
you are using directly URL, moreover to do what ?
To access remote of web services you need to change it in config about the
state server settings.
Amarnath
"shub" wrote:
> I just installed SQL Server 2005 and reporting services in my home
> computer (XP). From a different computer in my basement connected via
> peer to peer network I am able to connect to SQL Server installed in
> the computer upstairs byusing a SQL Server login.
> I have installed only the client components of SQL Server 2005 in my
> computer at the basement. I am now trying to add a web reference to
> the reporting services web services from my computer in the basement
> by typing in
> URL:http:/servername/reportserver/reportservice2005.asmx?wsdl
> but I get the following error...
> "The page cannot be displayed
> The page you are looking for is currently unavailable. The Web site
> might be experiencing technical difficulties, or you may need to
> adjust your browser settings. "
> What am I doing wrong? I am new to this so it is very likely that I am
> doing something wrong.
> I am able to access page when I paste the same URL in my computer
> upstairs where I instaled the reporting services.
> My main objective is to try and call the RS web services from the
> computer in the basement.
> My question is what do I need to do so that I can add web references
> of reporting services from a remote computer?
> Any help in this reagrd will be greatly appreciated. Any links
> pertaining to this will also be very helpful.
> Thanks
>

access is denied when starting service

We have a user who could start and stop the sql server service through EM at
one time and then he started getting an "error 5 (access is denied) occurred
while performing this service operation on the MSSQLServer service."
I removed his login and created a new one for him and gave him sysadmin
permissions but he still gets the same error when trying to start the
service.
Any ideas?
Thanks,
--
Dan D.Starting/ stopping services are OS specific. Make sure he's allowed to do
this at the OS level, also make sure that his password is correct in EM. Did
he change his password since the lat time he was able to do this?
--
TIA,
ChrisR
"Dan D." wrote:

> We have a user who could start and stop the sql server service through EM
at
> one time and then he started getting an "error 5 (access is denied) occurr
ed
> while performing this service operation on the MSSQLServer service."
> I removed his login and created a new one for him and gave him sysadmin
> permissions but he still gets the same error when trying to start the
> service.
> Any ideas?
> Thanks,
> --
> Dan D.|||I saw this recently when some of our users switched to a new Win 2003
domain.
We had forgotten to set them up in sql server.
Paul
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:7BB943F7-C48F-406A-A44D-22C200686A8C@.microsoft.com...[vbcol=seagreen]
> Starting/ stopping services are OS specific. Make sure he's allowed to do
> this at the OS level, also make sure that his password is correct in EM.
> Did
> he change his password since the lat time he was able to do this?
> --
> TIA,
> ChrisR
>
> "Dan D." wrote:
>|||They have logins in sqlserver and they are sysadmins in sqlserver.
--
Dan D.
"Paul Cahill" wrote:

> I saw this recently when some of our users switched to a new Win 2003
> domain.
> We had forgotten to set them up in sql server.
> Paul
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:7BB943F7-C48F-406A-A44D-22C200686A8C@.microsoft.com...
>
>|||I'm thinking it is OS related too. They also can't stop and start IIS. They
say they haven't changed their passwords recently.
--
Dan D.
"ChrisR" wrote:
[vbcol=seagreen]
> Starting/ stopping services are OS specific. Make sure he's allowed to do
> this at the OS level, also make sure that his password is correct in EM. D
id
> he change his password since the lat time he was able to do this?
> --
> TIA,
> ChrisR
>
> "Dan D." wrote:
>|||Another thing that happened with our new domain.
One of my colleagues (a user on our old domain) mapped a drive on the new
domain as the NEWDOMAIN\administrator (remember by password).
We then noticed that when he connected to an SQL Server on the new domain he
was logging in as NEWDOMAIN\administrator and not his OLDDOMAIN\username.
Ie the authentication of network resources affects sql server too. I guess
this makes sense but caught me out.
Maybe not the same issue for you but it looks like an authentication issue
of some sort.
Paul
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:90E92723-FA30-48F4-9415-50A4A0EF8797@.microsoft.com...[vbcol=seagreen]
> I'm thinking it is OS related too. They also can't stop and start IIS.
> They
> say they haven't changed their passwords recently.
> --
> Dan D.
>
> "ChrisR" wrote:
>

access is denied when starting service

We have a user who could start and stop the sql server service through EM at
one time and then he started getting an "error 5 (access is denied) occurred
while performing this service operation on the MSSQLServer service."
I removed his login and created a new one for him and gave him sysadmin
permissions but he still gets the same error when trying to start the
service.
Any ideas?
Thanks,
Dan D.
Starting/ stopping services are OS specific. Make sure he's allowed to do
this at the OS level, also make sure that his password is correct in EM. Did
he change his password since the lat time he was able to do this?
TIA,
ChrisR
"Dan D." wrote:

> We have a user who could start and stop the sql server service through EM at
> one time and then he started getting an "error 5 (access is denied) occurred
> while performing this service operation on the MSSQLServer service."
> I removed his login and created a new one for him and gave him sysadmin
> permissions but he still gets the same error when trying to start the
> service.
> Any ideas?
> Thanks,
> --
> Dan D.
|||I saw this recently when some of our users switched to a new Win 2003
domain.
We had forgotten to set them up in sql server.
Paul
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:7BB943F7-C48F-406A-A44D-22C200686A8C@.microsoft.com...[vbcol=seagreen]
> Starting/ stopping services are OS specific. Make sure he's allowed to do
> this at the OS level, also make sure that his password is correct in EM.
> Did
> he change his password since the lat time he was able to do this?
> --
> TIA,
> ChrisR
>
> "Dan D." wrote:
|||They have logins in sqlserver and they are sysadmins in sqlserver.
Dan D.
"Paul Cahill" wrote:

> I saw this recently when some of our users switched to a new Win 2003
> domain.
> We had forgotten to set them up in sql server.
> Paul
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:7BB943F7-C48F-406A-A44D-22C200686A8C@.microsoft.com...
>
>
|||I'm thinking it is OS related too. They also can't stop and start IIS. They
say they haven't changed their passwords recently.
Dan D.
"ChrisR" wrote:
[vbcol=seagreen]
> Starting/ stopping services are OS specific. Make sure he's allowed to do
> this at the OS level, also make sure that his password is correct in EM. Did
> he change his password since the lat time he was able to do this?
> --
> TIA,
> ChrisR
>
> "Dan D." wrote:
|||Another thing that happened with our new domain.
One of my colleagues (a user on our old domain) mapped a drive on the new
domain as the NEWDOMAIN\administrator (remember by password).
We then noticed that when he connected to an SQL Server on the new domain he
was logging in as NEWDOMAIN\administrator and not his OLDDOMAIN\username.
Ie the authentication of network resources affects sql server too. I guess
this makes sense but caught me out.
Maybe not the same issue for you but it looks like an authentication issue
of some sort.
Paul
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:90E92723-FA30-48F4-9415-50A4A0EF8797@.microsoft.com...[vbcol=seagreen]
> I'm thinking it is OS related too. They also can't stop and start IIS.
> They
> say they haven't changed their passwords recently.
> --
> Dan D.
>
> "ChrisR" wrote:

access is denied when starting service

We have a user who could start and stop the sql server service through EM at
one time and then he started getting an "error 5 (access is denied) occurred
while performing this service operation on the MSSQLServer service."
I removed his login and created a new one for him and gave him sysadmin
permissions but he still gets the same error when trying to start the
service.
Any ideas?
Thanks,
--
Dan D.Starting/ stopping services are OS specific. Make sure he's allowed to do
this at the OS level, also make sure that his password is correct in EM. Did
he change his password since the lat time he was able to do this?
--
TIA,
ChrisR
"Dan D." wrote:
> We have a user who could start and stop the sql server service through EM at
> one time and then he started getting an "error 5 (access is denied) occurred
> while performing this service operation on the MSSQLServer service."
> I removed his login and created a new one for him and gave him sysadmin
> permissions but he still gets the same error when trying to start the
> service.
> Any ideas?
> Thanks,
> --
> Dan D.|||I saw this recently when some of our users switched to a new Win 2003
domain.
We had forgotten to set them up in sql server.
Paul
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:7BB943F7-C48F-406A-A44D-22C200686A8C@.microsoft.com...
> Starting/ stopping services are OS specific. Make sure he's allowed to do
> this at the OS level, also make sure that his password is correct in EM.
> Did
> he change his password since the lat time he was able to do this?
> --
> TIA,
> ChrisR
>
> "Dan D." wrote:
>> We have a user who could start and stop the sql server service through EM
>> at
>> one time and then he started getting an "error 5 (access is denied)
>> occurred
>> while performing this service operation on the MSSQLServer service."
>> I removed his login and created a new one for him and gave him sysadmin
>> permissions but he still gets the same error when trying to start the
>> service.
>> Any ideas?
>> Thanks,
>> --
>> Dan D.|||They have logins in sqlserver and they are sysadmins in sqlserver.
--
Dan D.
"Paul Cahill" wrote:
> I saw this recently when some of our users switched to a new Win 2003
> domain.
> We had forgotten to set them up in sql server.
> Paul
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:7BB943F7-C48F-406A-A44D-22C200686A8C@.microsoft.com...
> > Starting/ stopping services are OS specific. Make sure he's allowed to do
> > this at the OS level, also make sure that his password is correct in EM.
> > Did
> > he change his password since the lat time he was able to do this?
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Dan D." wrote:
> >
> >> We have a user who could start and stop the sql server service through EM
> >> at
> >> one time and then he started getting an "error 5 (access is denied)
> >> occurred
> >> while performing this service operation on the MSSQLServer service."
> >>
> >> I removed his login and created a new one for him and gave him sysadmin
> >> permissions but he still gets the same error when trying to start the
> >> service.
> >>
> >> Any ideas?
> >>
> >> Thanks,
> >> --
> >> Dan D.
>
>|||I'm thinking it is OS related too. They also can't stop and start IIS. They
say they haven't changed their passwords recently.
--
Dan D.
"ChrisR" wrote:
> Starting/ stopping services are OS specific. Make sure he's allowed to do
> this at the OS level, also make sure that his password is correct in EM. Did
> he change his password since the lat time he was able to do this?
> --
> TIA,
> ChrisR
>
> "Dan D." wrote:
> > We have a user who could start and stop the sql server service through EM at
> > one time and then he started getting an "error 5 (access is denied) occurred
> > while performing this service operation on the MSSQLServer service."
> >
> > I removed his login and created a new one for him and gave him sysadmin
> > permissions but he still gets the same error when trying to start the
> > service.
> >
> > Any ideas?
> >
> > Thanks,
> > --
> > Dan D.|||Another thing that happened with our new domain.
One of my colleagues (a user on our old domain) mapped a drive on the new
domain as the NEWDOMAIN\administrator (remember by password).
We then noticed that when he connected to an SQL Server on the new domain he
was logging in as NEWDOMAIN\administrator and not his OLDDOMAIN\username.
Ie the authentication of network resources affects sql server too. I guess
this makes sense but caught me out.
Maybe not the same issue for you but it looks like an authentication issue
of some sort.
Paul
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:90E92723-FA30-48F4-9415-50A4A0EF8797@.microsoft.com...
> I'm thinking it is OS related too. They also can't stop and start IIS.
> They
> say they haven't changed their passwords recently.
> --
> Dan D.
>
> "ChrisR" wrote:
>> Starting/ stopping services are OS specific. Make sure he's allowed to do
>> this at the OS level, also make sure that his password is correct in EM.
>> Did
>> he change his password since the lat time he was able to do this?
>> --
>> TIA,
>> ChrisR
>>
>> "Dan D." wrote:
>> > We have a user who could start and stop the sql server service through
>> > EM at
>> > one time and then he started getting an "error 5 (access is denied)
>> > occurred
>> > while performing this service operation on the MSSQLServer service."
>> >
>> > I removed his login and created a new one for him and gave him sysadmin
>> > permissions but he still gets the same error when trying to start the
>> > service.
>> >
>> > Any ideas?
>> >
>> > Thanks,
>> > --
>> > Dan D.

Access denied problem when calling Webserivce

I 'm calling a web service using this code:
ReportingService service = new ReportingService();
service.Credentials = System.Net.CredentialCache.DefaultCredentials;
I was getting an "Access Denied" everytime, but it works when I use this
code :
ReportingService service = new ReportingService();
service.Credentials = new
NetworkCredential("myLogin","myPassword","myDomaine");
I have enabled impersonation by adding <identity impersonate="true" /> to my
web config and we are using windows authentication.What else should I add in
order to get it up and workin?
ThanksHi,
I think you're under IIS. So, you've got to check if you have disabled
'Anonymous Authentication' for your website. You can do this in IIS
Administration. Open the properties box for your WebSite, and go to
'Folder security" and click "modify". I work only with french versions
of IIS, sorry if the properties names i wrote are wrong.
Hope it helps.|||I think it impersonates asp.net wp account or network_service account.
Actually the best way is create a user with no privilages, and from report
mager give that user just "browse" right, and use that user within your
code.
"David DOS SANTOS" <david.dosantos@.gmail.com> wrote in message
news:1117102512.934187.161630@.o13g2000cwo.googlegroups.com...
> Hi,
> I think you're under IIS. So, you've got to check if you have disabled
> 'Anonymous Authentication' for your website. You can do this in IIS
> Administration. Open the properties box for your WebSite, and go to
> 'Folder security" and click "modify". I work only with french versions
> of IIS, sorry if the properties names i wrote are wrong.
> Hope it helps.
>|||The problem is that They have installed reporting services and our asp.net
application in the **same box** (which I know is not a good idea,but why I
don't know).Therefore that problem should not exist because as you mentioned
that's for the time you have reporting services and your app in two
different places.
I think I found the problem ,the person who has this problem is opening
another thread(than the asp.net thread) to call the webservice and the
reason he get the second logon page is that the token is not transfered from
the main thread to his newly-opened thread.
Can you guide me to something which shows the advantagesa dn disadvantages
of having RS and the main application in the same box?
Thanks|||I have been running in that configuration for over 2 years now without
many problems. In our case, we have a custom portal that provides rich
parameter-entry and improved report navigation which calls the Sql
Reporting Services webservice to render reports.
The only downside I have run across is the different performance
characteristics of our ASP.NET application as compared to Sql Reporting
Services. As a result, we had to scale-up our servers a bit higher
than for typical ASP.NET applications. However, this still allows us
to run with only 2 servers (2 load-balanced ASP.NET/Sql Reporting
servers) instead of 4 (2 load-balanced ASP.NET servers, and 2
loadbalanced Sql Reporting servers).
Technicically this is not even a problem, but just a decision of how
you want to scale your environment.
~Lance

Access denied on restart

The following error occures after installation of several
Hotfixes:
"The MSSQLServer service failed to start due to the
following error:
Access is denied."
It seems that the LocalSystem account cannot start the
MSSQL services. The service is temporarily started using
the domain admin account. I recently installed Hotfixes
KB824151, KB841533, KB840987, KB841356 en KB883935 on my
W2K SQL server, running SQL 7.0.
Before de-installing and restarting these hotfixes one-by-
one, i thought to have a try via this newsgroup.
TIA,
Wouter
Take a look in Books online... Search for Services Accounts.
There it details all of the requirements for permissions for the accounts...
The thing that is strange is that I have never , ever had any problems
starting SQL with localsystem...
If you have changed the account using control panel, services and are using
Full text search, you could cause a problem... In my opinion it is a best
practice to set up an account specifically for SQL Services login anyway...
Perhaps it is time you do that...
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
"Wouter" <anonymous@.discussions.microsoft.com> wrote in message
news:0f5b01c4d606$b1a624e0$a501280a@.phx.gbl...
> The following error occures after installation of several
> Hotfixes:
> "The MSSQLServer service failed to start due to the
> following error:
> Access is denied."
> It seems that the LocalSystem account cannot start the
> MSSQL services. The service is temporarily started using
> the domain admin account. I recently installed Hotfixes
> KB824151, KB841533, KB840987, KB841356 en KB883935 on my
> W2K SQL server, running SQL 7.0.
> Before de-installing and restarting these hotfixes one-by-
> one, i thought to have a try via this newsgroup.
> TIA,
> Wouter
|||Wayne,
Thanks for you reply. The thing is, we also never, ever
had problems starting SQL with the LocalSystem account,
untill I installed the hotfixes. I'm pretty sure un-
installing the hotfixes will solve my problem, but that is
not the general idea behind hotfixes, is it?
Any other suggestions? If not I'll consider creating a SQL
Services login account.
Wouter

>--Original Message--
>Take a look in Books online... Search for Services
Accounts.
>There it details all of the requirements for permissions
for the accounts...
>The thing that is strange is that I have never , ever had
any problems
>starting SQL with localsystem...
>If you have changed the account using control panel,
services and are using
>Full text search, you could cause a problem... In my
opinion it is a best
>practice to set up an account specifically for SQL
Services login anyway...
>Perhaps it is time you do that...
>--
>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
>"Wouter" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:0f5b01c4d606$b1a624e0$a501280a@.phx.gbl...
several[vbcol=seagreen]
by-
>
>.
>

Access denied on restart

The following error occures after installation of several
Hotfixes:
"The MSSQLServer service failed to start due to the
following error:
Access is denied."
It seems that the LocalSystem account cannot start the
MSSQL services. The service is temporarily started using
the domain admin account. I recently installed Hotfixes
KB824151, KB841533, KB840987, KB841356 en KB883935 on my
W2K SQL server, running SQL 7.0.
Before de-installing and restarting these hotfixes one-by-
one, i thought to have a try via this newsgroup.
TIA,
WouterTake a look in Books online... Search for Services Accounts.
There it details all of the requirements for permissions for the accounts...
The thing that is strange is that I have never , ever had any problems
starting SQL with localsystem...
If you have changed the account using control panel, services and are using
Full text search, you could cause a problem... In my opinion it is a best
practice to set up an account specifically for SQL Services login anyway...
Perhaps it is time you do that...
--
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
"Wouter" <anonymous@.discussions.microsoft.com> wrote in message
news:0f5b01c4d606$b1a624e0$a501280a@.phx.gbl...
> The following error occures after installation of several
> Hotfixes:
> "The MSSQLServer service failed to start due to the
> following error:
> Access is denied."
> It seems that the LocalSystem account cannot start the
> MSSQL services. The service is temporarily started using
> the domain admin account. I recently installed Hotfixes
> KB824151, KB841533, KB840987, KB841356 en KB883935 on my
> W2K SQL server, running SQL 7.0.
> Before de-installing and restarting these hotfixes one-by-
> one, i thought to have a try via this newsgroup.
> TIA,
> Wouter|||Wayne,
Thanks for you reply. The thing is, we also never, ever
had problems starting SQL with the LocalSystem account,
untill I installed the hotfixes. I'm pretty sure un-
installing the hotfixes will solve my problem, but that is
not the general idea behind hotfixes, is it?
Any other suggestions? If not I'll consider creating a SQL
Services login account.
Wouter
>--Original Message--
>Take a look in Books online... Search for Services
Accounts.
>There it details all of the requirements for permissions
for the accounts...
>The thing that is strange is that I have never , ever had
any problems
>starting SQL with localsystem...
>If you have changed the account using control panel,
services and are using
>Full text search, you could cause a problem... In my
opinion it is a best
>practice to set up an account specifically for SQL
Services login anyway...
>Perhaps it is time you do that...
>--
>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
>"Wouter" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0f5b01c4d606$b1a624e0$a501280a@.phx.gbl...
>> The following error occures after installation of
several
>> Hotfixes:
>> "The MSSQLServer service failed to start due to the
>> following error:
>> Access is denied."
>> It seems that the LocalSystem account cannot start the
>> MSSQL services. The service is temporarily started using
>> the domain admin account. I recently installed Hotfixes
>> KB824151, KB841533, KB840987, KB841356 en KB883935 on my
>> W2K SQL server, running SQL 7.0.
>> Before de-installing and restarting these hotfixes one-
by-
>> one, i thought to have a try via this newsgroup.
>> TIA,
>> Wouter
>
>.
>

Access denied on restart

The following error occures after installation of several
Hotfixes:
"The MSSQLServer service failed to start due to the
following error:
Access is denied."
It seems that the LocalSystem account cannot start the
MSSQL services. The service is temporarily started using
the domain admin account. I recently installed Hotfixes
KB824151, KB841533, KB840987, KB841356 en KB883935 on my
W2K SQL server, running SQL 7.0.
Before de-installing and restarting these hotfixes one-by-
one, i thought to have a try via this newsgroup.
TIA,
WouterTake a look in Books online... Search for Services Accounts.
There it details all of the requirements for permissions for the accounts...
The thing that is strange is that I have never , ever had any problems
starting SQL with localsystem...
If you have changed the account using control panel, services and are using
Full text search, you could cause a problem... In my opinion it is a best
practice to set up an account specifically for SQL Services login anyway...
Perhaps it is time you do that...
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
"Wouter" <anonymous@.discussions.microsoft.com> wrote in message
news:0f5b01c4d606$b1a624e0$a501280a@.phx.gbl...
> The following error occures after installation of several
> Hotfixes:
> "The MSSQLServer service failed to start due to the
> following error:
> Access is denied."
> It seems that the LocalSystem account cannot start the
> MSSQL services. The service is temporarily started using
> the domain admin account. I recently installed Hotfixes
> KB824151, KB841533, KB840987, KB841356 en KB883935 on my
> W2K SQL server, running SQL 7.0.
> Before de-installing and restarting these hotfixes one-by-
> one, i thought to have a try via this newsgroup.
> TIA,
> Wouter|||Wayne,
Thanks for you reply. The thing is, we also never, ever
had problems starting SQL with the LocalSystem account,
untill I installed the hotfixes. I'm pretty sure un-
installing the hotfixes will solve my problem, but that is
not the general idea behind hotfixes, is it?
Any other suggestions? If not I'll consider creating a SQL
Services login account.
Wouter

>--Original Message--
>Take a look in Books online... Search for Services
Accounts.
>There it details all of the requirements for permissions
for the accounts...
>The thing that is strange is that I have never , ever had
any problems
>starting SQL with localsystem...
>If you have changed the account using control panel,
services and are using
>Full text search, you could cause a problem... In my
opinion it is a best
>practice to set up an account specifically for SQL
Services login anyway...
>Perhaps it is time you do that...
>--
>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
>"Wouter" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0f5b01c4d606$b1a624e0$a501280a@.phx.gbl...
several[vbcol=seagreen]
by-[vbcol=seagreen]
>
>.
>

Access denied error with reporting service (ReportViewer)

I have a web page that has ReportViewer control in it. I load a report to it and it comes there nice and everything is ok. In report I have a link that opens another web page from the same web site where the original page is located (lets say that the original is in http//MySite and the page opened from the link is in MySite/Dialogs/MyDialog.aspx). The new page is opened with javascript function window.open(...) This new page contains reportviewer control, too and it's populated by the parameters given in the link url.

When I open the dialog page in the computer that has the web page and the report server on the same computer everything runs smoothly. But when I try to use the application from another computer it doesn't work right. The main page and the report opens to the browser in a proper way but when I click to the link that should open the dialog new browser window is opened but the reportviewer gives http 401 access denied error with ServerReport.SetProperties method.

I have set impersonate=true to the web config and I'm administrator in both computers that are used. What's the problem here? In another evironment it works nicely, but when the web site is used from another computer it gets broken...

Does ur report server have any credentials that u need to pass?

|||

What credentials should you have? I'm using windows authentication in my web page (set in web.config). Does the report server has a user account that should be set to the control?

|||

Suppose if i am trying to access my sql server data base from a different computer, windows authentication wont let me get into it... u will need a Username and password.. like sa or something like...

So i think u would need the same thing for report server... if i specify local host and the reports are hosted on ur computer i dont need any username or password to get in to the report server .. Suppose if u want to access it from a different computer and then give local host ... its gonna look in the local server and naturally not let u in to the report server...

regards,

Karen

|||

The link url doesn't point to localhost. It has the name of the computer where the report server is running (like http//MyAnotherComputer/ReportPage/ReportDialog.aspx). So I'm not pointing to localserver at any time. Even in the environment where the the application is working I use the name of the computer in the link url.

|||

then instead of the machine name ... try giving the ipaddress of that machine and one more when u try to access... http:/ServerName/Reports... does it prompt you for a username and password to get into it and view the reports?

|||Why would it make any difference to set ip address instead of computer name? The computers are both in the sam domain so there shouldn't be any problem with that. I gotta try the second test first time when I get back to my development computer. I'll let you know the result then.|||Why would it make any difference to set ip address instead of computer name? The computers are both in the same domain so there shouldn't be any problem with that. I gotta try the second test (accessing reports from another computer) first time when I get back to my development computer. I'll let you know the result then.|||Ok, I tried to access the report server with a browser on another computer (the url used washttp://computer_name/Reports) and worked just fine. Could it be possible that when I open another window from a report using a link, that the gredentials don't follow to the second window? If this is a case, what user account information should be forwarded to the dialog window? Should I use Web Service identity that is set for the Report Server? If I have set impersonate true in web.config, how does it affect to the behaviour of the control?|||I got this fixed! It seems that the application made a double hop. I made a mistake and called a report server on another computer instead of the one that was running on the web server.