Error when deploying Report Model

I installed SQL Server 2005 on my laptop, this also contains my SQL Server 2000, so I couldnt use localhost and I used CreweAlex/SQLSERVER2005 as the hostname.

What do I need to fill in the field:

TargetServerURL

Because when I type http:\\localhost\ReportServer it doesn't work (as mentioned in the tutorial which I am following), also CreweAlex/SQLSERVER2005/ReportServer doesnt work.

I tried all kinds of combinations, but nothing works.

Everything is installed on my laptop, also the Reporting Server.

Try http://crewealex/reportserver$sqlserver2005|||

Thanks for the quick respons, but I still get an error:

Connection could not be made to the report server

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.SemanticQueryDesign)

|||

When I type http://crewealex/reportserver in my browser then I can see that I log in into my Report Server, because this is the message that I get:

Microsoft SQL Server Reporting Services Version 9.00.1399.00

I typed http://crewealex/reportserver in my TargetServerURL and this works now. But my instance name is SQLSERVER2005. > Problem solved.

Error when deploying report builder model

I get the following error when I try to deploy a report builder model. The SQL Server 2005 "Reporting Services" are installed and running on the local machine.

TITLE: Microsoft Semantic Model Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.SemanticQueryDesign)

BUTTONS:

OKI ended up uninstalling SQL Server 2005, uninstalling the previously installed SQLExpress, and then reinstalling SQL Server 2005. This solved the problem.|||I had the same kind a problem and i started looking some other reporting tool .The very best one on the market in my opinion is Intelliview. It is very pricey

though! You can find it here: http://www.synaptris.com/products/reporting-analytics/index.html

Error when deploying report builder model

I get the following error when I try to deploy a report builder model. The SQL Server 2005 "Reporting Services" are installed and running on the local machine.

TITLE: Microsoft Semantic Model Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.SemanticQueryDesign)

BUTTONS:

OKI ended up uninstalling SQL Server 2005, uninstalling the previously installed SQLExpress, and then reinstalling SQL Server 2005. This solved the problem.|||I had the same kind a problem and i started looking some other reporting tool .The very best one on the market in my opinion is Intelliview. It is very pricey

though! You can find it here: http://www.synaptris.com/products/reporting-analytics/index.htmlsql

Error when creating DMX query

On screen states [Error loading mining model metadata: No Metadata found]

and on the functions states [Error loading functions: no functions found]

This also occures when trying to use the Data mining wizard, it will just not respond.

Have deleted and removed all references to SQL2005 Standard and reloaded and still get same errors

Could someone please advise, have sent errors to Microsoft with no responce back yet.

I assume you are using the DMX query in SQL Management Studio?

These results occur when you have a database selected that doesn't contain any mining models. If you select a database in the database selector on the toolbar that contains models, you will get the list of models in the database in that pane of the user interface.

Also you could just do

"CREATE MINING MODEL foo ( custid LONG KEY, MyColumn LONG CONTINUOUS) USING Microsoft_Clustering"

and that would create a model in the current database that should show up in the metadata browser.

Given that you have issues using the wizard as well, it sounds like there may be some other issues. Can you provide more details?

Thanks,

-Jamie

Error using neural network mining model viewer

I've successfully created and processed a very simple neural network mining model (defined against a cube). However, when I go to the model viewer in BI studio, it displays the following error:

"Execution of the managed stored procedure GetAttributeScores failed with the following error: Exception has been thrown by the target of an invocation.Input string was not in a correct format.."

Any ideas about what's going wrong? This is with SQL Server 2005 SP1.

Hello,

Some issues with the neural network viewer were fixed for Service Pack 2. You can download the latest technology preview (CTP2) for SP2 from here http://www.microsoft.com/downloads/details.aspx?FamilyID=7A9AD90F-7F95-4369-A206-E84053D63FD3&displaylang=en

If this is not an option, or it does not solve the problem with your model, could you provide a few details about the mining models? (columns, their content type , data type).

thanks

|||Going to the SP2 beta a bit problematic for us right now. Any idea when it's suppose to RTM?

I've been playing around with different variations of the mining structure - mostly super-simple structures (I'm just dipping my toes in the DM waters here). The results seem to vary. For example, a two attribute structure - a text key column and a double continuous Predict column results in the error

"Internal error: An unexpected exception occured.
Execution of the managed stored procedure GetAttributeScores failed with the following error: Exception has been thrown by the target of an invocation.Object reference not set to an instance of an object.."

I then added a nested table as an input (a text key column), and after that get a different error:

"Execution of the managed stored procedure GetAttributeScores failed with the following error: Exception has been thrown by the target of an invocation.Input string was not in a correct format.."

Processing the model and doing prediction queries seems to work OK, but the Mining Model Viewer is just completely broken.|||SP2 is scheduled for release in Q1 '07. If this becomes a blocking issue for you, please contact support (start at support.microsoft.com)