TargetServerURL for named instance?
Hi There
I am running the latest Sql Server 2005 CTP with reports server installed.
I am following thorugh the Reporting services tutorial on 2005 BOL.
I am at the publishing report step:
The tutorial stipulates that under the project properties the url is as followshttp://servername/reportserver orhttp://local/reportserver for TargetServerURL.
The problem is that i am running sql server 2000 and 2005 on my machine.
So the named instance for 2005 is called SEANLO\SQLSERVER2005 and the reportserver database is named ReportServer$SqlServer2005 in that instance.
Because 2000 is my default instance.
As a result i am having difficulty adding the URL.
I have triedhttp://seanlo\sqlserver2005\reportserver but it is an invalid format.
I have tried http"//localhost/reportserver$sqlserver2005 but i get a connection cannot be made to reportserver error.
Any idea how i stipulate this url for a named instance of sql server 2005, 2005 instance is named seanlo\sqlserver2005 and the reportserver database on that instance is named ReportServer$SqlServer2005.
I have tried various variations without any luck.
Thanx
[1465 byte] By [
SeanDL] at [2007-12-16]
Hi Brian I have tried that but i get the following error:
What user and password does it use to connect to reportserver as the only one i define is for my Dataset?
Thanx for your help.
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/reportserver$sqlserver2005.
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>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>
<body bgcolor="white">
<span><H1>Server Error in '/ReportServer$SqlServer2005' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Configuration Error</i> </h2></span>
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>
<b> Parser Error Message: </b>The format of the file 'ReportingServicesWebServer' is invalid.<br><br>
<b>Source Error:</b> <br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
Line 27: <assemblies>
Line 28: <clear />
<font color=red>Line 29: <add assembly="ReportingServicesWebServer" />
</font>Line 30: </assemblies>
Line 31: </compilation></pre></code>
</td>
</tr>
</table>
<br>
<b> Source File: </b> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config<b> Line: </b> 29
<br><br>
<b>Assembly Load Trace:</b> The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.<br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
=== Pre-bind state information ===
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Post-policy reference: ReportingServicesWebServer
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/reportserver$sqlserver2005/4d7ee047/edb4e7dc/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/reportserver$sqlserver2005/4d7ee047/edb4e7dc/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
</pre></code>
</td>
</tr>
</table>
<br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
</font>
</body>
</html>
<!--
[BadImageFormatException]: The format of the file 'ReportingServicesWebServer' is invalid.
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Boolean isStringized, Evidence assemblySecurity, Boolean throwOnFileNotFound, Assembly locationHint, StackCrawlMark& stackMark)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Boolean stringized, Evidence assemblySecurity, StackCrawlMark& stackMark)
at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark)
at System.Reflection.Assembly.Load(String assemblyString)
at System.Web.UI.CompilationConfiguration.LoadAssemblies(Hashtable original)
[ConfigurationException]: The format of the file 'ReportingServicesWebServer' is invalid. (C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config line 29)
at System.Web.UI.CompilationConfiguration.LoadAssemblies(Hashtable original)
at System.Web.UI.TemplateParser.AppendConfigAssemblies()
at System.Web.UI.TemplateParser.PrepareParse()
at System.Web.UI.TemplateParser.Parse()
at System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation()
at System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean fCreateIfNotFound)
at System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath()
at System.Web.UI.TemplateParser.GetParserCacheItem()
at System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String inputFile, HttpContext context, ApplicationFileParser& parser)
at System.Web.HttpApplicationFactory.CompileApplication(HttpContext context)
at System.Web.HttpApplicationFactory.Init(HttpContext context)
at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
-->
--. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK
If the above doesn't work here is a way to find out what the URL should be.
go to
Start -> Settings -> Control Panel -> Administrative Tools -> IIS
for Windows XP
or
Start -> Administrative Tools -> Internet Information Services(IIS) Manager
for Windows Server 2003
Expand the <Computer Name>(Local Computer) node
Expand the Websites node
Expand the Default Website node
You should now be able to see Reports and ReportServer items, they may have $<Instance Name> appended to them if you have a named instance.
Basically whatever name your ReportServer item has should be the last part of your URL.
E.g.
http://localhost/ReportServer
or
http://localhost/ReportServer$<Instance Name>
hope this helps
