SQLXML: error loading XSL stylesheet (A security error occurred)

[campwes]

Hey, all! We're having trouble displaying SQL Server data in a web site as
XML, using a transform. The query is a simple SELECT statement. When
running the query, we get the following error from the web site:

<error>
[COMException (0x80004005): SQLXML: error loading XSL stylesheet (A security
error occurred
)]

Microsoft.Data.SqlXml.Common.ISQLXMLCommandManaged Interface.ExecuteToOutputStream() +0
Microsoft.Data.SqlXml.SqlXmlCommand.innerExecute(S tream strm) +137

[SqlXmlException: SQLXML: error loading XSL stylesheet (A security error
occurred
)]
Microsoft.Data.SqlXml.SqlXmlCommand.innerExecute(S tream strm) +178
Microsoft.Data.SqlXml.SqlXmlCommand.ExecuteToStrea m(Stream outputStream)
+10
UATPWebApplication.QueryResults.Page_Load(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
</error>

There are 2 servers in an NLB config. WS1 works fine (no error), but WS2
doesn't.

I've searched and searched, but I'm not able to find a similar error neither
in the newsgroups, nor Google. Any help is appreciated.

[campwes]

SOLUTION! The error was being caused by my SSL certificate - access to our
XSL sheets required SSL. I replaced the SSL cert, and now all is good!

Thanks to everyone who... wait! I solved it MYSELF!!!

Not bitter at all,

campwes

"campwes" wrote:

Hey, all! We're having trouble displaying SQL Server data in a web site as
XML, using a transform. The query is a simple SELECT statement. When
running the query, we get the following error from the web site:

<error>
[COMException (0x80004005): SQLXML: error loading XSL stylesheet (A security
error occurred
)]

Microsoft.Data.SqlXml.Common.ISQLXMLCommandManaged Interface.ExecuteToOutputStream() +0
Microsoft.Data.SqlXml.SqlXmlCommand.innerExecute(S tream strm) +137

[SqlXmlException: SQLXML: error loading XSL stylesheet (A security error
occurred
)]
Microsoft.Data.SqlXml.SqlXmlCommand.innerExecute(S tream strm) +178
Microsoft.Data.SqlXml.SqlXmlCommand.ExecuteToStrea m(Stream outputStream)
+10
UATPWebApplication.QueryResults.Page_Load(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
</error>

There are 2 servers in an NLB config. WS1 works fine (no error), but WS2
doesn't.

I've searched and searched, but I'm not able to find a similar error neither
in the newsgroups, nor Google. Any help is appreciated.