Hi,
I'm having a few problems with getting SQL RS running and wondered
whether anyone could give me some help.
I have just installed RS and have never got into the Report Manager
yet. I think it is basically an IIS permissions problem as I am
getting a page that says "The request failed with HTTP status 401:
Unauthorized." whenever I try to get to
http://reporting.[domain].com/Reports, even if I add myself to the
domain Administrators group. I have all of the IIS settings as they
are specified in documentation.
My setup: Reporting Services SP2, IIS6, Windows 2003 Server, SQL Server
2000, installed on a non-default website following instructions on
SQLJunkies.com by Trent Miesner(although I'm pretty sure this isn't the
problem).
Thanks in advance,
SamJust check if this helps
http://support.microsoft.com/kb/896861/en-us
Sam wrote:
>Hi,
>I'm having a few problems with getting SQL RS running and wondered
>whether anyone could give me some help.
>I have just installed RS and have never got into the Report Manager
>yet. I think it is basically an IIS permissions problem as I am
>getting a page that says "The request failed with HTTP status 401:
>Unauthorized." whenever I try to get to
>http://reporting.[domain].com/Reports, even if I add myself to the
>domain Administrators group. I have all of the IIS settings as they
>are specified in documentation.
>My setup: Reporting Services SP2, IIS6, Windows 2003 Server, SQL Server
>2000, installed on a non-default website following instructions on
>SQLJunkies.com by Trent Miesner(although I'm pretty sure this isn't the
>problem).
>Thanks in advance,
>Sam
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200602/1|||As a few others have mentioned, the article(method 1) did fix my problem. I
had everything working but started getting this error when I required SSL in
the RS configuration/report server virtual directory configuration.
http://support.microsoft.com/kb/896861 I rebooted after doing it.
I'm using SQL2005 SP1 on Win2k3 SP1.
--Forrest
"BALAJI K via SQLMonster.com" wrote:
> Just check if this helps
> http://support.microsoft.com/kb/896861/en-us
>
>
> Sam wrote:
> >Hi,
> >
> >I'm having a few problems with getting SQL RS running and wondered
> >whether anyone could give me some help.
> >
> >I have just installed RS and have never got into the Report Manager
> >yet. I think it is basically an IIS permissions problem as I am
> >getting a page that says "The request failed with HTTP status 401:
> >Unauthorized." whenever I try to get to
> >http://reporting.[domain].com/Reports, even if I add myself to the
> >domain Administrators group. I have all of the IIS settings as they
> >are specified in documentation.
> >
> >My setup: Reporting Services SP2, IIS6, Windows 2003 Server, SQL Server
> >2000, installed on a non-default website following instructions on
> >SQLJunkies.com by Trent Miesner(although I'm pretty sure this isn't the
> >problem).
> >
> >Thanks in advance,
> >
> >Sam
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200602/1
>
Showing posts with label status. Show all posts
Showing posts with label status. Show all posts
Friday, March 16, 2012
Saturday, February 25, 2012
"Multiple-Step operation cannot be generated Check each status value" Error
Hi All,
I have a field 'Rowguid' of type uniqueidentifier in a table. This field is the last field in the table. In this case if I update a record through the application I don't get any error. Suppose if there are additional fields after the field Rowguid I get the error "Multiple-Step operation cannot be generated Check each status value"
For your reference I have used the following statement to add the RowGuid field
Alter table <tablename>
Add RowGuid uniqueidentifier ROWGUIDCOL NOT NULL Default (newid())
Can anyone please help me.
Thanks
SatheshPost your update statement, and any trigger code on this table.|||Where's Brett when we need him?
Logically, columns don't have any order within a table. It so happens that the current implementation of Microsoft SQL Server has a physical order, but that's implementation dependant. Relying on a column order (logical or physical) is a bug waiting to happen!
The problem is that you are not specifying a column list for your INSERT statement, you are relying on an implied order. Once you add columns so that the rowid is no longer the last column, your assumed order bytes you. If you specify the columns via a column list, this won't be a problem.DROP TABLE BadExample
GO
CREATE TABLE BadExample (
comment NVARCHAR(25)
)
GO
INSERT INTO BadExample
SELECT 'Simple case'
SELECT * FROM BadExample
GO
ALTER TABLE BadExample
ADD RowGuid uniqueidentifier ROWGUIDCOL NOT NULL
DEFAULT (newid())
INSERT INTO BadExample (comment)
SELECT 'Not as simple example'
SELECT * FROM BadExample
GO
ALTER TABLE BadExample
ADD myDate DATETIME NOT NULL
DEFAULT GetDate()
GO
INSERT INTO BadExample (comment, myDate)
SELECT 'This works!', '1950-01-02'
SELECT * FROM BadExample
GO
INSERT INTO BadExample
SELECT 'This fails', '1960-03-04'
SELECT * FROM BadExample-PatP|||The problem is that you are not specifying a column list for your INSERT statement, you are relying on an implied order.How did you come up with that from his post!?
I have a field 'Rowguid' of type uniqueidentifier in a table. This field is the last field in the table. In this case if I update a record through the application I don't get any error. Suppose if there are additional fields after the field Rowguid I get the error "Multiple-Step operation cannot be generated Check each status value"
For your reference I have used the following statement to add the RowGuid field
Alter table <tablename>
Add RowGuid uniqueidentifier ROWGUIDCOL NOT NULL Default (newid())
Can anyone please help me.
Thanks
SatheshPost your update statement, and any trigger code on this table.|||Where's Brett when we need him?
Logically, columns don't have any order within a table. It so happens that the current implementation of Microsoft SQL Server has a physical order, but that's implementation dependant. Relying on a column order (logical or physical) is a bug waiting to happen!
The problem is that you are not specifying a column list for your INSERT statement, you are relying on an implied order. Once you add columns so that the rowid is no longer the last column, your assumed order bytes you. If you specify the columns via a column list, this won't be a problem.DROP TABLE BadExample
GO
CREATE TABLE BadExample (
comment NVARCHAR(25)
)
GO
INSERT INTO BadExample
SELECT 'Simple case'
SELECT * FROM BadExample
GO
ALTER TABLE BadExample
ADD RowGuid uniqueidentifier ROWGUIDCOL NOT NULL
DEFAULT (newid())
INSERT INTO BadExample (comment)
SELECT 'Not as simple example'
SELECT * FROM BadExample
GO
ALTER TABLE BadExample
ADD myDate DATETIME NOT NULL
DEFAULT GetDate()
GO
INSERT INTO BadExample (comment, myDate)
SELECT 'This works!', '1950-01-02'
SELECT * FROM BadExample
GO
INSERT INTO BadExample
SELECT 'This fails', '1960-03-04'
SELECT * FROM BadExample-PatP|||The problem is that you are not specifying a column list for your INSERT statement, you are relying on an implied order.How did you come up with that from his post!?
Sunday, February 19, 2012
"HTTP status 400: Bad Request" - Reporting Services 2005
Has anyone ran into this error yet while testing Report Manager?
"The request failed with HTTP status 400: Bad Request."
I can deploy and access reports directly, but I receive the above error when
hitting the http://localhost/Reports URL (i.e. ReportManager)
Also, I'm seeing DCOM errors in the NT event log whenever this happens. A
search in the registry find CLSID references to network components (Network
Connection Manager Class, Network Connection Manager Connection Enumerator
Class, LAN Connection Manager Class, etc). Any ideas? Is there a security
configuration that I'm missing?
Here's an example entry:
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 11/8/2005
Time: 8:23:48 AM
User: NT AUTHORITY\NETWORK SERVICE
Computer: *SERVERNAME*
Description:
The application-specific permission settings do not grant Local Activation
permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative tool.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.I have the same problem and it turns out that you need to change the IP
address of your default website to "(all Unassigned)", instead of
specifiying a specific IP address.
thuan wrote:
> Has anyone ran into this error yet while testing Report Manager?
> "The request failed with HTTP status 400: Bad Request."
> I can deploy and access reports directly, but I receive the above error when
> hitting the http://localhost/Reports URL (i.e. ReportManager)
> Also, I'm seeing DCOM errors in the NT event log whenever this happens. A
> search in the registry find CLSID references to network components (Network
> Connection Manager Class, Network Connection Manager Connection Enumerator
> Class, LAN Connection Manager Class, etc). Any ideas? Is there a security
> configuration that I'm missing?
> Here's an example entry:
> Event Type: Error
> Event Source: DCOM
> Event Category: None
> Event ID: 10016
> Date: 11/8/2005
> Time: 8:23:48 AM
> User: NT AUTHORITY\NETWORK SERVICE
> Computer: *SERVERNAME*
> Description:
> The application-specific permission settings do not grant Local Activation
> permission for the COM Server application with CLSID
> {BA126AD1-2166-11D1-B1D0-00805FC1270E}
> to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
> permission can be modified using the Component Services administrative tool.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
"The request failed with HTTP status 400: Bad Request."
I can deploy and access reports directly, but I receive the above error when
hitting the http://localhost/Reports URL (i.e. ReportManager)
Also, I'm seeing DCOM errors in the NT event log whenever this happens. A
search in the registry find CLSID references to network components (Network
Connection Manager Class, Network Connection Manager Connection Enumerator
Class, LAN Connection Manager Class, etc). Any ideas? Is there a security
configuration that I'm missing?
Here's an example entry:
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 11/8/2005
Time: 8:23:48 AM
User: NT AUTHORITY\NETWORK SERVICE
Computer: *SERVERNAME*
Description:
The application-specific permission settings do not grant Local Activation
permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative tool.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.I have the same problem and it turns out that you need to change the IP
address of your default website to "(all Unassigned)", instead of
specifiying a specific IP address.
thuan wrote:
> Has anyone ran into this error yet while testing Report Manager?
> "The request failed with HTTP status 400: Bad Request."
> I can deploy and access reports directly, but I receive the above error when
> hitting the http://localhost/Reports URL (i.e. ReportManager)
> Also, I'm seeing DCOM errors in the NT event log whenever this happens. A
> search in the registry find CLSID references to network components (Network
> Connection Manager Class, Network Connection Manager Connection Enumerator
> Class, LAN Connection Manager Class, etc). Any ideas? Is there a security
> configuration that I'm missing?
> Here's an example entry:
> Event Type: Error
> Event Source: DCOM
> Event Category: None
> Event ID: 10016
> Date: 11/8/2005
> Time: 8:23:48 AM
> User: NT AUTHORITY\NETWORK SERVICE
> Computer: *SERVERNAME*
> Description:
> The application-specific permission settings do not grant Local Activation
> permission for the COM Server application with CLSID
> {BA126AD1-2166-11D1-B1D0-00805FC1270E}
> to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
> permission can be modified using the Component Services administrative tool.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
Friday, January 27, 2012
" the object invoked has disconnected from its clients"
I′m configuing a transacional replicationand after concluding it does not function, it is in the status initiating and later it gives the message: " the object invoked has disconnected from its clients"
Can you help me?
I have never heard of this error wrt replication.
The following article indicates it is a windows issue and the resolutions hopefully will help: http://www.kbalertz.com/Feedback_293631.aspx
Another poster upgraded his MDAC version to 2.8 and claims this solved his issue, although upgrading MDAC would not seem to be connected to the above article. Anyway, please let us know if you go down either route and how it works out.
Regards,
Paul Ibison
Can you help me?
I have never heard of this error wrt replication.
The following article indicates it is a windows issue and the resolutions hopefully will help: http://www.kbalertz.com/Feedback_293631.aspx
Another poster upgraded his MDAC version to 2.8 and claims this solved his issue, although upgrading MDAC would not seem to be connected to the above article. Anyway, please let us know if you go down either route and how it works out.
Regards,
Paul Ibison
Subscribe to:
Posts (Atom)
