rsInvalidDataSourceReference

I am getting the following error:

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

All i did is created the datasource in the same location where my report files .rdl files are. instead of datasource folder on the report server.

everything works fine from my project vs2005, but if i run the report via localhost/reports, it gives the above error:

please help, i created this method since i have 5 different sites on the same server, all of the sites has reports with same datasource name many of them are common for that reason.

Thank you very much for the informartion.

Try this:

Open up Report Manager, and drill down to open your report. Click on the Properties tab, then select 'Data Sources' from the left pane. Click the Browse button next to 'Select a shared data source'. From here, navigate to the folder where your report is, and select the data source that is in there (since this is where you deployed to). Click OK, then Apply your changes.

Hope this helps.

Jarret

|||Wow.. Jarret Thank you very much. you gave me two tips since yesterday. thks....|||

Hi,

I am using a rss script to deploy reports and data sources. All my datasources lie in the shared location "Data Sources". With the script the data source and reports are deployed but the it gives the same error as posted by cplusplus1.

Here is the rss script to deploy report and data source that I used. Please help.

'To deploy Data Source

Public Sub CreateDataSource(ByVal name As String, ByVal extension As String, ByVal connectionString As String)
'Define the data source definition.
Dim definition As New DataSourceDefinition()
definition.Extension = extension
definition.ConnectString = connectionString
definition.Enabled = True
definition.EnabledSpecified = True
definition.CredentialRetrieval = CredentialRetrievalEnum.Integrated
definition.WindowsCredentials = True
definition.Prompt = Nothing
definition.ImpersonateUserSpecified = True
Try
rs.CreateDataSource(name, dataSourcePath, overWriteExistingDataSource, definition, Nothing)
Console.WriteLine("Data source {0} created successfully", name)

Catch e As Exception
Console.WriteLine(e.Message)
End Try

End Sub

' TO DEPLOY Report

Public Sub PublishReport(ByVal reportName As String)
Try
Dim stream As FileStream = File.OpenRead(filePath + reportName + ".rdl")
definition = New [Byte](stream.Length) {}
stream.Read(definition, 0, CInt(stream.Length))
stream.Close()

Catch e As IOException
Console.WriteLine(e.Message)
End Try

Try
warnings = rs.CreateReport(reportName, parentPath, False, definition, Nothing)

Dim dataSources() As DataSource = rs.GetItemDataSources(parentPath + "/" + reportName)

Dim ds As DataSource
For Each ds In dataSources
If (ds.Item.GetType() Is Type.GetType("InvalidDataSourceReference")) Then
Dim NewDS As DataSource = New DataSource()
Dim dsRef As DataSourceReference = New DataSourceReference()

dsRef.Reference = dataSourcePath + "/" + dataSourceName
NewDS.Item = dsRef
NewDS.Name = ds.Name
Dim NewDataSources() As DataSource = New DataSource() {NewDS}

rs.SetItemDataSources(parentPath + "/" + reportName, NewDataSources)
End If
Next

If Not (warnings Is Nothing) Then
Dim warning As Warning
For Each warning In warnings
Console.WriteLine(warning.Message)
Next warning
Else
Console.WriteLine("Report: {0} published successfully with no warnings", reportName)
End If
Catch e As Exception
Console.WriteLine(e.Message)
End Try
End Sub

rsInvalidDataSourceReference

I am getting the following error:

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

All i did is created the datasource in the same location where my report files .rdl files are. instead of datasource folder on the report server.

everything works fine from my project vs2005, but if i run the report via localhost/reports, it gives the above error:

please help, i created this method since i have 5 different sites on the same server, all of the sites has reports with same datasource name many of them are common for that reason.

Thank you very much for the informartion.

Try this:

Open up Report Manager, and drill down to open your report. Click on the Properties tab, then select 'Data Sources' from the left pane. Click the Browse button next to 'Select a shared data source'. From here, navigate to the folder where your report is, and select the data source that is in there (since this is where you deployed to). Click OK, then Apply your changes.

Hope this helps.

Jarret

|||Wow.. Jarret Thank you very much. you gave me two tips since yesterday. thks....|||

Hi,

I am using a rss script to deploy reports and data sources. All my datasources lie in the shared location "Data Sources". With the script the data source and reports are deployed but the it gives the same error as posted by cplusplus1.

Here is the rss script to deploy report and data source that I used. Please help.

'To deploy Data Source

Public Sub CreateDataSource(ByVal name As String, ByVal extension As String, ByVal connectionString As String)
'Define the data source definition.
Dim definition As New DataSourceDefinition()
definition.Extension = extension
definition.ConnectString = connectionString
definition.Enabled = True
definition.EnabledSpecified = True
definition.CredentialRetrieval = CredentialRetrievalEnum.Integrated
definition.WindowsCredentials = True
definition.Prompt = Nothing
definition.ImpersonateUserSpecified = True
Try
rs.CreateDataSource(name, dataSourcePath, overWriteExistingDataSource, definition, Nothing)
Console.WriteLine("Data source {0} created successfully", name)

Catch e As Exception
Console.WriteLine(e.Message)
End Try

End Sub

' TO DEPLOY Report

Public Sub PublishReport(ByVal reportName As String)
Try
Dim stream As FileStream = File.OpenRead(filePath + reportName + ".rdl")
definition = New [Byte](stream.Length) {}
stream.Read(definition, 0, CInt(stream.Length))
stream.Close()

Catch e As IOException
Console.WriteLine(e.Message)
End Try

Try
warnings = rs.CreateReport(reportName, parentPath, False, definition, Nothing)

Dim dataSources() As DataSource = rs.GetItemDataSources(parentPath + "/" + reportName)

Dim ds As DataSource
For Each ds In dataSources
If (ds.Item.GetType() Is Type.GetType("InvalidDataSourceReference")) Then
Dim NewDS As DataSource = New DataSource()
Dim dsRef As DataSourceReference = New DataSourceReference()

dsRef.Reference = dataSourcePath + "/" + dataSourceName
NewDS.Item = dsRef
NewDS.Name = ds.Name
Dim NewDataSources() As DataSource = New DataSource() {NewDS}

rs.SetItemDataSources(parentPath + "/" + reportName, NewDataSources)
End If
Next

If Not (warnings Is Nothing) Then
Dim warning As Warning
For Each warning In warnings
Console.WriteLine(warning.Message)
Next warning
Else
Console.WriteLine("Report: {0} published successfully with no warnings", reportName)
End If
Catch e As Exception
Console.WriteLine(e.Message)
End Try
End Sub

sql

RS2005+ADAM+User!Userid

Hi,
I'm trying to obtain the value of some attributes of the current user,
this is made using an OLEDB connection to an ADAM server. Then I use a
query like this:
Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
ESP,DC=ibsesp,DC=loc' where userPrincipalName='jordi.ramis@.domain.loc'
and objectclass='user'
There is not problem with this, RS succesfully gets the corrent
information wich can be saved in a report parameter to filter my main
query.
The problem is that 'jordi.ramis@.domain.loc' must be obiously be
replaced with the current user, I've tried to simply use a report
parameter that is assigned to User!Userid, that's the error:
"The data extension OLE DB does not support named parameters, use
unnammed parameters instead"
I've tried to use something like an ? for a variable but I'm unable to
getting it to work. Can someone explain how to use report variables on
OLEDB to query an ADAM directory? Is the dynamic sql the solution? How
can I do this?
Thanks to all!It was my understanding that User!UserID returns the format: DOMAIN\User
when you want the user@.domain format - I don't see how this would even
work - have you tried to see if it returns you a record if you change your
select to this:
Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
ESP,DC=ibsesp,DC=loc' where userPrincipalName='domain.loc\jordi.ramis'
and objectclass='user'
'
=-Chris
<jordi_ramis@.hotmail.com> wrote in message
news:1164128212.934067.138640@.h54g2000cwb.googlegroups.com...
> Hi,
> I'm trying to obtain the value of some attributes of the current user,
> this is made using an OLEDB connection to an ADAM server. Then I use a
> query like this:
> Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
> ESP,DC=ibsesp,DC=loc' where userPrincipalName='jordi.ramis@.domain.loc'
> and objectclass='user'
> There is not problem with this, RS succesfully gets the corrent
> information wich can be saved in a report parameter to filter my main
> query.
> The problem is that 'jordi.ramis@.domain.loc' must be obiously be
> replaced with the current user, I've tried to simply use a report
> parameter that is assigned to User!Userid, that's the error:
> "The data extension OLE DB does not support named parameters, use
> unnammed parameters instead"
> I've tried to use something like an ? for a variable but I'm unable to
> getting it to work. Can someone explain how to use report variables on
> OLEDB to query an ADAM directory? Is the dynamic sql the solution? How
> can I do this?
> Thanks to all!
>|||This is about the silly Pre-Windows 2000 name, a.k.a. sAMAccountName in
Active Directory.
User!UserID gives you domain\username
Your query wants to have the userPrincipalName, which looks like
username@.domain
sAMAccountName looks like domain\username
You could try to change your where clause to look for the sAMAccountName,
which looks like domainUsername. Try something like this
Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
ESP,DC=ibsesp,DC=loc'
where sAMAccountName='domain\jorramis'
and objectclass='user'
Scropp down to the tech section at this page to see a list of AD attributes:
http://www.minasi.com/newsletters/nws0503.htm
Kaisa M. Lindahl Lervik
"Chris Conner" <Chris.Conner@.NOSPAMPolarisLibrary.com> wrote in message
news:%23%23IKvdaDHHA.1196@.TK2MSFTNGP02.phx.gbl...
> It was my understanding that User!UserID returns the format: DOMAIN\User
> when you want the user@.domain format - I don't see how this would even
> work - have you tried to see if it returns you a record if you change your
> select to this:
> Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
> ESP,DC=ibsesp,DC=loc' where userPrincipalName='domain.loc\jordi.ramis'
> and objectclass='user'
> '
> =-Chris
> <jordi_ramis@.hotmail.com> wrote in message
> news:1164128212.934067.138640@.h54g2000cwb.googlegroups.com...
>> Hi,
>> I'm trying to obtain the value of some attributes of the current user,
>> this is made using an OLEDB connection to an ADAM server. Then I use a
>> query like this:
>> Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
>> ESP,DC=ibsesp,DC=loc' where userPrincipalName='jordi.ramis@.domain.loc'
>> and objectclass='user'
>> There is not problem with this, RS succesfully gets the corrent
>> information wich can be saved in a report parameter to filter my main
>> query.
>> The problem is that 'jordi.ramis@.domain.loc' must be obiously be
>> replaced with the current user, I've tried to simply use a report
>> parameter that is assigned to User!Userid, that's the error:
>> "The data extension OLE DB does not support named parameters, use
>> unnammed parameters instead"
>> I've tried to use something like an ? for a variable but I'm unable to
>> getting it to work. Can someone explain how to use report variables on
>> OLEDB to query an ADAM directory? Is the dynamic sql the solution? How
>> can I do this?
>> Thanks to all!
>|||Hi,
Thanks for all the replies, they will be sure useful but the real
problem is that I'm unable to put any parameter to the report. I can't
make:
Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
ESP,DC=ibsesp,DC=loc'
where sAMAccountName=@.my_parameter
and objectclass='user'
due to restrictions in OLEDB extension. Has anyone been able to
acomplish this?. Thanks a lot.
Kaisa M. Lindahl Lervik ha escrito:
> This is about the silly Pre-Windows 2000 name, a.k.a. sAMAccountName in
> Active Directory.
> User!UserID gives you domain\username
> Your query wants to have the userPrincipalName, which looks like
> username@.domain
> sAMAccountName looks like domain\username
> You could try to change your where clause to look for the sAMAccountName,
> which looks like domainUsername. Try something like this
> Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
> ESP,DC=ibsesp,DC=loc'
> where sAMAccountName='domain\jorramis'
> and objectclass='user'
>
> Scropp down to the tech section at this page to see a list of AD attributes:
> http://www.minasi.com/newsletters/nws0503.htm
>
> Kaisa M. Lindahl Lervik
> "Chris Conner" <Chris.Conner@.NOSPAMPolarisLibrary.com> wrote in message
> news:%23%23IKvdaDHHA.1196@.TK2MSFTNGP02.phx.gbl...
> > It was my understanding that User!UserID returns the format: DOMAIN\User
> > when you want the user@.domain format - I don't see how this would even
> > work - have you tried to see if it returns you a record if you change your
> > select to this:
> >
> > Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
> > ESP,DC=ibsesp,DC=loc' where userPrincipalName='domain.loc\jordi.ramis'
> > and objectclass='user'
> >
> > '
> >
> > =-Chris
> >
> > <jordi_ramis@.hotmail.com> wrote in message
> > news:1164128212.934067.138640@.h54g2000cwb.googlegroups.com...
> >>
> >> Hi,
> >>
> >> I'm trying to obtain the value of some attributes of the current user,
> >> this is made using an OLEDB connection to an ADAM server. Then I use a
> >> query like this:
> >>
> >> Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
> >> ESP,DC=ibsesp,DC=loc' where userPrincipalName='jordi.ramis@.domain.loc'
> >> and objectclass='user'
> >>
> >> There is not problem with this, RS succesfully gets the corrent
> >> information wich can be saved in a report parameter to filter my main
> >> query.
> >>
> >> The problem is that 'jordi.ramis@.domain.loc' must be obiously be
> >> replaced with the current user, I've tried to simply use a report
> >> parameter that is assigned to User!Userid, that's the error:
> >>
> >> "The data extension OLE DB does not support named parameters, use
> >> unnammed parameters instead"
> >>
> >> I've tried to use something like an ? for a variable but I'm unable to
> >> getting it to work. Can someone explain how to use report variables on
> >> OLEDB to query an ADAM directory? Is the dynamic sql the solution? How
> >> can I do this?
> >>
> >> Thanks to all!
> >>
> >
> >|||Hi,
I finally found the solution so I'm answering myself.
You have to write the query dinamically:
="Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER
from 'LDAP://myserver/OU=Users ESP,DC=ibsesp,DC=loc'
where sAMAccountName='"+User!UserId+"' and objectclass='user'"
I never though that I could write the query dynamically in RS2005,
that's fantastic and solves many of my problems.
Thanks to all.
jordi_ramis@.hotmail.com ha escrito:
> Hi,
> Thanks for all the replies, they will be sure useful but the real
> problem is that I'm unable to put any parameter to the report. I can't
> make:
>
> Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
> ESP,DC=ibsesp,DC=loc'
> where sAMAccountName=@.my_parameter
> and objectclass='user'
> due to restrictions in OLEDB extension. Has anyone been able to
> acomplish this?. Thanks a lot.
> Kaisa M. Lindahl Lervik ha escrito:
> > This is about the silly Pre-Windows 2000 name, a.k.a. sAMAccountName in
> > Active Directory.
> >
> > User!UserID gives you domain\username
> > Your query wants to have the userPrincipalName, which looks like
> > username@.domain
> > sAMAccountName looks like domain\username
> >
> > You could try to change your where clause to look for the sAMAccountName,
> > which looks like domainUsername. Try something like this
> > Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
> > ESP,DC=ibsesp,DC=loc'
> >
> > where sAMAccountName='domain\jorramis'
> > and objectclass='user'
> >
> >
> > Scropp down to the tech section at this page to see a list of AD attributes:
> > http://www.minasi.com/newsletters/nws0503.htm
> >
> >
> > Kaisa M. Lindahl Lervik
> >
> > "Chris Conner" <Chris.Conner@.NOSPAMPolarisLibrary.com> wrote in message
> > news:%23%23IKvdaDHHA.1196@.TK2MSFTNGP02.phx.gbl...
> > > It was my understanding that User!UserID returns the format: DOMAIN\User
> > > when you want the user@.domain format - I don't see how this would even
> > > work - have you tried to see if it returns you a record if you change your
> > > select to this:
> > >
> > > Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
> > > ESP,DC=ibsesp,DC=loc' where userPrincipalName='domain.loc\jordi.ramis'
> > > and objectclass='user'
> > >
> > > '
> > >
> > > =-Chris
> > >
> > > <jordi_ramis@.hotmail.com> wrote in message
> > > news:1164128212.934067.138640@.h54g2000cwb.googlegroups.com...
> > >>
> > >> Hi,
> > >>
> > >> I'm trying to obtain the value of some attributes of the current user,
> > >> this is made using an OLEDB connection to an ADAM server. Then I use a
> > >> query like this:
> > >>
> > >> Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users
> > >> ESP,DC=ibsesp,DC=loc' where userPrincipalName='jordi.ramis@.domain.loc'
> > >> and objectclass='user'
> > >>
> > >> There is not problem with this, RS succesfully gets the corrent
> > >> information wich can be saved in a report parameter to filter my main
> > >> query.
> > >>
> > >> The problem is that 'jordi.ramis@.domain.loc' must be obiously be
> > >> replaced with the current user, I've tried to simply use a report
> > >> parameter that is assigned to User!Userid, that's the error:
> > >>
> > >> "The data extension OLE DB does not support named parameters, use
> > >> unnammed parameters instead"
> > >>
> > >> I've tried to use something like an ? for a variable but I'm unable to
> > >> getting it to work. Can someone explain how to use report variables on
> > >> OLEDB to query an ADAM directory? Is the dynamic sql the solution? How
> > >> can I do this?
> > >>
> > >> Thanks to all!
> > >>
> > >
> > >

RS2005 viewer control connection problem.

I am using the reporting services reportviewer control from Visual Studio®
2005 Beta 2.
When I run a repmote report I get the following error:
[WebException: The request was aborted: The connection was closed
unexpectedly.]
I can access the report from my browser doing a straight url access.
I am using RS2005 (did not install anything other than that from SQLServer
2005 cd) on Windows 2003 server, and a SQLserver 2000 back end on a different
machine for RS engine.
The report data source is on the same SQL server machine as the RS database.
can anyone explain what is happening.
Thanks Fred
--
FredI'm having the same problem here.
VS 2005 Beta 2, SQL 2005 April CTP.
Have you found what was causing the problem?
Anderson
Fred escreveu:
> I am using the reporting services reportviewer control from Visual Studio==AE
> 2005 Beta 2.
> When I run a repmote report I get the following error:
> [WebException: The request was aborted: The connection was closed
> unexpectedly.]
> I can access the report from my browser doing a straight url access.
> I am using RS2005 (did not install anything other than that from SQLServer
> 2005 cd) on Windows 2003 server, and a SQLserver 2000 back end on a diffe=rent
> machine for RS engine.
> The report data source is on the same SQL server machine as the RS databa=se.
> can anyone explain what is happening.
> > Thanks Fred
> > > > > > > -- > Fred|||No,
due to other we may actually not user RS2005 anyway, so not such a burnig
issue for the moment.
I still would like to know what's going on though.
I'm using SQLServer 2000 as the RS backend, the datasource is on the same
machine as SQL2000. RS sits on its own machine.
--
Fred
"Anderson dos Santos Pimentel" wrote:
> I'm having the same problem here.
> VS 2005 Beta 2, SQL 2005 April CTP.
> Have you found what was causing the problem?
>
> Anderson
>
> Fred escreveu:
> > I am using the reporting services reportviewer control from Visual Studio®
> > 2005 Beta 2.
> >
> > When I run a repmote report I get the following error:
> >
> > [WebException: The request was aborted: The connection was closed
> > unexpectedly.]
> >
> > I can access the report from my browser doing a straight url access.
> >
> > I am using RS2005 (did not install anything other than that from SQLServer
> > 2005 cd) on Windows 2003 server, and a SQLserver 2000 back end on a different
> > machine for RS engine.
> >
> > The report data source is on the same SQL server machine as the RS database.
> >
> > can anyone explain what is happening.
> >
> > Thanks Fred
> >
> >
> >
> >
> >
> >
> > --
> > Fred
>|||I've finally found the problem.
I was dumb enough to mistype the server's name... :-)
Now, it's OK!
Andersonsql

RS: Cannot create a connection to data source

Hi!

I've created a project includen 3 reports based on following code on 3 server. The report includes 3 different datasources an 3 different report. All 3 reports are grouped on Database and summerizad zise.

SELECT

SD.name [Database],

SMF.name [File],

SMF.size [Size]

FROM

sys.master_files SMF INNER JOIN sys.databases SD

ON SD.database_id = SMF.database_id

I can run all reports in Visual Studio (preview). But I can only run one the reports after depolying the project! I get this message when I raun the other 2 reports:

An error has occurred during report processing.

Cannot create a connection to data source 'uasql02_datasource'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors

I tried running the report from an server (where reportingservices is installed) finding that all the reports works as they should. I logged in another server with the same credentials. I got same message on the server as I get on my own camputer, "Cannot create a connection to data source ..."

Is there anybody out there having same problem as I, or someone who has any suggestion?

Thanks for any suggestion!

/*

Fari Sah

*/

Hello, Fari-- I am also getting the "Cannot create a connection to data source..." message, but the rest says "Login failed for user..."

Everything works fine on my production server, but I'm having trouble getting the same reports to work on my development PC and my test server. I'm going to keep hunting, so please post any new information!

RS: An unexpected error

I receive the message when I usehttp://mytest/reports (ReportManager):

The underlying connection was closed: An unexpected error occurred on a
receive.

Contents of log:

<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__06_16_2005_09_35_28.log</Path>
<SystemName>mytest</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!1e70!6/16/2005-09:35:28:: i INFO: Reporting Web Server started
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing ConnectionType
to '0' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing IsEventService
to 'True' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing PollingInterval
to '10' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing MaxQueueThreads
to '0' thread(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing MaxScheduleWait
to '5' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!resourceutilities!1e70!6/16/2005-09:35:28:: i INFO: Running on 2
physical processors, 4 logical processors
w3wp!resourceutilities!1e70!6/16/2005-09:35:28:: i INFO: Reporting Services
starting SKU: Enterprise
w3wp!runningjobs!1e70!6/16/2005-09:35:28:: i INFO: Database Cleanup (Web
Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1e70!6/16/2005-09:35:28:: i INFO: Running Requests
Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1e70!6/16/2005-09:35:28:: i INFO: Running Requests DB timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1e70!6/16/2005-09:35:28:: i INFO: Memory stats update timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1e70!06/16/2005-09:35:34:: i INFO: Call to GetSystemPermissions
w3wp!crypto!1e70!06/16/2005-09:35:35:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!1e70!06/16/2005-09:35:35:: i INFO: Exporting public key
w3wp!crypto!1e70!06/16/2005-09:35:35:: i INFO: Performing sku validation
w3wp!crypto!1e70!06/16/2005-09:35:35:: i INFO: Importing existing encryption
key
w3wp!webserver!16a4!6/16/2005-09:35:48:: i INFO: Reporting Web Server stopped

In what a problem?

P.S. Windows 2003 Standart, MS SQL 2000 SP4, RS SP 2

I am getting the same exact error. Why is there no response to this?

RS OLAP Connection Problem

I have a stand alone win2k3 reporting services server(i.e. SQL is not on the
box). RS SP1 is installed.
I have a SQLRS report developed in visual studio (on the same box) that runs
MDX against an analysis services cube. I am using the OLE DB provider for
OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting
services server to get the pivot table service and 8.0 provider to be
available)
I can successfully connect to Analysis Services and preview the report in
visual studio.
When I run the report in Report Manger, the report bombs with...
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'ServerNameBlahBlah'.
(rsErrorOpeningConnection) Get Online Help
Database 'CubeNameBlahBlah' does not exist.
I have a AS database role setup that should allow the stored
credentials to successfully authenticate.
HELP !!!!That is what you get when you don't have rights to the AS datasource. Open
Visual Studio Report Designer by right-clicking and choosing "Run as" and
choose the same credentials you are using as stored credentials for the AS
datasource. See if you can then preview the report, you will probably get a
similar error.
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"James" <carbonc@.carbonc.com> wrote in message
news:e8X%231pbJFHA.3928@.TK2MSFTNGP09.phx.gbl...
>I have a stand alone win2k3 reporting services server(i.e. SQL is not on
>the
> box). RS SP1 is installed.
> I have a SQLRS report developed in visual studio (on the same box) that
> runs
> MDX against an analysis services cube. I am using the OLE DB provider for
> OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting
> services server to get the pivot table service and 8.0 provider to be
> available)
> I can successfully connect to Analysis Services and preview the report in
> visual studio.
> When I run the report in Report Manger, the report bombs with...
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'ServerNameBlahBlah'.
> (rsErrorOpeningConnection) Get Online Help
> Database 'CubeNameBlahBlah' does not exist.
> I have a AS database role setup that should allow the stored
> credentials to successfully authenticate.
>
> HELP !!!!
>

RS Error: The underlying connection was closed: Could not establish secure channel for SSL

Hi,
I have been running Reporting Services without a hitch for the last
few weeks. Suddenly on saturday I started getting this error:
The underlying connection was closed: Could not establish secure
channel for SSL/TLS.
When I installed RS I did not check the SSL option.
SecureConnectionLevel is set to 0 in the config file.
No settings have been changed.
Any advise?
TerryRelated post:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3a7ae971-73e5-4ae1-a41d-7f14be6875ab
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Olap Worker" <olapwork@.yahoo.com> wrote in message
news:e0f48230.0407251452.4c976b05@.posting.google.com...
> Hi,
> I have been running Reporting Services without a hitch for the last
> few weeks. Suddenly on saturday I started getting this error:
> The underlying connection was closed: Could not establish secure
> channel for SSL/TLS.
> When I installed RS I did not check the SSL option.
> SecureConnectionLevel is set to 0 in the config file.
> No settings have been changed.
> Any advise?
> Terry|||> Related post:
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3a7ae971-73e5-4ae1-a41d-7f14be6875ab
Yeah, I have seen this article, but I am NOT using SSL. When I
navigate to the reports I use http://mycompany/reports
I tried navigating to https://mycompanyserver/ReportServer but IE
never loads the page
I also tried setting SecureConnectionLevel to 3 but nothing works.
I will try reinstall RS and see if this helps|||SSL is not a prerequisite for Reporting Services.
Can you access the report manager root and report root from IE? Please let
me know. I'll then follow up on your issue further.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ray" <Ray@.discussions.microsoft.com> wrote in message
news:AECF6320-C5AA-4FE5-B2E3-54356D0D5029@.microsoft.com...
> Ravi,
> We are having the same problem, but the IIS on the report server is NOT
configured for SSL! Is this a requirement for Reporting Services? Is there
a resolution to this problem if we are not configured for SSL to begin with?
Please advise, as this has happened in test and we would like to prevent it
from happening in our live area.
> Thanks,
> Aisha/Ray
> "Ravi Mumulla (Microsoft)" wrote:
> > Related post:
> >
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3a7ae971-73e5-4ae1-a41d-7f14be6875ab
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > "Olap Worker" <olapwork@.yahoo.com> wrote in message
> > news:e0f48230.0407251452.4c976b05@.posting.google.com...
> > > Hi,
> > >
> > > I have been running Reporting Services without a hitch for the last
> > > few weeks. Suddenly on saturday I started getting this error:
> > > The underlying connection was closed: Could not establish secure
> > > channel for SSL/TLS.
> > >
> > > When I installed RS I did not check the SSL option.
> > > SecureConnectionLevel is set to 0 in the config file.
> > >
> > > No settings have been changed.
> > >
> > > Any advise?
> > >
> > > Terry
> >
> >
> >|||Ravi,
No, we cannot access the report manager, root directory from IE. When navigating to the reports I use http://mycompanyserver/reports which results in the "The underlying connection was closed: Could not establish secure channel for SSL/TLS."
When I try navigating to http://mycompanyserver/ReportServer ,IE does not load the page and gives error "You are not authorized to view this page."
Please advise.
Thanks,
Aisha
"Ravi Mumulla (Microsoft)" wrote:
> SSL is not a prerequisite for Reporting Services.
> Can you access the report manager root and report root from IE? Please let
> me know. I'll then follow up on your issue further.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Ray" <Ray@.discussions.microsoft.com> wrote in message
> news:AECF6320-C5AA-4FE5-B2E3-54356D0D5029@.microsoft.com...
> > Ravi,
> >
> > We are having the same problem, but the IIS on the report server is NOT
> configured for SSL! Is this a requirement for Reporting Services? Is there
> a resolution to this problem if we are not configured for SSL to begin with?
> Please advise, as this has happened in test and we would like to prevent it
> from happening in our live area.
> >
> > Thanks,
> > Aisha/Ray
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > Related post:
> > >
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3a7ae971-73e5-4ae1-a41d-7f14be6875ab
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > "Olap Worker" <olapwork@.yahoo.com> wrote in message
> > > news:e0f48230.0407251452.4c976b05@.posting.google.com...
> > > > Hi,
> > > >
> > > > I have been running Reporting Services without a hitch for the last
> > > > few weeks. Suddenly on saturday I started getting this error:
> > > > The underlying connection was closed: Could not establish secure
> > > > channel for SSL/TLS.
> > > >
> > > > When I installed RS I did not check the SSL option.
> > > > SecureConnectionLevel is set to 0 in the config file.
> > > >
> > > > No settings have been changed.
> > > >
> > > > Any advise?
> > > >
> > > > Terry
> > >
> > >
> > >
>
>|||Hi all, I am experiencing the same issue. I am trying to trial the reporting
services (eval version) and am not using SSL. I have looked through all the
threads on this subject and many people are having this problem and there has
yet to be a solution. I am running the reporting services on a dev machine
with WinXP SP2, VS.Net 2003, SQL Server 2000 SP3a and IIS 5.1
I am running sql server authentication in mixed mode and my MSSQLSERVER
service is running under the local system account.
I try to access http:\\machinename\reports and I get the error:
The underlying connection was closed: Could not establish secure channel for
SSL/TLS.
I have read all the post in this newsgroup regarding this issue so please do
not ask me to check if SSL required is checked or if the <Add
Key="SecureConnectionLevel" Value="0"/> is present.
Thanks in advance for any help you can provide.
"Ray" wrote:
> Ravi,
> What is the status on this?
> Aisha
> "Ravi Mumulla (Microsoft)" wrote:
> > SSL is not a prerequisite for Reporting Services.
> >
> > Can you access the report manager root and report root from IE? Please let
> > me know. I'll then follow up on your issue further.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> > "Ray" <Ray@.discussions.microsoft.com> wrote in message
> > news:AECF6320-C5AA-4FE5-B2E3-54356D0D5029@.microsoft.com...
> > > Ravi,
> > >
> > > We are having the same problem, but the IIS on the report server is NOT
> > configured for SSL! Is this a requirement for Reporting Services? Is there
> > a resolution to this problem if we are not configured for SSL to begin with?
> > Please advise, as this has happened in test and we would like to prevent it
> > from happening in our live area.
> > >
> > > Thanks,
> > > Aisha/Ray
> > >
> > > "Ravi Mumulla (Microsoft)" wrote:
> > >
> > > > Related post:
> > > >
> > http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3a7ae971-73e5-4ae1-a41d-7f14be6875ab
> > > >
> > > > --
> > > > Ravi Mumulla (Microsoft)
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > "Olap Worker" <olapwork@.yahoo.com> wrote in message
> > > > news:e0f48230.0407251452.4c976b05@.posting.google.com...
> > > > > Hi,
> > > > >
> > > > > I have been running Reporting Services without a hitch for the last
> > > > > few weeks. Suddenly on saturday I started getting this error:
> > > > > The underlying connection was closed: Could not establish secure
> > > > > channel for SSL/TLS.
> > > > >
> > > > > When I installed RS I did not check the SSL option.
> > > > > SecureConnectionLevel is set to 0 in the config file.
> > > > >
> > > > > No settings have been changed.
> > > > >
> > > > > Any advise?
> > > > >
> > > > > Terry
> > > >
> > > >
> > > >
> >
> >
> >|||I figured out my problem. I checked my reportserver in IIS and noticed that
my application mappings were not set up correctly. I used the microsoft
knowledge base article located at http://support.microsoft.com/?kbid=867872
to figure out what the mappings should be. In the section to set up the
ReportServer application mappings in IIS you need to remove the mappings and
then add the mapping * click all verbs and select the Aspnet_isapi.dll.
It seems that this did not happen. For those of you using IIS 5.1 if you
try to enter just the * in the extension then you will not be able to click
OK (it will be disabled) enter ".*" (no quotes) and the OK button will be
enabled.
See http://forums.devarticles.com/archive/t-2527 for more info.
Click OK then restart the ReportServer Service and presto I am up and running.
So if you are using reporting services and not using SSL then check your
mappings and this may fix your problem and hopefully your frustrations.
I'm back in business baby!
Alex
"Alex" wrote:
> Hi all, I am experiencing the same issue. I am trying to trial the reporting
> services (eval version) and am not using SSL. I have looked through all the
> threads on this subject and many people are having this problem and there has
> yet to be a solution. I am running the reporting services on a dev machine
> with WinXP SP2, VS.Net 2003, SQL Server 2000 SP3a and IIS 5.1
> I am running sql server authentication in mixed mode and my MSSQLSERVER
> service is running under the local system account.
> I try to access http:\\machinename\reports and I get the error:
> The underlying connection was closed: Could not establish secure channel for
> SSL/TLS.
> I have read all the post in this newsgroup regarding this issue so please do
> not ask me to check if SSL required is checked or if the <Add
> Key="SecureConnectionLevel" Value="0"/> is present.
> Thanks in advance for any help you can provide.
>
> "Ray" wrote:
> > Ravi,
> >
> > What is the status on this?
> >
> > Aisha
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > SSL is not a prerequisite for Reporting Services.
> > >
> > > Can you access the report manager root and report root from IE? Please let
> > > me know. I'll then follow up on your issue further.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > "Ray" <Ray@.discussions.microsoft.com> wrote in message
> > > news:AECF6320-C5AA-4FE5-B2E3-54356D0D5029@.microsoft.com...
> > > > Ravi,
> > > >
> > > > We are having the same problem, but the IIS on the report server is NOT
> > > configured for SSL! Is this a requirement for Reporting Services? Is there
> > > a resolution to this problem if we are not configured for SSL to begin with?
> > > Please advise, as this has happened in test and we would like to prevent it
> > > from happening in our live area.
> > > >
> > > > Thanks,
> > > > Aisha/Ray
> > > >
> > > > "Ravi Mumulla (Microsoft)" wrote:
> > > >
> > > > > Related post:
> > > > >
> > > http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3a7ae971-73e5-4ae1-a41d-7f14be6875ab
> > > > >
> > > > > --
> > > > > Ravi Mumulla (Microsoft)
> > > > > SQL Server Reporting Services
> > > > >
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > > "Olap Worker" <olapwork@.yahoo.com> wrote in message
> > > > > news:e0f48230.0407251452.4c976b05@.posting.google.com...
> > > > > > Hi,
> > > > > >
> > > > > > I have been running Reporting Services without a hitch for the last
> > > > > > few weeks. Suddenly on saturday I started getting this error:
> > > > > > The underlying connection was closed: Could not establish secure
> > > > > > channel for SSL/TLS.
> > > > > >
> > > > > > When I installed RS I did not check the SSL option.
> > > > > > SecureConnectionLevel is set to 0 in the config file.
> > > > > >
> > > > > > No settings have been changed.
> > > > > >
> > > > > > Any advise?
> > > > > >
> > > > > > Terry
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >|||Thank you soo much!
This post helped fixed my problem (RS stopped working after renaming the
server). It was the IIS application mappings in RS.
Marlon
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:694C9B98-9AFF-4A4B-9D7A-258E4622A957@.microsoft.com...
>I figured out my problem. I checked my reportserver in IIS and noticed
>that
> my application mappings were not set up correctly. I used the microsoft
> knowledge base article located at
> http://support.microsoft.com/?kbid=867872
> to figure out what the mappings should be. In the section to set up the
> ReportServer application mappings in IIS you need to remove the mappings
> and
> then add the mapping * click all verbs and select the Aspnet_isapi.dll.
> It seems that this did not happen. For those of you using IIS 5.1 if you
> try to enter just the * in the extension then you will not be able to
> click
> OK (it will be disabled) enter ".*" (no quotes) and the OK button will be
> enabled.
> See http://forums.devarticles.com/archive/t-2527 for more info.
> Click OK then restart the ReportServer Service and presto I am up and
> running.
> So if you are using reporting services and not using SSL then check your
> mappings and this may fix your problem and hopefully your frustrations.
> I'm back in business baby!
> Alex
>
> "Alex" wrote:
>> Hi all, I am experiencing the same issue. I am trying to trial the
>> reporting
>> services (eval version) and am not using SSL. I have looked through all
>> the
>> threads on this subject and many people are having this problem and there
>> has
>> yet to be a solution. I am running the reporting services on a dev
>> machine
>> with WinXP SP2, VS.Net 2003, SQL Server 2000 SP3a and IIS 5.1
>> I am running sql server authentication in mixed mode and my MSSQLSERVER
>> service is running under the local system account.
>> I try to access http:\\machinename\reports and I get the error:
>> The underlying connection was closed: Could not establish secure channel
>> for
>> SSL/TLS.
>> I have read all the post in this newsgroup regarding this issue so please
>> do
>> not ask me to check if SSL required is checked or if the <Add
>> Key="SecureConnectionLevel" Value="0"/> is present.
>> Thanks in advance for any help you can provide.
>>
>> "Ray" wrote:
>> > Ravi,
>> >
>> > What is the status on this?
>> >
>> > Aisha
>> >
>> > "Ravi Mumulla (Microsoft)" wrote:
>> >
>> > > SSL is not a prerequisite for Reporting Services.
>> > >
>> > > Can you access the report manager root and report root from IE?
>> > > Please let
>> > > me know. I'll then follow up on your issue further.
>> > >
>> > > --
>> > > Ravi Mumulla (Microsoft)
>> > > SQL Server Reporting Services
>> > >
>> > > This posting is provided "AS IS" with no warranties, and confers no
>> > > rights.
>> > > "Ray" <Ray@.discussions.microsoft.com> wrote in message
>> > > news:AECF6320-C5AA-4FE5-B2E3-54356D0D5029@.microsoft.com...
>> > > > Ravi,
>> > > >
>> > > > We are having the same problem, but the IIS on the report server is
>> > > > NOT
>> > > configured for SSL! Is this a requirement for Reporting Services?
>> > > Is there
>> > > a resolution to this problem if we are not configured for SSL to
>> > > begin with?
>> > > Please advise, as this has happened in test and we would like to
>> > > prevent it
>> > > from happening in our live area.
>> > > >
>> > > > Thanks,
>> > > > Aisha/Ray
>> > > >
>> > > > "Ravi Mumulla (Microsoft)" wrote:
>> > > >
>> > > > > Related post:
>> > > > >
>> > > http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3a7ae971-73e5-4ae1-a41d-7f14be6875ab
>> > > > >
>> > > > > --
>> > > > > Ravi Mumulla (Microsoft)
>> > > > > SQL Server Reporting Services
>> > > > >
>> > > > > This posting is provided "AS IS" with no warranties, and confers
>> > > > > no
>> > > rights.
>> > > > > "Olap Worker" <olapwork@.yahoo.com> wrote in message
>> > > > > news:e0f48230.0407251452.4c976b05@.posting.google.com...
>> > > > > > Hi,
>> > > > > >
>> > > > > > I have been running Reporting Services without a hitch for the
>> > > > > > last
>> > > > > > few weeks. Suddenly on saturday I started getting this error:
>> > > > > > The underlying connection was closed: Could not establish
>> > > > > > secure
>> > > > > > channel for SSL/TLS.
>> > > > > >
>> > > > > > When I installed RS I did not check the SSL option.
>> > > > > > SecureConnectionLevel is set to 0 in the config file.
>> > > > > >
>> > > > > > No settings have been changed.
>> > > > > >
>> > > > > > Any advise?
>> > > > > >
>> > > > > > Terry
>> > > > >
>> > > > >
>> > > > >
>> > >
>> > >
>> > >|||THANK YOU! i was having similar problem after installing the full VS.net pro
version over an earlier version. where once my RS was working perfectly, i
then had the same problems as this post. followed your directions and the
post article from "junkies" site and i'm back in business. this group is
great!
dale
"TechnoSpyke" wrote:
> Thank you soo much!
> This post helped fixed my problem (RS stopped working after renaming the
> server). It was the IIS application mappings in RS.
> Marlon
> "Alex" <Alex@.discussions.microsoft.com> wrote in message
> news:694C9B98-9AFF-4A4B-9D7A-258E4622A957@.microsoft.com...
> >I figured out my problem. I checked my reportserver in IIS and noticed
> >that
> > my application mappings were not set up correctly. I used the microsoft
> > knowledge base article located at
> > http://support.microsoft.com/?kbid=867872
> > to figure out what the mappings should be. In the section to set up the
> > ReportServer application mappings in IIS you need to remove the mappings
> > and
> > then add the mapping * click all verbs and select the Aspnet_isapi.dll.
> >
> > It seems that this did not happen. For those of you using IIS 5.1 if you
> > try to enter just the * in the extension then you will not be able to
> > click
> > OK (it will be disabled) enter ".*" (no quotes) and the OK button will be
> > enabled.
> >
> > See http://forums.devarticles.com/archive/t-2527 for more info.
> >
> > Click OK then restart the ReportServer Service and presto I am up and
> > running.
> >
> > So if you are using reporting services and not using SSL then check your
> > mappings and this may fix your problem and hopefully your frustrations.
> >
> > I'm back in business baby!
> > Alex
> >
> >
> > "Alex" wrote:
> >
> >> Hi all, I am experiencing the same issue. I am trying to trial the
> >> reporting
> >> services (eval version) and am not using SSL. I have looked through all
> >> the
> >> threads on this subject and many people are having this problem and there
> >> has
> >> yet to be a solution. I am running the reporting services on a dev
> >> machine
> >> with WinXP SP2, VS.Net 2003, SQL Server 2000 SP3a and IIS 5.1
> >> I am running sql server authentication in mixed mode and my MSSQLSERVER
> >> service is running under the local system account.
> >>
> >> I try to access http:\\machinename\reports and I get the error:
> >> The underlying connection was closed: Could not establish secure channel
> >> for
> >> SSL/TLS.
> >>
> >> I have read all the post in this newsgroup regarding this issue so please
> >> do
> >> not ask me to check if SSL required is checked or if the <Add
> >> Key="SecureConnectionLevel" Value="0"/> is present.
> >>
> >> Thanks in advance for any help you can provide.
> >>
> >>
> >> "Ray" wrote:
> >>
> >> > Ravi,
> >> >
> >> > What is the status on this?
> >> >
> >> > Aisha
> >> >
> >> > "Ravi Mumulla (Microsoft)" wrote:
> >> >
> >> > > SSL is not a prerequisite for Reporting Services.
> >> > >
> >> > > Can you access the report manager root and report root from IE?
> >> > > Please let
> >> > > me know. I'll then follow up on your issue further.
> >> > >
> >> > > --
> >> > > Ravi Mumulla (Microsoft)
> >> > > SQL Server Reporting Services
> >> > >
> >> > > This posting is provided "AS IS" with no warranties, and confers no
> >> > > rights.
> >> > > "Ray" <Ray@.discussions.microsoft.com> wrote in message
> >> > > news:AECF6320-C5AA-4FE5-B2E3-54356D0D5029@.microsoft.com...
> >> > > > Ravi,
> >> > > >
> >> > > > We are having the same problem, but the IIS on the report server is
> >> > > > NOT
> >> > > configured for SSL! Is this a requirement for Reporting Services?
> >> > > Is there
> >> > > a resolution to this problem if we are not configured for SSL to
> >> > > begin with?
> >> > > Please advise, as this has happened in test and we would like to
> >> > > prevent it
> >> > > from happening in our live area.
> >> > > >
> >> > > > Thanks,
> >> > > > Aisha/Ray
> >> > > >
> >> > > > "Ravi Mumulla (Microsoft)" wrote:
> >> > > >
> >> > > > > Related post:
> >> > > > >
> >> > > http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3a7ae971-73e5-4ae1-a41d-7f14be6875ab
> >> > > > >
> >> > > > > --
> >> > > > > Ravi Mumulla (Microsoft)
> >> > > > > SQL Server Reporting Services
> >> > > > >
> >> > > > > This posting is provided "AS IS" with no warranties, and confers
> >> > > > > no
> >> > > rights.
> >> > > > > "Olap Worker" <olapwork@.yahoo.com> wrote in message
> >> > > > > news:e0f48230.0407251452.4c976b05@.posting.google.com...
> >> > > > > > Hi,
> >> > > > > >
> >> > > > > > I have been running Reporting Services without a hitch for the
> >> > > > > > last
> >> > > > > > few weeks. Suddenly on saturday I started getting this error:
> >> > > > > > The underlying connection was closed: Could not establish
> >> > > > > > secure
> >> > > > > > channel for SSL/TLS.
> >> > > > > >
> >> > > > > > When I installed RS I did not check the SSL option.
> >> > > > > > SecureConnectionLevel is set to 0 in the config file.
> >> > > > > >
> >> > > > > > No settings have been changed.
> >> > > > > >
> >> > > > > > Any advise?
> >> > > > > >
> >> > > > > > Terry
> >> > > > >
> >> > > > >
> >> > > > >
> >> > >
> >> > >
> >> > >
>
>|||I was not using SSL.
I seemed to get this issue at about the last time I ran Lockdown on IIS.
Setting an App Map in the config section of your Report Server virtual dir
for extension '*' seems to have resolved my issue.
This may not be too secure though
"Olap Worker" wrote:
> Hi,
> I have been running Reporting Services without a hitch for the last
> few weeks. Suddenly on saturday I started getting this error:
> The underlying connection was closed: Could not establish secure
> channel for SSL/TLS.
> When I installed RS I did not check the SSL option.
> SecureConnectionLevel is set to 0 in the config file.
> No settings have been changed.
> Any advise?
> Terry
>|||Alex,
I tried your fix, and followed the support article you mentioned,but i can't
put a '*' in the mappings box as it keeps telling me it's the wrong format! I
am using IIS6 Win2003, any ideas
"Alex" wrote:
> I figured out my problem. I checked my reportserver in IIS and noticed that
> my application mappings were not set up correctly. I used the microsoft
> knowledge base article located at http://support.microsoft.com/?kbid=867872
> to figure out what the mappings should be. In the section to set up the
> ReportServer application mappings in IIS you need to remove the mappings and
> then add the mapping * click all verbs and select the Aspnet_isapi.dll.
> It seems that this did not happen. For those of you using IIS 5.1 if you
> try to enter just the * in the extension then you will not be able to click
> OK (it will be disabled) enter ".*" (no quotes) and the OK button will be
> enabled.
> See http://forums.devarticles.com/archive/t-2527 for more info.
> Click OK then restart the ReportServer Service and presto I am up and running.
> So if you are using reporting services and not using SSL then check your
> mappings and this may fix your problem and hopefully your frustrations.
> I'm back in business baby!
> Alex
>
> "Alex" wrote:
> > Hi all, I am experiencing the same issue. I am trying to trial the reporting
> > services (eval version) and am not using SSL. I have looked through all the
> > threads on this subject and many people are having this problem and there has
> > yet to be a solution. I am running the reporting services on a dev machine
> > with WinXP SP2, VS.Net 2003, SQL Server 2000 SP3a and IIS 5.1
> > I am running sql server authentication in mixed mode and my MSSQLSERVER
> > service is running under the local system account.
> >
> > I try to access http:\\machinename\reports and I get the error:
> > The underlying connection was closed: Could not establish secure channel for
> > SSL/TLS.
> >
> > I have read all the post in this newsgroup regarding this issue so please do
> > not ask me to check if SSL required is checked or if the <Add
> > Key="SecureConnectionLevel" Value="0"/> is present.
> >
> > Thanks in advance for any help you can provide.
> >
> >
> > "Ray" wrote:
> >
> > > Ravi,
> > >
> > > What is the status on this?
> > >
> > > Aisha
> > >
> > > "Ravi Mumulla (Microsoft)" wrote:
> > >
> > > > SSL is not a prerequisite for Reporting Services.
> > > >
> > > > Can you access the report manager root and report root from IE? Please let
> > > > me know. I'll then follow up on your issue further.
> > > >
> > > > --
> > > > Ravi Mumulla (Microsoft)
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > > "Ray" <Ray@.discussions.microsoft.com> wrote in message
> > > > news:AECF6320-C5AA-4FE5-B2E3-54356D0D5029@.microsoft.com...
> > > > > Ravi,
> > > > >
> > > > > We are having the same problem, but the IIS on the report server is NOT
> > > > configured for SSL! Is this a requirement for Reporting Services? Is there
> > > > a resolution to this problem if we are not configured for SSL to begin with?
> > > > Please advise, as this has happened in test and we would like to prevent it
> > > > from happening in our live area.
> > > > >
> > > > > Thanks,
> > > > > Aisha/Ray
> > > > >
> > > > > "Ravi Mumulla (Microsoft)" wrote:
> > > > >
> > > > > > Related post:
> > > > > >
> > > > http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3a7ae971-73e5-4ae1-a41d-7f14be6875ab
> > > > > >
> > > > > > --
> > > > > > Ravi Mumulla (Microsoft)
> > > > > > SQL Server Reporting Services
> > > > > >
> > > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > > rights.
> > > > > > "Olap Worker" <olapwork@.yahoo.com> wrote in message
> > > > > > news:e0f48230.0407251452.4c976b05@.posting.google.com...
> > > > > > > Hi,
> > > > > > >
> > > > > > > I have been running Reporting Services without a hitch for the last
> > > > > > > few weeks. Suddenly on saturday I started getting this error:
> > > > > > > The underlying connection was closed: Could not establish secure
> > > > > > > channel for SSL/TLS.
> > > > > > >
> > > > > > > When I installed RS I did not check the SSL option.
> > > > > > > SecureConnectionLevel is set to 0 in the config file.
> > > > > > >
> > > > > > > No settings have been changed.
> > > > > > >
> > > > > > > Any advise?
> > > > > > >
> > > > > > > Terry
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >

RS 2005 Testing - database connection issue

Hi,
From my own PC, I have created a report in Report Builder (RB) that has a
SQL server database as a data source, and when I go to run it (in either RB
or Report Manager), I get the following message: -
"Cannot create a connection to data source 'dataSource'.
(rsErrorOpeningConnection)
--
An error has occurred during report processing. (rsProcessingAborted)"
However, when I run the report in Report Builder directly on the test
server, the report is produced no probs!
Any ideas as to why this is happening?
Cheers
TrevorReport Builder is probable running with NT Auth. Do you have permissions to
the data source and model that may be different then when run on the local
machine?
Try to follow how the connections are working. Client machine RB -> Model
-> Data Source. Somewhere there looks like your client has no access to or
it does not exist.
--
| Thread-Topic: RS 2005 Testing - database connection issue
| thread-index: AcXEPOQcb4FfUXeUQNyO6UODzJAI5Q==| X-WBNR-Posting-Host: 195.44.12.109
| From: =?Utf-8?B?YXVsZHJlaWR5?= <auldreidy@.discussions.microsoft.com>
| Subject: RS 2005 Testing - database connection issue
| Date: Wed, 28 Sep 2005 07:57:05 -0700
| Lines: 19
| Message-ID: <5777EA31-DEBF-4071-91B3-D6CE0C7004B0@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53272
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
|
| From my own PC, I have created a report in Report Builder (RB) that has a
| SQL server database as a data source, and when I go to run it (in either
RB
| or Report Manager), I get the following message: -
|
| "Cannot create a connection to data source 'dataSource'.
| (rsErrorOpeningConnection)
| --
| An error has occurred during report processing. (rsProcessingAborted)"
|
| However, when I run the report in Report Builder directly on the test
| server, the report is produced no probs!
|
| Any ideas as to why this is happening?
|
| Cheers
| Trevor
|
|