Showing posts with label authentication. Show all posts
Showing posts with label authentication. Show all posts

Friday, March 30, 2012

Profiler 2005 issue

Hi!

When I try to run profile 2005 ... as soon as i hit the connect button (authentication dialog) I get this error:

The procedure entry point lstrcpynI could not be located in the dynamic link library MSDART.DLL

any ideas?

Everything is up to date on my system. my configuration:

SQL Server 2000 enterprise (can't wait till next week to get EE for 2005)
WS 2003 w/SP1
.NET 1.1/2.0 (2.0 was installed with SQL 2005)
VS.NET 2003 (going to install 2005 later)

Office 2003 with SP2anyone?

Monday, March 12, 2012

Processing error

Hi all,

This came up and I have never see it before, I have tried logging in as sa and by using Windows Authentication and both give the same error. The error below occurred while using sa and the password. I get the same thing when I use WA (I am sysadmin).

Anyone have any ideas about what could be causing this?

Thanks,

Roy

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Parallel>

<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<Object>

<DatabaseID>Pipeline Cube</DatabaseID>

<DimensionID>Tbl Pipeline Date</DimensionID>

</Object>

<Type>ProcessFull</Type>

<WriteBackTableCreation>UseExisting</WriteBackTableCreation>

</Process>

</Parallel>

</Batch>

Processing Dimension 'Tbl Pipeline Date' completed successfully.

Start time: 2/24/2006 9:01:52 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:05

Processing Dimension Attribute '(All)' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:53 AM; Duration: 0:00:00

Processing Dimension Attribute 'DYear' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'Quarter' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'MonthNumber' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'ActualDate' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'WeekNumber' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'DayOfWeek' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'DayOfMonth' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'MonthName' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Errors and Warnings from Response

The following system error occurred: Logon failure: unknown user name or bad password. .

Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works', Name of 'Adventure Works'.

Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Tbl Pipeline Date', Name of 'Tbl Pipeline Date' was being processed.

Errors in the OLAP storage engine: An error occurred while the 'Quarter' attribute of the 'Tbl Pipeline Date' dimension from the 'Pipeline Cube' database was being processed.

Have you configured your data source to use the service account credentials? Analysis Services only supports that setting.

_-_-_ Dave

|||

Dave,

You are correct. I had forgotten all about using the service account credentials.

Thanks,

Roy