Connect to server from Report Builder

I am able to start Report Builder from the Reports site.

Report Builder opens but then it asks to "Select site or server", I don't see any data sources or anything, I can only enter a site or server. I tried http://crossdatabase/Reports and http://crossdatabase/ReportServer and http://crossdatabase nothing works. What's more, when I cancel and then click on the open button I get an exception:

Code Snippet

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.ReportBuilder.CatalogItemDialog.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
-
ReportBuilder
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Documents%20and%20Settings/Administrator.VDBRANDE/Local%20Settings/Apps/2.0/97YHGD67.7XE/97YX7M5J.5E2/repo..tion_c3bce3770c238a49_0009.0000_827b297b08a11874/ReportBuilder.exe
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
System.Deployment
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
-
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
-
System.Web.Services
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
-
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
-
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
-
yicgob7u
Assembly Version: 9.0.242.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
g5yh0wut
Assembly Version: 9.0.242.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
a0wegfwe
Assembly Version: 9.0.242.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

I run the Report Builder on the server so there should be no connection problems.

Thanks for any tips.

rept wrote:

I am able to start Report Builder from the Reports site.

Report Builder opens but then it asks to "Select site or server", I don't see any data sources or anything, I can only enter a site or server. I tried http://crossdatabase/Reports and http://crossdatabase/ReportServer and http://crossdatabase nothing works.

This doesn't work quite like you think it does.

In order for report builder to work properly, you need to create a Report Model Project in BIS. Once you've deployed a datasource, view and report model your report model will appear in the "select site or server" area in which you currently don't see anything.

The trick to defining the proper report model project is to define the proper relationships.

|||

Thanks for your help, I tried at first doing it in BIS but it doesn't seem possible to create a datasource based on OLAP in there? This is why I searched the net and found this tutorial which I'm trying to do:

http://msdn2.microsoft.com/en-us/library/ms345313.aspx

|||

Found the solution: I needed to open internet options in IE and then connections and check:

Bypass proxy server for local addressess. After that the Report Builder opened correctly and displayed the DSV perfectly.

Configuring Remote SMTP for Reporting Server

I am using the SQL server 2000 along with Microsoft Reporting Services. I need to configure SQLReporting services for sending reports through emails using subscription

services. I don't have any SMTP server located in my local network or on Reporting server. We are using external SMTP server for sending & receiving mails through outlook express. How to configure the RSReportServer.config file for the same?

If we refer documentation available in Reporting Service Books Online, it states that we

can configure using SMTPAuthenticate settings by using "SENDUSERNAME" & "SENDPASSWORD" in rsconfig file. But If We Refer the MSDN online it states SMTPAuthenticate authorization is not supported.

Please help us in matter to solve the problem. We are unable to send mails using reporting service by using the settings stated in the Reporting Service Books Online.

It gives error "The e-mail address of one or more recipients is not valid" due to relaying denied by mail server which requires authentication.

Please solve the following problems.

1. Whether it is possible to use SMTP server outside the network or not?

2. If yes what is the method of configuring SMTP services?

3. How can we send username & password to authenticate the user?

4. Send us sample RSReportServer.config if possible for the same.

Thanking you

I suppose no one wants to answer my question or no one knows the answer ? Well after the research i come to know that the my remote SMTP server do not allow relaying on server. So enabling relaying can solve the problem. But it can create SPAM mail problems.

I d't fine any method to send username & password to smtp server.Any body knows how to send user authorization & password to SMTP server for reporting service mails. ?

|||

Hi,

I saw your post today when I was doing a little bit reseach about this problem. Because my server was keep giving me the same reply. I was able to sent e-mail someone in our domain but not the outside world.

Luckly I found the answer. You need to add some authentication details to send an e-mail.

Here is my SMTP e-mail function. I am sure you will spot the missing codes immediately

Public Function sendMail(ByVal strFromEmail As String, ByVal strToEmail As String, ByVal strSubject As String, ByVal strMessage As String) As Boolean

Try

Dim msg As New System.Net.Mail.MailMessage

Dim addressFrom As New System.Net.Mail.MailAddress(strFromEmail)

Dim addressTo As New System.Net.Mail.MailAddress(strToEmail)

msg.From = addressFrom

msg.To.Add(addressTo)

msg.Subject = strSubject

msg.Body = strMessage

Dim smtp As System.Net.Mail.SmtpClient = New System.Net.Mail.SmtpClient

smtp.Host = "MAIL HOST"

smtp.Port = 25

Dim basicAuthenticationInfo As New System.Net.NetworkCredential("USERNAME", "PASSWORD")

smtp.UseDefaultCredentials = False

smtp.Credentials = basicAuthenticationInfo

'smtp.Attachments.Add(New System.Web.Mail.MailAttachment("c:\pic1.jpg"))

smtp.Send(msg)

Catch ex As Exception

MsgBox(ex.Message)

Debug.Print(ex.Message)

End Try

End Function

Configuring Remote SMTP for Reporting Server

I am using the SQL server 2000 along with Microsoft Reporting Services. I need to configure SQLReporting services for sending reports through emails using subscription

services. I don't have any SMTP server located in my local network or on Reporting server. We are using external SMTP server for sending & receiving mails through outlook express. How to configure the RSReportServer.config file for the same?

If we refer documentation available in Reporting Service Books Online, it states that we

can configure using SMTPAuthenticate settings by using "SENDUSERNAME" & "SENDPASSWORD" in rsconfig file. But If We Refer the MSDN online it states SMTPAuthenticate authorization is not supported.

Please help us in matter to solve the problem. We are unable to send mails using reporting service by using the settings stated in the Reporting Service Books Online.

It gives error "The e-mail address of one or more recipients is not valid" due to relaying denied by mail server which requires authentication.

Please solve the following problems.

1. Whether it is possible to use SMTP server outside the network or not?

2. If yes what is the method of configuring SMTP services?

3. How can we send username & password to authenticate the user?

4. Send us sample RSReportServer.config if possible for the same.

Thanking you

I suppose no one wants to answer my question or no one knows the answer ? Well after the research i come to know that the my remote SMTP server do not allow relaying on server. So enabling relaying can solve the problem. But it can create SPAM mail problems.

I d't fine any method to send username & password to smtp server.Any body knows how to send user authorization & password to SMTP server for reporting service mails. ?

|||

Hi,

I saw your post today when I was doing a little bit reseach about this problem. Because my server was keep giving me the same reply. I was able to sent e-mail someone in our domain but not the outside world.

Luckly I found the answer. You need to add some authentication details to send an e-mail.

Here is my SMTP e-mail function. I am sure you will spot the missing codes immediately

Public Function sendMail(ByVal strFromEmail As String, ByVal strToEmail As String, ByVal strSubject As String, ByVal strMessage As String) As Boolean

Try

Dim msg As New System.Net.Mail.MailMessage

Dim addressFrom As New System.Net.Mail.MailAddress(strFromEmail)

Dim addressTo As New System.Net.Mail.MailAddress(strToEmail)

msg.From = addressFrom

msg.To.Add(addressTo)

msg.Subject = strSubject

msg.Body = strMessage

Dim smtp As System.Net.Mail.SmtpClient = New System.Net.Mail.SmtpClient

smtp.Host = "MAIL HOST"

smtp.Port = 25

Dim basicAuthenticationInfo As New System.Net.NetworkCredential("USERNAME", "PASSWORD")

smtp.UseDefaultCredentials = False

smtp.Credentials = basicAuthenticationInfo

'smtp.Attachments.Add(New System.Web.Mail.MailAttachment("c:\pic1.jpg"))

smtp.Send(msg)

Catch ex As Exception

MsgBox(ex.Message)

Debug.Print(ex.Message)

End Try

End Function

Configuring access

How can I let all domain users run reports without adding them one by one
into Report Manager?
ThanksAdd <DOMAIN>\Domain Users and grant Browse Rights.
Or better yet, create a security group that is allowed to view reports and
add this group to the list of users. I.e. if your group was called
"ReportUsers" and the name of my domain is WORKHERE then you would add:
WORKHERE\ReportUsers
=-Chris
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:evt7ufc%23GHA.3352@.TK2MSFTNGP03.phx.gbl...
> How can I let all domain users run reports without adding them one by one
> into Report Manager?
> Thanks
>

Configure Report Server with SQL Server Express with Advanced Services.

I am having trouble with SQL Express Reporting services.

When going to http:/localhost/reports I get the following error message:

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

In configuring the Report Server Virtual Directory, it would not let me set the name as "Report Server", so I named it "Report Server2".

I have tried uninstalling .NET framework v2 and reinstalling, but this does not help.

Any ideas?

By default, Express Advanced installs Report Server to a name instance, so you should be trying to get to http://localhost/reports$sqlexress. A default installation should have configured the virtual directory for you.

You can open SQL Server Configuration Manager and it will show you if the reporting service is running and if it has a name.

Mike