A big, big SSIS for everything?

Dear all,

I would like to hear point of views, thoughts and ideas about the following request.

As some of us would have seen from a couple a days ago I’ve been setting posts one after one in order to obtain some answers about our business basis.

We’ve got a service running all day long (to accomplish this it was wrote by Visual Basic 6.0) which is checking up a file structure system for a several requirements such a verify if exists a .nul or .txt in each folder and therefore fires a DTS package. Up to here that’s fine, that system works amazing and even is be able to run till three packages at the same time. 400 Dts are scheduled this way and 100 are scheduled by Agent.

Problem comes naturally with SQL2005 where such control is not possible (it seems so) from old tools belonging to Visual Studio 6.0 because the aforementioned version uses assemblies instead of dll, bla,bla.

Keeping in mind that .NET is not possible for reasons that going beyond of any technical matter or whatever I’ve thought do that service by SSIS. A big SSIS running forever. Its responsabilities might be:

1-Look in each folder for the criteria specified in the scheduling of that SSIS

2-Launch a specified SSIS in the case that criteria has matched.

3-Update SQL tables with LOGS, times, executions, etc,

4-Look again

The point 3 will be visible from our Intranet via ASP 3.0 pages as currently we do.

Pros and cons?

Sorry for this painful request but I don’t believe that such issue can be of that kind of odd issues that nodoby suffer in its organizations.

Who else is needed for answers?

Thanks a lot for your time,

I'm not quite sure what your question is. Are you saying you want to run a SSIS package forever that simply keeps looping whenever a file is found? I don't see a problem with that. it would be interesting to see how it goes.

-Jamie

|||

When finds a Jamie.Nul file in d:\server25k\a\ launch SSIS package B and then would delete that .NUL.

Sensible information attached in that SSIS launched as flat file for example, accounts info would be stored in a backup folder. After one execution come back to verify and so on

60 days of backups

I have had a request to run backups of a database to disk, and retain the
backups until they are 60 days old. I've got the job set up, but it either
appends or overwrites the previous job. Does anyone know of a way to do
this?
TIA,
KSee
http://www.nigelrivett.net/BackupAllDatabases.html
You could use the sqlmaint exe but I think backups are too
important.
>--Original Message--
>I have had a request to run backups of a database to
disk, and retain the
>backups until they are 60 days old. I've got the job set
up, but it either
>appends or overwrites the previous job. Does anyone know
of a way to do
>this?
>TIA,
>K
>
>.
>|||Use the maintenance function in SLQ and enable the SQL server agent service
--
J
www.urbanvoyeur.com
"msnews.microsoft.com" <kb@.blah.com> wrote in message
news:uet5nU7iDHA.1696@.TK2MSFTNGP12.phx.gbl...
> I have had a request to run backups of a database to disk, and retain the
> backups until they are 60 days old. I've got the job set up, but it
either
> appends or overwrites the previous job. Does anyone know of a way to do
> this?
> TIA,
> K
>|||Thanks for the help...I setup a maintenance plan and have my fingers crossed
that this will work!
K
"UrbanVoyeur" <nospam@.nospam.com> wrote in message
news:ey9Bi4AjDHA.1676@.TK2MSFTNGP09.phx.gbl...
> Use the maintenance function in SLQ and enable the SQL server agent
service
> --
> J
> www.urbanvoyeur.com
>
> "msnews.microsoft.com" <kb@.blah.com> wrote in message
> news:uet5nU7iDHA.1696@.TK2MSFTNGP12.phx.gbl...
> > I have had a request to run backups of a database to disk, and retain
the
> > backups until they are 60 days old. I've got the job set up, but it
> either
> > appends or overwrites the previous job. Does anyone know of a way to do
> > this?
> >
> > TIA,
> > K
> >
> >
>

50(The request is not supported.)

I'm attempting to create an assembly in SQL Server Management Studio
express and I'm getting the following error message.
Msg 6502, Level 16, State 7, Line 1
CREATE ASSEMBLY failed because it could not read from the physical file
'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
supported.).
I've tried a ton of different things and I can't get this to work. Does
anyone have any ideas?<DIV>"IndyChris" <chrisshearier@.yahoo.com> wrote in message
news:1157049490.180110.320140@.74g2000cwt.googlegroups.com...</DIV>> I'm
attempting to create an assembly in SQL Server Management Studio
> express and I'm getting the following error message.
> Msg 6502, Level 16, State 7, Line 1
> CREATE ASSEMBLY failed because it could not read from the physical file
> 'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
> supported.).
> I've tried a ton of different things and I can't get this to work. Does
> anyone have any ideas?
>
Put the DLL in a folder that SQL Server can access, and reference it there.
David

50(The request is not supported.)

I'm attempting to create an assembly in SQL Server Management Studio
express and I'm getting the following error message.
Msg 6502, Level 16, State 7, Line 1
CREATE ASSEMBLY failed because it could not read from the physical file
'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
supported.).
I've tried a ton of different things and I can't get this to work. Does
anyone have any ideas?<DIV>"IndyChris" <chrisshearier@.yahoo.com> wrote in message
news:1157049490.180110.320140@.74g2000cwt.googlegroups.com...</DIV>> I'm
attempting to create an assembly in SQL Server Management Studio
> express and I'm getting the following error message.
> Msg 6502, Level 16, State 7, Line 1
> CREATE ASSEMBLY failed because it could not read from the physical file
> 'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
> supported.).
> I've tried a ton of different things and I can't get this to work. Does
> anyone have any ideas?
>
Put the DLL in a folder that SQL Server can access, and reference it there.
David

404 Request failed error

Hi
Iam reposting this as my qs seems to have submerged in a deluge of questions !
I have a .net application that lists all the reports within a specific
folder using RS.children methodand then calls a specific selected report in
Report viewer. My application code and reporting services are in two
different servers however in the same domain. The problem is that when I call
my .NET application it gives me this error on Line 85:
The request failed with HTTP status 404: Not Found.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Net.WebException: The request failed with HTTP
status 404: Not Found.
Source Error:
Line 84: RS.Credentials = System.Net.CredentialCache.DefaultCredentials
Line 85: Dim items As CatalogItem()
Line 86: items = RS.ListChildren("/eCMSDashboard", True)
iam setting the Server.URL property to http://<<Servername>>/ReportServer
Please Help !!
Thanks
PriyaI believe that after line 84 you should have something like this :
rs.Url = http://<<Servername>>/ReportServer
Thereafter line 85 and the rest will follow.
"Priya" <Priya@.discussions.microsoft.com> wrote in message
news:228D12EA-CC82-4015-AA6E-5BA7799CBEC3@.microsoft.com...
> Hi
> Iam reposting this as my qs seems to have submerged in a deluge of
> questions !
> I have a .net application that lists all the reports within a specific
> folder using RS.children methodand then calls a specific selected report
> in
> Report viewer. My application code and reporting services are in two
> different servers however in the same domain. The problem is that when I
> call
> my .NET application it gives me this error on Line 85:
> The request failed with HTTP status 404: Not Found.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
> Exception Details: System.Net.WebException: The request failed with HTTP
> status 404: Not Found.
> Source Error:
> Line 84: RS.Credentials => System.Net.CredentialCache.DefaultCredentials
> Line 85: Dim items As CatalogItem()
> Line 86: items = RS.ListChildren("/eCMSDashboard", True)
> iam setting the Server.URL property to http://<<Servername>>/ReportServer
> Please Help !!
> Thanks
> Priya
>

401 error?

When I try to access the reports site using
http://myserver/reports
I get the following error
The request failed with HTTP status 401: Unauthorized.
Is there any error happening with respect to web service level' If so how
can I track that service'I am having the same issue. Reporting Services was successfully installed
several months ago and rran beautifully but has gone belly up on a mission
critical application. I am busily RTFMing but if anybody has any bright
ideas I'd be eternally grateful!
"sqlster" wrote:
> When I try to access the reports site using
> http://myserver/reports
> I get the following error
> The request failed with HTTP status 401: Unauthorized.
> Is there any error happening with respect to web service level' If so how
> can I track that service'
>|||dbahawk wrote:
> I am having the same issue. Reporting Services was successfully installed
> several months ago and rran beautifully but has gone belly up on a mission
> critical application. I am busily RTFMing but if anybody has any bright
> ideas I'd be eternally grateful!
> "sqlster" wrote:
>
>>When I try to access the reports site using
>>http://myserver/reports
>>I get the following error
>>The request failed with HTTP status 401: Unauthorized.
>>Is there any error happening with respect to web service level' If so how
>>can I track that service'
looks like you're trying to access IIS anonymously, or anonymous access
allowed at IIS side.
Both will cause this error.|||Thanks for your swift reply!
However, I do have anonymous access turned off for the websites _Reports_
and _ReportServer_
When I try to connect to a previously working report, I get the following
error:
Here is the error and stack trace:
[begin error message]
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[WebException: The request failed with HTTP status 401: Unauthorized.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) +1303
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) +218
coiWeb.domain.domain.domain.domain.ReportingService.Render(String Report,
String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds) +143
coiWeb.print_form.Page_Load(Object sender, EventArgs e) +867
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +744
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300
[end of error message]|||I should also add that I am able to log into the site
[domaininfo]/ReportServer and run these manually, so the reporting services
installation does not seem to be the problem. It's getting access to
[domaininfo]\Reports that is the hangup here.
"dbahawk" wrote:
> Thanks for your swift reply!
> However, I do have anonymous access turned off for the websites _Reports_
> and _ReportServer_
>
> When I try to connect to a previously working report, I get the following
> error:
> Here is the error and stack trace:
> [begin error message]
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> Stack Trace:
>
> [WebException: The request failed with HTTP status 401: Unauthorized.]
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall) +1303
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) +218
> coiWeb.domain.domain.domain.domain.ReportingService.Render(String Report,
> String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> Warning[]& Warnings, String[]& StreamIds) +143
> coiWeb.print_form.Page_Load(Object sender, EventArgs e) +867
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +744
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
> Version:1.1.4322.2300
> [end of error message]
>|||I found the references to the DisableLoopbackCheck registry entry and applied
it to our development server. Worked great so I applied it to the production
box where it also worked like a charm.
All is good again :)
"dbahawk" wrote:
> I should also add that I am able to log into the site
> [domaininfo]/ReportServer and run these manually, so the reporting services
> installation does not seem to be the problem. It's getting access to
> [domaininfo]\Reports that is the hangup here.
>
> "dbahawk" wrote:
> > Thanks for your swift reply!
> >
> > However, I do have anonymous access turned off for the websites _Reports_
> > and _ReportServer_
> >
> >
> > When I try to connect to a previously working report, I get the following
> > error:
> >
> > Here is the error and stack trace:
> >
> > [begin error message]
> >
> > Source Error:
> >
> > An unhandled exception was generated during the execution of the current web
> > request. Information regarding the origin and location of the exception can
> > be identified using the exception stack trace below.
> >
> > Stack Trace:
> >
> >
> > [WebException: The request failed with HTTP status 401: Unauthorized.]
> >
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall) +1303
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) +218
> > coiWeb.domain.domain.domain.domain.ReportingService.Render(String Report,
> > String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> > Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> > String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> > Warning[]& Warnings, String[]& StreamIds) +143
> > coiWeb.print_form.Page_Load(Object sender, EventArgs e) +867
> > System.Web.UI.Control.OnLoad(EventArgs e) +67
> > System.Web.UI.Control.LoadRecursive() +35
> > System.Web.UI.Page.ProcessRequestMain() +744
> >
> >
> > ----
> > Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
> > Version:1.1.4322.2300
> >
> > [end of error message]
> >
> >

401 2 and repeat request errors

I have sort of asked this elsewhere, but with new information the questions
has changed slightly, so apologies for the broken thread.
I have a web service sending messages through to a SQL server.
I have integrated security on (no anonymous). For one application, when I
run the application i get an unauthorized error and the logs hold these
lines:
2006-02-21 10:32:58 173.1.1.1 GET
/ApplicationWebservice/DocumentContent.asmx - 80 - 172.25.1.1 - 401 2
2148074254
2006-02-21 10:32:58 173.1.1.1 GET
/ApplicationWebservice/DocumentContent.asmx - 80 LONDON\ShamS00 172.25.1.1 -
200 0 0
2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80 -
172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.N ET+CLR+1.1.4322)
401 2 2148074254
2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80
LONDON\ShamS00 172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.N ET+CLR+1.1.4322)
200 0 0
2006-02-21 10:32:59 173.1.1.1 POST
/applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+ Protocol+1.1.4322.2032)
401 2 2148074254
2006-02-21 10:32:59 173.1.1.1 POST
/applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+ Protocol+1.1.4322.2032)
401 2 2148074254
What I am confused about is why are there two entries for each request (one
with authentication and one without), and then the next question would be
why does the last 'request' have two entries, both without authentiacation.
perhaps this is an impossible question to answer, but i thought i'd see if
anyone out there had an idea.
I still seem to have my delegation problem, another application seems to be
sending through commands properly, bt not getting an answer from the web
service, but i've decided to take a break from that one.
Any help/thoughts would be apprecitaed.
Thanks
Saira
Where is your web service running? Are you using the http endpoint in SQL
Server 2005? If not, I'm not sure where SQL Server fits into this picture.
The double messages through authentication are normal. The client will try
without authentication and then try with authentication once it find out
what the server needs.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Saira" <Saira@.Bayonet.com> wrote in message
news:uWb%23ZftNGHA.2300@.TK2MSFTNGP15.phx.gbl...
>I have sort of asked this elsewhere, but with new information the questions
>has changed slightly, so apologies for the broken thread.
> I have a web service sending messages through to a SQL server.
> I have integrated security on (no anonymous). For one application, when I
> run the application i get an unauthorized error and the logs hold these
> lines:
> 2006-02-21 10:32:58 173.1.1.1 GET
> /ApplicationWebservice/DocumentContent.asmx - 80 - 172.25.1.1 - 401 2
> 2148074254
> 2006-02-21 10:32:58 173.1.1.1 GET
> /ApplicationWebservice/DocumentContent.asmx - 80 LONDON\ShamS00
> 172.25.1.1 - 200 0 0
> 2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80 -
> 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.N ET+CLR+1.1.4322)
> 401 2 2148074254
> 2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80
> LONDON\ShamS00 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.N ET+CLR+1.1.4322)
> 200 0 0
> 2006-02-21 10:32:59 173.1.1.1 POST
> /applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+ Protocol+1.1.4322.2032)
> 401 2 2148074254
> 2006-02-21 10:32:59 173.1.1.1 POST
> /applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+ Protocol+1.1.4322.2032)
> 401 2 2148074254
> What I am confused about is why are there two entries for each request
> (one with authentication and one without), and then the next question
> would be why does the last 'request' have two entries, both without
> authentiacation. perhaps this is an impossible question to answer, but i
> thought i'd see if anyone out there had an idea.
> I still seem to have my delegation problem, another application seems to
> be sending through commands properly, bt not getting an answer from the
> web service, but i've decided to take a break from that one.
> Any help/thoughts would be apprecitaed.
> Thanks
> Saira
>
|||Thanks, on the authentication, i sort of figured that, but was not positive.
I am not taking advantage of any of the new SQL 2005 features yet.
My setup is a recently installed SQL Server 2005 box, hosting an upgraded
SQL 2000 database.
The client (XP SP2) talks to the web server (IIS 6, in a seperate IP
segment), and the web server requests the data from the database. I had
assumed that I would not need to make massive changes for the upgrade to
2005, is this not the case?
Saira
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:u3wS5gvNGHA.2884@.TK2MSFTNGP12.phx.gbl...
> Where is your web service running? Are you using the http endpoint in SQL
> Server 2005? If not, I'm not sure where SQL Server fits into this
> picture. The double messages through authentication are normal. The
> client will try without authentication and then try with authentication
> once it find out what the server needs.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Saira" <Saira@.Bayonet.com> wrote in message
> news:uWb%23ZftNGHA.2300@.TK2MSFTNGP15.phx.gbl...
>
|||None that I can think of.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Saira" <Saira@.Bayonet.com> wrote in message
news:erGMpHwNGHA.428@.tk2msftngp13.phx.gbl...
> Thanks, on the authentication, i sort of figured that, but was not
> positive.
> I am not taking advantage of any of the new SQL 2005 features yet.
> My setup is a recently installed SQL Server 2005 box, hosting an upgraded
> SQL 2000 database.
> The client (XP SP2) talks to the web server (IIS 6, in a seperate IP
> segment), and the web server requests the data from the database. I had
> assumed that I would not need to make massive changes for the upgrade to
> 2005, is this not the case?
> Saira
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:u3wS5gvNGHA.2884@.TK2MSFTNGP12.phx.gbl...
>

401 2 and repeat request errors

I have sort of asked this elsewhere, but with new information the questions
has changed slightly, so apologies for the broken thread.
I have a web service sending messages through to a SQL server.
I have integrated security on (no anonymous). For one application, when I
run the application i get an unauthorized error and the logs hold these
lines:
2006-02-21 10:32:58 173.1.1.1 GET
/ApplicationWebservice/DocumentContent.asmx - 80 - 172.25.1.1 - 401 2
2148074254
2006-02-21 10:32:58 173.1.1.1 GET
/ApplicationWebservice/DocumentContent.asmx - 80 LONDON\ShamS00 172.25.1.1 -
200 0 0
2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80 -
172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
401 2 2148074254
2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80
LONDON\ShamS00 172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
200 0 0
2006-02-21 10:32:59 173.1.1.1 POST
/applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.
2032)
401 2 2148074254
2006-02-21 10:32:59 173.1.1.1 POST
/applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.
2032)
401 2 2148074254
What I am confused about is why are there two entries for each request (one
with authentication and one without), and then the next question would be
why does the last 'request' have two entries, both without authentiacation.
perhaps this is an impossible question to answer, but i thought i'd see if
anyone out there had an idea.
I still seem to have my delegation problem, another application seems to be
sending through commands properly, bt not getting an answer from the web
service, but i've decided to take a break from that one.
Any help/thoughts would be apprecitaed.
Thanks
SairaWhere is your web service running? Are you using the http endpoint in SQL
Server 2005? If not, I'm not sure where SQL Server fits into this picture.
The double messages through authentication are normal. The client will try
without authentication and then try with authentication once it find out
what the server needs.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Saira" <Saira@.Bayonet.com> wrote in message
news:uWb%23ZftNGHA.2300@.TK2MSFTNGP15.phx.gbl...
>I have sort of asked this elsewhere, but with new information the questions
>has changed slightly, so apologies for the broken thread.
> I have a web service sending messages through to a SQL server.
> I have integrated security on (no anonymous). For one application, when I
> run the application i get an unauthorized error and the logs hold these
> lines:
> 2006-02-21 10:32:58 173.1.1.1 GET
> /ApplicationWebservice/DocumentContent.asmx - 80 - 172.25.1.1 - 401 2
> 2148074254
> 2006-02-21 10:32:58 173.1.1.1 GET
> /ApplicationWebservice/DocumentContent.asmx - 80 LONDON\ShamS00
> 172.25.1.1 - 200 0 0
> 2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80 -
> 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
> 401 2 2148074254
> 2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80
> LONDON\ShamS00 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
> 200 0 0
> 2006-02-21 10:32:59 173.1.1.1 POST
> /applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.432
2.2032)
> 401 2 2148074254
> 2006-02-21 10:32:59 173.1.1.1 POST
> /applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.432
2.2032)
> 401 2 2148074254
> What I am confused about is why are there two entries for each request
> (one with authentication and one without), and then the next question
> would be why does the last 'request' have two entries, both without
> authentiacation. perhaps this is an impossible question to answer, but i
> thought i'd see if anyone out there had an idea.
> I still seem to have my delegation problem, another application seems to
> be sending through commands properly, bt not getting an answer from the
> web service, but i've decided to take a break from that one.
> Any help/thoughts would be apprecitaed.
> Thanks
> Saira
>|||Thanks, on the authentication, i sort of figured that, but was not positive.
I am not taking advantage of any of the new SQL 2005 features yet.
My setup is a recently installed SQL Server 2005 box, hosting an upgraded
SQL 2000 database.
The client (XP SP2) talks to the web server (IIS 6, in a seperate IP
segment), and the web server requests the data from the database. I had
assumed that I would not need to make massive changes for the upgrade to
2005, is this not the case?
Saira
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:u3wS5gvNGHA.2884@.TK2MSFTNGP12.phx.gbl...
> Where is your web service running? Are you using the http endpoint in SQL
> Server 2005? If not, I'm not sure where SQL Server fits into this
> picture. The double messages through authentication are normal. The
> client will try without authentication and then try with authentication
> once it find out what the server needs.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Saira" <Saira@.Bayonet.com> wrote in message
> news:uWb%23ZftNGHA.2300@.TK2MSFTNGP15.phx.gbl...
>|||None that I can think of.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Saira" <Saira@.Bayonet.com> wrote in message
news:erGMpHwNGHA.428@.tk2msftngp13.phx.gbl...
> Thanks, on the authentication, i sort of figured that, but was not
> positive.
> I am not taking advantage of any of the new SQL 2005 features yet.
> My setup is a recently installed SQL Server 2005 box, hosting an upgraded
> SQL 2000 database.
> The client (XP SP2) talks to the web server (IIS 6, in a seperate IP
> segment), and the web server requests the data from the database. I had
> assumed that I would not need to make massive changes for the upgrade to
> 2005, is this not the case?
> Saira
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:u3wS5gvNGHA.2884@.TK2MSFTNGP12.phx.gbl...
>

400: Bad Request

I am getting an "The request failed with HTTP status 400: Bad Request " Error in Report Manager Webpage. http://servername/Reports
The Reportserver itself and reports works fine (http://servername/reportserver).
Reports render OK and i am still able to connect to reportserver by management studio.

The environment is a W2K3 Standard with SQL 2005 (Build 2153) - and the server is a domain controller.

Reporting Service Configuration does not mention any issues - I have reapplied default settings - no change.
There are no errors in the eventlog.

I need some help - please

HANNESI have already checked the following posts

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=284929&SiteID=1
(I did not understend the "RSWebApplication.config" file - as soon as i write in the a reportserver url the website returns an execption - so this config must be empty I guess)

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=479636&SiteID=1|||This post gave me the finale hint (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=165851&SiteID=1) - but I do not habe a specific IP address bound to the website - but I had specific hostheaders and it seems the reportmanager needs at least one binding with no hosthader in my environment - therefor I added a fifth binding with no hosthander, no specific IP and default Port

Hannes