By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,359 Members | 1,495 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,359 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.