Error Connection with instance

How i can create the Instance into my sql server?
After create it , how to add into ODBC?have any different for the login
authentication between instance and local server?> How i can create the Instance into my sql server?
> After create it , how to add into ODBC?have any different for the login
> authentication between instance and local server?
It is hard to say what went wrong from your info. You can check how to
connect to SQL Server at
http://msdn2.microsoft.com/en-gb/library/ms190944.aspx. You can check
different connection string, including ODBS connection strings, at
http://www.connectionstrings.com/.
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

Error Connecting To SQL 2005 through Webservice using SQL Authentication

Running a SQL 2005 Database under a Default instance. i.e. (SERVERNAME) and not (SERVERNAME/SQL2005)

I have a SQL Login sa password.

When I connect to SQL 2005 from anywhere other then the webservice it works fine.

In my webservice i am using System.Data.SqlClient.

SqlConnection, SqlCommand, SqlDataAdapter are being used to called a stored procedure and return the data into a System.Data.DataSet.

I get the following error when calling DataAdapter.Fill(dataSet);

{"TCP Provider: An existing connection was forcibly closed by the remote host.\r\n\r\nLogin failed for user 'sa'."}

I have no resolutions as of yet. Any help would be greatly appreciated.

Did you mean you can connect to the SQL2005 from anywhere with 'sa' login, except webservice? You can check the status of 'sa' login in management studio under Security->Logins, also make sure the Authentication Mode is SQL Server and Windows.|||

I have checked the status of the login for user "sa" and it has access rights and grant levels to everything it needs to.

I have also created a new account specifically for that database which does not work either. Same error.

And yes my SQL 2005 Instance is configured to use both SQL Authentication and Windows Authentication. (Mixed Mode).

Any Ideas?

|||

If you encountered this issue when you're trying to establish encrypted connection , you may take a look at this article:

http://blogs.msdn.com/sql_protocols/archive/2006/07/26/678596.aspx

error connecting to datasource

environment:
Win 2000
SqlServer2000
ReportServices
Reports and ReportServer virtual directories set to Windows authentication
-- Sample reports installed without any problems thru the sql script
-- Reports and Reportserver pages accessible without any problems
VS .NET 2003
Using VS .NET 2003,
I have created a Report Project
Shared Data Source:
name mysqlodbc
ODBC
dsn=mysqlodbc;database=myski;Driver={MySQL ODBC 3.51 Driver}
I have created a report3.rdl using the mysqlodbc data source.
In the design view of the report, the preview of the report works fine.
When I try to run the report I get the following error:
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'mysqlodbc'. (rsErrorOpeningConnection) Get Online Help
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Please help.It looks like the mysqlodbc ODBC data source is not defined on the report
server machine. Check that
'mysqlodbc' is defined as a system-level DSN on the server.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"jerry" <jerry@.discussions.microsoft.com> wrote in message
news:34955583-B44A-4115-AACC-D7EB2A732CF2@.microsoft.com...
> environment:
> Win 2000
> SqlServer2000
> ReportServices
> Reports and ReportServer virtual directories set to Windows authentication
> -- Sample reports installed without any problems thru the sql script
> -- Reports and Reportserver pages accessible without any problems
> VS .NET 2003
> Using VS .NET 2003,
> I have created a Report Project
> Shared Data Source:
> name mysqlodbc
> ODBC
> dsn=mysqlodbc;database=myski;Driver={MySQL ODBC 3.51 Driver}
> I have created a report3.rdl using the mysqlodbc data source.
> In the design view of the report, the preview of the report works fine.
> When I try to run the report I get the following error:
> An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
> Cannot create a connection to data source 'mysqlodbc'.
(rsErrorOpeningConnection) Get Online Help
> ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified
> Please help.
>
>

Error Connecting SQL Server 2005

Hi There,
Any one can help me suggest what to do with below problem?
while install SQL Server 2005, there is no Authentication Mode Option
prompted out for users to select The Mixed Mode. This is installed using the
correct Copyright from Ms SQL Server 2005 CD with Standard Version, where it
having CD1 and CD2. After complete setup without any error message, when
trying to open the Ms SQL Server Management Studio and connect to the server,
there are error prompted out can not be connected. error message like below:
"an error has occurred while establishing a connection to the server. when
connecting to sql server 2005, this failure may be caused by the fact that
under the default settings sql server does not allow remote connections.
(provider: named pipes provider, error: 40 - could not open a connection to
sql server) (microsoft sql server, error: 2) "
Kindly advice
Thank you
Regards,
Carmen
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200711/1
As the error says, the default installation of SQL 2005 does not
allow remote connections.
You will have to enable remote connections and [optionally] start
the SQL Server Browser service.
Detailed information:
914277 - How to configure SQL Server 2005 to allow remote
connections
http://support.microsoft.com/?kbid=914277
__________________________________________________ _______
Vera Noest
MCSE, CCEA, Microsoft MVP - Terminal Server
SQL troubleshooting: http://sql.veranoest.net
___ please respond in newsgroup, NOT by private email ___
"carmen413 via droptable.com" <u21749@.uwe> wrote on 23 nov 2007
in microsoft.public.sqlserver.server:

> Hi There,
> Any one can help me suggest what to do with below problem?
> while install SQL Server 2005, there is no Authentication Mode
> Option prompted out for users to select The Mixed Mode. This is
> installed using the correct Copyright from Ms SQL Server 2005 CD
> with Standard Version, where it having CD1 and CD2. After
> complete setup without any error message, when trying to open
> the Ms SQL Server Management Studio and connect to the server,
> there are error prompted out can not be connected. error message
> like below: "an error has occurred while establishing a
> connection to the server. when connecting to sql server 2005,
> this failure may be caused by the fact that under the default
> settings sql server does not allow remote connections.
> (provider: named pipes provider, error: 40 - could not open a
> connection to sql server) (microsoft sql server, error: 2) "
> Kindly advice
> Thank you
> Regards,
> Carmen
|||Hello Carmen,
SQL Server 2005' s authentication mode is Windows Authentication by default
and the "sa" account will be disabled by default.
So, you can change your authentication mode by connecting your SQL Server
instance using SSMS after the setup. Go to Server Properties and Security.
You'll see the authentication modes there. I want to stress that "sa"
account is disabled by default. You can enable it (if you really need that)
from the Security\Logins nodes.
To be able to connect to your SQL Server instance, you must ensure that your
SQL Server service is running. You can check it using SQL Server
Configuration Manager or Services MMC.
This is not about remote connections at all because Remote Connections is
enabled by default for Standard and Enterprise Editions of SQL Server 2005.
It's disabled for Express and Developer Editions of SQL Server 2005 by
default.
Ekrem ?nsoy
"carmen413 via droptable.com" <u21749@.uwe> wrote in message
news:7ba5d81d07de2@.uwe...
> Hi There,
> Any one can help me suggest what to do with below problem?
> while install SQL Server 2005, there is no Authentication Mode Option
> prompted out for users to select The Mixed Mode. This is installed using
> the
> correct Copyright from Ms SQL Server 2005 CD with Standard Version, where
> it
> having CD1 and CD2. After complete setup without any error message, when
> trying to open the Ms SQL Server Management Studio and connect to the
> server,
> there are error prompted out can not be connected. error message like
> below:
> "an error has occurred while establishing a connection to the server. when
> connecting to sql server 2005, this failure may be caused by the fact that
> under the default settings sql server does not allow remote connections.
> (provider: named pipes provider, error: 40 - could not open a connection
> to
> sql server) (microsoft sql server, error: 2) "
> Kindly advice
> Thank you
> Regards,
> Carmen
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server/200711/1
>

Error Connecting SQL Server 2005

Hi There,
Any one can help me suggest what to do with below problem?
while install SQL Server 2005, there is no Authentication Mode Option
prompted out for users to select The Mixed Mode. This is installed using the
correct Copyright from Ms SQL Server 2005 CD with Standard Version, where it
having CD1 and CD2. After complete setup without any error message, when
trying to open the Ms SQL Server Management Studio and connect to the server,
there are error prompted out can not be connected. error message like below:
"an error has occurred while establishing a connection to the server. when
connecting to sql server 2005, this failure may be caused by the fact that
under the default settings sql server does not allow remote connections.
(provider: named pipes provider, error: 40 - could not open a connection to
sql server) (microsoft sql server, error: 2) "
Kindly advice
Thank you
Regards,
Carmen
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200711/1As the error says, the default installation of SQL 2005 does not
allow remote connections.
You will have to enable remote connections and [optionally] start
the SQL Server Browser service.
Detailed information:
914277 - How to configure SQL Server 2005 to allow remote
connections
http://support.microsoft.com/?kbid=914277
_________________________________________________________
Vera Noest
MCSE, CCEA, Microsoft MVP - Terminal Server
SQL troubleshooting: http://sql.veranoest.net
___ please respond in newsgroup, NOT by private email ___
"carmen413 via SQLMonster.com" <u21749@.uwe> wrote on 23 nov 2007
in microsoft.public.sqlserver.server:
> Hi There,
> Any one can help me suggest what to do with below problem?
> while install SQL Server 2005, there is no Authentication Mode
> Option prompted out for users to select The Mixed Mode. This is
> installed using the correct Copyright from Ms SQL Server 2005 CD
> with Standard Version, where it having CD1 and CD2. After
> complete setup without any error message, when trying to open
> the Ms SQL Server Management Studio and connect to the server,
> there are error prompted out can not be connected. error message
> like below: "an error has occurred while establishing a
> connection to the server. when connecting to sql server 2005,
> this failure may be caused by the fact that under the default
> settings sql server does not allow remote connections.
> (provider: named pipes provider, error: 40 - could not open a
> connection to sql server) (microsoft sql server, error: 2) "
> Kindly advice
> Thank you
> Regards,
> Carmen|||Hello Carmen,
SQL Server 2005' s authentication mode is Windows Authentication by default
and the "sa" account will be disabled by default.
So, you can change your authentication mode by connecting your SQL Server
instance using SSMS after the setup. Go to Server Properties and Security.
You'll see the authentication modes there. I want to stress that "sa"
account is disabled by default. You can enable it (if you really need that)
from the Security\Logins nodes.
To be able to connect to your SQL Server instance, you must ensure that your
SQL Server service is running. You can check it using SQL Server
Configuration Manager or Services MMC.
This is not about remote connections at all because Remote Connections is
enabled by default for Standard and Enterprise Editions of SQL Server 2005.
It's disabled for Express and Developer Editions of SQL Server 2005 by
default.
--
Ekrem Ã?nsoy
"carmen413 via SQLMonster.com" <u21749@.uwe> wrote in message
news:7ba5d81d07de2@.uwe...
> Hi There,
> Any one can help me suggest what to do with below problem?
> while install SQL Server 2005, there is no Authentication Mode Option
> prompted out for users to select The Mixed Mode. This is installed using
> the
> correct Copyright from Ms SQL Server 2005 CD with Standard Version, where
> it
> having CD1 and CD2. After complete setup without any error message, when
> trying to open the Ms SQL Server Management Studio and connect to the
> server,
> there are error prompted out can not be connected. error message like
> below:
> "an error has occurred while establishing a connection to the server. when
> connecting to sql server 2005, this failure may be caused by the fact that
> under the default settings sql server does not allow remote connections.
> (provider: named pipes provider, error: 40 - could not open a connection
> to
> sql server) (microsoft sql server, error: 2) "
> Kindly advice
> Thank you
> Regards,
> Carmen
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200711/1
>

Error Connecting SQL Server 2005

Hi There,
Any one can help me suggest what to do with below problem?
while install SQL Server 2005, there is no Authentication Mode Option
prompted out for users to select The Mixed Mode. This is installed using the
correct Copyright from Ms SQL Server 2005 CD with Standard Version, where it
having CD1 and CD2. After complete setup without any error message, when
trying to open the Ms SQL Server Management Studio and connect to the server
,
there are error prompted out can not be connected. error message like below:
"an error has occurred while establishing a connection to the server. when
connecting to sql server 2005, this failure may be caused by the fact that
under the default settings sql server does not allow remote connections.
(provider: named pipes provider, error: 40 - could not open a connection to
sql server) (microsoft sql server, error: 2) "
Kindly advice
Thank you
Regards,
Carmen
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200711/1As the error says, the default installation of SQL 2005 does not
allow remote connections.
You will have to enable remote connections and [optionally] start
the SQL Server Browser service.
Detailed information:
914277 - How to configure SQL Server 2005 to allow remote
connections
http://support.microsoft.com/?kbid=914277
________________________________________
_________________
Vera Noest
MCSE, CCEA, Microsoft MVP - Terminal Server
SQL troubleshooting: http://sql.veranoest.net
___ please respond in newsgroup, NOT by private email ___
"carmen413 via droptable.com" <u21749@.uwe> wrote on 23 nov 2007
in microsoft.public.sqlserver.server:

> Hi There,
> Any one can help me suggest what to do with below problem?
> while install SQL Server 2005, there is no Authentication Mode
> Option prompted out for users to select The Mixed Mode. This is
> installed using the correct Copyright from Ms SQL Server 2005 CD
> with Standard Version, where it having CD1 and CD2. After
> complete setup without any error message, when trying to open
> the Ms SQL Server Management Studio and connect to the server,
> there are error prompted out can not be connected. error message
> like below: "an error has occurred while establishing a
> connection to the server. when connecting to sql server 2005,
> this failure may be caused by the fact that under the default
> settings sql server does not allow remote connections.
> (provider: named pipes provider, error: 40 - could not open a
> connection to sql server) (microsoft sql server, error: 2) "
> Kindly advice
> Thank you
> Regards,
> Carmen|||Hello Carmen,
SQL Server 2005' s authentication mode is Windows Authentication by default
and the "sa" account will be disabled by default.
So, you can change your authentication mode by connecting your SQL Server
instance using SSMS after the setup. Go to Server Properties and Security.
You'll see the authentication modes there. I want to stress that "sa"
account is disabled by default. You can enable it (if you really need that)
from the Security\Logins nodes.
To be able to connect to your SQL Server instance, you must ensure that your
SQL Server service is running. You can check it using SQL Server
Configuration Manager or Services MMC.
This is not about remote connections at all because Remote Connections is
enabled by default for Standard and Enterprise Editions of SQL Server 2005.
It's disabled for Express and Developer Editions of SQL Server 2005 by
default.
Ekrem ?nsoy
"carmen413 via droptable.com" <u21749@.uwe> wrote in message
news:7ba5d81d07de2@.uwe...
> Hi There,
> Any one can help me suggest what to do with below problem?
> while install SQL Server 2005, there is no Authentication Mode Option
> prompted out for users to select The Mixed Mode. This is installed using
> the
> correct Copyright from Ms SQL Server 2005 CD with Standard Version, where
> it
> having CD1 and CD2. After complete setup without any error message, when
> trying to open the Ms SQL Server Management Studio and connect to the
> server,
> there are error prompted out can not be connected. error message like
> below:
> "an error has occurred while establishing a connection to the server. when
> connecting to sql server 2005, this failure may be caused by the fact that
> under the default settings sql server does not allow remote connections.
> (provider: named pipes provider, error: 40 - could not open a connection
> to
> sql server) (microsoft sql server, error: 2) "
> Kindly advice
> Thank you
> Regards,
> Carmen
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200711/1
>

Error Authentication User Informations

Hey Gang, I get a error message "Authentication Failed for SQL Server
instance: local with friendly name local SQL Server does not exist or
access denied". I have a Just loaded SQL Server on my virtual box and loaded
Microsofts bpa and microsoft security anlyzer. The security scan work but the
bpa scan does
not. I also look at the database,I can get access to and notice a new
database schema(sqlbpa). Any help would be appreciated.

Thanks
Garry DGarry D (garrydawkins@.hotmail.com) writes:
> Hey Gang, I get a error message "Authentication Failed for SQL Server
> instance: local with friendly name local SQL Server does not exist or
> access denied". I have a Just loaded SQL Server on my virtual box and
> loaded Microsofts bpa and microsoft security anlyzer. The security scan
> work but the bpa scan does not. I also look at the database,I can get
> access to and notice a new database schema(sqlbpa). Any help would be
> appreciated.

The message means that the specified SQL Server does not exist. (Or that
your network permissions prevented you from finding it).

If you have SQL Server running on your virtual box, and BPA running on your
host machine and have specified (local) as your SQL Server, that won't
fly. You need to specify the name of the virtual machine.

And, of course, you have to make sure that SQL Server is running.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks, that work perfectly. By Identifying the server name within bpa
it took off and authenticated and is running as we speak.

GDawkins

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Error accessing report

I am trying to use the render webmothod to render the report in PDF..I have
forms based authentication in place. The follwoing code is mainly to get rid
of open save dialog box when the report is running in a webbrowser.
The follwing is the code:
===================================================== 'specify the credentials
Dim s As RS.ReportingService = New RS.ReportingService
s.Credentials = System.Net.CredentialCache.DefaultCredentials
Try
' Render arguments
Dim result As Byte() = Nothing
' Please adapt report name and path
Dim reportPath As String = "/SKEL REPORTS/UserList"
Dim format As String = "PDF"
Dim historyID As String = Nothing
Dim devInfo As String = ""
Dim showHideToggle As String = Nothing
Dim encoding As String
Dim mimeType As String
Dim warnings As RS.Warning() = Nothing
Dim reportHistoryParameters As RS.ParameterValue() = Nothing
Dim streamIDs As String() = Nothing
Dim sh As RS.SessionHeader = New RS.SessionHeader
s.SessionHeaderValue = sh
'call the render method of webservice
result = s.Render(reportPath, format, historyID, devInfo, Nothing,
Nothing, showHideToggle, encoding, mimeType, reportHistoryParameters,
warnings, streamIDs)
'send the PDF report to IE using Response object
Response.ClearContent()
Response.ContentType = "application/pdf"
Response.AddHeader("content-disposition", "inline;
filename=report1.PDF")
Response.BinaryWrite(result)
Response.End()
'Response.Write ("done");
Catch ex As Exception
Response.Write(ex.ToString())
End Try
End Sub
===================================================== This is the error I get when I try to run a report:
===================================================== System.Net.WebException: The request failed with the error message: --
Object moved to here.
--. at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at RS.ReportingService.Render(String Report,
String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds) in c:\inetpub\wwwroot\skel\Web
References\RS\Reference.vb:line 549 at
EQ.SKEL.Web.WebForms.ReportViewer.RenderReport() in
c:\inetpub\wwwroot\skel\Reports\ReportViewer.aspx.vb:line 137
====================================================The "Object moved to here." is the Report Server trying to redirect you to
the login page. That means the forms auth cookie isn't getting transmitted
properly. Make sure your report server web service proxy is set up
correctly, and that you are calling the web site with the same servername
(FQDN recommended) as you have set up in the report server config files for
the report server. If they are different server names, the cookie won't be
recognized as coming from the same place.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"shahab" <shahab@.discussions.microsoft.com> wrote in message
news:90B97D80-FADB-4727-B71E-A9BF0D110530@.microsoft.com...
>I am trying to use the render webmothod to render the report in PDF..I have
> forms based authentication in place. The follwoing code is mainly to get
> rid
> of open save dialog box when the report is running in a webbrowser.
> The follwing is the code:
> =====================================================> 'specify the credentials
> Dim s As RS.ReportingService = New RS.ReportingService
> s.Credentials = System.Net.CredentialCache.DefaultCredentials
> Try
> ' Render arguments
> Dim result As Byte() = Nothing
> ' Please adapt report name and path
> Dim reportPath As String = "/SKEL REPORTS/UserList"
> Dim format As String = "PDF"
> Dim historyID As String = Nothing
> Dim devInfo As String = ""
> Dim showHideToggle As String = Nothing
> Dim encoding As String
> Dim mimeType As String
> Dim warnings As RS.Warning() = Nothing
> Dim reportHistoryParameters As RS.ParameterValue() = Nothing
> Dim streamIDs As String() = Nothing
> Dim sh As RS.SessionHeader = New RS.SessionHeader
> s.SessionHeaderValue = sh
> 'call the render method of webservice
> result = s.Render(reportPath, format, historyID, devInfo, Nothing,
> Nothing, showHideToggle, encoding, mimeType, reportHistoryParameters,
> warnings, streamIDs)
> 'send the PDF report to IE using Response object
> Response.ClearContent()
> Response.ContentType = "application/pdf"
> Response.AddHeader("content-disposition", "inline;
> filename=report1.PDF")
> Response.BinaryWrite(result)
> Response.End()
>
> 'Response.Write ("done");
> Catch ex As Exception
> Response.Write(ex.ToString())
> End Try
> End Sub
> =====================================================> This is the error I get when I try to run a report:
> =====================================================> System.Net.WebException: The request failed with the error message: --
> Object moved to here.
> --. at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at RS.ReportingService.Render(String
> Report,
> String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> Warning[]& Warnings, String[]& StreamIds) in c:\inetpub\wwwroot\skel\Web
> References\RS\Reference.vb:line 549 at
> EQ.SKEL.Web.WebForms.ReportViewer.RenderReport() in
> c:\inetpub\wwwroot\skel\Reports\ReportViewer.aspx.vb:line 137
> ====================================================|||Thank you I got it working, the problem was I converted the code to VB.net
and authcookie got confused with the local variable, hence the cookie was
never being passed around.
"Jeff A. Stucker" wrote:
> The "Object moved to here." is the Report Server trying to redirect you to
> the login page. That means the forms auth cookie isn't getting transmitted
> properly. Make sure your report server web service proxy is set up
> correctly, and that you are calling the web site with the same servername
> (FQDN recommended) as you have set up in the report server config files for
> the report server. If they are different server names, the cookie won't be
> recognized as coming from the same place.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "shahab" <shahab@.discussions.microsoft.com> wrote in message
> news:90B97D80-FADB-4727-B71E-A9BF0D110530@.microsoft.com...
> >I am trying to use the render webmothod to render the report in PDF..I have
> > forms based authentication in place. The follwoing code is mainly to get
> > rid
> > of open save dialog box when the report is running in a webbrowser.
> > The follwing is the code:
> > =====================================================> > 'specify the credentials
> > Dim s As RS.ReportingService = New RS.ReportingService
> > s.Credentials = System.Net.CredentialCache.DefaultCredentials
> >
> > Try
> >
> > ' Render arguments
> > Dim result As Byte() = Nothing
> > ' Please adapt report name and path
> > Dim reportPath As String = "/SKEL REPORTS/UserList"
> > Dim format As String = "PDF"
> > Dim historyID As String = Nothing
> > Dim devInfo As String = ""
> >
> > Dim showHideToggle As String = Nothing
> > Dim encoding As String
> > Dim mimeType As String
> > Dim warnings As RS.Warning() = Nothing
> > Dim reportHistoryParameters As RS.ParameterValue() = Nothing
> > Dim streamIDs As String() = Nothing
> > Dim sh As RS.SessionHeader = New RS.SessionHeader
> > s.SessionHeaderValue = sh
> >
> > 'call the render method of webservice
> > result = s.Render(reportPath, format, historyID, devInfo, Nothing,
> > Nothing, showHideToggle, encoding, mimeType, reportHistoryParameters,
> > warnings, streamIDs)
> >
> > 'send the PDF report to IE using Response object
> > Response.ClearContent()
> > Response.ContentType = "application/pdf"
> > Response.AddHeader("content-disposition", "inline;
> > filename=report1.PDF")
> > Response.BinaryWrite(result)
> > Response.End()
> >
> >
> > 'Response.Write ("done");
> > Catch ex As Exception
> > Response.Write(ex.ToString())
> > End Try
> >
> > End Sub
> > =====================================================> > This is the error I get when I try to run a report:
> > =====================================================> > System.Net.WebException: The request failed with the error message: --
> > Object moved to here.
> > --. at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) at RS.ReportingService.Render(String
> > Report,
> > String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> > Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> > String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> > Warning[]& Warnings, String[]& StreamIds) in c:\inetpub\wwwroot\skel\Web
> > References\RS\Reference.vb:line 549 at
> > EQ.SKEL.Web.WebForms.ReportViewer.RenderReport() in
> > c:\inetpub\wwwroot\skel\Reports\ReportViewer.aspx.vb:line 137
> > ====================================================>
>