impact of changing recovery model on a database that is currently"live"

I'm running sql server 2005 standard edition. We have given up on sql
server replication for various reasons and are gonig to implement
transaction log shipping. I need to switch the database to "Full"
recovery model but owing to a fascinating combination of circumstances
and indecisiveness the server has had replication disabled before the
new backup stratgey is in place. I don't want to wait another day
before I get a replication strategy going to I want to go to FULl
model right NOW. However the databse is in use and I don't want things
to be disrupted. The database server is only lightly loaded (8 cores,
only one running at any one time above 10% and disk queue about 0.1)
and a few seconds of latency is OK..
is it safe to switch recovery model to FULL during working hours on a
production database?
thanks,
sam
sam,
Switching to full mode will not add appreciably to the load on your server,
but it will keep the logs until they are backed up, so you may see grown in
your log (.ldf) files.
When switching to full mode, the first thing to do is a full backup. This
may cause about a 10% hit on the throughput of that server during the time
of the backup. Again, a small price to pay.
Then be sure to schedule regular transaction log backups so that your
transactions are saved and the log files do not grow excessively. (At least
once a day, but depending on your work and its critical nature it could be
as often as every 5 minutes.)
RLF
"sam.m.gardiner" <sam.m.gardiner@.gmail.com> wrote in message
news:6ad20370-72c2-4fec-b623-81e35b63bc9d@.u69g2000hse.googlegroups.com...
> I'm running sql server 2005 standard edition. We have given up on sql
> server replication for various reasons and are gonig to implement
> transaction log shipping. I need to switch the database to "Full"
> recovery model but owing to a fascinating combination of circumstances
> and indecisiveness the server has had replication disabled before the
> new backup stratgey is in place. I don't want to wait another day
> before I get a replication strategy going to I want to go to FULl
> model right NOW. However the databse is in use and I don't want things
> to be disrupted. The database server is only lightly loaded (8 cores,
> only one running at any one time above 10% and disk queue about 0.1)
> and a few seconds of latency is OK..
> is it safe to switch recovery model to FULL during working hours on a
> production database?
> thanks,
> sam
|||ah thanks for that russell, the backup was also a worry.
but i was wondering about the actual moment of switch over, will that
cause any freeze or hang ups?
|||No, basically I understand it does two things.
1. Stops truncating the log
2. Increases the amount of logging done for BULK INSERTs. (If you don't
want this behaviour, the Bulk-Logged recovery model is similar to FULL, but
gives reduced coverage for the bulk inserts.)
RLF
"sam.m.gardiner" <sam.m.gardiner@.gmail.com> wrote in message
news:dde0ef2e-c103-48fd-a5f7-df76652da702@.b1g2000hsg.googlegroups.com...
> ah thanks for that russell, the backup was also a worry.
> but i was wondering about the actual moment of switch over, will that
> cause any freeze or hang ups?
|||thanks for your advice. the switch over was completed with no fuss and
took only a few seconds..
sam
sql

impact of changing recovery model on a database that is currently

I'm running sql server 2005 standard edition. We have given up on sql
server replication for various reasons and are gonig to implement
transaction log shipping. I need to switch the database to "Full"
recovery model but owing to a fascinating combination of circumstances
and indecisiveness the server has had replication disabled before the
new backup stratgey is in place. I don't want to wait another day
before I get a replication strategy going to I want to go to FULl
model right NOW. However the databse is in use and I don't want things
to be disrupted. The database server is only lightly loaded (8 cores,
only one running at any one time above 10% and disk queue about 0.1)
and a few seconds of latency is OK..
is it safe to switch recovery model to FULL during working hours on a
production database?
thanks,
samsam,
Switching to full mode will not add appreciably to the load on your server,
but it will keep the logs until they are backed up, so you may see grown in
your log (.ldf) files.
When switching to full mode, the first thing to do is a full backup. This
may cause about a 10% hit on the throughput of that server during the time
of the backup. Again, a small price to pay.
Then be sure to schedule regular transaction log backups so that your
transactions are saved and the log files do not grow excessively. (At least
once a day, but depending on your work and its critical nature it could be
as often as every 5 minutes.)
RLF
"sam.m.gardiner" <sam.m.gardiner@.gmail.com> wrote in message
news:6ad20370-72c2-4fec-b623-81e35b63bc9d@.u69g2000hse.googlegroups.com...
> I'm running sql server 2005 standard edition. We have given up on sql
> server replication for various reasons and are gonig to implement
> transaction log shipping. I need to switch the database to "Full"
> recovery model but owing to a fascinating combination of circumstances
> and indecisiveness the server has had replication disabled before the
> new backup stratgey is in place. I don't want to wait another day
> before I get a replication strategy going to I want to go to FULl
> model right NOW. However the databse is in use and I don't want things
> to be disrupted. The database server is only lightly loaded (8 cores,
> only one running at any one time above 10% and disk queue about 0.1)
> and a few seconds of latency is OK..
> is it safe to switch recovery model to FULL during working hours on a
> production database?
> thanks,
> sam|||ah thanks for that russell, the backup was also a worry.
but i was wondering about the actual moment of switch over, will that
cause any freeze or hang ups?|||No, basically I understand it does two things.
1. Stops truncating the log
2. Increases the amount of logging done for BULK INSERTs. (If you don't
want this behaviour, the Bulk-Logged recovery model is similar to FULL, but
gives reduced coverage for the bulk inserts.)
RLF
"sam.m.gardiner" <sam.m.gardiner@.gmail.com> wrote in message
news:dde0ef2e-c103-48fd-a5f7-df76652da702@.b1g2000hsg.googlegroups.com...
> ah thanks for that russell, the backup was also a worry.
> but i was wondering about the actual moment of switch over, will that
> cause any freeze or hang ups?|||thanks for your advice. the switch over was completed with no fuss and
took only a few seconds..
sam

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.

Imaging SQL 7

I am almost embarrassed to post this, but I have an NT4 sp6 machine running
SQL 7. the machine is as old as the software and I am concerned at some
point I will not be able to recover this machine. The reason for this is
that the application that uses SQL is an old legacy application that will be
replaced with in the next year, but it is not supported any longer, and no
one has any idea how to reinstall it, this was done before my time. Any ways
it is a critical reporting tool and is used daily. I was hoping that someone
out there knows of a way that I could image the server and restore the image
to a diffrent hardware, or even to a virtual machine. Most everything that I
have looked at supports imaging NT4 but not restoring the image to diffrent
hardware, or to a virtual machine. I am posting this hoping someone else may
have found a solutionYou are trying to relocate the SQL Server or the entire application? If it's
just SQL server, you can install 7.0 on a new server, and deatch and attach
the databases.
But I think you should try put it into virtual machine; we did for few older
servers. I can't personally say of issues because just SQL Server guy, but
nothing went horribly wrong for us.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Schuml" wrote:
> I am almost embarrassed to post this, but I have an NT4 sp6 machine running
> SQL 7. the machine is as old as the software and I am concerned at some
> point I will not be able to recover this machine. The reason for this is
> that the application that uses SQL is an old legacy application that will be
> replaced with in the next year, but it is not supported any longer, and no
> one has any idea how to reinstall it, this was done before my time. Any ways
> it is a critical reporting tool and is used daily. I was hoping that someone
> out there knows of a way that I could image the server and restore the image
> to a diffrent hardware, or even to a virtual machine. Most everything that I
> have looked at supports imaging NT4 but not restoring the image to diffrent
> hardware, or to a virtual machine. I am posting this hoping someone else may
> have found a solution|||Just found this ...
http://search.techrepublic.com.com/search/Microsoft+Virtual+Server+and+Microsoft+Windows+NT+4.0.html
Might find it interseting for yaa. Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Schuml" wrote:
> I am almost embarrassed to post this, but I have an NT4 sp6 machine running
> SQL 7. the machine is as old as the software and I am concerned at some
> point I will not be able to recover this machine. The reason for this is
> that the application that uses SQL is an old legacy application that will be
> replaced with in the next year, but it is not supported any longer, and no
> one has any idea how to reinstall it, this was done before my time. Any ways
> it is a critical reporting tool and is used daily. I was hoping that someone
> out there knows of a way that I could image the server and restore the image
> to a diffrent hardware, or even to a virtual machine. Most everything that I
> have looked at supports imaging NT4 but not restoring the image to diffrent
> hardware, or to a virtual machine. I am posting this hoping someone else may
> have found a solution|||Very good Information I think the Virtual route is the way to go, I thought
about the just moving the data, but the unfortunate thing is no one knows how
to load the application thats the sticky part but it sounds like the VSMT
with virtual server is the way to go I will pursue that route.|||Minding firing me a mail when you do this ;-). Our server ops don't tell me
anything, I get the like DBA and ServerOps don't mix >,<. I wish you best
of luck ;-).
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Schuml" wrote:
> Very good Information I think the Virtual route is the way to go, I thought
> about the just moving the data, but the unfortunate thing is no one knows how
> to load the application thats the sticky part but it sounds like the VSMT
> with virtual server is the way to go I will pursue that route.
>

Images are fuzzy...

So, I actually have RS up and running and I've solved all the other issues with permissions and such. But a small problem is occuring that I'd like to get help with.
I have images in some of my reports. I've embeded some of them directly into the report and used a URL for others. The problem is that the images display and print fuzzy. The actual image files are hi-res and sharp. I've set the images to autosize so them match the real image in size, but everything is still fuzzy.
Is there a prefered way to display images so they're sharp? Is there a prefered image format, jpeg, bmp, etc?
Thanks!What renderer do you use?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in message
news:3F5158F3-D817-4326-BE07-B4F6D2982C5C@.microsoft.com...
> So, I actually have RS up and running and I've solved all the other issues
> with permissions and such. But a small problem is occuring that I'd like
> to get help with.
> I have images in some of my reports. I've embeded some of them directly
> into the report and used a URL for others. The problem is that the images
> display and print fuzzy. The actual image files are hi-res and sharp.
> I've set the images to autosize so them match the real image in size, but
> everything is still fuzzy.
> Is there a prefered way to display images so they're sharp? Is there a
> prefered image format, jpeg, bmp, etc?
> Thanks!|||Sorry. Using the PDF renderer, can't use any other so it has to be PDF.
Thanks!
"Lev Semenets [MSFT]" wrote:
> What renderer do you use?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in message
> news:3F5158F3-D817-4326-BE07-B4F6D2982C5C@.microsoft.com...
> > So, I actually have RS up and running and I've solved all the other issues
> > with permissions and such. But a small problem is occuring that I'd like
> > to get help with.
> >
> > I have images in some of my reports. I've embeded some of them directly
> > into the report and used a URL for others. The problem is that the images
> > display and print fuzzy. The actual image files are hi-res and sharp.
> > I've set the images to autosize so them match the real image in size, but
> > everything is still fuzzy.
> >
> > Is there a prefered way to display images so they're sharp? Is there a
> > prefered image format, jpeg, bmp, etc?
> >
> > Thanks!
>
>|||Just wondering - are you using SP1?
You can specify the DPI of images using some the PDF rendering device
information settings. I think we default to 300 DPI which should be pretty
good.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in message
news:D70FB400-86C5-44BB-9630-BB43A3E5345C@.microsoft.com...
> Sorry. Using the PDF renderer, can't use any other so it has to be PDF.
> Thanks!
> "Lev Semenets [MSFT]" wrote:
>> What renderer do you use?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in message
>> news:3F5158F3-D817-4326-BE07-B4F6D2982C5C@.microsoft.com...
>> > So, I actually have RS up and running and I've solved all the other
>> > issues
>> > with permissions and such. But a small problem is occuring that I'd
>> > like
>> > to get help with.
>> >
>> > I have images in some of my reports. I've embeded some of them
>> > directly
>> > into the report and used a URL for others. The problem is that the
>> > images
>> > display and print fuzzy. The actual image files are hi-res and sharp.
>> > I've set the images to autosize so them match the real image in size,
>> > but
>> > everything is still fuzzy.
>> >
>> > Is there a prefered way to display images so they're sharp? Is there a
>> > prefered image format, jpeg, bmp, etc?
>> >
>> > Thanks!
>>|||Yep, SP1 is installed. I'll look into the DPI settings and see if that changes anything.
Are jpegs the way to format the images or is there a better format? Also, does embedding them vs. linking do anything for me?
Thanks!
"Brian Welcker [MSFT]" wrote:
> Just wondering - are you using SP1?
> You can specify the DPI of images using some the PDF rendering device
> information settings. I think we default to 300 DPI which should be pretty
> good.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in message
> news:D70FB400-86C5-44BB-9630-BB43A3E5345C@.microsoft.com...
> > Sorry. Using the PDF renderer, can't use any other so it has to be PDF.
> >
> > Thanks!
> >
> > "Lev Semenets [MSFT]" wrote:
> >
> >> What renderer do you use?
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in message
> >> news:3F5158F3-D817-4326-BE07-B4F6D2982C5C@.microsoft.com...
> >> > So, I actually have RS up and running and I've solved all the other
> >> > issues
> >> > with permissions and such. But a small problem is occuring that I'd
> >> > like
> >> > to get help with.
> >> >
> >> > I have images in some of my reports. I've embeded some of them
> >> > directly
> >> > into the report and used a URL for others. The problem is that the
> >> > images
> >> > display and print fuzzy. The actual image files are hi-res and sharp.
> >> > I've set the images to autosize so them match the real image in size,
> >> > but
> >> > everything is still fuzzy.
> >> >
> >> > Is there a prefered way to display images so they're sharp? Is there a
> >> > prefered image format, jpeg, bmp, etc?
> >> >
> >> > Thanks!
> >>
> >>
> >>
>
>|||Yep, SP1 is installed. I'll look into the DPI settings and see if that changes anything.
Are jpegs the way to format the images or is there a better format? Also, does embedding them vs. linking do anything for me?
Thanks!
"Brian Welcker [MSFT]" wrote:
> Just wondering - are you using SP1?
> You can specify the DPI of images using some the PDF rendering device
> information settings. I think we default to 300 DPI which should be pretty
> good.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in message
> news:D70FB400-86C5-44BB-9630-BB43A3E5345C@.microsoft.com...
> > Sorry. Using the PDF renderer, can't use any other so it has to be PDF.
> >
> > Thanks!
> >
> > "Lev Semenets [MSFT]" wrote:
> >
> >> What renderer do you use?
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in message
> >> news:3F5158F3-D817-4326-BE07-B4F6D2982C5C@.microsoft.com...
> >> > So, I actually have RS up and running and I've solved all the other
> >> > issues
> >> > with permissions and such. But a small problem is occuring that I'd
> >> > like
> >> > to get help with.
> >> >
> >> > I have images in some of my reports. I've embeded some of them
> >> > directly
> >> > into the report and used a URL for others. The problem is that the
> >> > images
> >> > display and print fuzzy. The actual image files are hi-res and sharp.
> >> > I've set the images to autosize so them match the real image in size,
> >> > but
> >> > everything is still fuzzy.
> >> >
> >> > Is there a prefered way to display images so they're sharp? Is there a
> >> > prefered image format, jpeg, bmp, etc?
> >> >
> >> > Thanks!
> >>
> >>
> >>
>
>|||Embedding vs. linking doesn't matter. JPEG might resize a bit better but it
shouldn't matter.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in message
news:1EB2B5A5-92ED-485A-9997-2E7D0600C1C3@.microsoft.com...
> Yep, SP1 is installed. I'll look into the DPI settings and see if that
> changes anything.
> Are jpegs the way to format the images or is there a better format? Also,
> does embedding them vs. linking do anything for me?
> Thanks!
> "Brian Welcker [MSFT]" wrote:
>> Just wondering - are you using SP1?
>> You can specify the DPI of images using some the PDF rendering device
>> information settings. I think we default to 300 DPI which should be
>> pretty
>> good.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in message
>> news:D70FB400-86C5-44BB-9630-BB43A3E5345C@.microsoft.com...
>> > Sorry. Using the PDF renderer, can't use any other so it has to be
>> > PDF.
>> >
>> > Thanks!
>> >
>> > "Lev Semenets [MSFT]" wrote:
>> >
>> >> What renderer do you use?
>> >>
>> >> --
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:3F5158F3-D817-4326-BE07-B4F6D2982C5C@.microsoft.com...
>> >> > So, I actually have RS up and running and I've solved all the other
>> >> > issues
>> >> > with permissions and such. But a small problem is occuring that I'd
>> >> > like
>> >> > to get help with.
>> >> >
>> >> > I have images in some of my reports. I've embeded some of them
>> >> > directly
>> >> > into the report and used a URL for others. The problem is that the
>> >> > images
>> >> > display and print fuzzy. The actual image files are hi-res and
>> >> > sharp.
>> >> > I've set the images to autosize so them match the real image in
>> >> > size,
>> >> > but
>> >> > everything is still fuzzy.
>> >> >
>> >> > Is there a prefered way to display images so they're sharp? Is
>> >> > there a
>> >> > prefered image format, jpeg, bmp, etc?
>> >> >
>> >> > Thanks!
>> >>
>> >>
>> >>
>>

Image in Page Header

I'm running into an problem where I have an image in the page header of my report and I added sorting options to my column headers. When I sort the column when viewing the report, the image in the page header does not appear anymore (the little red box appears instead of the image.) Has anyone run into this same problem and figured out to fix it?

Thanks!

I think you want to post your question to SQL Server Reporting Services (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1)

Ovidiu

I'm gonna SHOOT the @#$% server!

Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual directory
using the SQLXML IIS utility and all is well. BUT... when I try connecting
to the web service via VS.NET, I keep getting this...
ERROR: 400.100 Bad Request
HResult: 0x80004005
Source: Microsoft SQL isapi extension
Description: The virtual name could not be recognized
I even get that if I try browsing the WSDL file directly from IE.
Now I've checked the security, I've checked the configuration, I've checked
it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
Now the odd thing is if I disable the application on that virtual directory
(thus stopping the maaping through the DLL, I can properly browse the WSDL
file. HUH?
So... anyone got any ideas and if not, any bullets or a large mallet?
Mark
Please don't shoot.
I forwarded your problem to one of the people of the SQLXML team and hope he
will reply to you.
Best regards
Michael
"Mark A. Donohoe" <Mark (at) MarkDonohoe.com> wrote in message
news:D27F9BE8-F783-41E8-83B8-8A3393EDF2F4@.microsoft.com...
> Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
> Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual
> directory
> using the SQLXML IIS utility and all is well. BUT... when I try
> connecting
> to the web service via VS.NET, I keep getting this...
> ERROR: 400.100 Bad Request
> HResult: 0x80004005
> Source: Microsoft SQL isapi extension
> Description: The virtual name could not be recognized
> I even get that if I try browsing the WSDL file directly from IE.
> Now I've checked the security, I've checked the configuration, I've
> checked
> it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
> Now the odd thing is if I disable the application on that virtual
> directory
> (thus stopping the maaping through the DLL, I can properly browse the WSDL
> file. HUH?
> So... anyone got any ideas and if not, any bullets or a large mallet?
> Mark
|||Hi there,
Do you have the SOAP Toolkit 2.0 installed? SqlXml 3.0 SP2 requires it for
using web services. However, if you can wait a bit longer, we will be
releasing SP3 which removes that dependency so SOAP Toolkit is no longer
needed.
Thanks,
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://blogs.msdn.com/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark A. Donohoe" <Mark (at) MarkDonohoe.com> wrote in message
news:D27F9BE8-F783-41E8-83B8-8A3393EDF2F4@.microsoft.com...
> Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
> Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual
> directory
> using the SQLXML IIS utility and all is well. BUT... when I try
> connecting
> to the web service via VS.NET, I keep getting this...
> ERROR: 400.100 Bad Request
> HResult: 0x80004005
> Source: Microsoft SQL isapi extension
> Description: The virtual name could not be recognized
> I even get that if I try browsing the WSDL file directly from IE.
> Now I've checked the security, I've checked the configuration, I've
> checked
> it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
> Now the odd thing is if I disable the application on that virtual
> directory
> (thus stopping the maaping through the DLL, I can properly browse the WSDL
> file. HUH?
> So... anyone got any ideas and if not, any bullets or a large mallet?
> Mark

IIS Service is getting down very frequently

Hi All,

We are having one web service it is running in iis 5.0.now a days it is getting down very frequently.can any one help me on this what could be the problem.

where i can see the log details when the service get down.

Hi,

Check the event logs and see if you find anything there. Paste the IIS/Web related events here.

IIS Server

I have a SQL Database that is used for storage for an application located on a IIS server.

The users are having a hard time running reports, and automatically assume that it is the SQL Database. I have look in all of the logs, I have done a dbcc checkdb and everything looks fine.

However when I go to the IIS server itself in the event logs there are all sorts of error like the one below:

Error occurred in file:
'D:\teamtrack\Source\Servers\NotificationServer\NS ServerEvents.cpp', line 611.
Resource Msg Id = 474

An error occurred while connecting to
the server.

Message id 38340 could not be sent to (email_address.com.

Does this seems like a sql problem?

Please advise.

LystraSQL Server and IIS do not play well on the same server. You may have to throttle SQL Server's use of memory on the box so that IIS is not memory starved. Search the KnowledgeBase site or Google the microsoft.public.* groups with IIS , SQL Server, and memory keywords.

This sounds reminiscent of a question in the microsoft admin test that I took years ago.

HTH

Tom|||Thanks Tom,

It is not on the same server. I am getting error like below:



Exception occurred in file:
'D:\teamtrack\Source\Db\AppRecord.cpp', line 2827.
Resource Msg Id = 451


The '' record could not be updated in the 'Support Services' database table.

No rows were affected by the update or delete operation.

It looks like a update issue. How should I go about troubleshooting this problem???

Lystra|||In order to narrow down if this is a SQL server problem, or an IIS/Application problem, you coudl get profiler running on the SQL Server to trace all error events. The output will be somewhat confusing, as Profiler will not give you the text of the error message, and some of the messages are actually "normal". I never knew how many "Object not found" errors Enterprise manager could throw.

With this trace, you will find any overt SQL error that the database may be having. Things like the application having timeout issues would be missed by this, as Profiler will only trace server side events.

In order to catch possible timeouts, you could trace for any statement that takes more than 30,000 ms. If you see a lot of these, then you could have either poor database performance, or lock contention.|||I will try using the profiler.

I ran across an article form MS Knowledge base entitled:

There many not be enought virtual memory with large number of database.

Currently the database size is 1.40 GB, and log size is 208MB.

For the server properties on the memory tab it have User a fixed memory size 1494 and the minimun query memory is fixed at 1024.

Is there a way to check to see if memory is okay for the server itself?

Thanks

Lystra|||HELPPPP!!!

Does anyone have any ideas?

IIS security problem

Hi,
I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1). IIS has all the patches that I can find. While IIS running, this computer has been hijacked or turn to proxy server to deliver spam mails. How can I provent it (no smpt service running.)I am not sure I understand the issue you're facing, can you explain some
more?
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"csoon" <csoon@.discussions.microsoft.com> wrote in message
news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> Hi,
> I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1). IIS
has all the patches that I can find. While IIS running, this computer has
been hijacked or turn to proxy server to deliver spam mails. How can I
provent it (no smpt service running.)|||Note that you do not need to have either an email client nor an email server
running. There would be no way for your server to be hijacked if you do not
have these installed. Yes, you can use either but you do not need to. I am
configured where RS sends the email to an SMTP server which resides
elsewhere.
Bruce L-C
"csoon" <csoon@.discussions.microsoft.com> wrote in message
news:CFC072A9-A3E9-46A2-BDAF-ECD7BE320BB9@.microsoft.com...
> I keep getting email indicate that my computer was hijack and used as
proxy server to deliver hugh emails while IIS5.0 running. It is very
difficult to get budget to try sql reporting service specially it is not
secure. First I did implement sending email in sql reporting service by
changing in configuration file (drop off email files in a folder to smtp to
pick them up). Once I had this problem then I turned off smtp but I still
got emails indicated that my computer was hijacked. I installed lock down
IIS and all the patch for IIS5.0. I would like to try RS but if I still
cause problem to others, I might not be able to test or implement this
software. If you need more info. please let me know.
> "Tudor Trufinescu (MSFT)" wrote:
> > I am not sure I understand the issue you're facing, can you explain some
> > more?
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "csoon" <csoon@.discussions.microsoft.com> wrote in message
> > news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> > > Hi,
> > > I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1).
IIS
> > has all the patches that I can find. While IIS running, this computer
has
> > been hijacked or turn to proxy server to deliver spam mails. How can I
> > provent it (no smpt service running.)
> >
> >
> >|||Thanks. Unfortunately, this is a test on my computer, I have to have mail client on this computer.
"Bruce Loehle-Conger" wrote:
> Note that you do not need to have either an email client nor an email server
> running. There would be no way for your server to be hijacked if you do not
> have these installed. Yes, you can use either but you do not need to. I am
> configured where RS sends the email to an SMTP server which resides
> elsewhere.
> Bruce L-C
> "csoon" <csoon@.discussions.microsoft.com> wrote in message
> news:CFC072A9-A3E9-46A2-BDAF-ECD7BE320BB9@.microsoft.com...
> > I keep getting email indicate that my computer was hijack and used as
> proxy server to deliver hugh emails while IIS5.0 running. It is very
> difficult to get budget to try sql reporting service specially it is not
> secure. First I did implement sending email in sql reporting service by
> changing in configuration file (drop off email files in a folder to smtp to
> pick them up). Once I had this problem then I turned off smtp but I still
> got emails indicated that my computer was hijacked. I installed lock down
> IIS and all the patch for IIS5.0. I would like to try RS but if I still
> cause problem to others, I might not be able to test or implement this
> software. If you need more info. please let me know.
> >
> > "Tudor Trufinescu (MSFT)" wrote:
> >
> > > I am not sure I understand the issue you're facing, can you explain some
> > > more?
> > >
> > > --
> > > Tudor Trufinescu
> > > Dev Lead
> > > Sql Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "csoon" <csoon@.discussions.microsoft.com> wrote in message
> > > news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> > > > Hi,
> > > > I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1).
> IIS
> > > has all the patches that I can find. While IIS running, this computer
> has
> > > been hijacked or turn to proxy server to deliver spam mails. How can I
> > > provent it (no smpt service running.)
> > >
> > >
> > >
>
>

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 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

IIS and SQL on same server?

Are there any problems with running an ASP based application over IIS and
the SQL Server to supply data to this application from the same physical
server?
This will not be a heavy-use application/database - probably about 25-50
users, only about 5-10 concurrent I would have thought.Hardware wise there are no problems; just install the proper hardware, i.e.,
memory & processing. But you have to consider security. Typically your db
server will be behind the firewall and the web server will be in a DMZ
(technically also behind a firewall.) For fairly obvious reasons, this is
because web servers can typically be hacked through weaknesses in the web
page's code and weaknesses in IIS. This really falls under the "even though
it _can_ be done, should I do it?"
Your main concern should be security; first and foremost. I would not do
it.
hth
Eric
"Keith" <@..> wrote in message
news:%23vOIzuyEEHA.1368@.TK2MSFTNGP11.phx.gbl...
> Are there any problems with running an ASP based application over IIS and
> the SQL Server to supply data to this application from the same physical
> server?
> This will not be a heavy-use application/database - probably about 25-50
> users, only about 5-10 concurrent I would have thought.
>|||Thanks
I had not thought of that until you mentioned it, but it is a very good
point.
Two servers it is then.
"Eric Sabine" <mopar41@.___ho_y_tmail.ScPoAmM> wrote in message
news:%23YZn2DzEEHA.2076@.TK2MSFTNGP09.phx.gbl...
> hardware wise there are no problems; just install the proper hardware,
i.e.,
> memory & processing. But you have to consider security. Typically your
db
> server will be behind the firewall and the web server will be in a DMZ
> (technically also behind a firewall.) For fairly obvious reasons, this is
> because web servers can typically be hacked through weaknesses in the web
> page's code and weaknesses in IIS. This really falls under the "even
though
> it _can_ be done, should I do it?"
> Your main concern should be security; first and foremost. I would not do
> it.
> hth
> Eric
>
> "Keith" <@..> wrote in message
> news:%23vOIzuyEEHA.1368@.TK2MSFTNGP11.phx.gbl...
and
>|||That's my philosophy too. Yes you can, no you shouldn't.
"Keith" <@..> wrote in message news:%23$4TbNzEEHA.628@.TK2MSFTNGP10.phx.gbl...
> Thanks
> I had not thought of that until you mentioned it, but it is a very good
> point.
> Two servers it is then.
>
> "Eric Sabine" <mopar41@.___ho_y_tmail.ScPoAmM> wrote in message
> news:%23YZn2DzEEHA.2076@.TK2MSFTNGP09.phx.gbl...
> i.e.,
> db
is
web
> though
do
> and
physical
25-50
>

IIS and Internet Access

Hi All,
I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I get
nothing back. I can access my web projects but cant access and display
reports from web. I am using a static ip address to access the website for
now. I don't have a domain name setup for this box yet if that makes a
difference. and internally when I refer to the box in the website I use the
boxs computer name. Any ideas on what could be wrong here?
Thanks,
JJThis topic might help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JJ" <JJ@.discussions.microsoft.com> wrote in message
news:9B7DEDB4-0940-4FED-B6C9-0F05CCDBEF43@.microsoft.com...
> Hi All,
> I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access my web projects but cant access and display
> reports from web. I am using a static ip address to access the website for
> now. I don't have a domain name setup for this box yet if that makes a
> difference. and internally when I refer to the box in the website I use
> the
> boxs computer name. Any ideas on what could be wrong here?
> Thanks,
> JJ|||Hi,
Did you arrange security settings for the browsing reports?
You should grant "Browser" Role to Guests or everyone from the Report
Manager to the folder where your reports are.
Eralper
http://www.kodyaz.com
"JJ" wrote:
> Hi All,
> I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I get
> nothing back. I can access my web projects but cant access and display
> reports from web. I am using a static ip address to access the website for
> now. I don't have a domain name setup for this box yet if that makes a
> difference. and internally when I refer to the box in the website I use the
> boxs computer name. Any ideas on what could be wrong here?
> Thanks,
> JJ|||Hi eralper,
Man I am so feed up trying to get Reporting Services to be accessed from
the web. I have windows 2003 server running Sql Server 2000 with Reporting
Services sp2 installed. I can see and execute the reports through Report
Manager with no problem internally. But when I have a buddy check out the
website using an IP address. He gets nothing. I have setup roles for
IUSR_Account as browser role and assigned the report trying to access to the
security property under report. In the datasource for report I have included
the user name and password that matchs a windows account mapped to a Sql
server user account. No problem there. How do you have IIS setup under
Directory securities for Report and Report Manager set?
I don't have a domain name setup for this server yet. I am using Static IP
address for the moment. Are you using SSL for Reporting Services? What else
should I check?
Thanks,
JJ
"eralper" wrote:
> Hi,
> Did you arrange security settings for the browsing reports?
> You should grant "Browser" Role to Guests or everyone from the Report
> Manager to the folder where your reports are.
> Eralper
> http://www.kodyaz.com
> "JJ" wrote:
> > Hi All,
> >
> > I have the following going on: A win 2k3 server running sql server and
> > reporting services. I have IIS configured on it and can run reports
> > internally on my network but when I try to access a report from the web I get
> > nothing back. I can access my web projects but cant access and display
> > reports from web. I am using a static ip address to access the website for
> > now. I don't have a domain name setup for this box yet if that makes a
> > difference. and internally when I refer to the box in the website I use the
> > boxs computer name. Any ideas on what could be wrong here?
> >
> > Thanks,
> >
> > JJ|||Hi JJ,
I tried to give a detailed answer on
http://www.kodyaz.com/ShowPost.aspx?PostID=19
I hope it helps.
Eralper
http://www.kodyaz.com
"JJ" wrote:
> Hi eralper,
> Man I am so feed up trying to get Reporting Services to be accessed from
> the web. I have windows 2003 server running Sql Server 2000 with Reporting
> Services sp2 installed. I can see and execute the reports through Report
> Manager with no problem internally. But when I have a buddy check out the
> website using an IP address. He gets nothing. I have setup roles for
> IUSR_Account as browser role and assigned the report trying to access to the
> security property under report. In the datasource for report I have included
> the user name and password that matchs a windows account mapped to a Sql
> server user account. No problem there. How do you have IIS setup under
> Directory securities for Report and Report Manager set?
> I don't have a domain name setup for this server yet. I am using Static IP
> address for the moment. Are you using SSL for Reporting Services? What else
> should I check?
> Thanks,
> JJ
>
> "eralper" wrote:
> >
> > Hi,
> >
> > Did you arrange security settings for the browsing reports?
> >
> > You should grant "Browser" Role to Guests or everyone from the Report
> > Manager to the folder where your reports are.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> > "JJ" wrote:
> >
> > > Hi All,
> > >
> > > I have the following going on: A win 2k3 server running sql server and
> > > reporting services. I have IIS configured on it and can run reports
> > > internally on my network but when I try to access a report from the web I get
> > > nothing back. I can access my web projects but cant access and display
> > > reports from web. I am using a static ip address to access the website for
> > > now. I don't have a domain name setup for this box yet if that makes a
> > > difference. and internally when I refer to the box in the website I use the
> > > boxs computer name. Any ideas on what could be wrong here?
> > >
> > > Thanks,
> > >
> > > JJ|||Hi Eralper,
I tried to access your website but I keep on getting Obj ref not set
error. This is happening even when I enter www. kodyak.com.
Thanks,
JJ
"eralper" wrote:
> Hi JJ,
> I tried to give a detailed answer on
> http://www.kodyaz.com/ShowPost.aspx?PostID=19
> I hope it helps.
> Eralper
> http://www.kodyaz.com
>
> "JJ" wrote:
> > Hi eralper,
> >
> > Man I am so feed up trying to get Reporting Services to be accessed from
> > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > Services sp2 installed. I can see and execute the reports through Report
> > Manager with no problem internally. But when I have a buddy check out the
> > website using an IP address. He gets nothing. I have setup roles for
> > IUSR_Account as browser role and assigned the report trying to access to the
> > security property under report. In the datasource for report I have included
> > the user name and password that matchs a windows account mapped to a Sql
> > server user account. No problem there. How do you have IIS setup under
> > Directory securities for Report and Report Manager set?
> >
> > I don't have a domain name setup for this server yet. I am using Static IP
> > address for the moment. Are you using SSL for Reporting Services? What else
> > should I check?
> >
> > Thanks,
> >
> > JJ
> >
> >
> > "eralper" wrote:
> >
> > >
> > > Hi,
> > >
> > > Did you arrange security settings for the browsing reports?
> > >
> > > You should grant "Browser" Role to Guests or everyone from the Report
> > > Manager to the folder where your reports are.
> > >
> > > Eralper
> > > http://www.kodyaz.com
> > >
> > > "JJ" wrote:
> > >
> > > > Hi All,
> > > >
> > > > I have the following going on: A win 2k3 server running sql server and
> > > > reporting services. I have IIS configured on it and can run reports
> > > > internally on my network but when I try to access a report from the web I get
> > > > nothing back. I can access my web projects but cant access and display
> > > > reports from web. I am using a static ip address to access the website for
> > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > difference. and internally when I refer to the box in the website I use the
> > > > boxs computer name. Any ideas on what could be wrong here?
> > > >
> > > > Thanks,
> > > >
> > > > JJ|||Hi,
Actually my configuration differs from yours with my web server is IIS5
working on Win2k. But I believe this will not cause a problem for anonymous
access to reports after the steps I'll try to summarize below.
Considering the site security, I'm not sure this is the best practice for
reporting services application but it seems working.
First you can view and run reports without problem because default
authentication method for virtual directories "Reports" and "ReportServer" is
window authentication. And I think you browse the reports with an admin group
user.
With these default configurations of the setup of Reporting Services, your
buddy should be able to get the username and password screen for windows
authentication when he calls http://YourIPComesHere/Reports
If you change IIS permissions for these two virtual directories (Reports &
ReportServer), your buddy should see an empty page because the internet guest
account has no browser role permission on none of the folders below home
(pointing VS.Net Reporting Services projects) or the individual reports in
those folders.
So before switching to anonymous access on these virtual directories, you
should grant Browser role permission to "everyone" in approtiate folders and
reports.
I used "everyone", I do not know if it makes sense for IUSR_ComputerName
So first go to Home directory (http://YourServer/Reports). Select Properties
tab for Home and hit the "New Role Assignment" button to add "everyone" as
Browser. By doing this, anonymous users will be able to list contents of the
Reports folder.
Second, select "Detailed View" and "Edit" the report folder where your
reports are deployed. Go to Security tab and add "everyone" as Browser.
I'm not sure but you may need to repeat a similar step (adding everyone as
Browser) for the reports.
You should hide the datasources in the list by editing their properties.
Check the "hide in list view" option in General tab.
One important note: you must edit RSWebApplication config file in
"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager" folder (default place for this configuration file)
Update ReportServerURL by changing the computer name with your IP. Otherwise
users will be able reach the report but will not be able to see it processing.
Now is time for changing the permissions of the two virtual directories
Reports and ReportServer via IIS Manager. Go to properties of the virtual
directories then select directory security tab. And allow anonymous access.
This configuration works for me. I hope you may find something useful within
my notes.
Eralper
http://www.kodyaz.com
"JJ" wrote:
> Hi Eralper,
> I tried to access your website but I keep on getting Obj ref not set
> error. This is happening even when I enter www. kodyak.com.
> Thanks,
> JJ
> "eralper" wrote:
> > Hi JJ,
> >
> > I tried to give a detailed answer on
> > http://www.kodyaz.com/ShowPost.aspx?PostID=19
> >
> > I hope it helps.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> >
> > "JJ" wrote:
> >
> > > Hi eralper,
> > >
> > > Man I am so feed up trying to get Reporting Services to be accessed from
> > > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > > Services sp2 installed. I can see and execute the reports through Report
> > > Manager with no problem internally. But when I have a buddy check out the
> > > website using an IP address. He gets nothing. I have setup roles for
> > > IUSR_Account as browser role and assigned the report trying to access to the
> > > security property under report. In the datasource for report I have included
> > > the user name and password that matchs a windows account mapped to a Sql
> > > server user account. No problem there. How do you have IIS setup under
> > > Directory securities for Report and Report Manager set?
> > >
> > > I don't have a domain name setup for this server yet. I am using Static IP
> > > address for the moment. Are you using SSL for Reporting Services? What else
> > > should I check?
> > >
> > > Thanks,
> > >
> > > JJ
> > >
> > >
> > > "eralper" wrote:
> > >
> > > >
> > > > Hi,
> > > >
> > > > Did you arrange security settings for the browsing reports?
> > > >
> > > > You should grant "Browser" Role to Guests or everyone from the Report
> > > > Manager to the folder where your reports are.
> > > >
> > > > Eralper
> > > > http://www.kodyaz.com
> > > >
> > > > "JJ" wrote:
> > > >
> > > > > Hi All,
> > > > >
> > > > > I have the following going on: A win 2k3 server running sql server and
> > > > > reporting services. I have IIS configured on it and can run reports
> > > > > internally on my network but when I try to access a report from the web I get
> > > > > nothing back. I can access my web projects but cant access and display
> > > > > reports from web. I am using a static ip address to access the website for
> > > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > > difference. and internally when I refer to the box in the website I use the
> > > > > boxs computer name. Any ideas on what could be wrong here?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > JJ|||When you mean grant access to everyone do you mean use IUSR_Compname account
and assign to folders.
By the way I really like your website! Any ideas on what's causing the
error? Would like to access it again. Did you build it yourself?
Thanks,
JJ
"eralper" wrote:
> Hi,
> Actually my configuration differs from yours with my web server is IIS5
> working on Win2k. But I believe this will not cause a problem for anonymous
> access to reports after the steps I'll try to summarize below.
> Considering the site security, I'm not sure this is the best practice for
> reporting services application but it seems working.
> First you can view and run reports without problem because default
> authentication method for virtual directories "Reports" and "ReportServer" is
> window authentication. And I think you browse the reports with an admin group
> user.
> With these default configurations of the setup of Reporting Services, your
> buddy should be able to get the username and password screen for windows
> authentication when he calls http://YourIPComesHere/Reports
> If you change IIS permissions for these two virtual directories (Reports &
> ReportServer), your buddy should see an empty page because the internet guest
> account has no browser role permission on none of the folders below home
> (pointing VS.Net Reporting Services projects) or the individual reports in
> those folders.
> So before switching to anonymous access on these virtual directories, you
> should grant Browser role permission to "everyone" in approtiate folders and
> reports.
> I used "everyone", I do not know if it makes sense for IUSR_ComputerName
> So first go to Home directory (http://YourServer/Reports). Select Properties
> tab for Home and hit the "New Role Assignment" button to add "everyone" as
> Browser. By doing this, anonymous users will be able to list contents of the
> Reports folder.
> Second, select "Detailed View" and "Edit" the report folder where your
> reports are deployed. Go to Security tab and add "everyone" as Browser.
> I'm not sure but you may need to repeat a similar step (adding everyone as
> Browser) for the reports.
> You should hide the datasources in the list by editing their properties.
> Check the "hide in list view" option in General tab.
> One important note: you must edit RSWebApplication config file in
> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager" folder (default place for this configuration file)
> Update ReportServerURL by changing the computer name with your IP. Otherwise
> users will be able reach the report but will not be able to see it processing.
> Now is time for changing the permissions of the two virtual directories
> Reports and ReportServer via IIS Manager. Go to properties of the virtual
> directories then select directory security tab. And allow anonymous access.
>
> This configuration works for me. I hope you may find something useful within
> my notes.
> Eralper
> http://www.kodyaz.com
> "JJ" wrote:
> > Hi Eralper,
> >
> > I tried to access your website but I keep on getting Obj ref not set
> > error. This is happening even when I enter www. kodyak.com.
> >
> > Thanks,
> >
> > JJ
> >
> > "eralper" wrote:
> >
> > > Hi JJ,
> > >
> > > I tried to give a detailed answer on
> > > http://www.kodyaz.com/ShowPost.aspx?PostID=19
> > >
> > > I hope it helps.
> > >
> > > Eralper
> > > http://www.kodyaz.com
> > >
> > >
> > > "JJ" wrote:
> > >
> > > > Hi eralper,
> > > >
> > > > Man I am so feed up trying to get Reporting Services to be accessed from
> > > > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > > > Services sp2 installed. I can see and execute the reports through Report
> > > > Manager with no problem internally. But when I have a buddy check out the
> > > > website using an IP address. He gets nothing. I have setup roles for
> > > > IUSR_Account as browser role and assigned the report trying to access to the
> > > > security property under report. In the datasource for report I have included
> > > > the user name and password that matchs a windows account mapped to a Sql
> > > > server user account. No problem there. How do you have IIS setup under
> > > > Directory securities for Report and Report Manager set?
> > > >
> > > > I don't have a domain name setup for this server yet. I am using Static IP
> > > > address for the moment. Are you using SSL for Reporting Services? What else
> > > > should I check?
> > > >
> > > > Thanks,
> > > >
> > > > JJ
> > > >
> > > >
> > > > "eralper" wrote:
> > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > > Did you arrange security settings for the browsing reports?
> > > > >
> > > > > You should grant "Browser" Role to Guests or everyone from the Report
> > > > > Manager to the folder where your reports are.
> > > > >
> > > > > Eralper
> > > > > http://www.kodyaz.com
> > > > >
> > > > > "JJ" wrote:
> > > > >
> > > > > > Hi All,
> > > > > >
> > > > > > I have the following going on: A win 2k3 server running sql server and
> > > > > > reporting services. I have IIS configured on it and can run reports
> > > > > > internally on my network but when I try to access a report from the web I get
> > > > > > nothing back. I can access my web projects but cant access and display
> > > > > > reports from web. I am using a static ip address to access the website for
> > > > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > > > difference. and internally when I refer to the box in the website I use the
> > > > > > boxs computer name. Any ideas on what could be wrong here?
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > JJ|||Hi,
I wrote "everyone" which will include "IUSR_Compname" also in the textbox
while defining a new role for folders. But I believe "IUSR_Compname" will
also work.
Thanks for your appreciation. One of my friends also said he had a problem
after the first use of the site. I will be checking what is going on and
inform you :)
"JJ" wrote:
> When you mean grant access to everyone do you mean use IUSR_Compname account
> and assign to folders.
> By the way I really like your website! Any ideas on what's causing the
> error? Would like to access it again. Did you build it yourself?
> Thanks,
> JJ
> "eralper" wrote:
> > Hi,
> >
> > Actually my configuration differs from yours with my web server is IIS5
> > working on Win2k. But I believe this will not cause a problem for anonymous
> > access to reports after the steps I'll try to summarize below.
> >
> > Considering the site security, I'm not sure this is the best practice for
> > reporting services application but it seems working.
> >
> > First you can view and run reports without problem because default
> > authentication method for virtual directories "Reports" and "ReportServer" is
> > window authentication. And I think you browse the reports with an admin group
> > user.
> >
> > With these default configurations of the setup of Reporting Services, your
> > buddy should be able to get the username and password screen for windows
> > authentication when he calls http://YourIPComesHere/Reports
> >
> > If you change IIS permissions for these two virtual directories (Reports &
> > ReportServer), your buddy should see an empty page because the internet guest
> > account has no browser role permission on none of the folders below home
> > (pointing VS.Net Reporting Services projects) or the individual reports in
> > those folders.
> >
> > So before switching to anonymous access on these virtual directories, you
> > should grant Browser role permission to "everyone" in approtiate folders and
> > reports.
> > I used "everyone", I do not know if it makes sense for IUSR_ComputerName
> >
> > So first go to Home directory (http://YourServer/Reports). Select Properties
> > tab for Home and hit the "New Role Assignment" button to add "everyone" as
> > Browser. By doing this, anonymous users will be able to list contents of the
> > Reports folder.
> >
> > Second, select "Detailed View" and "Edit" the report folder where your
> > reports are deployed. Go to Security tab and add "everyone" as Browser.
> >
> > I'm not sure but you may need to repeat a similar step (adding everyone as
> > Browser) for the reports.
> >
> > You should hide the datasources in the list by editing their properties.
> > Check the "hide in list view" option in General tab.
> >
> > One important note: you must edit RSWebApplication config file in
> > "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportManager" folder (default place for this configuration file)
> > Update ReportServerURL by changing the computer name with your IP. Otherwise
> > users will be able reach the report but will not be able to see it processing.
> >
> > Now is time for changing the permissions of the two virtual directories
> > Reports and ReportServer via IIS Manager. Go to properties of the virtual
> > directories then select directory security tab. And allow anonymous access.
> >
> >
> > This configuration works for me. I hope you may find something useful within
> > my notes.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> > "JJ" wrote:
> >
> > > Hi Eralper,
> > >
> > > I tried to access your website but I keep on getting Obj ref not set
> > > error. This is happening even when I enter www. kodyak.com.
> > >
> > > Thanks,
> > >
> > > JJ
> > >
> > > "eralper" wrote:
> > >
> > > > Hi JJ,
> > > >
> > > > I tried to give a detailed answer on
> > > > http://www.kodyaz.com/ShowPost.aspx?PostID=19
> > > >
> > > > I hope it helps.
> > > >
> > > > Eralper
> > > > http://www.kodyaz.com
> > > >
> > > >
> > > > "JJ" wrote:
> > > >
> > > > > Hi eralper,
> > > > >
> > > > > Man I am so feed up trying to get Reporting Services to be accessed from
> > > > > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > > > > Services sp2 installed. I can see and execute the reports through Report
> > > > > Manager with no problem internally. But when I have a buddy check out the
> > > > > website using an IP address. He gets nothing. I have setup roles for
> > > > > IUSR_Account as browser role and assigned the report trying to access to the
> > > > > security property under report. In the datasource for report I have included
> > > > > the user name and password that matchs a windows account mapped to a Sql
> > > > > server user account. No problem there. How do you have IIS setup under
> > > > > Directory securities for Report and Report Manager set?
> > > > >
> > > > > I don't have a domain name setup for this server yet. I am using Static IP
> > > > > address for the moment. Are you using SSL for Reporting Services? What else
> > > > > should I check?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > JJ
> > > > >
> > > > >
> > > > > "eralper" wrote:
> > > > >
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Did you arrange security settings for the browsing reports?
> > > > > >
> > > > > > You should grant "Browser" Role to Guests or everyone from the Report
> > > > > > Manager to the folder where your reports are.
> > > > > >
> > > > > > Eralper
> > > > > > http://www.kodyaz.com
> > > > > >
> > > > > > "JJ" wrote:
> > > > > >
> > > > > > > Hi All,
> > > > > > >
> > > > > > > I have the following going on: A win 2k3 server running sql server and
> > > > > > > reporting services. I have IIS configured on it and can run reports
> > > > > > > internally on my network but when I try to access a report from the web I get
> > > > > > > nothing back. I can access my web projects but cant access and display
> > > > > > > reports from web. I am using a static ip address to access the website for
> > > > > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > > > > difference. and internally when I refer to the box in the website I use the
> > > > > > > boxs computer name. Any ideas on what could be wrong here?
> > > > > > >
> > > > > > > Thanks,
> > > > > > >
> > > > > > > JJ

IIS 6 and Windows Authentication to SQL Server 2000

I am running a Windows Server 2003 machine as my web server. I would
like to use Windows authentication for connections to my SQL Server
2000 instance on a Windows 2000 server. I've read where mirroring the
ASPNET account and password on the web server and SQL server would
work. However, with IIS 6, ASP.NET runs under the 'NT
AUTHORITY\NETWORK SERVICE' account. Should I change the password of
the 'NT AUTHORITY\NETWORK SERVICE' account to something I know, and
create a mirrored 'NETWORK SERVICE' account on my SQL server? Or,
should I create another user like 'MY_WEB_USER' and mirror that on both
machines?
In short, how do I get Windows authentication to work between a Windows
Server 2003 web server and a Windows 2000 SQL server?
Thanks!
If you are truly using Windows Authentication, ie a user has an account on
the domain as well as SQL Server, you will do the following:
1. Ensure the user cannot sign in as anonymous
2. Add their account to a group that has SQL rights
You may mean "bastardized windows authentication", meaning SQL Server uses
WIndows Authentication, but you are using anon accounts in IIS. If you go
this route, you are advised to impersonate an account rather than give a
local account rights on another box. One way to easily do this is to place
the assembly in COM+ and declaratively assign a domain account to the
application.

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"mcollier" wrote:

> I am running a Windows Server 2003 machine as my web server. I would
> like to use Windows authentication for connections to my SQL Server
> 2000 instance on a Windows 2000 server. I've read where mirroring the
> ASPNET account and password on the web server and SQL server would
> work. However, with IIS 6, ASP.NET runs under the 'NT
> AUTHORITY\NETWORK SERVICE' account. Should I change the password of
> the 'NT AUTHORITY\NETWORK SERVICE' account to something I know, and
> create a mirrored 'NETWORK SERVICE' account on my SQL server? Or,
> should I create another user like 'MY_WEB_USER' and mirror that on both
> machines?
> In short, how do I get Windows authentication to work between a Windows
> Server 2003 web server and a Windows 2000 SQL server?
> Thanks!
>
|||Hi,
Are both the servers in the same domain?
If so create a domain user account and switch the identity of the ASP.NET
worker process to this acccount. You can do this by creating a new
application pool in IIS6.
Now configure this acccount as a login for sql server.
Don't forget to add this user to the IIS_WPG group on your Win2K3 machine.
HTH
Vikram Vamshi
Eclipsys Corporation
"mcollier" <michaelscollier@.gmail.com> wrote in message
news:1109016547.061210.221620@.f14g2000cwb.googlegr oups.com...
>I am running a Windows Server 2003 machine as my web server. I would
> like to use Windows authentication for connections to my SQL Server
> 2000 instance on a Windows 2000 server. I've read where mirroring the
> ASPNET account and password on the web server and SQL server would
> work. However, with IIS 6, ASP.NET runs under the 'NT
> AUTHORITY\NETWORK SERVICE' account. Should I change the password of
> the 'NT AUTHORITY\NETWORK SERVICE' account to something I know, and
> create a mirrored 'NETWORK SERVICE' account on my SQL server? Or,
> should I create another user like 'MY_WEB_USER' and mirror that on both
> machines?
> In short, how do I get Windows authentication to work between a Windows
> Server 2003 web server and a Windows 2000 SQL server?
> Thanks!
>
|||Both servers are not in the same domain. I've done this before when I
had two Windows 2000 servers. Having one Windows 2003 and one Windows
2000 server seems to be somewhat more confusing.
|||What you did for WIndows 2000 should still work for Win2K3.
Create a user on both the machines with the same username and password.
Then configure the ASP.NET worker process to run under this user account on
win2k3 machine
and configure sql on win2k machine to accept this user as a valid login.
As long as the username/password are same on both the machines this should
work.
hth
Vikram Vamshi
Eclipsys Corporation
"mcollier" <michaelscollier@.gmail.com> wrote in message
news:1109041768.768522.120100@.f14g2000cwb.googlegr oups.com...
> Both servers are not in the same domain. I've done this before when I
> had two Windows 2000 servers. Having one Windows 2003 and one Windows
> 2000 server seems to be somewhat more confusing.
>
|||Ok, I think I see where you're going with this. I was thinking I could
use the ASPNET or NETWORK SERVICE account for both servers. But, that
doesn't appear to be the case. What you're saying is that I could
create a user on both servers, for example MY_WEB_USER. Then, set the
ASP.NET worker process to run as this account. I would also need to
give that user the correct permissions (similar to NETWORK SERVICE
probably). Sound about right?
|||Yep,
That is what I had in mind.
Let us know how it goes.
Thanks
Vikram Vamshi
Eclipsys Corporation
"mcollier" <michaelscollier@.gmail.com> wrote in message
news:1109125129.410024.221630@.f14g2000cwb.googlegr oups.com...
> Ok, I think I see where you're going with this. I was thinking I could
> use the ASPNET or NETWORK SERVICE account for both servers. But, that
> doesn't appear to be the case. What you're saying is that I could
> create a user on both servers, for example MY_WEB_USER. Then, set the
> ASP.NET worker process to run as this account. I would also need to
> give that user the correct permissions (similar to NETWORK SERVICE
> probably). Sound about right?
>

IIS 6 and Windows Authentication to SQL Server 2000

I am running a Windows Server 2003 machine as my web server. I would
like to use Windows authentication for connections to my SQL Server
2000 instance on a Windows 2000 server. I've read where mirroring the
ASPNET account and password on the web server and SQL server would
work. However, with IIS 6, ASP.NET runs under the 'NT
AUTHORITY\NETWORK SERVICE' account. Should I change the password of
the 'NT AUTHORITY\NETWORK SERVICE' account to something I know, and
create a mirrored 'NETWORK SERVICE' account on my SQL server? Or,
should I create another user like 'MY_WEB_USER' and mirror that on both
machines?
In short, how do I get Windows authentication to work between a Windows
Server 2003 web server and a Windows 2000 SQL server?
Thanks!If you are truly using Windows Authentication, ie a user has an account on
the domain as well as SQL Server, you will do the following:
1. Ensure the user cannot sign in as anonymous
2. Add their account to a group that has SQL rights
You may mean "bastardized windows authentication", meaning SQL Server uses
WIndows Authentication, but you are using anon accounts in IIS. If you go
this route, you are advised to impersonate an account rather than give a
local account rights on another box. One way to easily do this is to place
the assembly in COM+ and declaratively assign a domain account to the
application.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"mcollier" wrote:

> I am running a Windows Server 2003 machine as my web server. I would
> like to use Windows authentication for connections to my SQL Server
> 2000 instance on a Windows 2000 server. I've read where mirroring the
> ASPNET account and password on the web server and SQL server would
> work. However, with IIS 6, ASP.NET runs under the 'NT
> AUTHORITY\NETWORK SERVICE' account. Should I change the password of
> the 'NT AUTHORITY\NETWORK SERVICE' account to something I know, and
> create a mirrored 'NETWORK SERVICE' account on my SQL server? Or,
> should I create another user like 'MY_WEB_USER' and mirror that on both
> machines?
> In short, how do I get Windows authentication to work between a Windows
> Server 2003 web server and a Windows 2000 SQL server?
> Thanks!
>|||Hi,
Are both the servers in the same domain?
If so create a domain user account and switch the identity of the ASP.NET
worker process to this acccount. You can do this by creating a new
application pool in IIS6.
Now configure this acccount as a login for sql server.
Don't forget to add this user to the IIS_WPG group on your Win2K3 machine.
HTH
--
Vikram Vamshi
Eclipsys Corporation
"mcollier" <michaelscollier@.gmail.com> wrote in message
news:1109016547.061210.221620@.f14g2000cwb.googlegroups.com...
>I am running a Windows Server 2003 machine as my web server. I would
> like to use Windows authentication for connections to my SQL Server
> 2000 instance on a Windows 2000 server. I've read where mirroring the
> ASPNET account and password on the web server and SQL server would
> work. However, with IIS 6, ASP.NET runs under the 'NT
> AUTHORITY\NETWORK SERVICE' account. Should I change the password of
> the 'NT AUTHORITY\NETWORK SERVICE' account to something I know, and
> create a mirrored 'NETWORK SERVICE' account on my SQL server? Or,
> should I create another user like 'MY_WEB_USER' and mirror that on both
> machines?
> In short, how do I get Windows authentication to work between a Windows
> Server 2003 web server and a Windows 2000 SQL server?
> Thanks!
>|||Both servers are not in the same domain. I've done this before when I
had two Windows 2000 servers. Having one Windows 2003 and one Windows
2000 server seems to be somewhat more confusing.|||What you did for Windows 2000 should still work for Win2K3.
Create a user on both the machines with the same username and password.
Then configure the ASP.NET worker process to run under this user account on
win2k3 machine
and configure sql on win2k machine to accept this user as a valid login.
As long as the username/password are same on both the machines this should
work.
hth
Vikram Vamshi
Eclipsys Corporation
"mcollier" <michaelscollier@.gmail.com> wrote in message
news:1109041768.768522.120100@.f14g2000cwb.googlegroups.com...
> Both servers are not in the same domain. I've done this before when I
> had two Windows 2000 servers. Having one Windows 2003 and one Windows
> 2000 server seems to be somewhat more confusing.
>|||Ok, I think I see where you're going with this. I was thinking I could
use the ASPNET or NETWORK SERVICE account for both servers. But, that
doesn't appear to be the case. What you're saying is that I could
create a user on both servers, for example MY_WEB_USER. Then, set the
ASP.NET worker process to run as this account. I would also need to
give that user the correct permissions (similar to NETWORK SERVICE
probably). Sound about right?|||Yep,
That is what I had in mind.
Let us know how it goes.
Thanks
--
Vikram Vamshi
Eclipsys Corporation
"mcollier" <michaelscollier@.gmail.com> wrote in message
news:1109125129.410024.221630@.f14g2000cwb.googlegroups.com...
> Ok, I think I see where you're going with this. I was thinking I could
> use the ASPNET or NETWORK SERVICE account for both servers. But, that
> doesn't appear to be the case. What you're saying is that I could
> create a user on both servers, for example MY_WEB_USER. Then, set the
> ASP.NET worker process to run as this account. I would also need to
> give that user the correct permissions (similar to NETWORK SERVICE
> probably). Sound about right?
>

Iis & Vs.net

This is a weird question, and I think it might have something to do with my SQL server.
I am running SQL server 2000 Developer Edition on XP pro, and now have been trying to instal VS.Net 2003, yet when I try to install, the installer disk tells me I dont have IIS and FPSE running and configured on my computer... I run through the steps given and IIS still doesn't appear in "Computer Mangaement". The "Inetpub" is on my C: drive, but http://localhost doesnt exist.
I figure it has something to do with my SQL server but I don't know what to do. I need to be able to create Web projects on my computer with VS.NET.
Should I uninstal SQL Server? Do I do this in the registry? Should I instal VS.Net anyway? Do I reformat my hard drive and start from scratch?

Any help will be unbelieveably appreciated, time is short and I'm going nuts.Your PWS (Personal IIS) is not running. Start the service and/or check to see if you have the service installed at all.|||There is no PWS for XP Pro, or rather IIS is the PWS. I followed the simple instructions found everywhere online and on the vs.net CD. Nothing. IIS still doesn't appear under Administrative Tools. I can't figure out why.

*chucks computer out 2nd story window*|||I went and uninstalled it fully and installed it again, I did this like 3 times over the past week, but last night it actually took. huh. If I wasn't so happy it was running I would be pissed that it was so tempermental.

Now all I have to do is create a webservice, and database in time to turn in for my midterm next monday. wish me luck!