error: 26 - Error Locating Server/Instance Specified

Hi

I have setup the membership schema on a hosted server using the asp_regsql.exe tool fine. I have setup roles/memberships using the website adminitraion tool and i have checked that its all being entered into my hosted MSSQL server. I have also setup my web.config file to point to the hosted server and all seems to be connecting ok! When i test/debug my project locally (using the F5 key), my login box works fine!

How ever, i have now uploaded my project to my hosted server. If i put an incorrect login, then i get the usual 'Your login attempt was not successful. Please try again.' - So i know its connecting to the right database. How ever, when i enter the correct login details, i get the following error:

An error has occurred while establishing a connection tothe server. When connecting to SQL Server 2005, this failure may becaused by the fact that under the default settings SQL Server does notallow remote connections. (provider: SQL Network Interfaces, error: 26- Error Locating Server/Instance Specified)

...if its connecting to the same database fine when i test it from my local machine, why will it not work when i test it from my hosted server?

thanks

Hi

I've got it working now, how ever the problem seems to be somthing to with trying to access a page which is not in the root. I placed a new folder called 'admin' into my root folder. Inside the admin folder i placed a login.aspx and a default.aspx page.

In my web.config i placed:

<authentication mode="Forms">
<forms loginUrl="4dm1n/login.aspx" />
</authentication>

When logging on using this folder system is when the error occurs!

Any ideas what i need to change in order to get the scope right?

|||

found the problem - I hadn't declared the roleManager provider, eg

<roleManager enabled="true" defaultProvider="CustomizedRoleProvider">
<providers>
<add name="CustomizedRoleProvider"
type="System.Web.Security.SqlRoleProvider"
connectionStringName="BVDB" />
</providers>
</roleManager>

duh!

Error with SP

After installing SP2, when i try to run a report !
Thanks
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\RSReportHost.exe', nessun simbolo caricato.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\System.Windows.Forms\2.0.0.0__b77a5c561934e089\System.Windows.Forms.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ReportingServicesLibrary.dll', nessun simbolo
caricato.
'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Diagnostics.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\ReportingServicesLibrary.resources.dll',
nessun simbolo caricato.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato
'C:\WINDOWS\assembly\GAC_MSIL\mscorlib.resources\2.0.0.0_it_b77a5c561934e089\mscorlib.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Interfaces.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ReportingServicesNativeClient.dll' caricato,
caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione 'Just My
Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato
'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0DE06ACD\msvcm80.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Designer.dll',
nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ReportPreview.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ReportPreview.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ProcessingCore.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingObjectModel.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato
'C:\WINDOWS\assembly\GAC_MSIL\System.resources\2.0.0.0_it_b77a5c561934e089\System.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'kxxqa_gb', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.XmlRendering.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.XmlRendering.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.CsvRendering.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.CsvRendering.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ImageRendering.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ImageRendering.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.HtmlRendering.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.HtmlRendering.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ExcelRendering.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ExcelRendering.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato
'expression_host_7e2a1ba8efe345ea9ede8dfc7bf53f89', nessun simbolo caricato.
'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.DataExtensions.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualBasic\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
Il thread 0x378 è terminato con il codice 0 (0x0).
Il programma '[4884] RSReportHost.exe: Gestito' è terminato con il codice 0
(0x0).On Mar 2, 9:30 am, Paolo <P...@.discussions.microsoft.com> wrote:
> After installing SP2, when i try to run a report !
> Thanks
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.d=ll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\RSReportHost.exe', nessun simbolo caricat=o=2E
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Windows.Forms\2.0.0.0__b77a5c561934e=089\System.Windows.Forms.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\Sy=stem.Drawing.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\ReportingServicesLibrary.dll', nessun sim=bolo
> caricato.
> 'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Diagnostics.d=ll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\ReportingServicesLibrary.resources.dll=',
> nessun simbolo caricato.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50=a3a\System.Configuration.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System=.Xml.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.W=eb.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato
> 'C:\WINDOWS\assembly\GAC_MSIL\mscorlib.resources\2.0.0.0_it_b77a5c561934e=089\mscorlib.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Interfaces.dl=l'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\ReportingServicesNativeClient.dll' carica=to,
> caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opzione 'Just= My
> Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato
> 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x=-ww_0DE06ACD\msvcm80.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Designer.dll',
> nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ReportPreview=.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCor=e=2Edll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ReportPrev=iew.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a=3a\System.Web.Services.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.Processing=Core.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.=Data.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingObj=ectModel.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato
> 'C:\WINDOWS\assembly\GAC_MSIL\System.resources\2.0.0.0_it_b77a5c561934e08=9\System.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'kxxqa_gb', nessun simbolo caricat=o=2E
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.XmlRendering.=dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.XmlRenderi=ng.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.CsvRendering.=dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.CsvRenderi=ng.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ImageRenderin=g=2Edll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ImageRende=ring.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.HtmlRendering=.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.HtmlRender=ing.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ExcelRenderin=g=2Edll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ExcelRende=ring.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato
> 'expression_host_7e2a1ba8efe345ea9ede8dfc7bf53f89', nessun simbolo carica=to.
> 'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.DataExtension=s=2Edll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089=\System.Transactions.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11=d50a3a\System.EnterpriseServices.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c56193=4e089\System.Data.OracleClient.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualBasic\8.0.0.0__b03f5f7f11d5=0a3a\Microsoft.VisualBasic.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> Il thread 0x378 =E8 terminato con il codice 0 (0x0).
> Il programma '[4884] RSReportHost.exe: Gestito' =E8 terminato con il codi=ce 0
> (0x0).
It seems like the service pack did not install completely, which
happens from time to time. Try to uninstall the service pack or search
online for the Microsoft service pack removal executable (don't quote
me on the name) and try to reinstall the SP. Also, make sure that you
have the correct SP2 installation file as well. Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer

error with rs.exe utility

I'm getting some errors when I run rs.exe from command line with regard to Parameters, and was hoping I might get some help here. I'm somewhat new to RS. I'm running SQL 2000 and RS 2000 on a Windows 2003 Server.

Here is my script:
***********************************************************
' File: RunReport.rss
Dim format as string = "Excel"
Dim fileName as String = "C:\Export2.xls"
Dim reportPath as String = "/APSAgentCourseCompletionByUserGroup"

Public Sub Main()

' Prepare Render arguments
Dim historyID as string = Nothing
Dim deviceInfo as string = Nothing
Dim showHide as string = Nothing
Dim results() as Byte
Dim encoding as string
Dim mimeType as string = "ms-excel"
Dim warnings() AS Warning = Nothing
Dim reportHistoryParameters() As ParameterValue = Nothing
Dim streamIDs() as string = Nothing
rs.Credentials = System.Net.CredentialCache.DefaultCredentials

' Report Parameters
Dim parameters(5) As ParameterValue
parameters(0) = New ParameterValue()
parameters(0).Name = "User Group"
parameters(0).Value = "66179312-f341-4df7-a855-79c5b8abaf9f"
parameters(1) = New ParameterValue()
parameters(1).Name = "Start Date"
parameters(1).Value = "12/22/2006"
parameters(2) = New ParameterValue()
parameters(2).Name = "End Date"
parameters(2).Value = "2/17/2007"
parameters(3) = New ParameterValue()
parameters(3).Name = "Course Name"
parameters(3).Value = "AA2B1AA0-E78A-4F84-834F-8EAAB75BEBD3"
parameters(4) = New ParameterValue()
parameters(4).Name = "Status To Include"
parameters(4).Value = "0"
results = rs.Render(reportPath, format, _
Nothing, Nothing, parameters, _
Nothing, Nothing, encoding, mimeType, _
reportHistoryParameters, warnings, streamIDs)

' Open a file stream and write out the report
Dim stream As FileStream = File.OpenWrite(fileName)
stream.Write(results, 0, results.Length)
stream.Close()

End Sub

'End of script
***********************************************************

As you can see, right now I've got all 5 report parameters hard-coded.

Here is the command line that I'm using as well as the error that I receive:

rs.exe -i c:\RunReport.rss -s http://localhost/reportserver -t
Unhandled exception: The value of parameter 'Parameters' is not valid. Check the documentation for information about valid values.

Any insight that anyone can provide is greatly appreciated.

Thanks!

Raywhat...? no response to this yet? i'm desperately seeking samples for
how to use this rs.exe utility, and there's just not enough out there.

a comprehensive tutorial would be nice too actually; but thats just a dream at this point.
|||Yeah, i was really hoping that someone would respond to it as well, but luckily i stumbled upon my own solution. The error that I was receiving was because the array I initialized was incremented by too much. Instead of

Dim parameters(5) As ParameterValue

it should have been:

Dim parameters(4) As ParameterValue

Once I made that change the script was executing just fine!

Hope this helps you somewhat. Are you receiving other errors?

error with rs.exe utility

I'm getting some errors when I run rs.exe from command line with regard to Parameters, and was hoping I might get some help here. I'm somewhat new to RS. I'm running SQL 2000 and RS 2000 on a Windows 2003 Server.

Here is my script:
***********************************************************
' File: RunReport.rss
Dim format as string = "Excel"
Dim fileName as String = "C:\Export2.xls"
Dim reportPath as String = "/APSAgentCourseCompletionByUserGroup"

Public Sub Main()

' Prepare Render arguments
Dim historyID as string = Nothing
Dim deviceInfo as string = Nothing
Dim showHide as string = Nothing
Dim results() as Byte
Dim encoding as string
Dim mimeType as string = "ms-excel"
Dim warnings() AS Warning = Nothing
Dim reportHistoryParameters() As ParameterValue = Nothing
Dim streamIDs() as string = Nothing
rs.Credentials = System.Net.CredentialCache.DefaultCredentials

' Report Parameters
Dim parameters(5) As ParameterValue
parameters(0) = New ParameterValue()
parameters(0).Name = "User Group"
parameters(0).Value = "66179312-f341-4df7-a855-79c5b8abaf9f"
parameters(1) = New ParameterValue()
parameters(1).Name = "Start Date"
parameters(1).Value = "12/22/2006"
parameters(2) = New ParameterValue()
parameters(2).Name = "End Date"
parameters(2).Value = "2/17/2007"
parameters(3) = New ParameterValue()
parameters(3).Name = "Course Name"
parameters(3).Value = "AA2B1AA0-E78A-4F84-834F-8EAAB75BEBD3"
parameters(4) = New ParameterValue()
parameters(4).Name = "Status To Include"
parameters(4).Value = "0"
results = rs.Render(reportPath, format, _
Nothing, Nothing, parameters, _
Nothing, Nothing, encoding, mimeType, _
reportHistoryParameters, warnings, streamIDs)

' Open a file stream and write out the report
Dim stream As FileStream = File.OpenWrite(fileName)
stream.Write(results, 0, results.Length)
stream.Close()

End Sub

'End of script
***********************************************************

As you can see, right now I've got all 5 report parameters hard-coded.

Here is the command line that I'm using as well as the error that I receive:

rs.exe -i c:\RunReport.rss -s http://localhost/reportserver -t
Unhandled exception: The value of parameter 'Parameters' is not valid. Check the documentation for information about valid values.

Any insight that anyone can provide is greatly appreciated.

Thanks!

Ray

what...? no response to this yet? i'm desperately seeking samples for
how to use this rs.exe utility, and there's just not enough out there.

a comprehensive tutorial would be nice too actually; but thats just a dream at this point.
|||Yeah, i was really hoping that someone would respond to it as well, but luckily i stumbled upon my own solution. The error that I was receiving was because the array I initialized was incremented by too much. Instead of

Dim parameters(5) As ParameterValue

it should have been:

Dim parameters(4) As ParameterValue

Once I made that change the script was executing just fine!

Hope this helps you somewhat. Are you receiving other errors?

Error while running service

Hi,
I have created .net windows service for running an exe. Exe is running
fine. It is used for inserting xml data in sql server database.
My service mode is automatic. Whenevr i start my computer it is
throwing me an error below :-
"An unhandled exception of type 'system.data.sqlclient.sqlexception'
occured in system.data.dll.
Additinal information : A connection was successfully established with
the server.but then an error occured during prelogin handshake.
(provider - SSL provider , error : 0 - the messege or signature
provided for verification has been altered"
When i start service in manual mode it runs perfectly fine. Can
someone please help me in this regard?
Arati
On Jul 31, 8:33 am, JPD <nos...@.nospamplease.com> wrote:
> Hi Arati,
> I've seen a similar problem just last week. In that case we deleted all
> certificates on the server and everything worked perfectly.
> Jonathan
>
> Arati wrote:
>
>
>
> - Show quoted text -
Hi,
Are you talking about server certificates for IIS or sql server?
Regards,
Arati
|||On Aug 2, 6:30 am, Jonathan Psaila-Depasquale
<nos...@.nospamplease.com> wrote:
> Hi Arati,
> You have delete all existing certificates on the server no matter what
> purpose they are serving. In the case I encountered last week the
> problem certificate was for SharePoint.
> Jonathan
>
> Arati wrote:
>
>
>
> - Show quoted text -
Hi,
There are no certificates for IIS server. And I don't know where I can
find certificate for sql server. Do you have any idea on this?
Regards,
Arati

Error while running service

Hi,
I have created .net windows service for running an exe. Exe is running
fine. It is used for inserting xml data in sql server database.
My service mode is automatic. Whenevr i start my computer it is
throwing me an error below :-
"An unhandled exception of type 'system.data.sqlclient.sqlexception'
occured in system.data.dll.
Additinal information : A connection was successfully established with
the server.but then an error occured during prelogin handshake.
(provider - SSL provider , error : 0 - the messege or signature
provided for verification has been altered"
When i start service in manual mode it runs perfectly fine. Can
someone please help me in this regard?
AratiHi Arati,
I've seen a similar problem just last week. In that case we deleted all
certificates on the server and everything worked perfectly.
Jonathan
Arati wrote:
> Hi,
> I have created .net windows service for running an exe. Exe is running
> fine. It is used for inserting xml data in sql server database.
> My service mode is automatic. Whenevr i start my computer it is
> throwing me an error below :-
> "An unhandled exception of type 'system.data.sqlclient.sqlexception'
> occured in system.data.dll.
> Additinal information : A connection was successfully established with
> the server.but then an error occured during prelogin handshake.
> (provider - SSL provider , error : 0 - the messege or signature
> provided for verification has been altered"
> When i start service in manual mode it runs perfectly fine. Can
> someone please help me in this regard?
> Arati
>|||On Jul 31, 8:33 am, JPD <nos...@.nospamplease.com> wrote:
> Hi Arati,
> I've seen a similar problem just last week. In that case we deleted all
> certificates on the server and everything worked perfectly.
> Jonathan
>
> Arati wrote:
>
>
>
>
>
>
> - Show quoted text -
Hi,
Are you talking about server certificates for IIS or sql server?
Regards,
Arati|||Hi Arati,
You have delete all existing certificates on the server no matter what
purpose they are serving. In the case I encountered last week the
problem certificate was for SharePoint.
Jonathan
Arati wrote:
> On Jul 31, 8:33 am, JPD <nos...@.nospamplease.com> wrote:
> Hi,
> Are you talking about server certificates for IIS or sql server?
> Regards,
> Arati
>|||On Aug 2, 6:30 am, Jonathan Psaila-Depasquale
<nos...@.nospamplease.com> wrote:
> Hi Arati,
> You have delete all existing certificates on the server no matter what
> purpose they are serving. In the case I encountered last week the
> problem certificate was for SharePoint.
> Jonathan
>
> Arati wrote:
>
>
>
>
>
>
> - Show quoted text -
Hi,
There are no certificates for IIS server. And I don't know where I can
find certificate for sql server. Do you have any idea on this?
Regards,
Arati|||Hi,
Open an MMC console. Go to File | Add/Remove Snap-in. Click on Add and
select Certificates. Choose Computer Account and then Local Computer.
Click Finish, Close, OK.
In the tree on the left expand Certificates (Local Computer), then click
on Personal. You need to delete all certificates that appear in the
details pane.
Jonathan
Arati wrote:
> On Aug 2, 6:30 am, Jonathan Psaila-Depasquale
> <nos...@.nospamplease.com> wrote:
> Hi,
> There are no certificates for IIS server. And I don't know where I can
> find certificate for sql server. Do you have any idea on this?
> Regards,
> Arati
>