Monday, March 26, 2012
Report Delivery Options To field is not editable
read only. I followed the step: "Configuration Options for Setting the To:
Field in a Message" in the document "Configuring a Report Server for E-Mail
Delivery" http://technet.microsoft.com/en-us/library/ms159155.aspx. However
the To: field still can not be changed.
What am I over looking?
Thanks, MikeI donâ't know if it has to do with the way we are configured or a step that
was omitted for the procedure outline in my post below. But I logged off of
the network then back on and now the To: field can be change when subscribing.
"Mike Mullane" wrote:
> In the Report Delivery Options page of a new subscription the To: field is
> read only. I followed the step: "Configuration Options for Setting the To:
> Field in a Message" in the document "Configuring a Report Server for E-Mail
> Delivery" http://technet.microsoft.com/en-us/library/ms159155.aspx. However
> the To: field still can not be changed.
> What am I over looking?
> Thanks, Mike
>
Report connection fails with DNS name
Hi,
I am facing problem while setting connection string in Report Service project.
Problem is when I specify DNS name instead of machine name as the Server in the connection string.
When I specify DNS name in the connection string it gives error that "A connection cannot be made.Ensure that the server is running" on click of "Test Connection"
Also I am not able to view reports directly through IE. I.e. http://<DNS_NAME>/Reports.
When I access Reports, it prompts me to enter username/password. Even after specifying valid username, it shows me the prompt again n again.
Is there some known issue with Reporting Service or with IIS setting not able to connect to a DNS name? I did not face with any issue when
I specified DNS name in the connection string of Analysis Service project.
Did anyone encountered DNS related problem with SQL Server 2005 Reporting Service?
We also verified that:
1: Ping with both machine name and DNS name returns same result.
2: nslookup with both machine name and DNS name resolves to same IP.
3: Tried putting the DNS name in the hosts file.
Eagerly awaiting some positive reply.
Note: I am working with SQL Server 2005 Standard Edition.
No replies yet
We are stuck up with this issue since quite some time.
still waiting for some positive inputs.
|||After doing some investigation, I have found that the issue is with Analysis server not able to connect using the DNS name (Note: my Reporting Service proj is connecting to Analysis services datasource). When I connect to Analysis server through SQL Server management studio (by def which uses Win authentication), and specify machine name (ABC) in Server then it connects but if I give DNS name (XYZ.PWR.COM) it gives me the following error:
************************************************************************************************************
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)
Program Location:
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
===================================
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
Program Location:
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()
************************************************************************************************************
If I connect to Reporting Service using DNS name then I get the following error:
************************************************************************************************************
===================================
Cannot connect to XYZ.PWR.COM.
===================================
A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using a report server URL for the Server name, or if the Distributed COM Users group exists on the remote computer, verify that you are a member. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
************************************************************************************************************
When I ping with machine name (ABC) and DNS name (XYZ.PWR.COM), both resolves to the same IP.
C:\Documents and Settings\Administrator>ping ABC
Pinging ABC.corp.abctech.com [xx.x.xx.xx] with 32 bytes of d
C:\Documents and Settings\Administrator>ping XYZ.PWR.COM
Pinging XYZ.PWR.COM [xx.x.xx.xx] with 32 bytes of data:
Is this problem because of the kerberos authentication that Analysis server uses to authenticate?
I am able to connect to the Database engine using DNS name (but using SQL Server authentication).
Also I was able to view the reportserver and reports page by changing the IIS authentication to NTLM.
But finally I am not able to view the reports.
Can anyone please help me in solving this issue.
Awatiitng some positive reply.
Report connection fails with DNS name
Hi,
I am facing problem while setting connection string in Report Service project.
Problem is when I specify DNS name instead of machine name as the Server in the connection string.
When I specify DNS name in the connection string it gives error that "A connection cannot be made.Ensure that the server is running" on click of "Test Connection"
Also I am not able to view reports directly through IE. I.e. http://<DNS_NAME>/Reports.
When I access Reports, it prompts me to enter username/password. Even after specifying valid username, it shows me the prompt again n again.
Is there some known issue with Reporting Service or with IIS setting not able to connect to a DNS name? I did not face with any issue when
I specified DNS name in the connection string of Analysis Service project.
Did anyone encountered DNS related problem with SQL Server 2005 Reporting Service?
We also verified that:
1: Ping with both machine name and DNS name returns same result.
2: nslookup with both machine name and DNS name resolves to same IP.
3: Tried putting the DNS name in the hosts file.
Eagerly awaiting some positive reply.
Note: I am working with SQL Server 2005 Standard Edition.
No replies yet
We are stuck up with this issue since quite some time.
still waiting for some positive inputs.
|||After doing some investigation, I have found that the issue is with Analysis server not able to connect using the DNS name (Note: my Reporting Service proj is connecting to Analysis services datasource). When I connect to Analysis server through SQL Server management studio (by def which uses Win authentication), and specify machine name (ABC) in Server then it connects but if I give DNS name (XYZ.PWR.COM) it gives me the following error:
************************************************************************************************************
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)
Program Location:
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
===================================
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
Program Location:
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()
************************************************************************************************************
If I connect to Reporting Service using DNS name then I get the following error:
************************************************************************************************************
===================================
Cannot connect to XYZ.PWR.COM.
===================================
A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using a report server URL for the Server name, or if the Distributed COM Users group exists on the remote computer, verify that you are a member. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
************************************************************************************************************
When I ping with machine name (ABC) and DNS name (XYZ.PWR.COM), both resolves to the same IP.
C:\Documents and Settings\Administrator>ping ABC
Pinging ABC.corp.abctech.com [xx.x.xx.xx] with 32 bytes of d
C:\Documents and Settings\Administrator>ping XYZ.PWR.COM
Pinging XYZ.PWR.COM [xx.x.xx.xx] with 32 bytes of data:
Is this problem because of the kerberos authentication that Analysis server uses to authenticate?
I am able to connect to the Database engine using DNS name (but using SQL Server authentication).
Also I was able to view the reportserver and reports page by changing the IIS authentication to NTLM.
But finally I am not able to view the reports.
Can anyone please help me in solving this issue.
Awatiitng some positive reply.
Tuesday, March 20, 2012
Report Builder Formatting Currency
Hi all
I need Report Builder to format Certain Numbers
as Currency by default. According to the documentation
I need to set the culture setting in the report's datasource.
I'm using a SSAS2005 Cube
The Report Manager then let's me create the Model wich is used
by Report Builder.
My Question is: Where do I set the culture setting?
I cannot find it in the Cube and viewing the model's xml hasn't helped.
Any help will be dearly appreciated
G
under format in properties of the textbox
change it to
$ ###, ###, ###.##
|||Thanks X
But I know how to format the textbox.
The problem is that I want my measures to default to
currency format like this: (R #,##.##0.00;R (#,##.##)0.00;R ##.#0)
when added to the table/matrix
The docementation for Report Builder says that it can be
done by setting the "Culture" Setting on the Datasource.?
They dont give any other specifics
Thanks for the responce
G
|||maybe set it in Connection String ?
Data Source=myServer;Initial Catalog=myDatabase;Current Language=en-us
|||Hi
No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.
Still stuck
G
|||GDavids - SAO wrote:
No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.
report model have Datasources link in Properties
Datasource have connection string ;]
|||thanks giret
Where do I view this?
In Report Manager? Because I dont find it..
Thanks for the reponces
|||http://localhost/Reports/
click on Your model name
Properties Tab:
General
DataSources
Security
|||This gives the path to my datasource.
Does this mean that I have to set the connection string for
that datasource that the path from the model refers to?
Report Builder Formatting Currency
Hi all
I need Report Builder to format Certain Numbers
as Currency by default. According to the documentation
I need to set the culture setting in the report's datasource.
I'm using a SSAS2005 Cube
The Report Manager then let's me create the Model wich is used
by Report Builder.
My Question is: Where do I set the culture setting?
I cannot find it in the Cube and viewing the model's xml hasn't helped.
Any help will be dearly appreciated
G
under format in properties of the textbox
change it to
$ ###, ###, ###.##
|||Thanks X
But I know how to format the textbox.
The problem is that I want my measures to default to
currency format like this: (R #,##.##0.00;R (#,##.##)0.00;R ##.#0)
when added to the table/matrix
The docementation for Report Builder says that it can be
done by setting the "Culture" Setting on the Datasource.?
They dont give any other specifics
Thanks for the responce
G
|||maybe set it in Connection String ?
Data Source=myServer;Initial Catalog=myDatabase;Current Language=en-us
|||Hi
No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.
Still stuck
G
|||GDavids - SAO wrote:
No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.
report model have Datasources link in Properties
Datasource have connection string ;]
|||thanks giret
Where do I view this?
In Report Manager? Because I dont find it..
Thanks for the reponces
|||http://localhost/Reports/
click on Your model name
Properties Tab:
General
DataSources
Security
|||This gives the path to my datasource.
Does this mean that I have to set the connection string for
that datasource that the path from the model refers to?