Could not open a connection to SQL Server

Hi,

Has somebody had a problem like this before?

Exception Details:System.Data.SqlClient.SqlException:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by thefact that under the default settings SQL Server does not allow remoteconnections. (provider: Named Pipes Provider, error: 40 - Could notopen a connection to SQL Server)

That's part of the code:

SqlConnection con;
string sql;
SqlCommand cmd;

con=new SqlConnection("Data Source=elf/SQLEXPRESS;Initial Catalog=logos;Integrated Security=SSPI;");
sql="SELECT max(id_kandydat) from Kandydat";
con.Open();
cmd=new SqlCommand(sql,con);
int id = Convert.ToInt32(cmd.ExecuteScalar());

con.Close();

SqlDataSource7.InsertCommand="INSERT INTO Kandydat_na_Kierunek(id_kandydat, id_kierunku, id_stan) VALUES ("+"'"+id+"'"+","+"'"+DropDownList1.SelectedValue+"'"+","+'1'+");";

I don't really get it. I'm nearly 100% sure that before some changes in my project this had worked perfectly. Does anybody have any idea how to make it work again? I would be very grateful for any help. And, yesy, I know it is quite common error, but proposed solution found didn't help.

Regards,

N.

Hi there,

In the SQL Management Studio, RightClick the SQL server instance, Choose
Properties, and under Select a Page list, click Connections. Now you should
see a checkbox labelled "Allow Remote Connections to This Server". Make sure
it is checked.

Check this link...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Hope this may helps you

Srinath

|||Hi,Thank you for your advice. The remote connection has already been set on.|||

Hi

From your description, it seems that you met error when you are trying to connect to your SQLServer,right?

First, you should make sure that if 1433 port has been enabled on your server, which is the default port for SQLServer remote connections.

And Generally, you can try the following ways to handle your problem.

1. Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition
2. Enable the SQL Server Browser service
3. Create exceptions in Windows Firewall
4. Create an exception for SQL Server 2005 in Windows Firewall
5. Create an exception for the SQL Server Browser service in Windows Firewall

More details for each step, you may see the following link:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Thanks.

|||

Thank you. Remote connection for both servers are enabled (always have been). Windows Firewall is shut; no other firewall is running. It does in fact work locally.

Regards,

N.

|||

Hi,

Then, let's back to your connection string.

con=new SqlConnection("Data Source=elf/SQLEXPRESS;Initial Catalog=logos;Integrated Security=SSPI;");

It seems that you are connecting to a SQLExpress instance, Generally, if you are using SQLExpress, you should assign the AttachDBFilename, but not the InitialCatalog.

See the following sample string:

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|YouDataBaseName.mdf;User Instance=true providerName="System.Data.SqlClient"

Thanks.

Could not establish trust relationship with remote server - Part.2

Hi,
Iâ'm posting now for the second time with this issueâ?¦hopefully can somebody
helpâ?¦
We have to new installed Server with the same configuration (except hardware):
- Windows 2003 Enterprise (fully updated)
- SQL Server 2000 Enterprise SP3a
- Reporting Services SP1
- Patch SQL2000-KB810185-8.00.0859 (asked by the installation cause using a
domain account for the Report Service and for the SQL Server connections.
- SSL (checked during installation)
The https://myserver.com/reportserver works fine. If I browse to
https://myserver.com/reports (Report manager) Iâ'm getting the message â'The
underlying connection was closed: Could not establish trust relationship with
remote serverâ'. Itâ's killing me. Iâ'm fighting since a long time with this
problemâ?¦.Iâ've everywhere within the config files the corresponding
https://myservber.com entries. SecureConnectionLevel set to 3 (tried with 2
also). Iâ'm able to browse to any https site on the server using the same
certificate without any messages or warnings. And Iâ've this problem on both
serversâ?¦.:-((
Following you will see theReportServerWebApp_xxxxxxx Log file. Why do I have
the entry â'Initializing SecureConnectionLevel to default value of '1' â' ?
Iâ've configured this Value to 3 within RSReportServer.config. Do I need to
change an other file as well? Or any other ideas ?
Many thanks for your help !!
Dominic
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>W. Europe Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerWebApp__11_10_2004_08_05_23.log</Path>
<SystemName>CLAPTON</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing MaxScheduleWait
to default value of '1' second(s) because it was not specified in
Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing InstanceName to
default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: The underlying connection was
closed: Could not establish trust relationship with remote server.
w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The underlying connection was closed: Could not
establish trust relationship with remote server. at
System.Net.HttpWebRequest.CheckFinalStatus() at
System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult) at
System.Net.HttpWebRequest.GetRequestStream() at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level) at
Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
System.Web.UI.Control.InitRecursive(Control namingContainer) at
System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!ea0!11/10/2004-08:05:46:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)Did you come up with an answer? if so, please post it... I am having the same
problem.
"Dominic" wrote:
> Hi,
> Iâ'm posting now for the second time with this issueâ?¦hopefully can somebody
> helpâ?¦
> We have to new installed Server with the same configuration (except hardware):
> - Windows 2003 Enterprise (fully updated)
> - SQL Server 2000 Enterprise SP3a
> - Reporting Services SP1
> - Patch SQL2000-KB810185-8.00.0859 (asked by the installation cause using a
> domain account for the Report Service and for the SQL Server connections.
> - SSL (checked during installation)
> The https://myserver.com/reportserver works fine. If I browse to
> https://myserver.com/reports (Report manager) Iâ'm getting the message â'The
> underlying connection was closed: Could not establish trust relationship with
> remote serverâ'. Itâ's killing me. Iâ'm fighting since a long time with this
> problemâ?¦.Iâ've everywhere within the config files the corresponding
> https://myservber.com entries. SecureConnectionLevel set to 3 (tried with 2
> also). Iâ'm able to browse to any https site on the server using the same
> certificate without any messages or warnings. And Iâ've this problem on both
> serversâ?¦.:-((
> Following you will see theReportServerWebApp_xxxxxxx Log file. Why do I have
> the entry â'Initializing SecureConnectionLevel to default value of '1' â' ?
> Iâ've configured this Value to 3 within RSReportServer.config. Do I need to
> change an other file as well? Or any other ideas ?
> Many thanks for your help !!
> Dominic
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>W. Europe Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerWebApp__11_10_2004_08_05_23.log</Path>
> <SystemName>CLAPTON</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing MaxScheduleWait
> to default value of '1' second(s) because it was not specified in
> Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> DatabaseQueryTimeout to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing InstanceName to
> default value of 'MSSQLSERVER.1' because it was not specified in
> Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> ProcessRecycleOptions to default value of '0' because it was not specified
> in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> RunningRequestsScavengerCycle to default value of '30' second(s) because it
> was not specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> RunningRequestsDbCycle to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> RunningRequestsAge to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> CleanupCycleMinutes to default value of '10' minute(s) because it was not
> specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> SecureConnectionLevel to default value of '1' because it was not specified
> in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing DisplayErrorLink
> to 'True' as specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it was not
> specified in Configuration file.
> w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: The underlying connection was
> closed: Could not establish trust relationship with remote server.
> w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The underlying connection was closed: Could not
> establish trust relationship with remote server. at
> System.Net.HttpWebRequest.CheckFinalStatus() at
> System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult) at
> System.Net.HttpWebRequest.GetRequestStream() at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at
> Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level) at
> Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
> EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
> System.Web.UI.Control.InitRecursive(Control namingContainer) at
> System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!ea0!11/10/2004-08:05:46:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)|||Hi Ron
No, I gave up. I'm running it now in mixed mode.....the users are running
the reports using SSL and the management part is actually running without
SSLâ?¦.itâ's bad but we had to go productionâ?¦anyway - the configuration-part is
not very well with RS (the logging is not always a real help)â?¦.RS is nice but
Microsoft has still a lot to do !
Regards,
Dominic
"Ron Sellers" wrote:
> Did you come up with an answer? if so, please post it... I am having the same
> problem.
> "Dominic" wrote:
> > Hi,
> >
> > Iâ'm posting now for the second time with this issueâ?¦hopefully can somebody
> > helpâ?¦
> >
> > We have to new installed Server with the same configuration (except hardware):
> > - Windows 2003 Enterprise (fully updated)
> > - SQL Server 2000 Enterprise SP3a
> > - Reporting Services SP1
> > - Patch SQL2000-KB810185-8.00.0859 (asked by the installation cause using a
> > domain account for the Report Service and for the SQL Server connections.
> > - SSL (checked during installation)
> >
> > The https://myserver.com/reportserver works fine. If I browse to
> > https://myserver.com/reports (Report manager) Iâ'm getting the message â'The
> > underlying connection was closed: Could not establish trust relationship with
> > remote serverâ'. Itâ's killing me. Iâ'm fighting since a long time with this
> > problemâ?¦.Iâ've everywhere within the config files the corresponding
> > https://myservber.com entries. SecureConnectionLevel set to 3 (tried with 2
> > also). Iâ'm able to browse to any https site on the server using the same
> > certificate without any messages or warnings. And Iâ've this problem on both
> > serversâ?¦.:-((
> >
> > Following you will see theReportServerWebApp_xxxxxxx Log file. Why do I have
> > the entry â'Initializing SecureConnectionLevel to default value of '1' â' ?
> > Iâ've configured this Value to 3 within RSReportServer.config. Do I need to
> > change an other file as well? Or any other ideas ?
> >
> > Many thanks for your help !!
> > Dominic
> >
> > <Header>
> > <Product>Microsoft SQL Server Reporting Services Version
> > 8.00.878.00</Product>
> > <Locale>en-US</Locale>
> > <TimeZone>W. Europe Standard Time</TimeZone>
> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\LogFiles\ReportServerWebApp__11_10_2004_08_05_23.log</Path>
> > <SystemName>CLAPTON</SystemName>
> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > <OSVersion>5.2.3790.0</OSVersion>
> > </Header>
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing MaxScheduleWait
> > to default value of '1' second(s) because it was not specified in
> > Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > DatabaseQueryTimeout to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing InstanceName to
> > default value of 'MSSQLSERVER.1' because it was not specified in
> > Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > ProcessRecycleOptions to default value of '0' because it was not specified
> > in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > RunningRequestsScavengerCycle to default value of '30' second(s) because it
> > was not specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > RunningRequestsDbCycle to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > RunningRequestsAge to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > CleanupCycleMinutes to default value of '10' minute(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > SecureConnectionLevel to default value of '1' because it was not specified
> > in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing DisplayErrorLink
> > to 'True' as specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > WebServiceUseFileShareStorage to default value of 'False' because it was not
> > specified in Configuration file.
> > w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: The underlying connection was
> > closed: Could not establish trust relationship with remote server.
> > w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: HTTP status code --> 500
> > --Details--
> > System.Net.WebException: The underlying connection was closed: Could not
> > establish trust relationship with remote server. at
> > System.Net.HttpWebRequest.CheckFinalStatus() at
> > System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult) at
> > System.Net.HttpWebRequest.GetRequestStream() at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) at
> > Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> > at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> > at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> > at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> > methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at
> > Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> > level) at
> > Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> > sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
> > EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
> > System.Web.UI.Control.InitRecursive(Control namingContainer) at
> > System.Web.UI.Page.ProcessRequestMain()
> > w3wp!ui!ea0!11/10/2004-08:05:46:: e ERROR: Exception in ShowErrorPage:
> > System.Threading.ThreadAbortException: Thread was being aborted.
> > at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg) at at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg)|||I was having the same problems until a few minutes ago. I went back through
the following article and found the problem (in my situation at least):
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sslsetup.asp
Down at the section:
Installing Reporting Services -> Reporting Services Configuration Files ->
RSWebApplication.config
I hadn't changed the <ReportServerUrl> value to the https://reports.xxx.xxx
(must by an exact match to the value in the SSL certificate) or added the
<Add Key="SecureConnectionLevel" Value="3"/> element. Actually, I hadn't even
looked in this file because my eyes fooling me into thinking it was the
RSReportServer.config file. oops!
Anyway making the RSWebApplication.config look like this worked when all
other paths had failed.
++++++++++++++++++++++++++++++
<Configuration>
<UI>
<ReportServerUrl>https://reports.xxx.xxx/ReportServer</ReportServerUrl>
</UI>
<Extensions>
<DeliveryUI>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider">
<Configuration>
<FileShare>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</FileShare>
</Configuration>
</Extension>
</DeliveryUI>
</Extensions>
<Add Key="SecureConnectionLevel" Value="3"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
++++++++++++++++++++++++++++++
Hope this is what you were looking for.
Mike Shaw
"Ron Sellers" wrote:
> Did you come up with an answer? if so, please post it... I am having the same
> problem.
> "Dominic" wrote:
> > Hi,
> >
> > Iâ'm posting now for the second time with this issueâ?¦hopefully can somebody
> > helpâ?¦
> >
> > We have to new installed Server with the same configuration (except hardware):
> > - Windows 2003 Enterprise (fully updated)
> > - SQL Server 2000 Enterprise SP3a
> > - Reporting Services SP1
> > - Patch SQL2000-KB810185-8.00.0859 (asked by the installation cause using a
> > domain account for the Report Service and for the SQL Server connections.
> > - SSL (checked during installation)
> >
> > The https://myserver.com/reportserver works fine. If I browse to
> > https://myserver.com/reports (Report manager) Iâ'm getting the message â'The
> > underlying connection was closed: Could not establish trust relationship with
> > remote serverâ'. Itâ's killing me. Iâ'm fighting since a long time with this
> > problemâ?¦.Iâ've everywhere within the config files the corresponding
> > https://myservber.com entries. SecureConnectionLevel set to 3 (tried with 2
> > also). Iâ'm able to browse to any https site on the server using the same
> > certificate without any messages or warnings. And Iâ've this problem on both
> > serversâ?¦.:-((
> >
> > Following you will see theReportServerWebApp_xxxxxxx Log file. Why do I have
> > the entry â'Initializing SecureConnectionLevel to default value of '1' â' ?
> > Iâ've configured this Value to 3 within RSReportServer.config. Do I need to
> > change an other file as well? Or any other ideas ?
> >
> > Many thanks for your help !!
> > Dominic
> >
> > <Header>
> > <Product>Microsoft SQL Server Reporting Services Version
> > 8.00.878.00</Product>
> > <Locale>en-US</Locale>
> > <TimeZone>W. Europe Standard Time</TimeZone>
> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\LogFiles\ReportServerWebApp__11_10_2004_08_05_23.log</Path>
> > <SystemName>CLAPTON</SystemName>
> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > <OSVersion>5.2.3790.0</OSVersion>
> > </Header>
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing MaxScheduleWait
> > to default value of '1' second(s) because it was not specified in
> > Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > DatabaseQueryTimeout to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing InstanceName to
> > default value of 'MSSQLSERVER.1' because it was not specified in
> > Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > ProcessRecycleOptions to default value of '0' because it was not specified
> > in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > RunningRequestsScavengerCycle to default value of '30' second(s) because it
> > was not specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > RunningRequestsDbCycle to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > RunningRequestsAge to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > CleanupCycleMinutes to default value of '10' minute(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > SecureConnectionLevel to default value of '1' because it was not specified
> > in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing DisplayErrorLink
> > to 'True' as specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > WebServiceUseFileShareStorage to default value of 'False' because it was not
> > specified in Configuration file.
> > w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: The underlying connection was
> > closed: Could not establish trust relationship with remote server.
> > w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: HTTP status code --> 500
> > --Details--
> > System.Net.WebException: The underlying connection was closed: Could not
> > establish trust relationship with remote server. at
> > System.Net.HttpWebRequest.CheckFinalStatus() at
> > System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult) at
> > System.Net.HttpWebRequest.GetRequestStream() at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) at
> > Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> > at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> > at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> > at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> > methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at
> > Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> > level) at
> > Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> > sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
> > EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
> > System.Web.UI.Control.InitRecursive(Control namingContainer) at
> > System.Web.UI.Page.ProcessRequestMain()
> > w3wp!ui!ea0!11/10/2004-08:05:46:: e ERROR: Exception in ShowErrorPage:
> > System.Threading.ThreadAbortException: Thread was being aborted.
> > at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg) at at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg)|||That did it! Thanks Mike!

Corrupted TDS packets

I have the same problem as this posting, but It has never
been answered. Could somebody help?
Here is the old posting:
I have repeatedly error message in the application log:
17805, severity:20, Stqte:3 invalid buffer received from
client"
The KB 295113 - fix offer to load the latest SQL SP, but I
already have SQL SP3. Do I need SP 3A?
What else I need to do to clean the errors,
Thanks a lot.
.do you know if the error occurs for all client computers
or for a particular one? try reinstalling sql client. try
to find out if the problem is with the server or client.
if you think there is something wrong with the sql server
then try uninstalling the sql server and then reinstall
sql server and sp3a. if you still get errors then call MS
support.
>--Original Message--
>I have the same problem as this posting, but It has never
>been answered. Could somebody help?
>Here is the old posting:
>I have repeatedly error message in the application log:
>17805, severity:20, Stqte:3 invalid buffer received from
>client"
>The KB 295113 - fix offer to load the latest SQL SP, but
I
>already have SQL SP3. Do I need SP 3A?
>What else I need to do to clean the errors,
>Thanks a lot.
>..
>
>.
>