connecting to server from SQL Server Management Studio

Hi,

I have 2 servers (test ,preprod ) with sql2005 and reporting services

Using SQL Server Management Studio I can connect on reporting services on test server

specifying server name http://smcanSQL10-tst/reportserver or smcanSQL10-tst

but for preprod server I have to specify

http://smcanSQL10-ppd/reportserver

if I simply put smcanSQL10-ppd application raise error

The machine could not be found (Microsoft.SqlServer.Management.UI.RSClient)

Is any setting missiing in my server configuration?

Alex,

Have you checked in your SQL 2005 Reporting Service Configuration manager under the "Report Server Virtual Directory" to make sure that the name is corrected?

Ham

|||

yes,

on both servers it is

name: ReportServer

Website: Defaut Web Site

sqlsql

Connecting to Server Fails

I'm running SQL Server 2005 RTM on my laptop (Dell Latitude D810) but
cannot connect to Reporting Services Server. When I try to connect to
it using SQL Server Management Studio (using windows authentication) I
get the following Error message...
TITLE: Connect to Server
--
Cannot connect to {ServerName}.
--
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.SqlServer.Management.UI.RSClient)
--
The request failed with HTTP status 404: Object Not Found.
(Microsoft.SqlServer.Management.UI.RSClient)
I have visual studio 2005 on the machine (which I installed after the
SQL Server install) and have .NET Framework version 2.0.50727.42.
The OS is windows XP Professional.
Anyone know what I will need to do to connect to the server?Simon Worth wrote:
> I'm running SQL Server 2005 RTM on my laptop (Dell Latitude D810) but
> cannot connect to Reporting Services Server. When I try to connect to
> it using SQL Server Management Studio (using windows authentication) I
> get the following Error message...
> TITLE: Connect to Server
> --
> Cannot connect to {ServerName}.
> --
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your
> connection information and that the report server is a compatible
> version. (Microsoft.SqlServer.Management.UI.RSClient)
> --
> The request failed with HTTP status 404: Object Not Found.
> (Microsoft.SqlServer.Management.UI.RSClient)
> I have visual studio 2005 on the machine (which I installed after the
> SQL Server install) and have .NET Framework version 2.0.50727.42.
> The OS is windows XP Professional.
> Anyone know what I will need to do to connect to the server?
I'm still having issues with this - if anyone can offer any insight it
would still be greatly appreciated.|||Hi,
I am also having the same problem,
and it seems that at least a few people in this newsgroup are having the
same problem.
Somebody please help us with this!|||I resolved the issue, at least for my machine. My IIS is ver. 5.1, and the
URLScan did not allow POST verb. Once I listed POST as an allowed verb in
URLScan.ini, I could successfully connect to the report manager.
For anybody having problem, as below, I suggest you check your URLScan
settings.
The problems are :
1) When you navigate to http://<localhost>/<reports>, you get, "The attempt
to connect to the report server failed. Check your connection information
and that the report server is a compatible version.
(Microsoft.SqlServer.Management.UI.RSClient)".
2) You cannot connect to your reporting services instance through the
Management Studio.

Connecting to Reporting Services Server Fails

Originally posted on Reporting Services newsgroup - Then on Setup - no
answer there though, so I thought I'd try the Server group as well.
I've looked through documentation and can't find an answer there, and
nothing on the web that seemed to apply either. I'm hoping someone can
give me a push in the right direction.
I'm running SQL Server 2005 RTM on my laptop (Dell Latitude D810) but
cannot connect to Reporting Services Server. When I try to connect to
it using SQL Server Management Studio (using windows authentication) I
get the following Error message...
TITLE: Connect to Server
--
Cannot connect to {ServerName}.
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.SqlServer.Management.UI.RSClient)
The request failed with HTTP status 404: Object Not Found.
(Microsoft.SqlServer.Management.UI.RSClient)
I have visual studio 2005 on the machine (which I installed after the
SQL Server install) and have .NET Framework version 2.0.50727.42.
The OS is Windows XP Professional.
Anyone know what I will need to do to connect to the server?Hi,
Did u configure the virtual directories for tht instance on which
reporting services are running if not configure it first.After
configuring it check it out wether it works or not and I am facing here
a diffrent problem with some unknown exceptions rising that is:
"The underlying connection was closed: An unexpected error occurred on
a receive. (Microsoft.SqlServer.Management.UI.RSClient)
Unable to read data from the transport connection: An established
connection was aborted by the software in your host machine. (System)
An established connection was aborted by the software in your host
machine (System)."
So, can u able to guide me through this problem,if it is it will be a
great help for ur friend from ur side.
Thanks and regards
- vishwas R
VISHWAS R
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message2000026.html

Connecting to Reporting Services Server Fails

Originally posted on Reporting Services newsgroup - Then on Setup - no
answer there though, so I thought I'd try the Server group as well.
I've looked through documentation and can't find an answer there, and
nothing on the web that seemed to apply either. I'm hoping someone can
give me a push in the right direction.
I'm running SQL Server 2005 RTM on my laptop (Dell Latitude D810) but
cannot connect to Reporting Services Server. When I try to connect to
it using SQL Server Management Studio (using windows authentication) I
get the following Error message...
TITLE: Connect to Server
--
Cannot connect to {ServerName}.
--
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.SqlServer.Management.UI.RSClient)
--
The request failed with HTTP status 404: Object Not Found.
(Microsoft.SqlServer.Management.UI.RSClient)
I have visual studio 2005 on the machine (which I installed after the
SQL Server install) and have .NET Framework version 2.0.50727.42.
The OS is windows XP Professional.
Anyone know what I will need to do to connect to the server?Hi,
Did u configure the virtual directories for tht instance on which
reporting services are running if not configure it first.After
configuring it check it out wether it works or not and I am facing here
a diffrent problem with some unknown exceptions rising that is:
"The underlying connection was closed: An unexpected error occurred on
a receive. (Microsoft.SqlServer.Management.UI.RSClient)
Unable to read data from the transport connection: An established
connection was aborted by the software in your host machine. (System)
An established connection was aborted by the software in your host
machine (System)."
So, can u able to guide me through this problem,if it is it will be a
great help for ur friend from ur side.
Thanks and regards
- vishwas R
VISHWAS R
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message2000026.html

Connecting to Reporting Services Server failed!!!

SQL Server 2005 and SSRS 2005 is curently installed on the same box. The OS is Windows 2003 (S) enterprise edition.

When I connect to the Reporting Services Server using the Sql Server Management studio I get the following error message

The request failed with HTTP status 407: Proxy Authentication Required.

(Microsoft.sqlserver.Management.UI.RSClient)

rsAccessDenied

I am tring to connect using the Windows Admin id. I would like to get an answer from this form.

-Aza

Any body to help here

-Nitu

Connecting to Reporting Services in Management Studio

I get the following error in connectig to RS in Management Studio - what do I
need to do to fix this - thanks.
Paddy
--
The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError)
Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.Go to the NTFS Permissions of C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config'
and make sure that ASPNET computer account has read access to this file.
or if the ReportServer directory has the correct permissions then just check
the inherit permission from parent checkbox.
"Paddy" wrote:
> I get the following error in connectig to RS in Management Studio - what do I
> need to do to fix this - thanks.
> Paddy
> --
> The report server has encountered a configuration error. See the report
> server log files for more information. (rsServerConfigurationError)
> Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportServer\RSReportServer.config' is denied.

Connecting to reporting services

I am trying to connect to my reporting services. I keep getting the following error. I am in the sysadmin role What else do I need access to in order to connect?
TIA,
Joe
TITLE: Connect to Server

Cannot connect to ENSQLD1\ENSQLD1_2005.

ADDITIONAL INFORMATION:

The request failed with HTTP status 401: Access Denied. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

OK

Are you a local system admin to the Report Server? If not then a local admin will have to grant you rights to the Report server. The Database roles have no meaning to the Report Server service.

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

Connecting to reporting services

I am trying to connect to my reporting services. I keep getting the following error. I am in the sysadmin role What else do I need access to in order to connect?
TIA,
Joe
TITLE: Connect to Server

Cannot connect to ENSQLD1\ENSQLD1_2005.

ADDITIONAL INFORMATION:

The request failed with HTTP status 401: Access Denied. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

OKAre you a local system admin to the Report Server? If not then a local admin will have to grant you rights to the Report server. The Database roles have no meaning to the Report Server service.

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

Connecting to Report Services now broken

I am now getting the error below while trying to connect to a registered server for reporting services. I was able to connect before I was messing with my IIS Settings for the Reports Folder under Default Web Site but I've reverted those changes back to their defaults and I'm still having issues. SSRS is running in Config Manager.

=====================================================

TITLE: New Server Registration

Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00" target="_blank">Get Online Help</a></li><ul>
<li>Object reference not set to an instance of an object.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

OK

Never mess with rs virtual directories. I learned it few months ago. Just reinstall ur RS2005 again you should be ok.

-kushpaw

Connecting to ODBC Connections with Report Services

I have just migrated from SQL 2000 to SQL 2005 and in the process upgraded to new hardware. I am now running SQL2005 (64 Bit) on Windows 2003 R2 (64 Bit). The problem is that when i deploy some reports to the new server that use ODBC to connect to the data, reporting services is erroring with :

Data source name not found and no default driver specified

The ODBC connections are set up exactly the same on the old server and the new server. Is it because it is looking for a 64 bit ODBC driver and not the 32 Bit one I have installed. If i go into the SysWOW64 and run the odbcad32.exe i can see the drivers and the connection. The connection test works fine from here.

Thanks

Has anyone got any ideas on this ?|||Did you find a resolution? I have the same problem.|||I am waiting for a company called Openlink to get back to me they are currently developing some drivers|||Thanks. My client is switching to 32-bit software to resolve this. Good luck.|||

Did anyone get this resolved? I am having the same problem. I fear I may have to revert back to the 32-Bit OS.

Any advice or suggestion are welcomed.

Thanks,

Andy

Connecting to ODBC Connections with Report Services

I have just migrated from SQL 2000 to SQL 2005 and in the process upgraded to new hardware. I am now running SQL2005 (64 Bit) on Windows 2003 R2 (64 Bit). The problem is that when i deploy some reports to the new server that use ODBC to connect to the data, reporting services is erroring with :

Data source name not found and no default driver specified

The ODBC connections are set up exactly the same on the old server and the new server. Is it because it is looking for a 64 bit ODBC driver and not the 32 Bit one I have installed. If i go into the SysWOW64 and run the odbcad32.exe i can see the drivers and the connection. The connection test works fine from here.

Thanks

Has anyone got any ideas on this ?|||Did you find a resolution? I have the same problem.|||I am waiting for a company called Openlink to get back to me they are currently developing some drivers|||Thanks. My client is switching to 32-bit software to resolve this. Good luck.|||

Did anyone get this resolved? I am having the same problem. I fear I may have to revert back to the 32-Bit OS.

Any advice or suggestion are welcomed.

Thanks,

Andy

Connecting to ODBC Connections with Report Services

I have just migrated from SQL 2000 to SQL 2005 and in the process upgraded to new hardware. I am now running SQL2005 (64 Bit) on Windows 2003 R2 (64 Bit). The problem is that when i deploy some reports to the new server that use ODBC to connect to the data, reporting services is erroring with :

Data source name not found and no default driver specified

The ODBC connections are set up exactly the same on the old server and the new server. Is it because it is looking for a 64 bit ODBC driver and not the 32 Bit one I have installed. If i go into the SysWOW64 and run the odbcad32.exe i can see the drivers and the connection. The connection test works fine from here.

Thanks

Has anyone got any ideas on this ?|||Did you find a resolution? I have the same problem.|||I am waiting for a company called Openlink to get back to me they are currently developing some drivers|||Thanks. My client is switching to 32-bit software to resolve this. Good luck.|||

Did anyone get this resolved? I am having the same problem. I fear I may have to revert back to the 32-Bit OS.

Any advice or suggestion are welcomed.

Thanks,

Andy

Connecting to DB2 Database - Drivers Needed

I am trying to connect my reporting services server to a DB2 server - What
drivers / info do i need to accomplish this. I cant seem to figure out how
to get this to work. Any help would be appreciated.You need an ODBC driver or an OLEDB driver. Either will work theorectically.
I go against Sybase and for them I found that the ODBC driver worked better.
Just a few days ago there was someone going against an AS400 running DB2
that has had good luck with ODBC.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"PCL" <PCL@.discussions.microsoft.com> wrote in message
news:16E09229-DEDF-4D37-9F9A-5D4897359C54@.microsoft.com...
> I am trying to connect my reporting services server to a DB2 server - What
> drivers / info do i need to accomplish this. I cant seem to figure out
how
> to get this to work. Any help would be appreciated.|||Thank You for your response - I guess i am not sure where i make this ODBC
connection. In .Net when i am creating a report it asks for a datasource
which I can use a DSN for. When i goto make a DSN, i do not see a generic
ODBC connection - I see ODBC for oracle but that is about it. How do i go
about creating this DSN?
Thanx!
"Bruce L-C [MVP]" wrote:
> You need an ODBC driver or an OLEDB driver. Either will work theorectically.
> I go against Sybase and for them I found that the ODBC driver worked better.
> Just a few days ago there was someone going against an AS400 running DB2
> that has had good luck with ODBC.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "PCL" <PCL@.discussions.microsoft.com> wrote in message
> news:16E09229-DEDF-4D37-9F9A-5D4897359C54@.microsoft.com...
> > I am trying to connect my reporting services server to a DB2 server - What
> > drivers / info do i need to accomplish this. I cant seem to figure out
> how
> > to get this to work. Any help would be appreciated.
>
>|||Assuming you have an ODBC driver installed, create a machine datasource
name. Then in RS create a new datasource, select the microsoft oledb for
odbc driver, you will then come to the screen that will allow you to pick
the DSN.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"PCL" <PCL@.discussions.microsoft.com> wrote in message
news:C27653D2-CBA2-43BD-A9AF-2A31DF5488FA@.microsoft.com...
> Thank You for your response - I guess i am not sure where i make this ODBC
> connection. In .Net when i am creating a report it asks for a datasource
> which I can use a DSN for. When i goto make a DSN, i do not see a generic
> ODBC connection - I see ODBC for oracle but that is about it. How do i go
> about creating this DSN?
> Thanx!
> "Bruce L-C [MVP]" wrote:
> > You need an ODBC driver or an OLEDB driver. Either will work
theorectically.
> > I go against Sybase and for them I found that the ODBC driver worked
better.
> > Just a few days ago there was someone going against an AS400 running DB2
> > that has had good luck with ODBC.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "PCL" <PCL@.discussions.microsoft.com> wrote in message
> > news:16E09229-DEDF-4D37-9F9A-5D4897359C54@.microsoft.com...
> > > I am trying to connect my reporting services server to a DB2 server -
What
> > > drivers / info do i need to accomplish this. I cant seem to figure
out
> > how
> > > to get this to work. Any help would be appreciated.
> >
> >
> >|||On Fri, 4 Mar 2005 08:59:03 -0800, PCL <PCL@.discussions.microsoft.com>
wrote:
>I am trying to connect my reporting services server to a DB2 server - What
>drivers / info do i need to accomplish this. I cant seem to figure out how
>to get this to work. Any help would be appreciated.
You maybe out of luck. OLE DB Provider for DB2 is not something you
can obtain free or even separately for a fee. As far as I know, it
only comes with MS Host Integration Server 2000 and 2004 (~$2500). We
recently had a discussion with Microsoft about this, and they
confirmed that this is a known business problem.
If you end up buying Host Integration Server, I'd strongly suggest you
get the latest release (2004): the provider seems to be less bugged
(it had some annoying instability issues in 2000), plus they now
include a managed provider as well, which is nice to have, if you're
programming on .NET platform.
There are other options, like getting a provider from IBM (or even
some 3rd party), but those are not free either, and I cannot tell you
much about them...

Connecting to data source rs2005sbsDW

I'm trying to connect to the sample database (rs2005sbsDW) that I installed from a CD that came with the book SQL Server 2005 Reporting Services. When I try to connect to this database in the report wizard following instructions on page 41, it tells me my database doesn't exist. The following path was entered into the New Project dialog box which does exist. C:\Documents and Settings\Brett Somers\My Documents\Microsoft Press\RS2005SBS\workspace. The book guides me to enter Localhost as the server name. The rs2005sbsDW database does not appear in the "select or enter a database name" dropdown field.

If you installed SQLExpress as the server then it probably installed as a named instance so you need ot connect to (local)\sqlexpress|||SQL Express Server is installed. But I have recently installed the Business Intelligence SQL 2005 program. I have reinstalled the workstation components for the Business Intelligence Install. I'm not sure how to proceed with your advice.
|||How do I connect to (local)\sqlexpress? If this is what I need to do.
|||Put (local)\sqlexpress in the connection string or the server name in the connection dialog.

Connecting to Analysis Services using HTTP

my analysis server is hosted on a win2k server with IIS, the hosting page is
on another machine. I have followed everything as per MS KB article and I
could not connect through the analysis server using http. i have similar
implementation on my dev machine but the main difference is my OLAP is on
top of winxp. i just wanted to know if i am missing any other setting not
specified on the MS KB article on how to implement OLAP cube through HTTP
over win2k operating system.

note: i tried connecting to olap using the MDX sample application using
MSOLAP.2 provider and connecting through a simple office web component. I
think the best way to test the connection is through the MDX sample
application that comes with Analysis Server installation.Check security for IIS and to the C:\Program Files\Microsoft Analaysis
Server\Bin folder and hidden share. Without any error messages there
is little we can help you with.|||Adam,
I am able to access the msolap.asp through the website. that means I
have permission to the file on the IIS side.
I will be checking the permission on the Analysis Server folder.

Whenever I try to connect using the MDX Sample Application to the HTTP
server(with my cubes) the app seem to hang. after waiting
for about 2 minutes it gives me an error "unable to connect..."

"Adam J. Tybor" <adam.tybor@.gmail.com> wrote in message
news:1096106771.514490.178060@.k17g2000odb.googlegr oups.com...
> Check security for IIS and to the C:\Program Files\Microsoft Analaysis
> Server\Bin folder and hidden share. Without any error messages there
> is little we can help you with.

Connecting to Analysis Services on different domain

Does anyone know how I can connecting to an analysis services cube that
is located on a different server/domain than the one I am developing
the report on.
I am able to remote connect to the server and process the cube, however
I don't know how to create a connection to the cube.
I am woring on the corp domain and the cube is located on the corp2
domain, server name cr2rchmiis10.
Thanks in advance for any help.
John CCan you set up a SQL linked server on a SQL server in the corp domain
that connects to the AS in the corp2 domain?
If you can get the linked server set up across domains, you can run
your query against the linked server in the corp domain.|||If you are using Analysis Services ENTERPRISE edition, you can connect to
Analysis Services through Http, and that would probably solve your problem.
If you are using AS Standard edition, you need to do something else. (Like
Potter suggested.)
With Analysis Services 2005 Enterprise edition
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx
With ANalysis Services 2000 Enterprise edition:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/aghtconfig_4giq.asp
Kaisa
<john.r.carter@.bankofamerica.com> wrote in message
news:1135094407.938804.228280@.g14g2000cwa.googlegroups.com...
> Does anyone know how I can connecting to an analysis services cube that
> is located on a different server/domain than the one I am developing
> the report on.
> I am able to remote connect to the server and process the cube, however
> I don't know how to create a connection to the cube.
> I am woring on the corp domain and the cube is located on the corp2
> domain, server name cr2rchmiis10.
> Thanks in advance for any help.
> John C
>

Connecting to Analysis Services Manager

Hi,
I have Windows 2000 sp4, and SQL Server 2000 with sp3a.
No matter what I do I cannot connect to the Analysis
Services manager. I get the following message:
Unable to connect to registry on server (xxxxx), or you
are not in Group OLAP Administrators on this server.
I'm signed on with full admin privleges and am in the OLAP
Admin group.
What else could I be missing ?
Thanks for any help.Shad,
>> Is there a seperate sp3 specifically for Analysis Services?
Yes.Its called Sql2kasp3.exe and you can find it in :
SQL Server 2000 Service Pack 3a
http://www.microsoft.com/sql/downloads/2000/sp3.asp
>>version of the Analysis Services it is Version 8.0.194
Means you dont have any analysis services service pack installed.
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Shad" <msgmeus@.yahoo.com> wrote in message
news:007f01c36cb0$7c70ff90$a301280a@.phx.gbl...
> Thanks,
> I have installed SP3a for SQL Server, if I look at the
> version of the Analysis Services it is Version 8.0.194
> My SQL 2000 version is 8.0.760(sp3)
> The first link you gave me pertains to Windows XP (I
> think), the second says SP3 should solve the problem.
> Is there a seperate sp3 specifically for Analysis Services?
> Thanks
> >--Original Message--
> >Shad,
> >
> >What is the Analysis Services service pack level? See
> >
> >PRB: Cannot Connect Through Analysis Manager Although a
> Member of
> >Administrator Group
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;307365
> >
> >FIX: Pre-Analysis Services Service Pack 3 Client Cannot
> Administer Analysis
> >Services Service Pack 3
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;331925
> >
> >--
> >Dinesh.
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"Shad Gamel" <msgmeus@.yahoo.com> wrote in message
> >news:0da201c36ca1$040bea10$a301280a@.phx.gbl...
> >> Hi,
> >>
> >> I have Windows 2000 sp4, and SQL Server 2000 with sp3a.
> >>
> >> No matter what I do I cannot connect to the Analysis
> >> Services manager. I get the following message:
> >>
> >> Unable to connect to registry on server (xxxxx), or you
> >> are not in Group OLAP Administrators on this server.
> >>
> >> I'm signed on with full admin privleges and am in the
> OLAP
> >> Admin group.
> >>
> >> What else could I be missing ?
> >>
> >> Thanks for any help.
> >
> >
> >.
> >

Connecting to Analysis Services cubes from Reporting Services

Hi,
I have created cubes using Analysis Services. Could I please know how to create a data source to connect to those cubes in Reporting Services to generate reports out of them. When I choose to create a data source in Reporting Services, I am able to see options only to connect to Sql Server, ODBC and Oracle. I do not see an option like 'OLAP Services' to connect to cubes in Analysis Services. I would be happy if anyone could help by giving me the steps to connect to the cubes in Analysis Services and to generate report/pivot table out of it.
Thanks,
Raj.Information on the integration of Reporting Services (RS) 2000 and Analysis
Services (AS) 2000 is provided at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
It describes how to connect to AS 2000 cubes and use multidimensional data
in RS 2000. The data provider is OleDB provider for OLAP 8.0.
You might also want to check out some samples on parameterized MDX available
for download:
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
Note: The upcoming SQL 2005 Beta 2 will contain graphical MDX and DMX query
designers, which will work best against AS 2005 cubes, but they also support
AS 2000 cubes.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <Raj@.discussions.microsoft.com> wrote in message
news:66825BE3-5342-4C34-AD06-589B73491B01@.microsoft.com...
> Hi,
> I have created cubes using Analysis Services. Could I please know how to
create a data source to connect to those cubes in Reporting Services to
generate reports out of them. When I choose to create a data source in
Reporting Services, I am able to see options only to connect to Sql Server,
ODBC and Oracle. I do not see an option like 'OLAP Services' to connect to
cubes in Analysis Services. I would be happy if anyone could help by giving
me the steps to connect to the cubes in Analysis Services and to generate
report/pivot table out of it.
> Thanks,
> Raj.

Connecting to Analysis Services

I am having trouble getting my IS package to connect to an AS database when I schedule the package as a job.

The package executes fine through BI Development Studio, but I get the following error in the package log when I run the job step:
OnError,<server name>,NT AUTHORITY\SYSTEM,Process Cube,{C4951602-2594-4572-9587-72E539A2FB6B},{AD6B3CE0-FA38-4DC6-93C0-59D339751EC9},8/22/2007 2:05:19 PM,8/22/2007 2:05:19 PM,0,0x,A connection cannot be made. Ensure that the server is running.

Here is the connection string I am using in both BI Dev Studio and the job:
Data Source=<server name>;User ID=<user>;Password=<password>;Initial Catalog=<DB name>;Provider=MSOLAP.3;Persist Security Info=True;Impersonation Level=Impersonate;

The AS server is set up to allow remote connections, and the user I am connecting as is an administrator on the AS server.

-Randy

Dalmut1 wrote:

I am having trouble getting my IS package to connect to an AS database when I schedule the package as a job.

The package executes fine through BI Development Studio, but I get the following error in the package log when I run the job step:
OnError,<server name>,NT AUTHORITY\SYSTEM,Process Cube,{C4951602-2594-4572-9587-72E539A2FB6B},{AD6B3CE0-FA38-4DC6-93C0-59D339751EC9},8/22/2007 2:05:19 PM,8/22/2007 2:05:19 PM,0,0x,A connection cannot be made. Ensure that the server is running.

Here is the connection string I am using in both BI Dev Studio and the job:
Data Source=<server name>;User ID=<user>;Password=<password>;Initial Catalog=<DB name>;Provider=MSOLAP.3;Persist Security Info=True;Impersonation Level=Impersonate;

The AS server is set up to allow remote connections, and the user I am connecting as is an administrator on the AS server.

-Randy

It looks to me as though you're connecting using NT AUTHORITY\SYSTEM. Is that account an administrator on the AS server?

-Jamie

|||I think I should clarify: the server running the job is not on the same box as the analysis server. Should it matter what user is executing the job as long as the connection string for the AS DB is correct?
|||

Dalmut1 wrote:

I think I should clarify: the server running the job is not on the same box as the analysis server. Should it matter what user is executing the job as long as the connection string for the AS DB is correct?

Absolutely. The conenction will be made usig the credentials of whoever is running teh job. Unless you have set up a proxy account this will be the account that SQL Agent is running under.

-Jamie

|||

Jamie Thomson wrote:

Dalmut1 wrote:

I think I should clarify: the server running the job is not on the same box as the analysis server. Should it matter what user is executing the job as long as the connection string for the AS DB is correct?

Absolutely. The conenction will be made usig the credentials of whoever is running teh job. Unless you have set up a proxy account this will be the account that SQL Agent is running under.

-Jamie

Aha. I set up a proxy account that is working like a charm. Thanks.

Connecting to Analysis Services

Hello,
I have analysis services running on a server in our internet datacentre
(servers are colocated at an ISP). It is working fine with no problems
whatsoever. I can also manage it fine when I terminal onto the box.
However, the problems start when I try to mange the server from my local
machine at work. There is a VPN setup between my work and the datacentre.
All the servers are on a different subnet at the datacenter.
This works fine for managing SQL server on the same machine with enterprise
manager. However, when I try to connect to analysis services using Analysis
Manager, I get the following error when trying to register:
Errors occurred while trying to connect to 10.2.1.2
Cannot open connection to Analsysis Server '10.2.1.2'
Error in data [Possible data corruption]"
Do you still want to register this server?
What in the world is going on? Maybe it has something to do with the fact
that Analsysis Server doesn't have 'SQL Authentication' and thus its a
security issue since my Windows cridentials aren't being passed/accepted
since those servers are all standalone?
Please help!
thanks in advance,
-ZD
hello.
i have the same problem and have no idea what happens.i have reinstalled analyis services, service pack 3, mdac 2.8 ... nothings happens. always the same error message. can't find anything in the web about this only on this board.
would be very happy if someone can help me about this problem
mario
"Z D" wrote:

> Hello,
> I have analysis services running on a server in our internet datacentre
> (servers are colocated at an ISP). It is working fine with no problems
> whatsoever. I can also manage it fine when I terminal onto the box.
> However, the problems start when I try to mange the server from my local
> machine at work. There is a VPN setup between my work and the datacentre.
> All the servers are on a different subnet at the datacenter.
> This works fine for managing SQL server on the same machine with enterprise
> manager. However, when I try to connect to analysis services using Analysis
> Manager, I get the following error when trying to register:
>
> Errors occurred while trying to connect to 10.2.1.2
> Cannot open connection to Analsysis Server '10.2.1.2'
> Error in data [Possible data corruption]"
> Do you still want to register this server?
>
> What in the world is going on? Maybe it has something to do with the fact
> that Analsysis Server doesn't have 'SQL Authentication' and thus its a
> security issue since my Windows cridentials aren't being passed/accepted
> since those servers are all standalone?
> Please help!
> thanks in advance,
> -ZD
>
>