Sunday, March 25, 2012
Authorization Error in Reporting Services on Windows 2003
I have just reinstalled Reporting Services on win 2003 server that was
added to a domain and has been renamed. Two strange things happen:
1) In IE I am prompted for an ID and password with a basic security
prompt.
2) After supplying the credentials I get some of the report manager web
page but it has a 401 error instead of the folder and options to manage
projects.
The page looks like this:
Error
The request failed with HTTP status 401: Unauthorized.
Home
The reporting services error log contains the following error:
Unknown!ui!ed8!2/9/2005-20:44:32:: v VERBOSE: User
map'<Users><User><Name>DOMAIN\Administrator</Name><Paths><Pa=ADth>/reports/= Home.aspx</Path><NrReq>1</NrReq></Paths></User><=AD/Users>'
Unknown!ui!a24!2/9/2005-20:44:33:: v VERBOSE: User
map'<Users><User><Name>DOMAIN\Administrator</Name><Paths><Pa=ADth>/reports/= Pages/Folder.aspx</Path><NrReq>1</NrReq></Paths>=AD</User></Users>'
Unknown!ui!a24!2/9/2005-20:44:34:: e ERROR: The request failed with
HTTP status 401: Unauthorized.
Unknown!ui!a24!2/9/2005-20:44:35:: e ERROR: HTTP status code --> 500
I have not changed any of the config files that are installed.
Thanks for any help in advance,
EricTry restarting IIS. I think that is how they fixed the problem here.|||Try restarting IIS. I think that is how they cured the problem here.
authorization error in reporting services on win2003
I have just reinstalled Reporting Services on win 2003 server that was
added to a domain and has been renamed. Two strange things happen:
1) In IE I am prompted for an ID and password with a basic security
prompt.
2) After supplying the credentials I get some of the report manager web
page but it has a 401 error instead of the folder and options to manage
projects.
The page looks like this:
Error
The request failed with HTTP status 401: Unauthorized.
Home
The reporting services error log contains the following error:
Unknown!ui!ed8!2/9/2005-20:44:32:: v VERBOSE: User
map'<Users><User><Name>DOMAIN\Administrator</Name><Paths><Path>/reports/Home.aspx</Path><NrReq>1</NrReq></Paths></User></Users>'
Unknown!ui!a24!2/9/2005-20:44:33:: v VERBOSE: User
map'<Users><User><Name>DOMAIN\Administrator</Name><Paths><Path>/reports/Pages/Folder.aspx</Path><NrReq>1</NrReq></Paths></User></Users>'
Unknown!ui!a24!2/9/2005-20:44:34:: e ERROR: The request failed with
HTTP status 401: Unauthorized.
Unknown!ui!a24!2/9/2005-20:44:35:: e ERROR: HTTP status code --> 500
I have not changed any of the config files that are installed.
Thanks for any help in advance,
EricI have no idea, although there if you search Google groups for "sql
2000 reporting services http 401" there are a number of hits which may
be useful. You will probably get a better answer in
microsoft.public.sqlserver.reportingsvcs.
Simon
Tuesday, March 20, 2012
Authentication failed in EM
We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
servers.
I am facing strange issue in 2 of our 3 instances.
When I open EM and try to open it says Authentication failure, I tried both
methods viz. windows authentication and SQL authentication but failed though
I am giving correct username and passwords
While installation I had prefered mixed mode authentication.
through ODBC connection is successful, SQL server service is running but
application
is unable to get database.
What could be the problem, I am unable to find out, can somebody please help
me to find the cause of this problem and solution.
Thanks,
Kishor.
since what event you are facing this problem.i mean any updations or patches
made before this failure?
"Kishor Yadav" wrote:
> Hi,
> We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
> servers.
> I am facing strange issue in 2 of our 3 instances.
> When I open EM and try to open it says Authentication failure, I tried both
> methods viz. windows authentication and SQL authentication but failed though
> I am giving correct username and passwords
> While installation I had prefered mixed mode authentication.
> through ODBC connection is successful, SQL server service is running but
> application
> is unable to get database.
> What could be the problem, I am unable to find out, can somebody please help
> me to find the cause of this problem and solution.
> Thanks,
> Kishor.
|||No updation or patches, it started giving me this problem suddenly.
"Khwaja Arshaduddin" wrote:
[vbcol=seagreen]
> since what event you are facing this problem.i mean any updations or patches
> made before this failure?
> "Kishor Yadav" wrote:
Authentication failed in EM
We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
servers.
I am facing strange issue in 2 of our 3 instances.
When I open EM and try to open it says Authentication failure, I tried both
methods viz. windows authentication and SQL authentication but failed though
I am giving correct username and passwords
While installation I had prefered mixed mode authentication.
through ODBC connection is successful, SQL server service is running but
application
is unable to get database.
What could be the problem, I am unable to find out, can somebody please help
me to find the cause of this problem and solution.
Thanks,
Kishor.since what event you are facing this problem.i mean any updations or patches
made before this failure?
"Kishor Yadav" wrote:
> Hi,
> We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
> servers.
> I am facing strange issue in 2 of our 3 instances.
> When I open EM and try to open it says Authentication failure, I tried both
> methods viz. windows authentication and SQL authentication but failed though
> I am giving correct username and passwords
> While installation I had prefered mixed mode authentication.
> through ODBC connection is successful, SQL server service is running but
> application
> is unable to get database.
> What could be the problem, I am unable to find out, can somebody please help
> me to find the cause of this problem and solution.
> Thanks,
> Kishor.|||No updation or patches, it started giving me this problem suddenly.
"Khwaja Arshaduddin" wrote:
> since what event you are facing this problem.i mean any updations or patches
> made before this failure?
> "Kishor Yadav" wrote:
> > Hi,
> > We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
> > servers.
> > I am facing strange issue in 2 of our 3 instances.
> > When I open EM and try to open it says Authentication failure, I tried both
> > methods viz. windows authentication and SQL authentication but failed though
> > I am giving correct username and passwords
> > While installation I had prefered mixed mode authentication.
> > through ODBC connection is successful, SQL server service is running but
> > application
> > is unable to get database.
> > What could be the problem, I am unable to find out, can somebody please help
> > me to find the cause of this problem and solution.
> > Thanks,
> > Kishor.
Authentication failed in EM
We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
servers.
I am facing strange issue in 2 of our 3 instances.
When I open EM and try to open it says Authentication failure, I tried both
methods viz. windows authentication and SQL authentication but failed though
I am giving correct username and passwords
While installation I had prefered mixed mode authentication.
through ODBC connection is successful, SQL server service is running but
application
is unable to get database.
What could be the problem, I am unable to find out, can somebody please help
me to find the cause of this problem and solution.
Thanks,
Kishor.since what event you are facing this problem.i mean any updations or patches
made before this failure?
"Kishor Yadav" wrote:
> Hi,
> We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
> servers.
> I am facing strange issue in 2 of our 3 instances.
> When I open EM and try to open it says Authentication failure, I tried bot
h
> methods viz. windows authentication and SQL authentication but failed thou
gh
> I am giving correct username and passwords
> While installation I had prefered mixed mode authentication.
> through ODBC connection is successful, SQL server service is running but
> application
> is unable to get database.
> What could be the problem, I am unable to find out, can somebody please he
lp
> me to find the cause of this problem and solution.
> Thanks,
> Kishor.|||No updation or patches, it started giving me this problem suddenly.
"Khwaja Arshaduddin" wrote:
[vbcol=seagreen]
> since what event you are facing this problem.i mean any updations or patch
es
> made before this failure?
> "Kishor Yadav" wrote:
>
Friday, February 24, 2012
Attempted to read or write protected memory
There was an error displaying the layout.
Additional Information: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (msddsp)
When I click on the help icon, I get:
Event ID: DDSErrorDeserializeDiagram
Source: Microsoft.DataTransformationServices.Design.SR
I should note that I am using custom components, none of which have been changed since the last time this package worked.
When I click ok, all my components have the information icon. No names are displayed (although all are accessible from the properties window) ... When I double click them, I still get the custom UI for my component, and all the properties are there and correct.
Other packages using the same tools work fine.
Any ideas/suggestions?
Thanks,
Steve
I am having a similar problem - did anyone find a solution to this?
Attempted to read or write protected memory
There was an error displaying the layout.
Additional Information: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (msddsp)
When I click on the help icon, I get:
Event ID: DDSErrorDeserializeDiagram
Source: Microsoft.DataTransformationServices.Design.SR
I should note that I am using custom components, none of which have been changed since the last time this package worked.
When I click ok, all my components have the information icon. No names are displayed (although all are accessible from the properties window) ... When I double click them, I still get the custom UI for my component, and all the properties are there and correct.
Other packages using the same tools work fine.
Any ideas/suggestions?
Thanks,
SteveI am having a similar problem - did anyone find a solution to this?