Showing posts with label http. Show all posts
Showing posts with label http. Show all posts

Friday, March 30, 2012

Imitating ownership possible?

In SQL Server 2000 you could use the SETUSER command
(http://msdn2.microsoft.com/en-us/li...40(SQL.80).aspx) to
impersonate the user context for a SQL user account. However, this can only
be used by a sysadmin or db_owner and could not be used for Windows
accounts. In SQL Server 2005 you can use the EXECUTE AS clause to change the
execution context.

Here is a good article about EXECUTE AS:
http://blogs.msdn.com/sqlserverstor.../21/642061.aspx
HTH,

Plamen Ratchev
http://www.SQLStudio.comAwesome. Thanks for the quick response. I've got a lot of experience
in SQL in other languages, and some in SQL Server, but all the little
tricks of the trade I'm still short on.

Thanks again.

J

Monday, March 26, 2012

Images are not shown

Hi,
I have an image in a report. (Set to External, Url is set to
http://localhost/JB/images/name.gif).
When I try to display the report in HTML or PDF, the image is not shown.
All my webs are set to intergrated security. In the IIS log I see, that the
report server tries to access the image via Anonymous.
Why?
How I can change that he use integrated security? ( I have tried to set the
'unattended report processing', but no change)
Thanks
EricHello Eric,
Based on my experience, this issue can occur because images folder is not
set up to a virtual directory. You could only use link /images/name.gif
inside the virutal directory JB. For example, when you access
http://localhost/JB/images/name.gif directly in IE, the image cannot be
shown. However, if you copy name.gif to the folder of the virtual directory
JB, you could access the image directly via the URL
http://localhost/JB/name.gif
Therefore, I suggest that you create a new VD to point to the images folder
so that you could access the images directly in IE. After that, you could
use the URL in Report design.
Because the issue is a IIS related issue, if you need further assistance on
the issue, please post the quesiton in the following newsgroup:
microsoft.public.inetserver.iis
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Eric" <jug@.nospam.nospam>
| Subject: Images are not shown
| Date: Mon, 27 Jun 2005 11:18:47 +0200
| Lines: 17
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <eNd76kveFHA.2420@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: c-213-160-47-98.customer.ggaweb.ch 213.160.47.98
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:46745
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
|
| I have an image in a report. (Set to External, Url is set to
| http://localhost/JB/images/name.gif).
| When I try to display the report in HTML or PDF, the image is not shown.
|
| All my webs are set to intergrated security. In the IIS log I see, that
the
| report server tries to access the image via Anonymous.
|
| Why?
| How I can change that he use integrated security? ( I have tried to set
the
| 'unattended report processing', but no change)
|
| Thanks
| Eric
|
|
||||Hello Eric,
Sorry for my typo, we shall be able to access the image properly though it
is not directly under JB virtual directory
http://localhost/JB/images/name.gif
Please check if you could access the image directly in IE. If not, IIS
newsgroup is more proper place to submist this issue.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| From: petery@.online.microsoft.com (Peter Yang [MSFT])
| Organization: Microsoft
| Date: Tue, 28 Jun 2005 02:23:28 GMT
| Subject: RE: Images are not shown
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
|
| Hello Eric,
|
| Based on my experience, this issue can occur because images folder is not
| set up to a virtual directory. You could only use link /images/name.gif
| inside the virutal directory JB. For example, when you access
| http://localhost/JB/images/name.gif directly in IE, the image cannot be
| shown. However, if you copy name.gif to the folder of the virtual
directory
| JB, you could access the image directly via the URL
| http://localhost/JB/name.gif
|
| Therefore, I suggest that you create a new VD to point to the images
folder
| so that you could access the images directly in IE. After that, you could
| use the URL in Report design.
|
| Because the issue is a IIS related issue, if you need further assistance
on
| the issue, please post the quesiton in the following newsgroup:
|
| microsoft.public.inetserver.iis
|
| Regards,
|
| Peter Yang
| MCSE2000/2003, MCSA, MCDBA
| Microsoft Online Partner Support
|
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
|
| =====================================================|
|
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
|
| --
| | From: "Eric" <jug@.nospam.nospam>
| | Subject: Images are not shown
| | Date: Mon, 27 Jun 2005 11:18:47 +0200
| | Lines: 17
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| | x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.2527
| | X-RFC2646: Format=Flowed; Original
| | Message-ID: <eNd76kveFHA.2420@.TK2MSFTNGP12.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| | NNTP-Posting-Host: c-213-160-47-98.customer.ggaweb.ch 213.160.47.98
| | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:46745
| | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| |
| | Hi,
| |
| | I have an image in a report. (Set to External, Url is set to
| | http://localhost/JB/images/name.gif).
| | When I try to display the report in HTML or PDF, the image is not shown.
| |
| | All my webs are set to intergrated security. In the IIS log I see, that
| the
| | report server tries to access the image via Anonymous.
| |
| | Why?
| | How I can change that he use integrated security? ( I have tried to set
| the
| | 'unattended report processing', but no change)
| |
| | Thanks
| | Eric
| |
| |
| |
||||Hello Peter,
Thanks for answering.
Yes, I can access the image directly in IE.
How I mentioned before, the problem is that the report server doesn't access
the URL with Integrated security.
The report self (HTML Preview) runs under integrated security.
Thanks
Eric
"Peter Yang [MSFT]" <petery@.online.microsoft.com> schrieb im Newsbeitrag
news:RH00wn4eFHA.940@.TK2MSFTNGXA01.phx.gbl...
> Hello Eric,
> Sorry for my typo, we shall be able to access the image properly though it
> is not directly under JB virtual directory
> http://localhost/JB/images/name.gif
> Please check if you could access the image directly in IE. If not, IIS
> newsgroup is more proper place to submist this issue.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> --
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | From: petery@.online.microsoft.com (Peter Yang [MSFT])
> | Organization: Microsoft
> | Date: Tue, 28 Jun 2005 02:23:28 GMT
> | Subject: RE: Images are not shown
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | MIME-Version: 1.0
> | Content-Type: text/plain
> | Content-Transfer-Encoding: 7bit
> |
> | Hello Eric,
> |
> | Based on my experience, this issue can occur because images folder is
> not
> | set up to a virtual directory. You could only use link /images/name.gif
> | inside the virutal directory JB. For example, when you access
> | http://localhost/JB/images/name.gif directly in IE, the image cannot be
> | shown. However, if you copy name.gif to the folder of the virtual
> directory
> | JB, you could access the image directly via the URL
> | http://localhost/JB/name.gif
> |
> | Therefore, I suggest that you create a new VD to point to the images
> folder
> | so that you could access the images directly in IE. After that, you
> could
> | use the URL in Report design.
> |
> | Because the issue is a IIS related issue, if you need further assistance
> on
> | the issue, please post the quesiton in the following newsgroup:
> |
> | microsoft.public.inetserver.iis
> |
> | Regards,
> |
> | Peter Yang
> | MCSE2000/2003, MCSA, MCDBA
> | Microsoft Online Partner Support
> |
> | When responding to posts, please "Reply to Group" via your newsreader so
> | that others may learn and benefit from your issue.
> |
> | =====================================================> |
> |
> | This posting is provided "AS IS" with no warranties, and confers no
> rights.
> |
> |
> |
> |
> | --
> | | From: "Eric" <jug@.nospam.nospam>
> | | Subject: Images are not shown
> | | Date: Mon, 27 Jun 2005 11:18:47 +0200
> | | Lines: 17
> | | X-Priority: 3
> | | X-MSMail-Priority: Normal
> | | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
> | | x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.2527
> | | X-RFC2646: Format=Flowed; Original
> | | Message-ID: <eNd76kveFHA.2420@.TK2MSFTNGP12.phx.gbl>
> | | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | | NNTP-Posting-Host: c-213-160-47-98.customer.ggaweb.ch 213.160.47.98
> | | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:46745
> | | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | |
> | | Hi,
> | |
> | | I have an image in a report. (Set to External, Url is set to
> | | http://localhost/JB/images/name.gif).
> | | When I try to display the report in HTML or PDF, the image is not
> shown.
> | |
> | | All my webs are set to intergrated security. In the IIS log I see,
> that
> | the
> | | report server tries to access the image via Anonymous.
> | |
> | | Why?
> | | How I can change that he use integrated security? ( I have tried to
> set
> | the
> | | 'unattended report processing', but no change)
> | |
> | | Thanks
> | | Eric
> | |
> | |
> | |
> |
>|||Peter,
I have the same problem as Eric. I followed your instructions and can view
the logo.jpg in IE, and also in my report designer.
My problem is after deploying the report to the report server and running
the report, the report will not show the image.
The SP1 Read Me said that external images in image controls are now
supported, and that I must configure an account for unattended report
execution. I did this, but still cannot view the image when the deployed
report runs on the report server.
-- Mike J|||Hello Eric,
Based on my test, this behavior seems to be as designed. I think this is
because the referenced images are usually on public sites which only
requires anonymous authentication. Usually reporting service shall re-try
with the impersonated credential of the client. Apparently it does not do
so in getting image from other web sites/VDs.
We have to enable "anonymouse authentication" on the image folder of other
VD so that the report can work properly.
Please rest assured your feedback and concerns on this issue is routed to
the proper channel. Also, you may want to submit your feedback by following
method:
Visit the following Microsoft Product Feedback Web site
http://register.microsoft.com/mswish/suggestion.asp
and then complete and submit the form.
E-mail - To send comments or suggestions via e-mail, use the following
Microsoft Wish Program e-mail address, mswish@.microsoft.com.
Have a great day!
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
| From: "Eric" <jug@.nospam.nospam>
| References: <eNd76kveFHA.2420@.TK2MSFTNGP12.phx.gbl>
<fPG2gh4eFHA.2656@.TK2MSFTNGXA01.phx.gbl>
<RH00wn4eFHA.940@.TK2MSFTNGXA01.phx.gbl>
| Subject: Re: Images are not shown
| Date: Tue, 28 Jun 2005 09:30:33 +0200
| Lines: 142
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| Message-ID: <u27iIN7eFHA.1400@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: c-213-160-47-98.customer.ggaweb.ch 213.160.47.98
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:46852
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hello Peter,
|
| Thanks for answering.
| Yes, I can access the image directly in IE.
|
| How I mentioned before, the problem is that the report server doesn't
access
| the URL with Integrated security.
|
| The report self (HTML Preview) runs under integrated security.
|
| Thanks
| Eric
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> schrieb im Newsbeitrag
| news:RH00wn4eFHA.940@.TK2MSFTNGXA01.phx.gbl...
| > Hello Eric,
| >
| > Sorry for my typo, we shall be able to access the image properly though
it
| > is not directly under JB virtual directory
| >
| > http://localhost/JB/images/name.gif
| >
| > Please check if you could access the image directly in IE. If not, IIS
| > newsgroup is more proper place to submist this issue.
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader so
| > that others may learn and benefit from your issue.
| >
| > =====================================================| >
| >
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
| >
| >
| >
| > --
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | From: petery@.online.microsoft.com (Peter Yang [MSFT])
| > | Organization: Microsoft
| > | Date: Tue, 28 Jun 2005 02:23:28 GMT
| > | Subject: RE: Images are not shown
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | MIME-Version: 1.0
| > | Content-Type: text/plain
| > | Content-Transfer-Encoding: 7bit
| > |
| > | Hello Eric,
| > |
| > | Based on my experience, this issue can occur because images folder is
| > not
| > | set up to a virtual directory. You could only use link
/images/name.gif
| > | inside the virutal directory JB. For example, when you access
| > | http://localhost/JB/images/name.gif directly in IE, the image cannot
be
| > | shown. However, if you copy name.gif to the folder of the virtual
| > directory
| > | JB, you could access the image directly via the URL
| > | http://localhost/JB/name.gif
| > |
| > | Therefore, I suggest that you create a new VD to point to the images
| > folder
| > | so that you could access the images directly in IE. After that, you
| > could
| > | use the URL in Report design.
| > |
| > | Because the issue is a IIS related issue, if you need further
assistance
| > on
| > | the issue, please post the quesiton in the following newsgroup:
| > |
| > | microsoft.public.inetserver.iis
| > |
| > | Regards,
| > |
| > | Peter Yang
| > | MCSE2000/2003, MCSA, MCDBA
| > | Microsoft Online Partner Support
| > |
| > | When responding to posts, please "Reply to Group" via your newsreader
so
| > | that others may learn and benefit from your issue.
| > |
| > | =====================================================| > |
| > |
| > | This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| > |
| > |
| > |
| > |
| > | --
| > | | From: "Eric" <jug@.nospam.nospam>
| > | | Subject: Images are not shown
| > | | Date: Mon, 27 Jun 2005 11:18:47 +0200
| > | | Lines: 17
| > | | X-Priority: 3
| > | | X-MSMail-Priority: Normal
| > | | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| > | | x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.2527
| > | | X-RFC2646: Format=Flowed; Original
| > | | Message-ID: <eNd76kveFHA.2420@.TK2MSFTNGP12.phx.gbl>
| > | | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | | NNTP-Posting-Host: c-213-160-47-98.customer.ggaweb.ch 213.160.47.98
| > | | Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | | Xref: TK2MSFTNGXA01.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:46745
| > | | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | |
| > | | Hi,
| > | |
| > | | I have an image in a report. (Set to External, Url is set to
| > | | http://localhost/JB/images/name.gif).
| > | | When I try to display the report in HTML or PDF, the image is not
| > shown.
| > | |
| > | | All my webs are set to intergrated security. In the IIS log I see,
| > that
| > | the
| > | | report server tries to access the image via Anonymous.
| > | |
| > | | Why?
| > | | How I can change that he use integrated security? ( I have tried to
| > set
| > | the
| > | | 'unattended report processing', but no change)
| > | |
| > | | Thanks
| > | | Eric
| > | |
| > | |
| > | |
| > |
| >
|
|
|sql

Friday, March 23, 2012

Image problem

Hello,

I'm using SQL 2005 & reporting service 2005

I have a picture control and the image come from a web. (http://myserver/logo.jpg)

The report contain parameters.

While user generate the reporting the image display without a problem.

But if user change his parameters selected (without close the reports) than click on generate report the image doesn't dispaly and red X show.

If user click on the refresh icon in the report the image load again.

Any sugestion how to solve this problem ?

Thanks

I had a similar problem before and had to use an embedded image instead to get rid of the problem.|||This issue was addressed in SP1. After applying SP1, are you still seeing the issue?|||I still didn;t applay SP1 because the "Select All" in ,ulti selection list removed in SP1|||If you don't want to apply SP1, then the only workaround is to use an embedded image instead.|||Thanks

Friday, March 9, 2012

IIS is not running

Hi,
I have MS 2000 server with IIS. When I type http://localhost, it bring me t
o Lycos search page. How do I know if IIS has started? Is this info displa
yed in the Admin tool's Services sreen? Thank you.
ChrisHi Chris,
Yes go to the IIS admin snap in and check the status of the default web
site. This will tell you if it is running.
Or from the cmd prompt type in
Net start and look for World Wide Web Publishing Service
You can type
net start "world wide web publishing service"
to start the service.
"yingjian ma" <yingjian.ma@.cox.net> wrote in message
news:On5GnguCEHA.3024@.tk2msftngp13.phx.gbl...
Hi,
I have MS 2000 server with IIS. When I type http://localhost, it bring me
to Lycos search page. How do I know if IIS has started? Is this info
displayed in the Admin tool's Services sreen? Thank you.
Chris