Can''t Deploy Cube SSAS step by step

Hi,

This is extremely frustrating, I really hope someone can give me a hand.

I've just completed all the steps from the book and clicked deploy. I was asked for a password and since it wouldn't accept blank I entered a string.

This apparently was a big mistake as i got the

"Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty."

message. Now I don't know what to do next.

2 questions:

1. How do I change the fake password I entered?

2. What do I need to do to make the process work.

Thanks,

Y.

in visual studio AS, right-click in the datasource and there is options relatite to this subject, like using the service account or a specific user to deploy the cube...

helped? if not, I could give you more specific answer!

Regards!

|||

hanks Pedro,

I managed to change the password using your instructions.

Best,

Yaniv.

Cant create database. VS 2008. Need help.

Hello,

I just installed VS 2008.

I opened the Server Explorer window and right clicked on Data Connections and selected "Create New SQL Server Database".

Then I selected the Server Name and wrote the database name. I have Windows Authentication selected.

When I click OK I get the error:

"An error has occurred while establishing a connection to the server. When connection 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: Named Pipes Provides, error: 40 - Could not open a connection to SQL Server)

Could someone, please, tell me what I am doing wrong?

Thanks,

Miguel

error: 40 - Could not open a connection to SQL Server

It's a connection problem. Are you sure you have typed the correct server name? Also note there could be firewall issues which block your connection. I would suggest you connecting the database server

through mangement studio frist and see if the server is reachable from your machine.

Hope my suggestion helps

Can't create a new publication

Hi,
I'm trying to create a publication in a SQL Server 2005 server. I
right clicked on Replication tab in management studio and selected
'New Publication'. The management studio waits for a long time and
then nothing happens. It does not start any 'New Publication' wizard
nor does it report any error. Could you please let me know if there
are any server settings that need to be enabled before configuring
Publications.
Thanks and Regards,
Thyagu.D
Does anything appear in the sql server log, or the windows log? What happens
if you run sp_adddistributor and sp_adddistributiondb directly?
Cheers,
Paul Ibison
|||You probably have some locking going on from a previous replication process.
Issue calls to sp_who2 or select * from sysprocesses where blocked<>0 order
by waittime desc to see if you can see these processes and kill them.
You might also want to try to create they publication by using replication
stored procedures.
Try sp_replicationdboption 'MyDatabase', 'published', true for a start.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Thyagu" <tdelli@.gmail.com> wrote in message
news:1184566869.270526.315190@.e16g2000pri.googlegr oups.com...
> Hi,
> I'm trying to create a publication in a SQL Server 2005 server. I
> right clicked on Replication tab in management studio and selected
> 'New Publication'. The management studio waits for a long time and
> then nothing happens. It does not start any 'New Publication' wizard
> nor does it report any error. Could you please let me know if there
> are any server settings that need to be enabled before configuring
> Publications.
> Thanks and Regards,
> Thyagu.D
>
|||On Jul 16, 2:14 pm, Paul Ibison <Paul.Ibi...@.Pygmalion.Com> wrote:
> Does anything appear in the sql server log, or the windows log? What happens
> if you run sp_adddistributor and sp_adddistributiondb directly?
> Cheers,
> Paul Ibison
This worked. Thanks!
Regards,
Thyagu.D