Immediate Updating Subscription - Hangs

We have installed SQL Server 2000 on a new server running Windows 2003.
This server is the distirbution Server. It also contains a one database. THis database subscibes to data from other servers and publishes data to other servers.
One of the publications is an updateable subscription. Ths subscription is pushed to the subscriber.
The replication works fine from publisher to subscriber, but when the subscriber attempts an update it just hangs. I see no blocking on either server.
DTC is running on both servers. I executed sp_link_pubisher on the subscriber to populate the publisher login and password in the MSsubscription_properties table.
I must be missing something else.
Can anyone help?
When you say it hangs do you mean it is slow or it doesn't work?
Do you eventually get an error message saying "Access denied"?
If you get this error message, DTC on your Subcriber cannot talk to your Publisher. Its either a name resolution problem, or more likely a permissions problem. Check the accound your SQL Server agent runs under on the Susbcriber and make sure it is part o
f the local administrators group on your Publisher.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||Thank you Hilary for your prompt reply.
WHat I mean by it hangs is it never completes. And it doesn't appear to time out.
I do feel it is something to do with DTC. I will investigate the account SQL Server agent runs under on the Susbcriber
and make sure it is part of the local administrators group on the Publisher.
If you cant hink of anything else in the meantime, I am all ears.
Thanks again.
|||I verified that the account the SQL Server agent runs under on the Susbcriber is part of the local administrators group on the Publisher.
I do not get an "Access denied" error. I get no response at all.
Can you suggest anything else?
-- Hilary Cotter wrote: --
When you say it hangs do you mean it is slow or it doesn't work?
Do you eventually get an error message saying "Access denied"?
If you get this error message, DTC on your Subcriber cannot talk to your Publisher. Its either a name resolution problem, or more likely a permissions problem. Check the accound your SQL Server agent runs under on the Susbcriber and make sure it is p
art of the local administrators group on your Publisher.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||what does your msdtc log say. It can be found in
C:\WINDOWS\System32\MSDtc
"casey@.newsgroups.nospam" <anonymous@.discussions.microsoft.com> wrote in
message news:24BA0D29-2D9B-417D-8730-3B2920FBF11B@.microsoft.com...
> I verified that the account the SQL Server agent runs under on the
Susbcriber is part of the local administrators group on the Publisher.
> I do not get an "Access denied" error. I get no response at all.
> Can you suggest anything else?
> -- Hilary Cotter wrote: --
> When you say it hangs do you mean it is slow or it doesn't work?
> Do you eventually get an error message saying "Access denied"?
> If you get this error message, DTC on your Subcriber cannot talk to
your Publisher. Its either a name resolution problem, or more likely a
permissions problem. Check the accound your SQL Server agent runs under on
the Susbcriber and make sure it is part of the local administrators group on
your Publisher.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
|||Helen,
The DTC log contains mostly non-displayable characters. Same for the Trace. Is there a tool I should be using to read this file?
|||My problem is resolved.
The trouble was that with Windows 2003, Enable network DTC access is not "enabled" by default. Once I enabled this, everything works fine.
Thanks for your help.

Images do not display in Reporting Sevices on Windows 2003 Server

Hi,
I have reporting services installed on windows 2003 server.
Embedded Images do display in designer preview, but they do not display in
Report Manager or browser. When I use localhost instead of my machine name in
report url, then images are displayed. I have installed service pack 1 & 2
for RS. After that I installed SP4 for SQL Server. Can some body help in this
regard?
Thanks in anticipation.Hi
Following issue is resolved.
Please look at following link. "_" in the machine name is the
culprit. I used the IP and it worked fine. Also replace machine name in
report server and report manager config files with machine IP address.
http://groups.google.com.pk/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/dc1fcfec0c41ec70/23425c9cbdabb2a1?q=%22reporting+services%22+%2B+%22images%22&rnum=1&hl=en#23425c9cbdabb2a1
"Saeed Ahmad" wrote:
> Hi,
> I have reporting services installed on windows 2003 server.
> Embedded Images do display in designer preview, but they do not display in
> Report Manager or browser. When I use localhost instead of my machine name in
> report url, then images are displayed. I have installed service pack 1 & 2
> for RS. After that I installed SP4 for SQL Server. Can some body help in this
> regard?
> Thanks in anticipation.
>|||I've narrowed this down a bit. It seems to happen only with line art no
matter what file format your using (png, gif etc.) The only way I've found
around it (which isn't acceptable in my opinion) is to use the "fit"
parameter for the image.
From what I've read - RS sends a jscript to resize image in browser. I'm
guessing it fails to work because it is line art.
"Saeed Ahmad" <Saeed Ahmad@.discussions.microsoft.com> wrote in message
news:B47ABB44-24D6-433D-A621-9DCBE48690C1@.microsoft.com...
> Hi,
> I have reporting services installed on windows 2003 server.
> Embedded Images do display in designer preview, but they do not display in
> Report Manager or browser. When I use localhost instead of my machine name
> in
> report url, then images are displayed. I have installed service pack 1 & 2
> for RS. After that I installed SP4 for SQL Server. Can some body help in
> this
> regard?
> Thanks in anticipation.
>sql

Images and PDF Export POST SP2

I've come accross the same problem having also installed SP2. Still looking
for the answer.
I did notice that exporting via the preview window in Visual Studio works
perfectly. It's only exporting to pdf via a browser that causes the
scrambled images.
Does anyone have a work around, besides changing every report to read a png
image? We still need transparency.
Ryan
>On Follow Up.. this appears to be images other than JPEG's, which according
>to documentation are all rendered as PNG's.
>"Rob Johnson" wrote:
>> After installing RS SP2, images included in my reports display fine in
>> HTML
>> View, Excel View and TIFF View, but when exported to PDF they are not
>> displaying properly (they appear garbled, much like a scrambled TV
>> signal).
>>
>> Any ideas or thoughts?Same issue here, although my image is being converted at runtime to png via a
.Net assembly. I get the same results through the browser and VS IDE.
"Ryan Opfer" wrote:
> I've come accross the same problem having also installed SP2. Still looking
> for the answer.
> I did notice that exporting via the preview window in Visual Studio works
> perfectly. It's only exporting to pdf via a browser that causes the
> scrambled images.
> Does anyone have a work around, besides changing every report to read a png
> image? We still need transparency.
> Ryan
> >On Follow Up.. this appears to be images other than JPEG's, which according
> >to documentation are all rendered as PNG's.
> >"Rob Johnson" wrote:
> >> After installing RS SP2, images included in my reports display fine in
> >> HTML
> >> View, Excel View and TIFF View, but when exported to PDF they are not
> >> displaying properly (they appear garbled, much like a scrambled TV
> >> signal).
> >>
> >> Any ideas or thoughts?
>
>|||I use a custom centering/scaling function as the data source for my image
control. Converting the function's output to either GIF or JPEG eliminated
the problem for me. I have my image control's format set to JPEG. The
problem appears for me when the function's output is set to PNG.
"Ryan Opfer" wrote:
> I've come accross the same problem having also installed SP2. Still looking
> for the answer.
> I did notice that exporting via the preview window in Visual Studio works
> perfectly. It's only exporting to pdf via a browser that causes the
> scrambled images.
> Does anyone have a work around, besides changing every report to read a png
> image? We still need transparency.
> Ryan
> >On Follow Up.. this appears to be images other than JPEG's, which according
> >to documentation are all rendered as PNG's.
> >"Rob Johnson" wrote:
> >> After installing RS SP2, images included in my reports display fine in
> >> HTML
> >> View, Excel View and TIFF View, but when exported to PDF they are not
> >> displaying properly (they appear garbled, much like a scrambled TV
> >> signal).
> >>
> >> Any ideas or thoughts?
>
>|||I've tried a couple of images and didn't see PNG corruption when exporting
to PDF. Would one of you please email me a sample PNG that is exhibiting
this behavior so I can take a look? Thank you.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ken Fox" <KenFox@.discussions.microsoft.com> wrote in message
news:DF0704F5-B6DF-4BEF-A042-0DE8D7E0F30D@.microsoft.com...
>I use a custom centering/scaling function as the data source for my image
> control. Converting the function's output to either GIF or JPEG
> eliminated
> the problem for me. I have my image control's format set to JPEG. The
> problem appears for me when the function's output is set to PNG.
> "Ryan Opfer" wrote:
>> I've come accross the same problem having also installed SP2. Still
>> looking
>> for the answer.
>> I did notice that exporting via the preview window in Visual Studio works
>> perfectly. It's only exporting to pdf via a browser that causes the
>> scrambled images.
>> Does anyone have a work around, besides changing every report to read a
>> png
>> image? We still need transparency.
>> Ryan
>> >On Follow Up.. this appears to be images other than JPEG's, which
>> >according
>> >to documentation are all rendered as PNG's.
>> >"Rob Johnson" wrote:
>> >> After installing RS SP2, images included in my reports display fine in
>> >> HTML
>> >> View, Excel View and TIFF View, but when exported to PDF they are not
>> >> displaying properly (they appear garbled, much like a scrambled TV
>> >> signal).
>> >>
>> >> Any ideas or thoughts?
>>|||We don't currently support true color w/alpha PNG files, only indexed color
(color type 3). If your graphics editing program allows you to specify the
color type of your PNG and save it as a type 3 file you should be fine.
Prior to SP2, we converted all images to bitmaps which bloated the PDF file.
We now compress but have less flexibility on certain image types.
I've opened a bug for this issue so we can hopefully get it fixed in Yukon.
The easiest work-around for our SQL Server 2000 release is to save as a type
3 file or use a jpg.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
news:%23IailDwWFHA.3584@.TK2MSFTNGP14.phx.gbl...
> Thanks Donovan for looking into this. Here is our logo
> (logoRenderedFromBrowser.png). It was originally a GIF image but when
> rendered to the browser it becomes a png image (perhaps a reason why we
> can export to PDF via visual studio but not from the browser). Also
> attached is the scrambled logo (scrambledImage.jpg) screen shot taken
> directly after export to pdf via the browser.
> Again, prior to SP2 all reports exported as expected via the browser to
> pdf. One can only assume that there's been a change with sp2.
> Thanks in advance,
> Ryan
>
> "Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
> news:%23b0JjJnWFHA.2256@.TK2MSFTNGP14.phx.gbl...
>> I've tried a couple of images and didn't see PNG corruption when
>> exporting
>> to PDF. Would one of you please email me a sample PNG that is exhibiting
>> this behavior so I can take a look? Thank you.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ken Fox" <KenFox@.discussions.microsoft.com> wrote in message
>> news:DF0704F5-B6DF-4BEF-A042-0DE8D7E0F30D@.microsoft.com...
>>I use a custom centering/scaling function as the data source for my image
>> control. Converting the function's output to either GIF or JPEG
>> eliminated
>> the problem for me. I have my image control's format set to JPEG. The
>> problem appears for me when the function's output is set to PNG.
>> "Ryan Opfer" wrote:
>> I've come accross the same problem having also installed SP2. Still
>> looking
>> for the answer.
>> I did notice that exporting via the preview window in Visual Studio
>> works
>> perfectly. It's only exporting to pdf via a browser that causes the
>> scrambled images.
>> Does anyone have a work around, besides changing every report to read a
>> png
>> image? We still need transparency.
>> Ryan
>> >On Follow Up.. this appears to be images other than JPEG's, which
>> >according
>> >to documentation are all rendered as PNG's.
>> >"Rob Johnson" wrote:
>> >> After installing RS SP2, images included in my reports display fine
>> >> in
>> >> HTML
>> >> View, Excel View and TIFF View, but when exported to PDF they are
>> >> not
>> >> displaying properly (they appear garbled, much like a scrambled TV
>> >> signal).
>> >>
>> >> Any ideas or thoughts?
>>
>>
>
>|||Thanks Donovan for the information. I was in error when I had said that we
were originally using a GIF image and that RS was converting it when
rendering for the browser. We are indeed using png files at 24 bit.
I did save the image as png-8 (which I assume is color type 3) which does
fix this problem--although it's lousy quality.
So thanks again for the solution/work around.
Ryan
It is interesting though that you mention that RS doesn't currently support
true color w/alpha PNG files. I'm not even using PNG, it's RS that is
converting it to
"Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:eXILSR1WFHA.3584@.TK2MSFTNGP14.phx.gbl...
> We don't currently support true color w/alpha PNG files, only indexed
> color (color type 3). If your graphics editing program allows you to
> specify the color type of your PNG and save it as a type 3 file you should
> be fine. Prior to SP2, we converted all images to bitmaps which bloated
> the PDF file. We now compress but have less flexibility on certain image
> types.
> I've opened a bug for this issue so we can hopefully get it fixed in
> Yukon. The easiest work-around for our SQL Server 2000 release is to save
> as a type 3 file or use a jpg.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
> news:%23IailDwWFHA.3584@.TK2MSFTNGP14.phx.gbl...
>> Thanks Donovan for looking into this. Here is our logo
>> (logoRenderedFromBrowser.png). It was originally a GIF image but when
>> rendered to the browser it becomes a png image (perhaps a reason why we
>> can export to PDF via visual studio but not from the browser). Also
>> attached is the scrambled logo (scrambledImage.jpg) screen shot taken
>> directly after export to pdf via the browser.
>> Again, prior to SP2 all reports exported as expected via the browser to
>> pdf. One can only assume that there's been a change with sp2.
>> Thanks in advance,
>> Ryan
>>
>> "Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
>> news:%23b0JjJnWFHA.2256@.TK2MSFTNGP14.phx.gbl...
>> I've tried a couple of images and didn't see PNG corruption when
>> exporting
>> to PDF. Would one of you please email me a sample PNG that is
>> exhibiting
>> this behavior so I can take a look? Thank you.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ken Fox" <KenFox@.discussions.microsoft.com> wrote in message
>> news:DF0704F5-B6DF-4BEF-A042-0DE8D7E0F30D@.microsoft.com...
>>I use a custom centering/scaling function as the data source for my
>>image
>> control. Converting the function's output to either GIF or JPEG
>> eliminated
>> the problem for me. I have my image control's format set to JPEG. The
>> problem appears for me when the function's output is set to PNG.
>> "Ryan Opfer" wrote:
>> I've come accross the same problem having also installed SP2. Still
>> looking
>> for the answer.
>> I did notice that exporting via the preview window in Visual Studio
>> works
>> perfectly. It's only exporting to pdf via a browser that causes the
>> scrambled images.
>> Does anyone have a work around, besides changing every report to read
>> a
>> png
>> image? We still need transparency.
>> Ryan
>> >On Follow Up.. this appears to be images other than JPEG's, which
>> >according
>> >to documentation are all rendered as PNG's.
>> >"Rob Johnson" wrote:
>> >> After installing RS SP2, images included in my reports display fine
>> >> in
>> >> HTML
>> >> View, Excel View and TIFF View, but when exported to PDF they are
>> >> not
>> >> displaying properly (they appear garbled, much like a scrambled TV
>> >> signal).
>> >>
>> >> Any ideas or thoughts?
>>
>>
>>
>>
>|||Ah, OK. I couldn't quite understand the GIF part of your message. :)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
news:ep6g6EAXFHA.3348@.TK2MSFTNGP14.phx.gbl...
> Thanks Donovan for the information. I was in error when I had said that
> we were originally using a GIF image and that RS was converting it when
> rendering for the browser. We are indeed using png files at 24 bit.
> I did save the image as png-8 (which I assume is color type 3) which does
> fix this problem--although it's lousy quality.
> So thanks again for the solution/work around.
> Ryan
> It is interesting though that you mention that RS doesn't currently
> support true color w/alpha PNG files. I'm not even using PNG, it's RS
> that is converting it to
> "Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
> news:eXILSR1WFHA.3584@.TK2MSFTNGP14.phx.gbl...
>> We don't currently support true color w/alpha PNG files, only indexed
>> color (color type 3). If your graphics editing program allows you to
>> specify the color type of your PNG and save it as a type 3 file you
>> should be fine. Prior to SP2, we converted all images to bitmaps which
>> bloated the PDF file. We now compress but have less flexibility on
>> certain image types.
>> I've opened a bug for this issue so we can hopefully get it fixed in
>> Yukon. The easiest work-around for our SQL Server 2000 release is to save
>> as a type 3 file or use a jpg.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
>> news:%23IailDwWFHA.3584@.TK2MSFTNGP14.phx.gbl...
>> Thanks Donovan for looking into this. Here is our logo
>> (logoRenderedFromBrowser.png). It was originally a GIF image but when
>> rendered to the browser it becomes a png image (perhaps a reason why we
>> can export to PDF via visual studio but not from the browser). Also
>> attached is the scrambled logo (scrambledImage.jpg) screen shot taken
>> directly after export to pdf via the browser.
>> Again, prior to SP2 all reports exported as expected via the browser to
>> pdf. One can only assume that there's been a change with sp2.
>> Thanks in advance,
>> Ryan
>>
>> "Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
>> news:%23b0JjJnWFHA.2256@.TK2MSFTNGP14.phx.gbl...
>> I've tried a couple of images and didn't see PNG corruption when
>> exporting
>> to PDF. Would one of you please email me a sample PNG that is
>> exhibiting
>> this behavior so I can take a look? Thank you.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ken Fox" <KenFox@.discussions.microsoft.com> wrote in message
>> news:DF0704F5-B6DF-4BEF-A042-0DE8D7E0F30D@.microsoft.com...
>>I use a custom centering/scaling function as the data source for my
>>image
>> control. Converting the function's output to either GIF or JPEG
>> eliminated
>> the problem for me. I have my image control's format set to JPEG.
>> The
>> problem appears for me when the function's output is set to PNG.
>> "Ryan Opfer" wrote:
>> I've come accross the same problem having also installed SP2. Still
>> looking
>> for the answer.
>> I did notice that exporting via the preview window in Visual Studio
>> works
>> perfectly. It's only exporting to pdf via a browser that causes the
>> scrambled images.
>> Does anyone have a work around, besides changing every report to read
>> a
>> png
>> image? We still need transparency.
>> Ryan
>> >On Follow Up.. this appears to be images other than JPEG's, which
>> >according
>> >to documentation are all rendered as PNG's.
>> >"Rob Johnson" wrote:
>> >> After installing RS SP2, images included in my reports display
>> >> fine in
>> >> HTML
>> >> View, Excel View and TIFF View, but when exported to PDF they are
>> >> not
>> >> displaying properly (they appear garbled, much like a scrambled TV
>> >> signal).
>> >>
>> >> Any ideas or thoughts?
>>
>>
>>
>>
>>
>|||One more export issue. When exporting to pdf using the 8 bit png image
(color type 3) from the browser, transparency doesn't work (and it use to
under SP1). As proof that the image is transparent, I can print using the
new print button and transparency works fine. Also when exporting to pdf
via Visual Studio transparency works fine as well (of course so did the 24
bit png).
At least it's not scrambled though!
Ryan
"Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:%23MmyV8AXFHA.2288@.TK2MSFTNGP14.phx.gbl...
> Ah, OK. I couldn't quite understand the GIF part of your message. :)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
> news:ep6g6EAXFHA.3348@.TK2MSFTNGP14.phx.gbl...
>> Thanks Donovan for the information. I was in error when I had said that
>> we were originally using a GIF image and that RS was converting it when
>> rendering for the browser. We are indeed using png files at 24 bit.
>> I did save the image as png-8 (which I assume is color type 3) which does
>> fix this problem--although it's lousy quality.
>> So thanks again for the solution/work around.
>> Ryan
>> It is interesting though that you mention that RS doesn't currently
>> support true color w/alpha PNG files. I'm not even using PNG, it's RS
>> that is converting it to
>> "Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
>> news:eXILSR1WFHA.3584@.TK2MSFTNGP14.phx.gbl...
>> We don't currently support true color w/alpha PNG files, only indexed
>> color (color type 3). If your graphics editing program allows you to
>> specify the color type of your PNG and save it as a type 3 file you
>> should be fine. Prior to SP2, we converted all images to bitmaps which
>> bloated the PDF file. We now compress but have less flexibility on
>> certain image types.
>> I've opened a bug for this issue so we can hopefully get it fixed in
>> Yukon. The easiest work-around for our SQL Server 2000 release is to
>> save as a type 3 file or use a jpg.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
>> news:%23IailDwWFHA.3584@.TK2MSFTNGP14.phx.gbl...
>> Thanks Donovan for looking into this. Here is our logo
>> (logoRenderedFromBrowser.png). It was originally a GIF image but when
>> rendered to the browser it becomes a png image (perhaps a reason why we
>> can export to PDF via visual studio but not from the browser). Also
>> attached is the scrambled logo (scrambledImage.jpg) screen shot taken
>> directly after export to pdf via the browser.
>> Again, prior to SP2 all reports exported as expected via the browser to
>> pdf. One can only assume that there's been a change with sp2.
>> Thanks in advance,
>> Ryan
>>
>> "Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
>> news:%23b0JjJnWFHA.2256@.TK2MSFTNGP14.phx.gbl...
>> I've tried a couple of images and didn't see PNG corruption when
>> exporting
>> to PDF. Would one of you please email me a sample PNG that is
>> exhibiting
>> this behavior so I can take a look? Thank you.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ken Fox" <KenFox@.discussions.microsoft.com> wrote in message
>> news:DF0704F5-B6DF-4BEF-A042-0DE8D7E0F30D@.microsoft.com...
>>I use a custom centering/scaling function as the data source for my
>>image
>> control. Converting the function's output to either GIF or JPEG
>> eliminated
>> the problem for me. I have my image control's format set to JPEG.
>> The
>> problem appears for me when the function's output is set to PNG.
>> "Ryan Opfer" wrote:
>>> I've come accross the same problem having also installed SP2. Still
>>> looking
>>> for the answer.
>>>
>>> I did notice that exporting via the preview window in Visual Studio
>>> works
>>> perfectly. It's only exporting to pdf via a browser that causes the
>>> scrambled images.
>>>
>>> Does anyone have a work around, besides changing every report to
>>> read a
>>> png
>>> image? We still need transparency.
>>>
>>> Ryan
>>> >On Follow Up.. this appears to be images other than JPEG's, which
>>> >according
>>> >to documentation are all rendered as PNG's.
>>>
>>> >"Rob Johnson" wrote:
>>>
>>> >> After installing RS SP2, images included in my reports display
>>> >> fine in
>>> >> HTML
>>> >> View, Excel View and TIFF View, but when exported to PDF they are
>>> >> not
>>> >> displaying properly (they appear garbled, much like a scrambled
>>> >> TV
>>> >> signal).
>>> >>
>>> >> Any ideas or thoughts?
>>>
>>>
>>>
>>
>>
>>
>>
>

I'm not sure what to do...Help

Hi everyone

I have a secure web site with SSRS 2005 installed. The service points to a backend server on our network where the databases reside and we have a firewall.

Previously we have configured our reports and data extentions to use Windows Integrated Security. Now that I have a remote install I need to switch to either forms authentication or Kerberos authentication.

Which one is the easiest to use? My guess is that doing a little coding for forms authentication is the way to go.

With forms authentication I need to create a security extention. What will that do to my custom data extention?

When using Kerberos or Forms authentication can a client still use Report Builder?

I would appreciate any help.

Thanks

-JW

I can't speak to forms authentication, but Kerberos can work.

I say 'can' because if the certificates aren't 100% perfect (URL name matches cert, complete cert chain is trusted, etc), then it will fail, and Kerberos failures are painfully difficult to troubleshoot as normally the only helpful message you receive is 'access denied', with little clue why.

If the server is re-using the client's credentials to access the backend data, then you are already using Kerberos, because that's the only way it's possible to do that, using delegation. An easy way to test if Kerberos will work without having to access outside a firewall is to disable NTLM for that directory in IIS using the adsutil.vbs utility (google can assist with a sample, I don't have the syntax handy), so only the Kerberos half of Windows Authentication is enabled.

And yes, I was able to get Report Builder to work as well. Not sure what effect it might have on the custom data extension without some more details of what it does.

So, my suggestion would be to give Kerberos a try, because if it works, it'll work fairly quickly with no code required. If it gets muddy, then maybe give Forms a try. But as I said, I've never used Forms so can't help you on how.

Geof

I'm new, I'm lost, I think I've installed the wrong this!

Hi folks

I've got experience of developing applications using relational databases, but I've never installed a database on my PC.

I've just downloaded and installed .NET Framework 2.0 without issues. I also did Visual C# Express with no problems and I've made a couple of example projects successfully.

What I wanted to do next was install SQL Server Express so I can design a database and then use Visual C# to create a GUI to do a simple add/edit/delete type scenario.

So, I have installed something called SQL Server 2005. I tried to install SQL Server Express, but for some reason it isn't called that on my list of programs.

When I open that up I have a choice of SQL Server Configuration Manager or SQL Server 2005 Surface Area Configuration. None of these look like what I was expecting - a nice Studio where I can create tables much like MS Access.

Perhaps I need to do something with one of these tools to get to where I want to be, or perhaps I am barking up the wrong tree and I need to do some uninstalling.

I wondered if someone could guide me? I feel so lost that I don't even know the right questions to ask to get the answers.

Thanks

Richard

The 'standard' installation for SQL Express does not include any 'client tools', i.e., "where I can create tables".

However, you can download and install the SQL Server Management Studio Express from:

SQL Server 2005 Express Books Online Express Edition
http://msdn2.microsoft.com/en-us/library/ms165706.aspx

SQL Server 2005 Express Edition (Advanced/SSMS)
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
http://msdn2.microsoft.com/en-us/library/ms365247.aspx
http://tinyurl.com/yelwr9

I included the url for Books Online -the definitive help source for SQL Server.

|||

Thank you kind sir.

I guessed there was another step to do but I just couldn't figure it out.

I'm downloading now, so if I have any issues with the installation I'll pop back for help. Or, I'll try the online book which looks like it'll be a great help.

Have a nice day.

I'm New & Need Help. Install + Use SQLExpress with Access

I'm totally new to using RDBM's, and have never installed or used SQl. Can someone please tell me how to install SQL Express, do whatever I need to to at the command prompt, etc., and then what I need to do in order to create a database in Access which uses SQL Express as the backend?

I'm using Windows XP

I have .Net framework 2.0 installed and the .Net SDK

Can someone please help a noob out? :)

Thanks.,

James

What do you mean by "then what I need to do in order to create a database in Access which uses SQL Express as the backend?" I do not think that is possible. What are you trying to do?

You can find Express Edition on the Web Site at the following location

http://www.microsoft.com/downloads/details.aspx?familyid=220549B5-0B07-4448-8848-DCC397514B41&displaylang=en

Running the install will step you through the installation process.

michelle

IIS4 lockdown install conflicts with MS SQL 7.0

I need to install IIS4 lockdown for FTP services.
However, when i installed it, it caused problems with my
MS SQL 7.0 installation. I had to re-installed the old
odbc from the sql7 cd and rerun sql service pack 4 in
order to get the SQL7 to function again. Can you PLEASE
help me on how to install these two products to play nice
together.
Thanks.
Your urgent response will be greatly appreciated!!!
Hi
I guess you are running both IIS and SQL Server on the same machine, which
is not advisable!
I am not sure what IIS lockdown would have done apart from disabling the
services and closing the ports. I didn't think it removed ODBC drivers but
to load more up-to-date drivers re-install MDAC.
Check your SQL Server log file and the Event Log to see if there is any
useful information there.
John
"Grasshopper" <anonymous@.discussions.microsoft.com> wrote in message
news:286a401c4645a$8f826c20$a501280a@.phx.gbl...
> I need to install IIS4 lockdown for FTP services.
> However, when i installed it, it caused problems with my
> MS SQL 7.0 installation. I had to re-installed the old
> odbc from the sql7 cd and rerun sql service pack 4 in
> order to get the SQL7 to function again. Can you PLEASE
> help me on how to install these two products to play nice
> together.
> Thanks.
> Your urgent response will be greatly appreciated!!!

IIS4 lockdown install conflicts with MS SQL 7.0

I need to install IIS4 lockdown for FTP services.
However, when i installed it, it caused problems with my
MS SQL 7.0 installation. I had to re-installed the old
odbc from the sql7 cd and rerun sql service pack 4 in
order to get the SQL7 to function again. Can you PLEASE
help me on how to install these two products to play nice
together.
Thanks.
Your urgent response will be greatly appreciated!!!Hi
I guess you are running both IIS and SQL Server on the same machine, which
is not advisable!
I am not sure what IIS lockdown would have done apart from disabling the
services and closing the ports. I didn't think it removed ODBC drivers but
to load more up-to-date drivers re-install MDAC.
Check your SQL Server log file and the Event Log to see if there is any
useful information there.
John
"Grasshopper" <anonymous@.discussions.microsoft.com> wrote in message
news:286a401c4645a$8f826c20$a501280a@.phx
.gbl...
> I need to install IIS4 lockdown for FTP services.
> However, when i installed it, it caused problems with my
> MS SQL 7.0 installation. I had to re-installed the old
> odbc from the sql7 cd and rerun sql service pack 4 in
> order to get the SQL7 to function again. Can you PLEASE
> help me on how to install these two products to play nice
> together.
> Thanks.
> Your urgent response will be greatly appreciated!!!

IIS Virtual Directory for SQL

On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql sp4)
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any clues
Hi
Maybe
http://support.microsoft.com/default...b;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues

IIS Virtual Directory for SQL

On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql sp4)
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/default.aspx?scid=kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues

IIS Virtual Directory for SQL

On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql sp4)
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=dat
a
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/defaul...kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues

IIS not installed

Can someone explain mistery behind that message while installing RS?
What if IIS is running? What else to check then?
ThanksOn Jul 1, 8:35 pm, "markgoldin" <markgoldin_2...@.yahoo.com> wrote:
> Can someone explain mistery behind that message while installing RS?
> What if IIS is running? What else to check then?
> Thanks
If you are running Windows Vista, this article might help.
http://support.microsoft.com/kb/934164/
Regards,
Enrique Martinez
Sr. Software Consultant|||No, it's Server 2003.
A thought about that article. Just imagine aliens reading it. Their
impression would have been probably:
Wow, these humans must be smart if they can understand it. Sorry, bad mood.
I think closer to midnight I am going to honor myself with a title
:"Microsoft uncertified installer".
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1183343909.508685.227570@.q69g2000hsb.googlegroups.com...
> On Jul 1, 8:35 pm, "markgoldin" <markgoldin_2...@.yahoo.com> wrote:
>> Can someone explain mistery behind that message while installing RS?
>> What if IIS is running? What else to check then?
>> Thanks
>
> If you are running Windows Vista, this article might help.
> http://support.microsoft.com/kb/934164/
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

IIS issue

I just installed IIS on my windows xp pro machine and when I try to access a
website on the local IIS server, I get the following error message:

"You are not authorized to view this page"

I have enabled "Anonymous access" inside Directory Security option of IIS
and I also granted full NTFS permissions to all users so that the IIS root
directory is readily accessible. However, I am still not able to access any
website that resides on the localhost.

Please help.

Thanks.
JessIs this a SQL Server question?

IIS Internet Info Services

Hi,

I'm trying to install SQL Server 2005 Enterprise edition.

It is telling me that I don't have IIS installed and that it may

cause some problems. I can't find where to install from

add/remove components nor can I find it in any of my

network connections. Does anyone know where to

install this from? Thanks in advance.

Newbie.......Eric

IIS comes with XP Pro, it is not available with XP Home. It's never installed by default, but you can add it in add windows components.

|||

Yes I did look through the add/remove components section

in the control panel but I don't see it in there anywhere.

Any other ideas would be helpful. I'm on my way the the MS

web-site to see if I can download it somewhere. But yes,

I am running the Home ED.

TIA....Eric

|||

Then, as I said, you're stuck. Home Edition cannot run IIS. That would be a point of differentiation that helps sell the Pro edition.

|||

Yeah that's a bummer.

Well I'm just learning VB all over again.

I did some programming in VB6 for a little while.

So since I'm just learning VB 2005 maybe I won't

that functionality for awhile to come.

Thanks for the help......Eric

|||

If you want to do ASP.NET, I believe VS2005 has a mini web server built into it, but I don't believe that will help if SQL Server thinks it needs it for some reason ( I assume it needs it only to expose itself over the web, which you won't want to do anyhow ).

IIS and SQL Server 2005 Express Edition

hi

Currently have SQL Server 2005 Express Edition installed. Wanted to install reporting services, but wouldn't let me re no IIS as I only have Windows XP Home Edition.

My question is therefore: Is there any way of installing IIS to allow me to install Reporting Services for SQL Server 2005 Express Edition

Many thanks

Tim

Leicester, UK

Hi,

actually there is none without breakign the licensing rules.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I have XP Pro but IIS was not installed at the beginning.

I would want to use Sql Server 2005 Express ( with reporting ).

I never found the way to install IIS. Is There anybody who could tell me how to install IIS ?

I've installed the advanced version of Sql Server 2005 Express. Is there any problem to install IIS after SQL Server ?

Excuse me for my poor English and thank you for advance

Have a nice day

|||

hi to unistall IIS, you have to access the Setitngs, Control Panel Add or Remove Programs, Add or Remove Windows Components.. applet..

regards

|||

I too had a problem running/using reporting services as I didn't have IIS installed on my PC (XP Home edition).

After rebuilding the computer and installing XP Proffessional I installed SQL Express with Avd Services and Toolkit etc but forgot to install the IIS correctly (I think I installed the .net framework before installing IIS). So even after installing IIS my reports would not work.

After all that hassle I started AGAIN with a clean install of XP Proff, installed all the components of IIS, then installed the.net 2.0 framework and then installed SQL Express etc and it worked fine.

Good luck

Garry

|||

Thank you for your clear answer

I see that if you do not install IIS before SQL Server, it's impossible to use reporting services.

All i regreat is that Microsoft nowhere warns about that problem except at the beginning of the installation of SQL Server with a meagre warning.

I hope that Microsoft will correct this absence in the documentation to avoid complete desinstallation/installation of Visual Studio,net 2.0 framework and SQL Server.

Have all a good day

|||

There is no need to start everything from scratch if you have not installed IIS prior to installing SQL Server. There is a need to configure ASP.NET on IIS once you have installed it though because it doesn't happen automatically unless you install the .NET Framework 2.0 after IIS, which you didn't do. Instructions on how to register ASP.NET on IIS can be found here. Once you've registered ASP.NET, you can install Reporting Services by going into Add/Remove Programs, Selecting SQL Server 2005 and using the option to Change an existing installation. The maintenance mode installer will allow you to add Reporting Services to your installation without removing anything else.

As to the wish that we would document this, we do. Durring installation of SQL Server you are warned that IIS is not installed and you have the option of stoping the installation of SQL Server, installing IIS and then starting again.

Mike

IIS

I have .net 2003 installed on my pc without IIS, because in our organisation there is web server separate and there its installed IIS. Can anybody let me know how to configure my application to the server so that i can open my application. because its giving the following error

The Web server reported the following error when attempting to create or open the web project location at the following location URL:http://192.168.0.61/HelpDesk' http/1.1 503 Service unavailable.

im using windows 2000

is it possible to run asp.net application file from web server without installing IIS in my system.. please reply .

Its very urgent. Thanks

Sorry, this is not an IIS forum, but before you move over to another you should check if the Virtual Directory you want to use is exisiting on port 80, if the service is started and ready to answer requests on the WebServer. if you are starting a web application on a remote server, then yes, the execution of an ASP.NET application from a "simple" equiped client with just a brwoser is possible. if you want to host an ASP.NET application on your computer then you probably will need to have some sort of WebServer with support for ASP.NET.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

IIS

Hi,
A few of the machines have not got IIS installed (business related).
Is there a way to install sql server 2005 without having IIS on the machine?
Thanks

From my understanding the IIS Part is only for the reporting services, and som other smaller functions. You should remove the reporting service components and it should install.

|||

Tried that already and still sql server 2005 management studio does not appear.

|||

Are you able to install SQL Server?

What all components are you selcting while installing? Since you are not able to open Sql sever 2005, it seems like you are not selecting tools option.

Could you please give a snapshot of the error that you are getting?

(This http://msdn2.microsoft.com/en-us/library/ms143506.aspx mentions that “Reporting Services, which is installed as part of SQL Server Express with Advanced Services, will not install on operating systems that do not include Internet Information Services (IIS)”. There should be no problem in installing SQL server without IIS (We tried in our lab we were able to install SQL Server without IIS).)

Thanks

Arpita

|||

Management Studio can be installed regardless of whether IIS is installed.

Management Studio is one of the "Workstation components", so you need to check that checkbox on the "Components to Install" page of the setup wizard. If you need to be more selective, you can also click the "Advanced" button the "Components to Install" page, expand the "Client Components" folder, and then install just the Management Tools to your machine.

Hope this helps,
Steve

IIS

Hi,
A few of the machines have not got IIS installed (business related).
Is there a way to install sql server 2005 without having IIS on the machine?
Thanks

From my understanding the IIS Part is only for the reporting services, and som other smaller functions. You should remove the reporting service components and it should install.

|||

Tried that already and still sql server 2005 management studio does not appear.

|||

Are you able to install SQL Server?

What all components are you selcting while installing? Since you are not able to open Sql sever 2005, it seems like you are not selecting tools option.

Could you please give a snapshot of the error that you are getting?

(Thishttp://msdn2.microsoft.com/en-us/library/ms143506.aspx mentions that “Reporting Services, which is installed as part of SQL Server Express with Advanced Services, will not install on operating systems that do not include Internet Information Services (IIS)”. There should be no problem in installing SQL server without IIS (We tried in our lab we were able to install SQL Server without IIS).)

Thanks

Arpita

|||

Management Studio can be installed regardless of whether IIS is installed.

Management Studio is one of the "Workstation components", so you need to check that checkbox on the "Components to Install" page of the setup wizard. If you need to be more selective, you can also click the "Advanced" button the "Components to Install" page, expand the "Client Components" folder, and then install just the Management Tools to your machine.

Hope this helps,
Steve

Iis

Hi,
A few of the machines have not got IIS installed (business related).
Is there a way to install sql server 2005 without having IIS on the machine?
ThanksAs far as I've understood (I'm still on 2000), there's no need for IIS. At least it's not listed in the software requirements for Express Edition.

IIS

Hi,
A few of the machines have not got IIS installed (business related).
Is there a way to install sql server 2005 without having IIS on the machine?
Thanks

From my understanding the IIS Part is only for the reporting services, and som other smaller functions. You should remove the reporting service components and it should install.

|||

Tried that already and still sql server 2005 management studio does not appear.

|||

Are you able to install SQL Server?

What all components are you selcting while installing? Since you are not able to open Sql sever 2005, it seems like you are not selecting tools option.

Could you please give a snapshot of the error that you are getting?

(This http://msdn2.microsoft.com/en-us/library/ms143506.aspx mentions that “Reporting Services, which is installed as part of SQL Server Express with Advanced Services, will not install on operating systems that do not include Internet Information Services (IIS)”. There should be no problem in installing SQL server without IIS (We tried in our lab we were able to install SQL Server without IIS).)

Thanks

Arpita

|||

Management Studio can be installed regardless of whether IIS is installed.

Management Studio is one of the "Workstation components", so you need to check that checkbox on the "Components to Install" page of the setup wizard. If you need to be more selective, you can also click the "Advanced" button the "Components to Install" page, expand the "Client Components" folder, and then install just the Management Tools to your machine.

Hope this helps,
Steve