OLAP Connectivity

Hello all,

We have Analysis Services 2000 with an OLAP cube. The cube has a role allowing access to all Windows domain users. From my development workstation we can connect to the cube, using Excel or a HTML page with the Office Web component, logged on as any user. However, from any other computer in the domain, and logged on with the same users, we cannot create a connection; the OLAP server is not visible!

The client computers are all the same: Windows 2000 Pro and the users all belong to the domain.

Why can we not connect? Has anybody ever experienced this sort of problem? We need to solve this by Monday, our deadline to show our OLAP application to the users. I would really appreciate somebody's help.

Thanks in advance,

Jerome Smith

Have all other workstations pivot table services installed, that is the local client that SSAS 2000 requires? It muste be the same version(service pack) as the server.

It is not sufficient with Excel installed on each client, you also need pivot table services.

You can download this add in for Excel: http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

HTH

Thomas Ivarsson

|||

Hello Thomas,

I thought that PTS was included in Office. At least that's what the manual for the MS-2074 course says, and I have always been able to connect to Analysis Servers from Excel and FrontPage, and in different companies.

The download you referred me to is actually not PTS but the Excel Add-In for Analysis Services, which affords enhanced functionality but does not solve the problem.

What I really need to do is connect to the OLAP cube from a HTML page with the OLAP web component, included in Office and also in FrontPage.

Thank you for your time.

Regards,

Jerome Smith

|||

Like I have told you earlier, PTS is not installed by default. Install it on the machines that do not work and see if this helps.

The download of the Excel add in will include PTS.

If you are trying to do a http-connection then it is a different story. Office web components are ActiveX and do not use http by default.

Regards

Thomas Ivarsson

|||

OK Thomas,

I'll try this.

Thanks,

Jerome

|||

Good luck. If this is not the problem return with more information and we can continue with other causes.

Regards

Thomas Ivarsson

|||

Hi Thomas,

Well, actually I managed to deploy the application on almost all client PCs WITHOUT installing PTS. Just as I thought, PTS comes included with Office, so it is almost never necessary to install PTS.

The problem was never solved on some developer's notebooks in the IT department; we couldn't connect to the AS Server, no matter what we did (including installing the Add-In from the link you gave me).

It beats me why. I wish I knew. Any ideas?

Jerome

sql

OLAP connection problems

I have two systems setup with SQL Server 2000 + Analysis Services. Both servers have been patched with both SP3a patches.

I wrote a trivial command line app that tests connection strings through ADO.

On each system, I can connect locally perfectly using the connection string:
"Provider=MSOLAP;Data Source=localhost;Initial Catalog=FoodMart 2000"

However, once I change "Data Source" to refer to the other system, the call to ADODB.Connection.Open throws a "System.Runtime.InteropServices.COMException" with message: "Unspecified error". (The simple app is written in C# and talks to ADO through Interop)

I've tried referencing ADO 2.1, ADO 2.5 and ADO 2.7
I've tried a "Provider" of "MSOLAP.2" as well as just "MSOLAP"
I've also tried a variety of different connection strings with many different permissions settings.

It is very frustrating to get an absolutely generic error message.

Any ideas?

Thanks in advance!Have you tried adding "User ID=xxx;Password=xxx"

or

"Integrated Security=SSPI"|||Yes, just retried all of them and they all result in the same System.Runtime.InteropServices.COMException, "Unspecified error"

adomdtest "Provider=MSOLAP;Data Source=localhost;Initial Catalog=FoodMart 2000"
adomdtest "Provider=MSOLAP;Data Source=192.168.128.53;Initial Catalog=FoodMart 2000"
adomdtest "Provider=MSOLAP;Data Source=192.168.128.53;Integrated Security=SSPI;Initial Catalog=FoodMart 2000"
adomdtest "Provider=MSOLAP;Data Source=192.168.128.53;User Id=sa;Password=xxxx;Initial Catalog=FoodMart 2000"|||Let me reclarify. This one works fine:

adomdtest "Provider=MSOLAP;Data Source=localhost;Initial Catalog=FoodMart 2000"

These (that reference another system) fail with System.Runtime.InteropServices.COMException, "Unspecified error":

adomdtest "Provider=MSOLAP;Data Source=192.168.128.53;Initial Catalog=FoodMart 2000"
adomdtest "Provider=MSOLAP;Data Source=192.168.128.53;Integrated Security=SSPI;Initial Catalog=FoodMart 2000"
adomdtest "Provider=MSOLAP;Data Source=192.168.128.53;User Id=sa;Password=xxxx;Initial Catalog=FoodMart 2000"

I experience the same effect from two systems; either system can open its own database but can't open a remote one.|||Can't think of anything here...Maybe these links can give you some ideas?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/agtroubleshoot_8wfm.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/agtroubleshoot_64fb.asp

OLAP Cluster SQL 2005

Hi dear friends,
I must to install an cluster active-active on SQL Server 2005 with reporting
services and analysis services, can any one help me with references to do it
or links about how do it?.
I know that is no possible to do under SQL 2000 cluster.
A lot of thanks in advange
Clustering Documents
Original SS2K:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
Updated SS2K5:
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
http://msdn2.microsoft.com/en-us/library/ms143736.aspx
http://msdn2.microsoft.com/en-us/library/ms157293.aspx
Sincerely,
Anthony Thomas

"WalidSQL2k5" <WalidSQL2k5@.discussions.microsoft.com> wrote in message
news:E4ACCF02-33F8-4B80-9896-978D78854B49@.microsoft.com...
> Hi dear friends,
> I must to install an cluster active-active on SQL Server 2005 with
reporting
> services and analysis services, can any one help me with references to do
it
> or links about how do it?.
> I know that is no possible to do under SQL 2000 cluster.
> A lot of thanks in advange
>
|||I'm sorry; and for SS2K Analysis Service (yes; you can).
http://support.microsoft.com/kb/308023
Anthony Thomas

"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:OwQHuEGOHHA.536@.TK2MSFTNGP02.phx.gbl...
> Clustering Documents
> Original SS2K:
>
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
> Updated SS2K5:
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en[vbcol=seagreen]
> http://msdn2.microsoft.com/en-us/library/ms143736.aspx
> http://msdn2.microsoft.com/en-us/library/ms157293.aspx
> Sincerely,
>
> Anthony Thomas
>
> --
> "WalidSQL2k5" <WalidSQL2k5@.discussions.microsoft.com> wrote in message
> news:E4ACCF02-33F8-4B80-9896-978D78854B49@.microsoft.com...
> reporting
do
> it
>
|||Dear Anthony,
A lot of thanks i thing is more simple to install in this case than SQL
2000.
Best Regards
"Anthony Thomas" wrote:

> I'm sorry; and for SS2K Analysis Service (yes; you can).
> http://support.microsoft.com/kb/308023
>
> Anthony Thomas
>
> --
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:OwQHuEGOHHA.536@.TK2MSFTNGP02.phx.gbl...
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
> do
>
>
|||Yes, quite a bit actually, but it is still doable, kind of like clustering
SQL Server on 6.5 or 7.0.
Anthony Thomas

"WalidSQL2k5" <WalidSQL2k5@.discussions.microsoft.com> wrote in message
news:5BD4CE2B-E878-4329-90F4-30E300059F61@.microsoft.com...[vbcol=seagreen]
> Dear Anthony,
> A lot of thanks i thing is more simple to install in this case than SQL
> 2000.
> --
> Best Regards
>
> "Anthony Thomas" wrote:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx[vbcol=seagreen]
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx[vbcol=seagreen]
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en[vbcol=seagreen]
to[vbcol=seagreen]
sql

OLAP Client

Upgrading to Analysis Services 2005 has put me in difficult position because of lack of good client from Microsoft and using Excel 2002/2003.

We are small shop and use Excel (Pivot Table) big time as client tool. We upgraded to Analysis Services 2005 and we all know on server side it helped a lot.

BUT, I was expecting Excel 2002/2003 to work "at least same" even it can not use new stuff in 2005. What's killing now is Excel 2002/2003 Pivot Table client using Analysis Services 2005 on server "Not able to display Measure Names in alphabetical order" - Big problem for users.

Upgrading to Excel 2007 is not easy at least let me put this way Upgrading to Analysis Services 2005 and Excel 2007 same time is not possible. It's a very big project with big risk if you are in financial company. It worse for us because we still use windows 2000 so upgrade OS for what? cube access.

Now what. Think about buying new client with one of these companies BO/Crystal, ProClarity etc. is also hard choice because it's not Excel and hard to sell to business group to pay for it when you ask for ......

one of the big business guy asked me yesterday "Can we go back to Analysis Services 2000 because I don't know what you got in Server but it's not giving me what I had before...."

what you will do?

- Ashok

Hello. This add in for older versions of Excel(2002 and 2003) might help:

http://www.microsoft.com/downloads/details.aspx?familyid=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

HTH

Thomas Ivarsson

|||

Hi Thomas,

As I was typing my question I knew this coming as first reply. This is not very helpful Add-in and just wandering any one using this in production let me know.

As you visit page first line you see this -

Microsoft does not provide any support for this solution accelerator and has no plans to release future versions. This add-in is not designed to work with with Office 2007.

That's ok

The number one reason to move to Analysis Services 2005 is to takeoff load from client. Remember when you run large query from client to Analysis Services 2000 your whole machine hang for some time. With excel "Cube Analysis" I don't know technologies behind but it's slow and uses client side memory. If you run large query and like to cancel (Esc key), you can not.

Interface is hard to use. Not looking for too much but mainly it's slow and using client memory.

One thing can help me if any one knows if this is possible. If it is possible to write VB code/macro which can run when excel file gets open and change the order in pivot table cube field list using Office APIs. Not looking for code just yes or no.

Thank you - Ashok

|||The Excel Add-in for Analysis Services is a good work around until you upgrade to Office 2007. There is no need for this tool in Office 2007 because PivotTable features in 2007 have been enhanced to include all the functionality that the Excel Add-In for Analysis Services includes. If you're thinking of using VB macros, I think it's a very bad road to take. You would be much better off using Reporting Services directly against the cube.|||

Thanks Martin. I understand using Add-in is good choice for now. Only issue I have with that it is taking client side memory and it will slow down not only cube query whole users box while they are using cube.

Reporting Services I can use what are the options we have in Reporting services to expose cube to end users? I know OLAP can be one data source to reporting services but then we need to design flat reports. Is there any control which allow users can drag drop fields and see data. I know about ReportBuilder.

Thanks again - Ashok

|||

Hi Ashok,

I wouldn't think that the Add-In would use more client-side memory than PivotTable services but I can't say I've done an exhaustive study either. ReportBuilder is another option but limited. If you have measure groups that are associated to dimensions at non-leaf levels, it likely won't be your solution. Additionally, users will only be able to construct reports using measures from a single measure group at a time so the produced reports are going to have to be simple. If your user's reporting requirements aren't complex, it's a good approach and very easy to implement and I'd recommend it.

|||

Thank's Martin for the comments.

Ashok, the add-in is a close you can get to the interface in Excel2007. It is not perfect but it works.

You can also choose to upgrade only the OLEDB-provider from 8 to 9 and use Excel2003 pivot tables. It will not look good but it will work.

If you choose to stay with older versions of clients you are left with that choice.

I have no advice of a cheap add-in for Excel that will solve your problem.

HTH

Thomas Ivarsson

|||

It may sound funny but it helped my cube users, when they really don't want any major change in the way they use current excel 2002/2003. so I had to find solution some thing they can accept.

I stored all my Analysis Services 2005 cubes measures from different measures groups in one xml file and created an excel form. Understanding all limitation in this way and giving some thing that can help cube users, trade off worked for this solution.

They have original Pivot table Field List to get Dimensions and for measures they open this excel form and get measures in much easy way. This is helping because we have over 200 measures.

Private Sub CommandButton1_Click()
'Try
For l = 1 To ListBox1.ListCount - 1
If ListBox1.Selected(l) = True Then
ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _
"PivotTable1").CubeFields("[Measures].[" & ListBox1.List(l) & "]"), ListBox1.List(l)
'MsgBox (ListBox1.List(l))
End If
Next l
'Catch ex As Exception
'MsgBox ("Error in getting records: " + ex.Message)

End Sub

Private Sub TextBox1_Change()
For l = 1 To ListBox1.ListCount - 1
If UCase(ListBox1.List(l)) = UCase(TextBox1.Text) Then
ListBox1.Selected(l) = True
Else
ListBox1.Selected(l) = False
End If
Next l
End Sub

Private Sub UserForm_Initialize()
Dim oXML As Object, oXSL As Object
Set oXML = CreateObject("MSXML.DOMDocument")
oXML.Load "T:\IT\Cubes\CubeMeasures.xml"
Dim t As String
For Counter = 1 To oXML.documentElement.childNodes.Length - 1
ListBox1.AddItem (oXML.documentElement.childNodes.Item(Counter).Text)
Next Counter
ListBox1.MultiSelect = fmMultiSelectExtended
End Sub

T:\IT\Cubes\CubeMeasures.xml File

<All>
<MeasureName>Measure 1</MeasureName>
<MeasureName>Measure 2</MeasureName>
<MeasureName>Measure 3</MeasureName>
<MeasureName>Measure 4</MeasureName>
</All>

OLAP Client

Upgrading to Analysis Services 2005 has put me in difficult position because of lack of good client from Microsoft and using Excel 2002/2003.

We are small shop and use Excel (Pivot Table) big time as client tool. We upgraded to Analysis Services 2005 and we all know on server side it helped a lot.

BUT, I was expecting Excel 2002/2003 to work "at least same" even it can not use new stuff in 2005. What's killing now is Excel 2002/2003 Pivot Table client using Analysis Services 2005 on server "Not able to display Measure Names in alphabetical order" - Big problem for users.

Upgrading to Excel 2007 is not easy at least let me put this way Upgrading to Analysis Services 2005 and Excel 2007 same time is not possible. It's a very big project with big risk if you are in financial company. It worse for us because we still use windows 2000 so upgrade OS for what? cube access.

Now what. Think about buying new client with one of these companies BO/Crystal, ProClarity etc. is also hard choice because it's not Excel and hard to sell to business group to pay for it when you ask for ......

one of the big business guy asked me yesterday "Can we go back to Analysis Services 2000 because I don't know what you got in Server but it's not giving me what I had before...."

what you will do?

- Ashok

Hello. This add in for older versions of Excel(2002 and 2003) might help:

http://www.microsoft.com/downloads/details.aspx?familyid=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

HTH

Thomas Ivarsson

|||

Hi Thomas,

As I was typing my question I knew this coming as first reply. This is not very helpful Add-in and just wandering any one using this in production let me know.

As you visit page first line you see this -

Microsoft does not provide any support for this solution accelerator and has no plans to release future versions. This add-in is not designed to work with with Office 2007.

That's ok

The number one reason to move to Analysis Services 2005 is to takeoff load from client. Remember when you run large query from client to Analysis Services 2000 your whole machine hang for some time. With excel "Cube Analysis" I don't know technologies behind but it's slow and uses client side memory. If you run large query and like to cancel (Esc key), you can not.

Interface is hard to use. Not looking for too much but mainly it's slow and using client memory.

One thing can help me if any one knows if this is possible. If it is possible to write VB code/macro which can run when excel file gets open and change the order in pivot table cube field list using Office APIs. Not looking for code just yes or no.

Thank you - Ashok

|||The Excel Add-in for Analysis Services is a good work around until you upgrade to Office 2007. There is no need for this tool in Office 2007 because PivotTable features in 2007 have been enhanced to include all the functionality that the Excel Add-In for Analysis Services includes. If you're thinking of using VB macros, I think it's a very bad road to take. You would be much better off using Reporting Services directly against the cube.|||

Thanks Martin. I understand using Add-in is good choice for now. Only issue I have with that it is taking client side memory and it will slow down not only cube query whole users box while they are using cube.

Reporting Services I can use what are the options we have in Reporting services to expose cube to end users? I know OLAP can be one data source to reporting services but then we need to design flat reports. Is there any control which allow users can drag drop fields and see data. I know about ReportBuilder.

Thanks again - Ashok

|||

Hi Ashok,

I wouldn't think that the Add-In would use more client-side memory than PivotTable services but I can't say I've done an exhaustive study either. ReportBuilder is another option but limited. If you have measure groups that are associated to dimensions at non-leaf levels, it likely won't be your solution. Additionally, users will only be able to construct reports using measures from a single measure group at a time so the produced reports are going to have to be simple. If your user's reporting requirements aren't complex, it's a good approach and very easy to implement and I'd recommend it.

|||

Thank's Martin for the comments.

Ashok, the add-in is a close you can get to the interface in Excel2007. It is not perfect but it works.

You can also choose to upgrade only the OLEDB-provider from 8 to 9 and use Excel2003 pivot tables. It will not look good but it will work.

If you choose to stay with older versions of clients you are left with that choice.

I have no advice of a cheap add-in for Excel that will solve your problem.

HTH

Thomas Ivarsson

|||

It may sound funny but it helped my cube users, when they really don't want any major change in the way they use current excel 2002/2003. so I had to find solution some thing they can accept.

I stored all my Analysis Services 2005 cubes measures from different measures groups in one xml file and created an excel form. Understanding all limitation in this way and giving some thing that can help cube users, trade off worked for this solution.

They have original Pivot table Field List to get Dimensions and for measures they open this excel form and get measures in much easy way. This is helping because we have over 200 measures.

Private Sub CommandButton1_Click()
'Try
For l = 1 To ListBox1.ListCount - 1
If ListBox1.Selected(l) = True Then
ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _
"PivotTable1").CubeFields("[Measures].[" & ListBox1.List(l) & "]"), ListBox1.List(l)
'MsgBox (ListBox1.List(l))
End If
Next l
'Catch ex As Exception
'MsgBox ("Error in getting records: " + ex.Message)

End Sub

Private Sub TextBox1_Change()
For l = 1 To ListBox1.ListCount - 1
If UCase(ListBox1.List(l)) = UCase(TextBox1.Text) Then
ListBox1.Selected(l) = True
Else
ListBox1.Selected(l) = False
End If
Next l
End Sub

Private Sub UserForm_Initialize()
Dim oXML As Object, oXSL As Object
Set oXML = CreateObject("MSXML.DOMDocument")
oXML.Load "T:\IT\Cubes\CubeMeasures.xml"
Dim t As String
For Counter = 1 To oXML.documentElement.childNodes.Length - 1
ListBox1.AddItem (oXML.documentElement.childNodes.Item(Counter).Text)
Next Counter
ListBox1.MultiSelect = fmMultiSelectExtended
End Sub

T:\IT\Cubes\CubeMeasures.xml File

<All>
<MeasureName>Measure 1</MeasureName>
<MeasureName>Measure 2</MeasureName>
<MeasureName>Measure 3</MeasureName>
<MeasureName>Measure 4</MeasureName>
</All>

OLAP based reports not rendering

I hope someone with a bit of knowledge about Analysis Services and Reporting
Services can give me some help here, please.
A client has the following setup:
One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services sp
2 and IIS 5.
One Windows 2003 server running Analysis Services sp 3.
--
1 role has been created in AS, with full access to everything. This is an AD
group, and we've tried adding all sorts of AD users to this group, to give
them access to the cube. We haven't tried adding "Everyone" and given it
full access.
--
When developing reports, we can access the OLAP cube with the usual NT login
of the developer. The report report renders perfectly on the dev box.
In Report Manager, reports based on SQL Server queries works perfectly.
Reports based on OLAP will work when run on the server running Reporing
Services, but NO OTHER computer. So when we access the Reporing Services
server with Remote Desktop, the OLAP report will render. From any other
computer, all in the same domain, it won't work.
The error message we get is basically "Cannot create a connection to data
source '<our datasource>'". But the "explanation" varies depending on what
user we try to use in our connection settings. The most common was "Database
'<our database>' could not be found." The other one was "Unknown error
E_(bunch of characters)".
So... any suggestions? I've found posts from other people who seem to have
had the same problem as ours, but no solution. We haven't figured out where
the problem is. Is it the credentials sent from Internet Explorer? Is it the
identity used in the connection string? Is it a new bug in SP 2? Reporting
Services has just been installed, and SP2 was installed immedeately. We
don't know if it would have worked without SP2, and I guess we won't find
out.
All help is really appreciated on this one!
Yours,
Kaisa M. Lindahloh yes please - we are having the same problems and noone seems to be able
to help !!!!
Please can someone help ?
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:OqAZtwYbFHA.3240@.TK2MSFTNGP12.phx.gbl...
>I hope someone with a bit of knowledge about Analysis Services and
>Reporting Services can give me some help here, please.
> A client has the following setup:
> One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services
> sp 2 and IIS 5.
> One Windows 2003 server running Analysis Services sp 3.
> --
> 1 role has been created in AS, with full access to everything. This is an
> AD group, and we've tried adding all sorts of AD users to this group, to
> give them access to the cube. We haven't tried adding "Everyone" and given
> it full access.
> --
> When developing reports, we can access the OLAP cube with the usual NT
> login of the developer. The report report renders perfectly on the dev
> box.
> In Report Manager, reports based on SQL Server queries works perfectly.
> Reports based on OLAP will work when run on the server running Reporing
> Services, but NO OTHER computer. So when we access the Reporing Services
> server with Remote Desktop, the OLAP report will render. From any other
> computer, all in the same domain, it won't work.
> The error message we get is basically "Cannot create a connection to data
> source '<our datasource>'". But the "explanation" varies depending on what
> user we try to use in our connection settings. The most common was
> "Database '<our database>' could not be found." The other one was "Unknown
> error E_(bunch of characters)".
> So... any suggestions? I've found posts from other people who seem to have
> had the same problem as ours, but no solution. We haven't figured out
> where the problem is. Is it the credentials sent from Internet Explorer?
> Is it the identity used in the connection string? Is it a new bug in SP 2?
> Reporting Services has just been installed, and SP2 was installed
> immedeately. We don't know if it would have worked without SP2, and I
> guess we won't find out.
> All help is really appreciated on this one!
> Yours,
> Kaisa M. Lindahl
>|||Provider=MSOLAP.2;Client Cache Size=25;Data
Source=myOLAPServer;SSPI=Kerberos;Initial Catalog=myOLAPDB;Auto Synch
Period=20000
Look into setting up Kerberos/trust betweent he servers and check the
connection string above "Kerberos"
--
Gary Foster
"Kathy" wrote:
> oh yes please - we are having the same problems and noone seems to be able
> to help !!!!
> Please can someone help ?
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> news:OqAZtwYbFHA.3240@.TK2MSFTNGP12.phx.gbl...
> >I hope someone with a bit of knowledge about Analysis Services and
> >Reporting Services can give me some help here, please.
> >
> > A client has the following setup:
> >
> > One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services
> > sp 2 and IIS 5.
> >
> > One Windows 2003 server running Analysis Services sp 3.
> > --
> > 1 role has been created in AS, with full access to everything. This is an
> > AD group, and we've tried adding all sorts of AD users to this group, to
> > give them access to the cube. We haven't tried adding "Everyone" and given
> > it full access.
> > --
> >
> > When developing reports, we can access the OLAP cube with the usual NT
> > login of the developer. The report report renders perfectly on the dev
> > box.
> > In Report Manager, reports based on SQL Server queries works perfectly.
> > Reports based on OLAP will work when run on the server running Reporing
> > Services, but NO OTHER computer. So when we access the Reporing Services
> > server with Remote Desktop, the OLAP report will render. From any other
> > computer, all in the same domain, it won't work.
> >
> > The error message we get is basically "Cannot create a connection to data
> > source '<our datasource>'". But the "explanation" varies depending on what
> > user we try to use in our connection settings. The most common was
> > "Database '<our database>' could not be found." The other one was "Unknown
> > error E_(bunch of characters)".
> >
> > So... any suggestions? I've found posts from other people who seem to have
> > had the same problem as ours, but no solution. We haven't figured out
> > where the problem is. Is it the credentials sent from Internet Explorer?
> > Is it the identity used in the connection string? Is it a new bug in SP 2?
> > Reporting Services has just been installed, and SP2 was installed
> > immedeately. We don't know if it would have worked without SP2, and I
> > guess we won't find out.
> >
> > All help is really appreciated on this one!
> >
> > Yours,
> >
> > Kaisa M. Lindahl
> >
>
>|||For our reports that use Analysis Services we had to do the following.
First, we ended up was using a single domain account hard-coded in the
data-link properties for the datasource. This account must have at least a
read-only role on the AS box in Analysis Manager. We were not allowed to use
Kerberos delegation as out SA team thought it was a security reisk on AD2k.
We may go this route once they have upgraded to AD2k3 as that release is
supposed to have the ability to provide scope limited Kerberos delegation.
Anyway, from here, it seemed like it would work. Our users are given access
or not based on their domain accounts being in a group ReportingServices on
the Report Server machine. What we found though was this still did not work.
Finally we found that after every deploy, we always have to go to the
web-based report manager, find the datasource that points to AS and check the
box "Use as Windows credentials when connecting to the data source" and then
retype the password and apply. After this our reports worked fine. Be aware
that this check box gets unchecked each time you deploy. I have not found
any other workaround. If you do, please let me know.
Hope this helps.
"garyf@.someone.com" wrote:
> Provider=MSOLAP.2;Client Cache Size=25;Data
> Source=myOLAPServer;SSPI=Kerberos;Initial Catalog=myOLAPDB;Auto Synch
> Period=20000
> Look into setting up Kerberos/trust betweent he servers and check the
> connection string above "Kerberos"
> --
> Gary Foster
>
> "Kathy" wrote:
> > oh yes please - we are having the same problems and noone seems to be able
> > to help !!!!
> > Please can someone help ?
> >
> >
> > "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> > news:OqAZtwYbFHA.3240@.TK2MSFTNGP12.phx.gbl...
> > >I hope someone with a bit of knowledge about Analysis Services and
> > >Reporting Services can give me some help here, please.
> > >
> > > A client has the following setup:
> > >
> > > One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services
> > > sp 2 and IIS 5.
> > >
> > > One Windows 2003 server running Analysis Services sp 3.
> > > --
> > > 1 role has been created in AS, with full access to everything. This is an
> > > AD group, and we've tried adding all sorts of AD users to this group, to
> > > give them access to the cube. We haven't tried adding "Everyone" and given
> > > it full access.
> > > --
> > >
> > > When developing reports, we can access the OLAP cube with the usual NT
> > > login of the developer. The report report renders perfectly on the dev
> > > box.
> > > In Report Manager, reports based on SQL Server queries works perfectly.
> > > Reports based on OLAP will work when run on the server running Reporing
> > > Services, but NO OTHER computer. So when we access the Reporing Services
> > > server with Remote Desktop, the OLAP report will render. From any other
> > > computer, all in the same domain, it won't work.
> > >
> > > The error message we get is basically "Cannot create a connection to data
> > > source '<our datasource>'". But the "explanation" varies depending on what
> > > user we try to use in our connection settings. The most common was
> > > "Database '<our database>' could not be found." The other one was "Unknown
> > > error E_(bunch of characters)".
> > >
> > > So... any suggestions? I've found posts from other people who seem to have
> > > had the same problem as ours, but no solution. We haven't figured out
> > > where the problem is. Is it the credentials sent from Internet Explorer?
> > > Is it the identity used in the connection string? Is it a new bug in SP 2?
> > > Reporting Services has just been installed, and SP2 was installed
> > > immedeately. We don't know if it would have worked without SP2, and I
> > > guess we won't find out.
> > >
> > > All help is really appreciated on this one!
> > >
> > > Yours,
> > >
> > > Kaisa M. Lindahl
> > >
> >
> >
> >sql

OLAP Analysis Services: Errors in Encryption Library

Hi!

I am trying to process a cube in analysis services of visual studio
2005, with sql server 2005. The error is:

"Errors in the encryption library: Failed to encrypt sensitive data.
Possibly the encryption key is inaccessible because of improper service
account change."

Thanks in advance,

--Dimitris Doukas

You might have changed the account for your Analysis Server service.

To solve this problem you will have to stop Analysis Server. Remove all the files from the Data folder ( located under installation folder) and then start Analysis Server again.

Create a backup for your existing databases before doing that in case you cannot re-process them.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

It worked. Thanks a lot.

--Dimitris

OLAP Analysis Services - Remote Connection issue

Hi!

does anybody tell me how to connect remotely to an OLAP Analysis Server?

I have defined a local windows account on the OLAP server and added it to AS cube roles.

Despite that I still can't connect remotely to the AS server.

Thanks,

Chris

If this is about connecting with SQL Management Studio (or BI Development Studio) to Analysis Services 2005:

- you need to have a Windows account in the domain of the 2 machines (the AS2005 machine and the client machine from where you want to connect remotely)

- temporarily make the user a server administrator on the AS2005 (to eliminate the potential permission problems); you can do this with SQL Management Studio, right click on the server item -> Properties -> Security

- run SQL Management Studio on the client machine as that user ("Run As..." should be fine, no need to login to Windows as that user)

- if the connection fails, then please check the firewall(s), allow incoming connections for msmdsrv.exe (the AS2005 server)

- if the connection succeeds, then downgrade the user from server administrator; it is enough to grant read definition permission for the database intended; to do this, run SQL Management Studio from an AS2005 admin account and then add the user as a member of the database role

Adrian Dumitrascu

OLAP / Analysis services version checking by client

The problem is that i would like to integrate a code to the file in net where MS Office Web Components and OLAP services are beeing used.
Code should automatically detect a version of olap client and office web service components (OWC) and if newer version is needed, then it should download it.
Good instructions were @. http://support.microsoft.com/default.aspx?scid=kb;en-us;312876
where ptssetup.exe included all necessary information, but it was applied to Microsoft SQL Server 2000 Analysis Services. Now what i need to know is how to write a code which is working on Microsoft SQL Server 2005. Or how the old code can be changed to get it work on sql server 2005?

Hello,

I'm going to move your question to one of the SQL Server forums were they should be able to help you.

Daniel Roth

|||

Erkki wrote:

The problem is that i would like to integrate a code to the file in net where MS Office Web Components and OLAP services are beeing used.
Code should automatically detect a version of olap client and office web service components (OWC) and if newer version is needed, then it should download it.
Good instructions were @. http://support.microsoft.com/default.aspx?scid=kb;en-us;312876
where ptssetup.exe included all necessary information, but it was applied to Microsoft SQL Server 2000 Analysis Services. Now what i need to know is how to write a code which is working on Microsoft SQL Server 2005. Or how the old code can be changed to get it work on sql server 2005?

I would like to know that too. Anyway, how is it possible to verify the version of OLAP ? How can it be done? Maybe to somehow connect to server where the olap is being used?

Olap

Hi...

Please, someone knows what is this message:

OLAP Services Processing Task error '8004ffff'
Microsoft SQL Server OLAP Services must be installed on this computer and the user must be an OLAP Administrator in order to create an OLAP processing task.

The OLAP Services are OK, and the User is a OLAP Admin....

Thanks

David.HOw about the SP level on the SQL and OS?
Try to RESTART the OLAP services and see.|||Originally posted by Satya
HOw about the SP level on the SQL and OS?
Try to RESTART the OLAP services and see.

I tried, but don't work. The problem persists.

(Sorry about my english, but I'm not American)|||May refer this OLAP resources (http://groups.msn.com/MicrosoftOLAPServicesUsersCommunity/_homepage.msnw?pgmarket=en-us) for any help.

If nothing found then the only option is to reinstall the OLAP services as specified.

olap

hi,
i need "microsoft(r) sql server(tm) 2000 analysis services step by step" in digital,can you help me ?
shawnlee@.cena.com.cnI don't know of such a beastie. You might try to contact Microsoft Press to see if they can help you, but I think it would be easier to just buy the book than to try to get a digital copy.

-PatP

Ok, Apply buttons not working in Report Manager

This is weird. I have 2 different installs of Reporting Services and both do
nothing when trying to upload a file (rdl, datasource, etc)
Basically, the buttons don't post. This also happens on the apply buttons
in the property pages. Cancel and other buttons work.
I am thinking I need something in my aspnet_client folder that is not there.
I have the 1_1_4322 folder.
Any ideas?Nevermind...This happens if you misconfigure stuff when moving virtual
directories to another site.
"Eric" wrote:
> This is weird. I have 2 different installs of Reporting Services and both do
> nothing when trying to upload a file (rdl, datasource, etc)
> Basically, the buttons don't post. This also happens on the apply buttons
> in the property pages. Cancel and other buttons work.
> I am thinking I need something in my aspnet_client folder that is not there.
> I have the 1_1_4322 folder.
> Any ideas?

OK button not working...

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

I have installed the app, SP2, and a hotfix that is on the website. Help....
What happens when you try to click the OK button, or is it disabled?|||Thanks. The button presses, but doesn't "click". There aren't any tool tips when I mouse over or hover, and the page doesn't change.|||I have tried to reinstall the Reoporting Services app on the server, but after the install was completed, the functions are the same. I cannot use the web page GUI to do anything. I can deploy reports and data connections via Visual Studio, though. I need the web GUI to work too. HELP!|||This sounds like some sort of network issue. Can you access it while logged in on the server? Does http://localhost/reports work? Do you have any special security set in the browser? Does it work from other machines?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same "Ok button" issue. Was this ever resolved?|||I just solved this problem.

For some reason, my aspnet_client/system_web/1_1_4322 directory was missing. In that directory is WebUIValidation.js, a file required by Reporting Services for validation.

To fix it, I just copied the folder from my local IIS installation and now it works perfectly.|||hmm... it could just be the browser you are using. the first time i used reporting services (without reading the requirements specs - who wants to waste time on that kinda ***? ) i was working on mozilla and most of the functionality got disabled. the safest browser to use with reporting services is ie.
|||osubvr

Did you reinstall .net framework or copy file? Has anyone else had this issue?
|||

I have the same issue. Nothing seems to work:

the file is there

reinstalling .Net doesn't bring any good news either.

I even put the physical name in machine.conf in the root of .Net and still nothing

Please Help!

|||I reinstalled .net framework and now the buttons are working again.....weird|||

I deleted even the aspnet_client directory and then simply used aspnet_regiis -i. No error messages. the aspnet_client directory was copied back to inetpub\wwwroot\ but my SQLReportingServices still not working (web interface) ..always asking for his WebUiValidation.js. I'm exasperated.

I have an SBS Premium...I don't know if this makes any change to a normal Server 2003.

|||Miracle..but it works now. The mysteries of computer science...|||

I only have the D:\InetPub\WWWRoot\aspnet_client\system_web\2_0_50727 folder...it does not include any files...should it? I just installed this on a fresh server...

BTW, the other issue is that reports have "X" for the controls...assume its tied to the same issue...

|||

I've run aspnet_regiss -i (and -c) , I still get the same error. The complication might be that the default website points to d:/websites/wwwroot instead of c:/inetpub.

Is there any way to get it to work?

Regards Bert

OK button not working...

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

I have installed the app, SP2, and a hotfix that is on the website. Help....
What happens when you try to click the OK button, or is it disabled?|||Thanks. The button presses, but doesn't "click". There aren't any tool tips when I mouse over or hover, and the page doesn't change.|||I have tried to reinstall the Reoporting Services app on the server, but after the install was completed, the functions are the same. I cannot use the web page GUI to do anything. I can deploy reports and data connections via Visual Studio, though. I need the web GUI to work too. HELP!|||This sounds like some sort of network issue. Can you access it while logged in on the server? Does http://localhost/reports work? Do you have any special security set in the browser? Does it work from other machines?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same "Ok button" issue. Was this ever resolved?|||I just solved this problem.

For some reason, my aspnet_client/system_web/1_1_4322 directory was missing. In that directory is WebUIValidation.js, a file required by Reporting Services for validation.

To fix it, I just copied the folder from my local IIS installation and now it works perfectly.|||hmm... it could just be the browser you are using. the first time i used reporting services (without reading the requirements specs - who wants to waste time on that kinda ***? ) i was working on mozilla and most of the functionality got disabled. the safest browser to use with reporting services is ie.
|||osubvr

Did you reinstall .net framework or copy file? Has anyone else had this issue?
|||

I have the same issue. Nothing seems to work:

the file is there

reinstalling .Net doesn't bring any good news either.

I even put the physical name in machine.conf in the root of .Net and still nothing

Please Help!

|||I reinstalled .net framework and now the buttons are working again.....weird|||

I deleted even the aspnet_client directory and then simply used aspnet_regiis -i. No error messages. the aspnet_client directory was copied back to inetpub\wwwroot\ but my SQLReportingServices still not working (web interface) ..always asking for his WebUiValidation.js. I'm exasperated.

I have an SBS Premium...I don't know if this makes any change to a normal Server 2003.

|||Miracle..but it works now. The mysteries of computer science...|||

I only have the D:\InetPub\WWWRoot\aspnet_client\system_web\2_0_50727 folder...it does not include any files...should it? I just installed this on a fresh server...

BTW, the other issue is that reports have "X" for the controls...assume its tied to the same issue...

|||

I've run aspnet_regiss -i (and -c) , I still get the same error. The complication might be that the default website points to d:/websites/wwwroot instead of c:/inetpub.

Is there any way to get it to work?

Regards Bert

sql

OK button not working...

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

I have installed the app, SP2, and a hotfix that is on the website. Help....
What happens when you try to click the OK button, or is it disabled?|||Thanks. The button presses, but doesn't "click". There aren't any tool tips when I mouse over or hover, and the page doesn't change.|||I have tried to reinstall the Reoporting Services app on the server, but after the install was completed, the functions are the same. I cannot use the web page GUI to do anything. I can deploy reports and data connections via Visual Studio, though. I need the web GUI to work too. HELP!|||This sounds like some sort of network issue. Can you access it while logged in on the server? Does http://localhost/reports work? Do you have any special security set in the browser? Does it work from other machines?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same "Ok button" issue. Was this ever resolved?|||I just solved this problem.

For some reason, my aspnet_client/system_web/1_1_4322 directory was missing. In that directory is WebUIValidation.js, a file required by Reporting Services for validation.

To fix it, I just copied the folder from my local IIS installation and now it works perfectly.|||hmm... it could just be the browser you are using. the first time i used reporting services (without reading the requirements specs - who wants to waste time on that kinda ***? ) i was working on mozilla and most of the functionality got disabled. the safest browser to use with reporting services is ie.
|||osubvr

Did you reinstall .net framework or copy file? Has anyone else had this issue?
|||

I have the same issue. Nothing seems to work:

the file is there

reinstalling .Net doesn't bring any good news either.

I even put the physical name in machine.conf in the root of .Net and still nothing

Please Help!

|||I reinstalled .net framework and now the buttons are working again.....weird|||

I deleted even the aspnet_client directory and then simply used aspnet_regiis -i. No error messages. the aspnet_client directory was copied back to inetpub\wwwroot\ but my SQLReportingServices still not working (web interface) ..always asking for his WebUiValidation.js. I'm exasperated.

I have an SBS Premium...I don't know if this makes any change to a normal Server 2003.

|||Miracle..but it works now. The mysteries of computer science...|||

I only have the D:\InetPub\WWWRoot\aspnet_client\system_web\2_0_50727 folder...it does not include any files...should it? I just installed this on a fresh server...

BTW, the other issue is that reports have "X" for the controls...assume its tied to the same issue...

|||

I've run aspnet_regiss -i (and -c) , I still get the same error. The complication might be that the default website points to d:/websites/wwwroot instead of c:/inetpub.

Is there any way to get it to work?

Regards Bert

OK button not working...

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

I have installed the app, SP2, and a hotfix that is on the website. Help....
What happens when you try to click the OK button, or is it disabled?|||Thanks. The button presses, but doesn't "click". There aren't any tool tips when I mouse over or hover, and the page doesn't change.|||I have tried to reinstall the Reoporting Services app on the server, but after the install was completed, the functions are the same. I cannot use the web page GUI to do anything. I can deploy reports and data connections via Visual Studio, though. I need the web GUI to work too. HELP!|||This sounds like some sort of network issue. Can you access it while logged in on the server? Does http://localhost/reports work? Do you have any special security set in the browser? Does it work from other machines?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same "Ok button" issue. Was this ever resolved?|||I just solved this problem.

For some reason, my aspnet_client/system_web/1_1_4322 directory was missing. In that directory is WebUIValidation.js, a file required by Reporting Services for validation.

To fix it, I just copied the folder from my local IIS installation and now it works perfectly.|||hmm... it could just be the browser you are using. the first time i used reporting services (without reading the requirements specs - who wants to waste time on that kinda ***? ) i was working on mozilla and most of the functionality got disabled. the safest browser to use with reporting services is ie.
|||osubvr

Did you reinstall .net framework or copy file? Has anyone else had this issue?
|||

I have the same issue. Nothing seems to work:

the file is there

reinstalling .Net doesn't bring any good news either.

I even put the physical name in machine.conf in the root of .Net and still nothing

Please Help!

|||I reinstalled .net framework and now the buttons are working again.....weird|||

I deleted even the aspnet_client directory and then simply used aspnet_regiis -i. No error messages. the aspnet_client directory was copied back to inetpub\wwwroot\ but my SQLReportingServices still not working (web interface) ..always asking for his WebUiValidation.js. I'm exasperated.

I have an SBS Premium...I don't know if this makes any change to a normal Server 2003.

|||Miracle..but it works now. The mysteries of computer science...|||

I only have the D:\InetPub\WWWRoot\aspnet_client\system_web\2_0_50727 folder...it does not include any files...should it? I just installed this on a fresh server...

BTW, the other issue is that reports have "X" for the controls...assume its tied to the same issue...

|||

I've run aspnet_regiss -i (and -c) , I still get the same error. The complication might be that the default website points to d:/websites/wwwroot instead of c:/inetpub.

Is there any way to get it to work?

Regards Bert

OK button not working...

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

I have installed the app, SP2, and a hotfix that is on the website. Help....What happens when you try to click the OK button, or is it disabled?|||Thanks. The button presses, but doesn't "click". There aren't any tool tips when I mouse over or hover, and the page doesn't change.|||I have tried to reinstall the Reoporting Services app on the server, but after the install was completed, the functions are the same. I cannot use the web page GUI to do anything. I can deploy reports and data connections via Visual Studio, though. I need the web GUI to work too. HELP!|||This sounds like some sort of network issue. Can you access it while logged in on the server? Does http://localhost/reports work? Do you have any special security set in the browser? Does it work from other machines?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same "Ok button" issue. Was this ever resolved?|||I just solved this problem.

For some reason, my aspnet_client/system_web/1_1_4322 directory was missing. In that directory is WebUIValidation.js, a file required by Reporting Services for validation.

To fix it, I just copied the folder from my local IIS installation and now it works perfectly.|||hmm... it could just be the browser you are using. the first time i used reporting services (without reading the requirements specs - who wants to waste time on that kinda ***? ) i was working on mozilla and most of the functionality got disabled. the safest browser to use with reporting services is ie.|||osubvr

Did you reinstall .net framework or copy file? Has anyone else had this issue?|||

I have the same issue. Nothing seems to work:

the file is there

reinstalling .Net doesn't bring any good news either.

I even put the physical name in machine.conf in the root of .Net and still nothing

Please Help!

|||I reinstalled .net framework and now the buttons are working again.....weird|||

I deleted even the aspnet_client directory and then simply used aspnet_regiis -i. No error messages. the aspnet_client directory was copied back to inetpub\wwwroot\ but my SQLReportingServices still not working (web interface) ..always asking for his WebUiValidation.js. I'm exasperated.

I have an SBS Premium...I don't know if this makes any change to a normal Server 2003.

|||Miracle..but it works now. The mysteries of computer science...|||

I only have the D:\InetPub\WWWRoot\aspnet_client\system_web\2_0_50727 folder...it does not include any files...should it? I just installed this on a fresh server...

BTW, the other issue is that reports have "X" for the controls...assume its tied to the same issue...

|||

I've run aspnet_regiss -i (and -c) , I still get the same error. The complication might be that the default website points to d:/websites/wwwroot instead of c:/inetpub.

Is there any way to get it to work?

Regards Bert

OK button not working...

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

I have installed the app, SP2, and a hotfix that is on the website. Help....
What happens when you try to click the OK button, or is it disabled?|||Thanks. The button presses, but doesn't "click". There aren't any tool tips when I mouse over or hover, and the page doesn't change.|||I have tried to reinstall the Reoporting Services app on the server, but after the install was completed, the functions are the same. I cannot use the web page GUI to do anything. I can deploy reports and data connections via Visual Studio, though. I need the web GUI to work too. HELP!|||This sounds like some sort of network issue. Can you access it while logged in on the server? Does http://localhost/reports work? Do you have any special security set in the browser? Does it work from other machines?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same "Ok button" issue. Was this ever resolved?|||I just solved this problem.

For some reason, my aspnet_client/system_web/1_1_4322 directory was missing. In that directory is WebUIValidation.js, a file required by Reporting Services for validation.

To fix it, I just copied the folder from my local IIS installation and now it works perfectly.|||hmm... it could just be the browser you are using. the first time i used reporting services (without reading the requirements specs - who wants to waste time on that kinda ***? ) i was working on mozilla and most of the functionality got disabled. the safest browser to use with reporting services is ie.
|||osubvr

Did you reinstall .net framework or copy file? Has anyone else had this issue?
|||

I have the same issue. Nothing seems to work:

the file is there

reinstalling .Net doesn't bring any good news either.

I even put the physical name in machine.conf in the root of .Net and still nothing

Please Help!

|||I reinstalled .net framework and now the buttons are working again.....weird|||

I deleted even the aspnet_client directory and then simply used aspnet_regiis -i. No error messages. the aspnet_client directory was copied back to inetpub\wwwroot\ but my SQLReportingServices still not working (web interface) ..always asking for his WebUiValidation.js. I'm exasperated.

I have an SBS Premium...I don't know if this makes any change to a normal Server 2003.

|||Miracle..but it works now. The mysteries of computer science...|||

I only have the D:\InetPub\WWWRoot\aspnet_client\system_web\2_0_50727 folder...it does not include any files...should it? I just installed this on a fresh server...

BTW, the other issue is that reports have "X" for the controls...assume its tied to the same issue...

|||

I've run aspnet_regiss -i (and -c) , I still get the same error. The complication might be that the default website points to d:/websites/wwwroot instead of c:/inetpub.

Is there any way to get it to work?

Regards Bert

Ok button not responding

I installed the developer version of reporting services
and I am having problems getting things entered in the
admin screens. When I go to the "New Data Source"
screen, the OK button does nothing. I have no script
errors on the page, and have other .net applications
running on the web server. I also have problems when
trying to update roles/security. I get an error when
click the ok button telling me that I need to select at
least 1 role even though I have them selected.I ran this command and all my .net pages stopped
responding. I had to uninstall .net and reinstall, and
then uninstall RS and reinstall and I still have the same
problem.
Any suggestions?
Thanks,
Dan J
>--Original Message--
>Dan
>I also encountered this problem.
>Sometimes during the install the IIS registration fails.
If you run the
>following at the command line this resolves the problem.
>C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
\aspnet_regiis.exe -i
>This should fix your problem
>Cheers
>
>"Dan J" wrote:
>> I installed the developer version of reporting
services
>> and I am having problems getting things entered in the
>> admin screens. When I go to the "New Data Source"
>> screen, the OK button does nothing. I have no script
>> errors on the page, and have other .net applications
>> running on the web server. I also have problems when
>> trying to update roles/security. I get an error when
>> click the ok button telling me that I need to select
at
>> least 1 role even though I have them selected.
>>
>.
>|||Dan,
I ran into something like this before. Reporting services installs to your
default website. When things get moved around (like I tried to do), your root
website can be missing the aspnet_client folder (usually found in
c:\inetpub\wwwroot). Just copy this folder over to the root of your website.
That folder contains some java scripts that contain some generic code which
is required for RS to execute the commands in the manager.
- Matt
"Dan J" wrote:
> I ran this command and all my .net pages stopped
> responding. I had to uninstall .net and reinstall, and
> then uninstall RS and reinstall and I still have the same
> problem.
> Any suggestions?
> Thanks,
> Dan J
> >--Original Message--
> >Dan
> >
> >I also encountered this problem.
> >
> >Sometimes during the install the IIS registration fails.
> If you run the
> >following at the command line this resolves the problem.
> >
> >C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
> \aspnet_regiis.exe -i
> >
> >This should fix your problem
> >
> >Cheers
> >
> >
> >"Dan J" wrote:
> >
> >> I installed the developer version of reporting
> services
> >> and I am having problems getting things entered in the
> >> admin screens. When I go to the "New Data Source"
> >> screen, the OK button does nothing. I have no script
> >> errors on the page, and have other .net applications
> >> running on the web server. I also have problems when
> >> trying to update roles/security. I get an error when
> >> click the ok button telling me that I need to select
> at
> >> least 1 role even though I have them selected.
> >>
> >>
> >.
> >
>|||I havent moved any websites on my server. I tried
copying the aspnet_client to the root of both of the RS
virtual directories (out of frustration) but still no
luck. I assume it is an asp problem, just not sure what
it needs. I havent done anything "wierd" with the server
or any of the installs.
Please help!!!
Dan
>--Original Message--
>Dan,
>I ran into something like this before. Reporting
services installs to your
>default website. When things get moved around (like I
tried to do), your root
>website can be missing the aspnet_client folder (usually
found in
>c:\inetpub\wwwroot). Just copy this folder over to the
root of your website.
>That folder contains some java scripts that contain some
generic code which
>is required for RS to execute the commands in the
manager.
>- Matt
>"Dan J" wrote:
>> I ran this command and all my .net pages stopped
>> responding. I had to uninstall .net and reinstall,
and
>> then uninstall RS and reinstall and I still have the
same
>> problem.
>> Any suggestions?
>> Thanks,
>> Dan J
>> >--Original Message--
>> >Dan
>> >
>> >I also encountered this problem.
>> >
>> >Sometimes during the install the IIS registration
fails.
>> If you run the
>> >following at the command line this resolves the
problem.
>> >
>> >C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
>> \aspnet_regiis.exe -i
>> >
>> >This should fix your problem
>> >
>> >Cheers
>> >
>> >
>> >"Dan J" wrote:
>> >
>> >> I installed the developer version of reporting
>> services
>> >> and I am having problems getting things entered in
the
>> >> admin screens. When I go to the "New Data Source"
>> >> screen, the OK button does nothing. I have no
script
>> >> errors on the page, and have other .net
applications
>> >> running on the web server. I also have problems
when
>> >> trying to update roles/security. I get an error
when
>> >> click the ok button telling me that I need to
select
>> at
>> >> least 1 role even though I have them selected.
>> >>
>> >>
>> >.
>> >
>.
>sql

OK button is not working on file upload page

Hi everybody,
I hope than somebody can help me to fix my reporting services server.
I can upload reports on my reportin services server i dont know why but when
i press the OK button nothings happend everything is working bit i need to to
ulpload to new reports but i can't...
maybe if smebody know some diagnostic tool than can help to fix the problem
will be great.
plase, help....
Thanks.This happened to me once. But with the Apply button in the parameters section
of the report manager. This indicates the installation of reporting services
is corrupted and I had to reinstall it on the server.
Maybe that's not the problem for you, but it solved my problem.
"Edman" wrote:
> Hi everybody,
> I hope than somebody can help me to fix my reporting services server.
> I can upload reports on my reportin services server i dont know why but when
> i press the OK button nothings happend everything is working bit i need to to
> ulpload to new reports but i can't...
> maybe if smebody know some diagnostic tool than can help to fix the problem
> will be great.
> plase, help....
> Thanks.