Errors when setting up Cube from Project Server 2007 in Analysis Server

We try to setup a cube from Project Server in our (seperated) Analysis Server.

Even though following all the instructions which can be found and equally we setup the repository in the SQL 2005 Server or use the .mdb, we run into the following errors:

[26.07.2007 12:19 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server SERVER. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:
===== Process Completed =====
[26.07.2007 12:19 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server SERVER. Error: Your permissions on the server computer do not allow you to administer this Analysis server.

The Project Server Queue Service user is a) SQL sysadmin and b) SQL Server Admin group member - at least it became this after everything else didn't work out..

The correct shares etc. on filebase are given, even it is checked that the Queue Account can connect to the share from another computer, ...

So now I wonder whether someone else had this issue and can help out here?

Thanks in advance.

Hello! In order to set up an SSAS2005 cube you will need to have administrators permissions on SSAS2005.

I assume that SSAS2005 and SQL Server 2005 run on the same server.

Connect to SSAS2005 with Management Studio and right click on the server. Choose properties and the security tab(server wide security privileges) and the add the user who shoul have rights to deploy and process the cube.

HTH

Thomas Ivarsson

|||

I am having similar problems.

I have added the shared service provider to AS box. I restarted AS and I am still gettting the same error.

Any help would be greatly appreciated....

Here is the event log:

"Standard InformationSI Entry Point:
Project User: <domain\server name>
Correlation Id: 4f990c61-13e6-49b3-949e-2867e681c38b
PWA Site URL: <server name>
SSP Name: SharedServices1
PSError: CBSASConnectionFailure (17003)
Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=<IP Address> ASDBName=OLAPCUBE ASExtraNetAddress=<IP Address> RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=08/01/2007 12:11:58 ToDate=08/01/2007 12:11:58 HighPriority=True

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

"

Errors accessing VFP data.

I have a test system setup in Reading.
SQL Server is on machine EUK01314
IIS 5 also is on machine EUK01314
Reporting services are installed on machine EUK01314
Visual Studo is on machine EUK01314
I can create reports that access SQL server data, or via ODBC, or via OLEDB
to SQL server on EUK01314.
I can use those reports from our Terminal Server, no problem.
I can create reports that access Oracle data, via ODBC, or via OLEDB to
Oracle on a server in Belgim..
I can use those reports from our Terminal Server, no problem.
I draw a total blank accessing Visual FoxPro data.
I can create reports that access VFP data, via ODBC or OLEDB.
Those reports work on EUK01314 in Visual Studio.
Those reports work on EUK01314 in IE via Report Manager.
So why on earth (or any other planet) don't they work on any other machine
?
Connection string: Driver={Microsoft Visual FoxPro
Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
file \\ecengds001\connections\data\connrdp.dbc. ERROR [IM006]
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR
[01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the
version of ODBC behavior that the application requested (see SQLSetEnvAttr).
Connection string: Driver={Microsoft Visual FoxPro
Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Query execution failed for data set 'DataSet1'.
(rsErrorExecutingCommand) Get Online Help
a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
file \\ecengds001\connections\data\service.dbf.
Connection String: Provider=VFPOLEDB.1;Data
Source=\\eukfs01\mis_deve\andersonanalysis\data\;Collating Sequence=MACHINE
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. Invalid path or file name.
Change to use credentials when connecting to datasource. (my user ID and
password)
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.
Change to also impersonate user in Windows after connection.
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot impersonate user for data source 'DataSource1'.
(rsErrorImpersonatingUser) Get Online Help
a.. Specified method is not supported.
Remember, these work just fine when Report Manager is accessed from
EUK01314.
They do not work if Report Manager is accessed from another machine.
--
PAulHi PAul :-)
I think checking the Deleted box corresponds to SET DELETED ON which
evaluates to DELETED=YES in the connection string so be sure to verify that
you're getting what you want. Sorry I can't help on the ReportingSvcs stuff.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:efE5woQwEHA.3872@.TK2MSFTNGP11.phx.gbl...
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO|||You are using SP1, right? This looks similar to an issue that we had with
Access databases (MDBs) on remote shares. Is the FoxPro database on the same
machine as the Report Server? At one point, we were incorrectly adding an
Integrated Security property to the connection string but this should have
been fixed.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:efE5woQwEHA.3872@.TK2MSFTNGP11.phx.gbl...
>I have a test system setup in Reading.
> SQL Server is on machine EUK01314
> IIS 5 also is on machine EUK01314
> Reporting services are installed on machine EUK01314
> Visual Studo is on machine EUK01314
> I can create reports that access SQL server data, or via ODBC, or via
> OLEDB to SQL server on EUK01314.
> I can use those reports from our Terminal Server, no problem.
> I can create reports that access Oracle data, via ODBC, or via OLEDB to
> Oracle on a server in Belgim..
> I can use those reports from our Terminal Server, no problem.
> I draw a total blank accessing Visual FoxPro data.
> I can create reports that access VFP data, via ODBC or OLEDB.
> Those reports work on EUK01314 in Visual Studio.
> Those reports work on EUK01314 in IE via Report Manager.
> So why on earth (or any other planet) don't they work on any other machine
> ?
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
> file \\ecengds001\connections\data\connrdp.dbc. ERROR [IM006]
> [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR
> [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the
> version of ODBC behavior that the application requested (see
> SQLSetEnvAttr).
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Query execution failed for data set 'DataSet1'.
> (rsErrorExecutingCommand) Get Online Help
> a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
> file \\ecengds001\connections\data\service.dbf.
> Connection String: Provider=VFPOLEDB.1;Data
> Source=\\eukfs01\mis_deve\andersonanalysis\data\;Collating
> Sequence=MACHINE
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Invalid path or file name.
> Change to use credentials when connecting to datasource. (my user ID and
> password)
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Multiple-step OLE DB operation generated errors. Check each OLE
> DB status value, if available. No work was done.
> Change to also impersonate user in Windows after connection.
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot impersonate user for data source 'DataSource1'.
> (rsErrorImpersonatingUser) Get Online Help
> a.. Specified method is not supported.
> Remember, these work just fine when Report Manager is accessed from
> EUK01314.
> They do not work if Report Manager is accessed from another machine.
> --
> PAul
>|||Thanks Brian.
Sorry for the delay, I've been away in Utrecht.
I started out with the evaluation edition, then installed the SP1 download
onto that.
I had no errors reported during the installation of SP1, so I assume it
really completed OK.
How can I find out what the connection string being used is?
I know what I typed into the Report Manager, but you're implying that
something else is actually sent.
If there's a way to debug this, I'd like to get to the bottom of it.|||Hmm. I'm not sure there is a trace for VFP. Is it OLE DB or ODBC? For SP1,
the string should be the same (we don't add the Integrated Security flag for
other providers). You can make sure SP1 was successful by looking at the
version under http://server/reportserver.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:OZUD5Xx0EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Thanks Brian.
> Sorry for the delay, I've been away in Utrecht.
> I started out with the evaluation edition, then installed the SP1 download
> onto that.
> I had no errors reported during the installation of SP1, so I assume it
> really completed OK.
> How can I find out what the connection string being used is?
> I know what I typed into the Report Manager, but you're implying that
> something else is actually sent.
> If there's a way to debug this, I'd like to get to the bottom of it.
>|||Sorry for the delay, I've been dragged onto a BizTalk project for a while.
Microsoft SQL Server Reporting Services Version 8.00.878.00

errorlog monitoring & job outputs

Considering email is setup, how would you send emails by scanning errorlog for any issues. Also, how to send program outputs using email.
Thanks...nobody has this kind of setup?|||Which mail, setup how?

-PatP|||email setup to send emails from SQL Server.|||Need more info from ya, Mkalsi...you can use xp_sendmail to do it...I have things setup to do what I THINK you are trying to do...

Although, this is probably more convoluted than you need...I wanted to try to make my messages a little more readable than just inserting the error message row columns from the EventLog table...

Anyway...check out the sendmail code near the bottom...that's the gist of what you'll need.

Keep in mind though, that there's a whole 'nother arm-wrestling match about permissions and user id stuff that must be in place to send mail from SQL Server 2000 through outlook - it was a tad more complex than just point-n-shoot.

*================================================= ====================================
| Name: Send_EventLog_Mail_By_Level
| Description: Performs a select against the EventLog table based on input parameters for target date and
| target error level and inserts the selected rows into an email which is then sent to a static
| mail address list. No email is sent if selection results in no rows selected for that date/error level.
|
| Created: 04/29/2004 by Yo_Mama
| Modified: 09/20/2004 by Yo_Mama - Added Server Name to message subject/message body.
| Inputs: TDate (smalldatetime) - The date for which any errors are to be selected/reported via email.
| TLevel (int) - The relative error level for which rows are to be selected/reported via email.
|================================================= =====================================*/
CREATE PROCEDURE [dbo].[Send_EventLog_Mail_By_Level]
@.TDate smalldatetime = NULL,
@.TLevel int = 0
AS

DECLARE @.SQLCmd varchar(256)
DECLARE @.Message varchar(256)
DECLARE @.Subject varchar(128)
DECLARE @.TargetDate smalldatetime
DECLARE @.LargestEventSize int
DECLARE @.SvrName varchar(30)

/*-- Capture Server Name and build string to use in WaitForFile request */
SET @.SvrName = CONVERT(varchar, SERVERPROPERTY ('ServerName'))

IF (@.TDate IS NULL)
SET @.TargetDate = CONVERT(varchar(10), GETDATE(), 101)
ELSE
SET @.TargetDate = CONVERT(varchar(10), @.TDate, 101)

/*-- Drop the temporary table and recreate it */
IF EXISTS (SELECT *
FROM dbo.sysobjects
WHERE ID = OBJECT_ID(N'[dbo].[EventLogTbl]')
AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[EventLogTbl]

CREATE TABLE [dbo].[EventLogTbl] (EvtID int, EventDesc varchar(1200))

/*-- Build rows in the temporary table by selecting the date and message level desired and formatting row */
INSERT INTO EventLogTbl
SELECT [ID] as EvtID, ('---> ID=' + LTRIM(CONVERT(varchar(10), [ID])) +
', Date=' + CONVERT(varchar(20), [Date]) + ', Level=' +
LTRIM(CONVERT(varchar(2), MsgLevel)) + ', APP=' + RTRIM(App) +
', Function=' + RTRIM([Function]) + ', Message=' + RTRIM(Message) +
', Rows=' + LTRIM(CONVERT(varchar(5), [Rows])) + ', Host=' +
RTRIM(Host)) AS EventDesc
FROM EventLog
WHERE (CONVERT(varchar(10), [Date], 101) = CONVERT(varchar(10), @.TargetDate, 101)) AND
MsgLevel = @.TLevel

/*-- If our dragnet caught anything, then format subject line, message intro, and detail the message rows */
IF (@.@.ROWCOUNT > 0)
BEGIN
SET @.Subject = @.SvrName + '.IBDIndex - Level ' +
CONVERT(varchar(3), @.TLevel) + ' Processing Events were found for ' +
CONVERT(varchar(10), @.TargetDate,101)

SET @.Message = 'The following events (Message Level ' + CONVERT(varchar(3), @.TLevel) +
') occurred in ' + @.SvrName + '.IBDIndex processing on ' +
CONVERT(varchar(12), @.TargetDate,101) + CHAR(13) + CHAR(10) +
CHAR(9) + '- Check EventLog table for details and context' +
CHAR(13) + CHAR(10)

/*-- Capture the longest message in the temp table...need it to cast varchar below */
SELECT @.LargestEventSize = Max(Len(EventDesc))
FROM EventLogTbl

/*-- Set the SQL command for xp_sendmail - need to recast varchar to avoid trailing blanks */
SET @.SqlCmd = 'SELECT Cast(EventDesc AS varchar(' +
CONVERT(varchar(5), @.LargestEventSize) +
')) FROM EventLogTbl ORDER BY EvtID'

/*-- Send of the email!!! */
EXECUTE Master.dbo.xp_sendmail
'Yo_Mama@.AngieDaddyToo.com',
@.query = @.SQLCmd,
@.no_header= 'TRUE',
@.dbuse = 'MyDatabase',
@.subject=@.Subject,
@.message=@.message
END

DROP TABLE EventLogTbl

RETURN

GO

error-1920.service mssqlserver failed

hi
i am trying to install a software package called arrayinformatics. this
comes along with msde as part of it.
when i run the setup for arrayinformatics, as admin, after sometime, the
status of the installshield wizard shows that...
generating script operations for action:......
and thats it..after that nothing happens and i get a dozen dll load
error...starting from...
REPLRES.RLL cannot load resource dll error..
run setup again to install this file...
after clicking ok for a dozen of such error...
the installshield wizard now says that...
error-1920. service mssqlserver failed to start. verify that you have
sufficient privileges to start system services...
and closes,without completing the installation.
i tried installing the msde separately..and it got installed.. and i was
even able to start and stop the services...
but the arrayinformatics doesnt install with a previously installed mssql
server...
so i am struck here...i tried to figure out this problem...searching the net
for the past 2 days and couldnt solve it...
kindly help me..to fix this problem
thanks
vijayaraj nagarajan
graduate student
the university of southern mississippi
MS - USA
hi,
vijayaraj nagarajan wrote:
> hi
> i am trying to install a software package called arrayinformatics.
> this comes along with msde as part of it.
> when i run the setup for arrayinformatics, as admin, after sometime,
> the status of the installshield wizard shows that...
> generating script operations for action:......
> and thats it..after that nothing happens and i get a dozen dll load
> error...starting from...
> REPLRES.RLL cannot load resource dll error..
> run setup again to install this file...
> after clicking ok for a dozen of such error...
> the installshield wizard now says that...
> error-1920. service mssqlserver failed to start. verify that you have
> sufficient privileges to start system services...
> and closes,without completing the installation.
> i tried installing the msde separately..and it got installed.. and i
> was even able to start and stop the services...
> but the arrayinformatics doesnt install with a previously installed
> mssql server...
> so i am struck here...i tried to figure out this problem...searching
> the net for the past 2 days and couldnt solve it...
if you separately succesfully installed MSDE with the official Microsoft
package, I think you have to check this issue with arrayinformatics
technicians... perhaps their installshield script is not correct...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Error-14010-remote server not defined as subscription server

Running SQL Server Personal Ed (Server A) on Tablet PC (publication and distribution setup here) trying to push data to SQL Server 2000 Enterprise Ed. (Server B). When I start sync I get two failures. First is 'remote server not defined as subscription server'. Second, subscription to publication xx not valid (error# -2147201019). The snapshot is succeeding fine. What do I need to setup on Server B? I have the same db on both servers.

Try with running sp_addsubscriber 'Server B' to see if it will be fixed.|||

I did run sp_add subscriber only to verify Server B already exists. A subscription shows up on server B; listed as never started.

I have not been able to succeed this task.

Server A db properties-replication tab-configure-subscribers tab-set agent connection to subscriber to impersonate-rerun PUSH suscription-response-login fail for anonymous logon.

How to setup both servers to accept anonymous logon?

|||

This issue has been resolved.

Security settings was the problem on both servers.

thx..bt