little server icon in the Enterprise Manager had a red squiggly mark next

Hi,
I have observed some errors in my sql server. I dont know
whether it makes any problems or not.
"little server icon in the Enterprise Manager had a red
squiggly mark next to it."
Can anyone tell me what is this.
Regards
RajIt just indicates that you are logged on to the SQL Server. It is a good
thing.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Raj" <anonymous@.discussions.microsoft.com> wrote in message
news:03e601c3bfdb$f25c63b0$a001280a@.phx.gbl...
> Hi,
> I have observed some errors in my sql server. I dont know
> whether it makes any problems or not.
> "little server icon in the Enterprise Manager had a red
> squiggly mark next to it."
> Can anyone tell me what is this.
> Regards
> Raj
>|||Raj wrote:
> Hi,
> I have observed some errors in my sql server. I dont know
> whether it makes any problems or not.
> "little server icon in the Enterprise Manager had a red
> squiggly mark next to it."
> Can anyone tell me what is this.
> Regards
> Raj
It is NOT an error, it just tells you you're connected to that server. Try
rightclickingon the server and choose disconnect to see it dissapear

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,
>

List control and pdf export issues

I have created a report that contained a subreport that was databound inside a table but I was getting errors when I export to excel - "Subreports within table/matrix cells are ignored".

So I changed my report to bind the subreport to a list control instead of a table and it exports to excel fine but I now have new issues:

1) When I export to pdf it seems to ignore width and height properties, creating a blank page every other page (because it thinks the list control is wider than the page), and it also overlaps other elements below the list control.

2) I also seems to have lost the paging in the viewer control that is handled by setting the interactive height property.

Are these known limitations of the list control and pdf or do I have something wrong in the way I have set-up the report. I can provide .rdlc file samples if necessary.

Thank you

Lee Whitney

For your first issue, I guess the width of your subreport (in designer) is more than the width of the subreport control in your main report. For example, if you had used 8 inches in your subreport designer and if the width of the subreport control in your main report is only 7 inches, it will be spilled to the next page.

Hopefully this will solve your other issues as well.

Shyam

|||

I already made sure that my sub report width is less than the control width, in fact if I use the table control rather than the list control (and the widths for both controls are the same) the table control exports just fine to pdf where the list control does not. The list control seems to add a colspan=2 to the raw html though I don't know why but this seems to be my culprit though I have no idea how to get rs not to render the html in this fashion.Thanks