Cannot restore / Create Analysis Database

Hi everybody,

I've installed SSAS 2008.

When I try to create a new database or to restore a database, I've many errors :

Create Database :

Either the 'TLS\christophe.laporte' user does not have permission to create a new object in 'PC-LAPORTE', or the object does not exist.
(Microsoft.AnalysisServices)

Program Location:

at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate)
at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.Server.SendUpdate(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings)
at Microsoft.AnalysisServices.MajorObject.Update()
at Microsoft.AnalysisServices.ManagementDialogs.OlapCreateDB.SendDataToServer()

Restore Database when I click on browse button:

Database administrator or server administrator permissions are required to execute SystemGetLogicalDrives command. (Microsoft SQL Server code name "Katmai" Analysis Services)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(CommandBehavior behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Microsoft.AnalysisServices.Controls.FileSystemBrowser.Call(String function)
at

Any idea ?

I've installed Katmai on Vista. My account is in the administrators group on the computer. All services are started with a domain admin account ( and I'am too).

Maybe I've te setup katmai again ?

Thanks.

Christophe.

France.

Oups, sorry,

SSMS launched with administrator privileges is OK.

But why I get this error ? MMy account is administrator ...

And why SSMS don't query about privilege elevation when browsing for files or creating a database ?

Chrisstophe.

France.

|||

Chris,

I am not surprised that you have issues with SSAS on Vista PC. Actually on CTP download page Microsoft has a note regarding this:

The SQL Server 2008 June CTP has known compatibility issues with Windows Vista and Windows Server 2008 Beta. We do not recommend testing this CTP on this configuration. Instead, test this CTP on Windows Server 2003 Enterprise Edition with SP1 installed for 32-bit x86 and 64-bit x64 editions, and Windows XP Professional Edition with SP2 installed for 32-bit x86 and 64-bit x64 editions.

So I think you just will have to wait for future CTPs and see if they fixed issues on Vista.

Vidas Matelis

http://www.ssas2008-info.com