Showing posts with label call. Show all posts
Showing posts with label call. Show all posts

Friday, March 23, 2012

ListSecureMethods - does not return any data

I'm calling ListSecureMethods to verify the requirements for each of
the methods. This call returns no errors but the object does not have
any method names.
Here is the code:
Dim RS As New ProjectName.systemname.ReportingService
RS.Credentials = New System.Net.NetworkCredential(sUserName,
sPassword)
Dim methods As String() = RS.ListSecureMethods()
If Not (methods Is Nothing) Then
Dim method As String
For Each method In methods
'Console.WriteLine(method)
Listbox4.Items.Add(method)
Next method
End If
I pulled this code from the Microsoft site.
I'm running in Debug mode on my pc. The Reporting Server is a win2003
server. The SQL database is on a Win2000 server.
I'm running Visual Studio.Net vs 7.1.3088 with a Framework 1.1.4322.
The machine.config file has the Level set to 0 (zero).
I'm sure this is a security setting - I'm just not sure what it needs
to be. SSL is not being used as of yet. The Lan Admin group is
researching the request.
Any pointers would be greatly appreciated.
Thanks,ListSecureMethod will return various methods based on the value of
SecureConnectionLevel in the RSReportServer.config file.
For more info on the value of SecureConnectionLevel see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_2xiq.asp
Also this link gives info about using ListSecureMethods:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_5zdu.asp
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"coder" <tkingsle@.unifirst.com> wrote in message
news:1102969274.316120.216520@.z14g2000cwz.googlegroups.com...
> I'm calling ListSecureMethods to verify the requirements for each of
> the methods. This call returns no errors but the object does not have
> any method names.
> Here is the code:
> Dim RS As New ProjectName.systemname.ReportingService
> RS.Credentials = New System.Net.NetworkCredential(sUserName,
> sPassword)
> Dim methods As String() = RS.ListSecureMethods()
> If Not (methods Is Nothing) Then
> Dim method As String
> For Each method In methods
> 'Console.WriteLine(method)
> Listbox4.Items.Add(method)
> Next method
> End If
> I pulled this code from the Microsoft site.
> I'm running in Debug mode on my pc. The Reporting Server is a win2003
> server. The SQL database is on a Win2000 server.
> I'm running Visual Studio.Net vs 7.1.3088 with a Framework 1.1.4322.
> The machine.config file has the Level set to 0 (zero).
> I'm sure this is a security setting - I'm just not sure what it needs
> to be. SSL is not being used as of yet. The Lan Admin group is
> researching the request.
> Any pointers would be greatly appreciated.
> Thanks,
>

Wednesday, March 21, 2012

ListChildren Error

If I call the ListChildren() in ReportingService2005, and the network is
connected, it works great.
If I call the ListChildren() in ReportingService2005, and the network is not
connected, I get a really ugly exception.
I'd like to find an API in ReportingService2005 to detect if reporting
services is running and accessible on the SQL server before calling
ListChildren from the client. Any suggestions on what to call before calling
ListChildren?
Thanks
--
RandyHi Randy,
Thank you for posting.
As for the ListChildren method, it is one of the webservice function of the
ReportingService2005 service class, and so far there is no built-in
methods for check the service connection status or availability.
#ReportingService2005 Methods
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswe
bservice.rsmanagementservice2005.reportingservice2005_methods(SQL.90).aspx
Actually, since webservice method call is tranferred over underlying
transport protocol(normally it is http), so this should be done by our own
application's code to check the protocol connection wellness. For example,
in our application which call the webservice methods, we can use exception
block (try...catch...) to capture any exception when perform webservice
call to the SSRS service, if any underlying exception occurs( like http 500
service unavailable error), we can get that the service is currently not
available.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Monday, March 19, 2012

listavailablesqlservers returns only default instances - please help!

Hiya,
I'm trying to write an application in which I call listavailablesqlservers()
(using
SQLDMO). My intention is to get a list of all available sql server instances
available on the network (including the machine on which the app is
running). However, listavailablesqlservers() seems to return only the
default instances and ignores all other instances.
Anyone else encounter this problem or have a work around?
I'm developing using VB.NET on a Windows XP Professional machine running
both SQL Server Developer edition (my default instance) and an MSDE named
instance.
Any help would be greatly appreciated as I've unsuccessfully trawled the
Internet looking for an answer.
Thanks in advance.
Kas.Kas,
Does this help?
http://msdn.microsoft.com/library/default.asp
?url=/library/en-us/sqldmo/dmoref_p_i_95gp.asp
Russell Fields
"rearwindow" <summerof_89@.hotmail.com> wrote in message
news:bsarm9$as3$1$8302bc10@.news.demon.co.uk...
> Hiya,
> I'm trying to write an application in which I call
listavailablesqlservers()
> (using
> SQLDMO). My intention is to get a list of all available sql server
instances
> available on the network (including the machine on which the app is
> running). However, listavailablesqlservers() seems to return only the
> default instances and ignores all other instances.
> Anyone else encounter this problem or have a work around?
> I'm developing using VB.NET on a Windows XP Professional machine running
> both SQL Server Developer edition (my default instance) and an MSDE named
> instance.
> Any help would be greatly appreciated as I've unsuccessfully trawled the
> Internet looking for an answer.
> Thanks in advance.
> Kas.
>