Error accessing report: successfully

Showing posts with label successfully. Show all posts

Monday, March 26, 2012

error during installing SP3

Hi
I've got following error during installing SP3
by running this file Sql2kasp3.exe after successfully
installation sql 2ksp3.exe,
(SQL server 2000,server station)
"an error occurred during move data process : -145"
Thanks for any reply
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/Are you running analysis services?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opr1kakxwshqligo@.msnews.microsoft.com...
> Hi
> I've got following error during installing SP3
> by running this file Sql2kasp3.exe after successfully
> installation sql 2ksp3.exe,
> (SQL server 2000,server station)
> "an error occurred during move data process : -145"
> Thanks for any reply
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/sql

error during install SP3

quote:

> Hi
> I've SQL server 2000 on server station and wanted
> to install SP3,at first installation of sql2ksp3.exe
> was completed successfully,and following error appearred
> on running sql2kasp3.exe:
> "An error occurred during move data process : -145"
> why ?
> what's wrong?
> any help would be greatly appreciated.
> --
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

|||no ,I didn't install completely
an error casued to exit it,
On Sun, 11 Jan 2004 12:07:47 +0000 (UTC), John Bell
<jbellnewsposts@.hotmail.com> wrote:

quote:

> Hi
> Sql2kasp3.exe Updates Analysis Services is this actually installed?
> John
> "RM" <m_r1824@.yahoo.co.uk> wrote in message
> news:opr1linpoqhqligo@.msnews.microsoft.com...
>

Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/|||Hi
Sql2kasp3.exe will update your existing install of Analysis services,
you need Analysis services to already be installed and working before
applying this patch.
John
RM <m_r1824@.yahoo.co.uk> wrote in message news:<opr1nbozoghqligo@.msnews.microsoft.com>...[QUOTE][c
olor=darkred]
> no ,I didn't install completely
> an error casued to exit it,
> On Sun, 11 Jan 2004 12:07:47 +0000 (UTC), John Bell
> <jbellnewsposts@.hotmail.com> wrote:
>

error during install SP3

Hi
I've SQL server 2000 on server station and wanted
to install SP3,at first installation of sql2ksp3.exe
was completed successfully,and following error appearred
on running sql2kasp3.exe:
"An error occurred during move data process : -145"
why ?
what's wrong?
any help would be greatly appreciated.
--
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/Hi
Sql2kasp3.exe Updates Analysis Services is this actually installed?
John
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opr1linpoqhqligo@.msnews.microsoft.com...
> Hi
> I've SQL server 2000 on server station and wanted
> to install SP3,at first installation of sql2ksp3.exe
> was completed successfully,and following error appearred
> on running sql2kasp3.exe:
> "An error occurred during move data process : -145"
> why ?
> what's wrong?
> any help would be greatly appreciated.
> --
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/|||no ,I didn't install completely
an error casued to exit it,
On Sun, 11 Jan 2004 12:07:47 +0000 (UTC), John Bell
<jbellnewsposts@.hotmail.com> wrote:
> Hi
> Sql2kasp3.exe Updates Analysis Services is this actually installed?
> John
> "RM" <m_r1824@.yahoo.co.uk> wrote in message
> news:opr1linpoqhqligo@.msnews.microsoft.com...
>> Hi
>> I've SQL server 2000 on server station and wanted
>> to install SP3,at first installation of sql2ksp3.exe
>> was completed successfully,and following error appearred
>> on running sql2kasp3.exe:
>> "An error occurred during move data process : -145"
>> why ?
>> what's wrong?
>> any help would be greatly appreciated.
>> --
>> --
>> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
>
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/|||Hi
Sql2kasp3.exe will update your existing install of Analysis services,
you need Analysis services to already be installed and working before
applying this patch.
John
RM <m_r1824@.yahoo.co.uk> wrote in message news:<opr1nbozoghqligo@.msnews.microsoft.com>...
> no ,I didn't install completely
> an error casued to exit it,
> On Sun, 11 Jan 2004 12:07:47 +0000 (UTC), John Bell
> <jbellnewsposts@.hotmail.com> wrote:
> > Hi
> >
> > Sql2kasp3.exe Updates Analysis Services is this actually installed?
> >
> > John
> >
> > "RM" <m_r1824@.yahoo.co.uk> wrote in message
> > news:opr1linpoqhqligo@.msnews.microsoft.com...
> >> Hi
> >>
> >> I've SQL server 2000 on server station and wanted
> >> to install SP3,at first installation of sql2ksp3.exe
> >> was completed successfully,and following error appearred
> >> on running sql2kasp3.exe:
> >>
> >> "An error occurred during move data process : -145"
> >>
> >> why ?
> >> what's wrong?
> >> any help would be greatly appreciated.
> >>
> >> --
> >>
> >> --
> >> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
> >
> >

Wednesday, March 21, 2012

Error creating Report Model based upon Oracle Database

In MS Visual Studio, when creating a new Report Model Project, after defining a datasource to an Oracle database (and successfully testing it), and a simple datasource view (1 table), when I click "Run" in Report Model Wizard, I receive the following error:
"ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }"

It does not appear that one can create Report Models from an Oracle database (since the SQL being used to query the Oracle database cannot be edited and contains syntax errors?). Is this the case?

Thank you.

Models for Oracle are not currently supported.

BTW, what version of Oracle are you using?

|||

Tried it on Oracle 9.2 and 10.1.

Thank you.

|||I have also encountered the identical problem. Has a resolution been provided yet?|||Report Models support Oracle starting from SQL 2005 SP2. Please check SP2 docs for more details.|||I do not see anything for SQL Server 2005 SP2, where can I find more info.|||

Alexandre

Where is SQL Server 2005 SP2? We can not find any reference to this release.

|||

Will it be supported by SP 2? When can we expect SP 2?

Thanks,

Roman

|||

Report Models for Oracle 9 and above will be supported in Yukon SP2.
Public SP2 CTP is on its way. Keep an eye on http://microsoft.com/sqlserver

|||

What is CTP?

Thank you.

|||CTP is community tech preview. sort of Beta|||Has anyone been succesful getting this to work on
SQL Server 2005 Service Pack 2 CTP (November 2006)?

|||I've installed SQL Server 2005 SP2 and still the same error message pops up. Anyone been able to fix it?

Error creating Report Model based upon Oracle Database

It does not appear that one can create Report Models from an Oracle database (since the SQL being used to query the Oracle database cannot be edited and contains syntax errors?). Is this the case?

Thank you.

Models for Oracle are not currently supported.

BTW, what version of Oracle are you using?

|||

Tried it on Oracle 9.2 and 10.1.

Thank you.

Alexandre

Where is SQL Server 2005 SP2? We can not find any reference to this release.

|||

Will it be supported by SP 2? When can we expect SP 2?

Thanks,

Roman

|||

Report Models for Oracle 9 and above will be supported in Yukon SP2.
Public SP2 CTP is on its way. Keep an eye on http://microsoft.com/sqlserver

|||

What is CTP?

Thank you.

|||CTP is community tech preview. sort of Beta|||Has anyone been succesful getting this to work on
SQL Server 2005 Service Pack 2 CTP (November 2006)?

|||I've installed SQL Server 2005 SP2 and still the same error message pops up. Anyone been able to fix it?sql

Error creating Report Model based upon Oracle Database

It does not appear that one can create Report Models from an Oracle database (since the SQL being used to query the Oracle database cannot be edited and contains syntax errors?). Is this the case?

Thank you.

Models for Oracle are not currently supported.

BTW, what version of Oracle are you using?

|||

Tried it on Oracle 9.2 and 10.1.

Thank you.

Alexandre

Where is SQL Server 2005 SP2? We can not find any reference to this release.

|||

Will it be supported by SP 2? When can we expect SP 2?

Thanks,

Roman

|||

Report Models for Oracle 9 and above will be supported in Yukon SP2.
Public SP2 CTP is on its way. Keep an eye on http://microsoft.com/sqlserver

|||

What is CTP?

Thank you.

|||CTP is community tech preview. sort of Beta|||Has anyone been succesful getting this to work on
SQL Server 2005 Service Pack 2 CTP (November 2006)?

|||I've installed SQL Server 2005 SP2 and still the same error message pops up. Anyone been able to fix it?

Error creating Report Model based upon Oracle Database

It does not appear that one can create Report Models from an Oracle database (since the SQL being used to query the Oracle database cannot be edited and contains syntax errors?). Is this the case?

Thank you.

Models for Oracle are not currently supported.

BTW, what version of Oracle are you using?

|||

Tried it on Oracle 9.2 and 10.1.

Thank you.

Alexandre

Where is SQL Server 2005 SP2? We can not find any reference to this release.

|||

Will it be supported by SP 2? When can we expect SP 2?

Thanks,

Roman

|||

Report Models for Oracle 9 and above will be supported in Yukon SP2.
Public SP2 CTP is on its way. Keep an eye on http://microsoft.com/sqlserver

|||

What is CTP?

Thank you.

|||CTP is community tech preview. sort of Beta|||Has anyone been succesful getting this to work on
SQL Server 2005 Service Pack 2 CTP (November 2006)?

|||I've installed SQL Server 2005 SP2 and still the same error message pops up. Anyone been able to fix it?

Error creating Report Model based upon Oracle Database

It does not appear that one can create Report Models from an Oracle database (since the SQL being used to query the Oracle database cannot be edited and contains syntax errors?). Is this the case?

Thank you.

Models for Oracle are not currently supported.

BTW, what version of Oracle are you using?

|||

Tried it on Oracle 9.2 and 10.1.

Thank you.

Alexandre

Where is SQL Server 2005 SP2? We can not find any reference to this release.

|||

Will it be supported by SP 2? When can we expect SP 2?

Thanks,

Roman

|||

Report Models for Oracle 9 and above will be supported in Yukon SP2.
Public SP2 CTP is on its way. Keep an eye on http://microsoft.com/sqlserver

|||

What is CTP?

Thank you.

|||CTP is community tech preview. sort of Beta|||Has anyone been succesful getting this to work on
SQL Server 2005 Service Pack 2 CTP (November 2006)?

|||I've installed SQL Server 2005 SP2 and still the same error message pops up. Anyone been able to fix it?

Wednesday, March 7, 2012

Error Connecting to Database Engine

I have been successfully using SQL Server 2005 developer edition for a couple of months now.However, when I started Microsoft SQL Server Management Studio this morning I could not connect to the “Database Engine” (I’m using Windows Authentication). I can still connect with the “Integration Services” and “Analysis Services” on the same server. The server running on my local machine, so there shouldn’t be any problems with the network.I am also able to connect with it through ODBC, it just seems to be the Server Management Studio which can’t connect, and it only has problems with the “Database Engine.” Any help would be appreciated.

David

The detailed error message says:

An error has occurred while establishing a connection to the server.When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476

Error Number: 10061

Severity: 20

State: 0

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)

at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

I'm not sure exactly which setting fixed it, however after reinstalling and adjusting some settings it now is working again.|||I had the same problem. What I did is open the SQL Server Management Studio and view registered servers. Then I right clicked on my server and went to SQL Server Configuration Manager. I then checked the protocols on my server and they were all disabled!! I reenabled them then restarted the SQL Server service. Now I am all good.|||I, too, have this problem. Unfortunately, after enabling the protocols I am still not able to connect! Does anyone have any other ideas?
|||

I am having the same problem. I installed SQL Server last week and used it fine until yesterday. Yesterday, I changed the properties on my ASPNET user and tried to restart SQL. The restart failed and I was unable to ever make a connection again. I rebooted my machine a couple of times, I changed the Protocols to "Enabled", etc. yet nothing worked.

I had to uninstall SQL and then re-install it to get it working. That is until this morning. I tried to login this morning and I received the error again. Is this a daily routine now, uninstall and re-install SQL to start my day off?

Does anyone know what is causing this and even better what it takes to fix it?

Thanks,

|||

This happened to me after updating common language runtime and/or installing SQL Server 2005 SP1 and/or configuring some ODBC connections. Here's how I corrected:

Navigate to Start-->Admin Tools-->Computer Mgt-->Sevices&Apps-->SQL Server Config Mgr-->SQL Server 2005 Network Config

Expand & select Protocols for MSSQL Server and verify the following settings:

Shared Memory Enabled (found Enabled)

Named Pipes Enabled (found Disabled)

TCP/IP Enabled (found Disabled)

VIA Disabled (doesn't seem to matter)

To change settings, double-click or right-click each of the above. Then use SQL Server Manager (the server PC icon in your system tray with either the green arrow or red dot) to Stop (if Started) and/or to then Start (if Stopped) the SQL Sever for the changed settings to take effect.

Error Connecting to Database Engine

David

The detailed error message says:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476

Error Number: 10061

Severity: 20

State: 0

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)

at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Does anyone know what is causing this and even better what it takes to fix it?

Thanks,

|||

This happened to me after updating common language runtime and/or installing SQL Server 2005 SP1 and/or configuring some ODBC connections. Here's how I corrected:

Navigate to Start-->Admin Tools-->Computer Mgt-->Sevices&Apps-->SQL Server Config Mgr-->SQL Server 2005 Network Config

Expand & select Protocols for MSSQL Server and verify the following settings:

Shared Memory Enabled (found Enabled)

Named Pipes Enabled (found Disabled)

TCP/IP Enabled (found Disabled)

VIA Disabled (doesn't seem to matter)

Error Connecting to Database Engine

I have been successfully using SQL Server 2005 developer

edition for a couple of months now.However,

when I started Microsoft SQL Server Management Studio this morning I could not

connect to the “Database Engine” (I’m using Windows Authentication). I can still connect with the “Integration

Services” and “Analysis Services” on the same server. The server running on my local machine, so

there shouldn’t be any problems with the network.I am also able to connect with it through

ODBC, it just seems to be the Server Management Studio which can’t connect, and it only has

problems with the “Database Engine.” Any

help would be appreciated.

David

The detailed error message says:

An error has occurred while establishing a connection to the

server.When connecting to SQL Server

2005, this failure may be caused by the fact that under the default settings SQL

Server does not allow remote connections. (provider: TCP Provider, error: 0 -

No connection could be made because the target machine actively refused it.)

(.Net SqlClient Data Provider)

For help, click:

http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476

Error Number: 10061

Severity: 20

State: 0

Program Location:

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,

Boolean breakConnection)

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject

stateObj)

System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,

Boolean& failoverDemandDone, String host, String failoverPartner, String

protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean

encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection

owningObject, Boolean aliasLookup)

System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection

owningObject, SqlConnectionString connectionOptions, String newPassword,

Boolean redirectedUserInstance)

System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity

identity, SqlConnectionString connectionOptions, Object providerInfo, String

newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions

options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection

owningConnection)

System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection

owningConnection, DbConnectionPoolGroup poolGroup)

System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection

owningConnection)

System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection

outerConnection, DbConnectionFactory connectionFactory)

System.Data.SqlClient.SqlConnection.Open()

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo

ci, IServerType server)

Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Does anyone know what is causing this and even better what it takes to fix it?

Thanks,

|||

This happened to me after updating common language runtime and/or installing SQL Server 2005 SP1 and/or configuring some ODBC connections. Here's how I corrected:

Navigate to Start-->Admin Tools-->Computer Mgt-->Sevices&Apps-->SQL Server Config Mgr-->SQL Server 2005 Network Config

Expand & select Protocols for MSSQL Server and verify the following settings:

Shared Memory Enabled (found Enabled)

Named Pipes Enabled (found Disabled)

TCP/IP Enabled (found Disabled)

VIA Disabled (doesn't seem to matter)

Sunday, February 26, 2012

Error connecting to a SQL 2005 (June CTP) Cube using Excel 2003

When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube
,
the wizard successfully finds and connects to the cube, but when I click
'finish' to retrieve the data, I get the following error:
"Initialization of the data source failed.
Check the database server or contact your database administrator. Make sure
the external database is available, and then try the operation again. If you
see this message again, create a new data source to connect to the database.
"
Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
CTP) running on the same machine.
Thanks,
--
DuncanHi Duncan
I have the same error.
I have Excel 2000 and Excel 2003 installed on my pc and SQL server 2000 and
SQL Server 2005 installed on a server. It seems that I can use most
combinations of these 2 - Excel 2000 will read data from SQL server 2000 and
2005, Excel 2003 will read data from SQL Server 2000 cubes.
But I get the same error as you when I try to read data from SQL Server 2005
Analysis Services Cubes from Excel 2003. It knows the cubes are there but
can't read the data.
Did you manage to resolve this? Can anyone else help?
Regards
Dave
"Duncan" wrote:

> When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cu
be,
> the wizard successfully finds and connects to the cube, but when I click
> 'finish' to retrieve the data, I get the following error:
> "Initialization of the data source failed.
> Check the database server or contact your database administrator. Make sur
e
> the external database is available, and then try the operation again. If y
ou
> see this message again, create a new data source to connect to the databas
e. "
> Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
> CTP) running on the same machine.
> Thanks,
> --
> Duncan|||If you found a solution, please let me know. I'm getting the same error
message.
Thanks a lot.
Duncan wrote:
> *When I use the PivotTable Wizard in Excel 2003 to connect to a SQL
> 2005 cube,
> the wizard successfully finds and connects to the cube, but when I
> click
> 'finish' to retrieve the data, I get the following error:
> "Initialization of the data source failed.
> Check the database server or contact your database administrator.
> Make sure
> the external database is available, and then try the operation again.
> If you
> see this message again, create a new data source to connect to the
> database. "
> Any ideas what could be causing this? I have Excel 2003 and SQL 2005
> (June
> CTP) running on the same machine.
> Thanks,
> --
> Duncan *
hpanneflek
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1781676.html|||hpanneflek wrote:
> *If you found a solution, please let me know. I'm getting the same
> error message.
> Thanks a lot. *
I got around this by re-registering the OLAP v9.0 dll:
regsvr32 c:\program files\common files\system\oledb\msolap90.dll
This worked for me.
Good luck
Dave
Daffyd
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1781676.html|||Thank you! It worked.
I've been using AS 2K for 3 years now and I love it. I started playing
with AS2K5 and I am realizing that a lot of things changed. My email is
hpanneflek@.univision.net in case you have any question, I'll be glad to
help.
Thanks again.
Daffyd wrote:
> *I got around this by re-registering the OLAP v9.0 dll:
> regsvr32 c:\program files\common files\system\oledb\msolap90.dll
> This worked for me.
> Good luck
> Dave *
hpanneflek
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1781676.html

Error connecting to a SQL 2005 (June CTP) Cube using Excel 2003

Quote:

Originally posted by Duncan
When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube,
the wizard successfully finds and connects to the cube, but when I click
'finish' to retrieve the data, I get the following error:
"Initialization of the data source failed.
Check the database server or contact your database administrator. Make sure
the external database is available, and then try the operation again. If you
see this message again, create a new data source to connect to the database. "
Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
CTP) running on the same machine.
Thanks,
Duncan

|||Hi both - I have exactly the same problem. Did you ever find a solution to this?
Yours in hope,

Quote:

|||Hi Duncan
I have the same error.
I have Excel 2000 and Excel 2003 installed on my pc and SQL server 2000 and
SQL Server 2005 installed on a server. It seems that I can use most
combinations of these 2 - Excel 2000 will read data from SQL server 2000 and
2005, Excel 2003 will read data from SQL Server 2000 cubes.
But I get the same error as you when I try to read data from SQL Server 2005
Analysis Services Cubes from Excel 2003. It knows the cubes are there but
can't read the data.
Did you manage to resolve this? Can anyone else help?
Regards
Dave
"Duncan" wrote:

> When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube,
> the wizard successfully finds and connects to the cube, but when I click
> 'finish' to retrieve the data, I get the following error:
> "Initialization of the data source failed.
> Check the database server or contact your database administrator. Make sure
> the external database is available, and then try the operation again. If you
> see this message again, create a new data source to connect to the database. "
> Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
> CTP) running on the same machine.
> Thanks,
> --
> Duncan

Monday, March 26, 2012

error during installing SP3

error during install SP3

error during install SP3

Wednesday, March 21, 2012

Error creating Report Model based upon Oracle Database

Error creating Report Model based upon Oracle Database

Error creating Report Model based upon Oracle Database

Error creating Report Model based upon Oracle Database

Error creating Report Model based upon Oracle Database

Wednesday, March 7, 2012

Error Connecting to Database Engine

Error Connecting to Database Engine

Error Connecting to Database Engine

Sunday, February 26, 2012

Error connecting to a SQL 2005 (June CTP) Cube using Excel 2003

Error connecting to a SQL 2005 (June CTP) Cube using Excel 2003

Error accessing report

Blog Archive

About Me