Miserable failure deploying cube

#1

Hello all:

Trying my hand at an analysis services project, but the Deploy fails
with the error:

"The following system error occurred: Logon failure: unknown user name

or bad password."

Okey-dokey, says I; I pull up the datasource editor, go to the
"Impersonation Information" tab, select the "Use a specific name and
password" option, and put in the "sa" userid and password, and think
that oughtta do it.

It don't. I get the same error.

???

Many thanks,

zdrakec

#2

I had the same issue and this is what worked for me. Under the general tab of
the Datasource --> Edit button --> this is where I used the SA username and
password but under the Impersonation tab I selected "Use the service account"

It is worth a shot
--
Marty

"zdrakec" wrote:

Quote:

Hello all:

Trying my hand at an analysis services project, but the Deploy fails
with the error:

"The following system error occurred: Logon failure: unknown user name

or bad password."

Okey-dokey, says I; I pull up the datasource editor, go to the
"Impersonation Information" tab, select the "Use a specific name and
password" option, and put in the "sa" userid and password, and think
that oughtta do it.

It don't. I get the same error.

???

Many thanks,

zdrakec

#3

Hello Marty:

Thank you for the info. Unfortunately, that is exactly what I had done,
but with no luck. I did get it to work by adding my Windows user as a
valid login to the database; but this is not the route I wanted to
take.

Any other thoughts?

Thanks again,

zdrakec

Marty wrote:

Quote:

I had the same issue and this is what worked for me. Under the general tab of
the Datasource --> Edit button --> this is where I used the SA username and
password but under the Impersonation tab I selected "Use the service account"

It is worth a shot
--
Marty

"zdrakec" wrote:

Hello all:

Trying my hand at an analysis services project, but the Deploy fails
with the error:

"The following system error occurred: Logon failure: unknown user name

or bad password."

Okey-dokey, says I; I pull up the datasource editor, go to the
"Impersonation Information" tab, select the "Use a specific name and
password" option, and put in the "sa" userid and password, and think
that oughtta do it.

It don't. I get the same error.

???

Many thanks,

zdrakec

#4

Nope, That taps me out, This is my third day with cubes so I am new at this
as you can tell by couple of my questions I posted earier today.

Sorry,
--
Marty

"zdrakec" wrote:

Quote:

Hello Marty:

Thank you for the info. Unfortunately, that is exactly what I had done,
but with no luck. I did get it to work by adding my Windows user as a
valid login to the database; but this is not the route I wanted to
take.

Any other thoughts?

Thanks again,

zdrakec

Marty wrote:
I had the same issue and this is what worked for me. Under the general tab of
the Datasource --> Edit button --> this is where I used the SA username and
password but under the Impersonation tab I selected "Use the service account"

It is worth a shot
--
Marty

"zdrakec" wrote:

Hello all:

Trying my hand at an analysis services project, but the Deploy fails
with the error:

"The following system error occurred: Logon failure: unknown user name

or bad password."

Okey-dokey, says I; I pull up the datasource editor, go to the
"Impersonation Information" tab, select the "Use a specific name and
password" option, and put in the "sa" userid and password, and think
that oughtta do it.

It don't. I get the same error.

???

Many thanks,

zdrakec

#5

I had the same issue. I reset my user id/password in the impersonation tab,
rebuild project and redeploy it.

"zdrakec" wrote:

Quote:

Hello Marty:

Thank you for the info. Unfortunately, that is exactly what I had done,
but with no luck. I did get it to work by adding my Windows user as a
valid login to the database; but this is not the route I wanted to
take.

Any other thoughts?

Thanks again,

zdrakec

Marty wrote:
I had the same issue and this is what worked for me. Under the general tab of
the Datasource --> Edit button --> this is where I used the SA username and
password but under the Impersonation tab I selected "Use the service account"

It is worth a shot
--
Marty

"zdrakec" wrote:

Hello all:

Trying my hand at an analysis services project, but the Deploy fails
with the error:

"The following system error occurred: Logon failure: unknown user name

or bad password."

Okey-dokey, says I; I pull up the datasource editor, go to the
"Impersonation Information" tab, select the "Use a specific name and
password" option, and put in the "sa" userid and password, and think
that oughtta do it.

It don't. I get the same error.

???

Many thanks,

zdrakec

#6

This is quite a common mistake. The Impersonation for a datasource can be
set to a particular User -- but that user is a Windows user and not a
username/password in the relational database.

If you need to specify a username/password for SQL Authentication to the
relational database then it should be specified in the connection dialog and
not as an Impersonation configuration (the impersonation should stay as the
service account normally)...

Specifying a username/password in the Impersonation dialog says:
- impersonate this Windows user
- connect to the SQL Server database while running as this user
(normally using Windows authentication)

Since 'sa' isn't a Windows user, I guess it is failing for you...

HTH,
Akshai

--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Marty" <Marty (AT) discussions (DOT) microsoft.com> wrote

Quote:

Nope, That taps me out, This is my third day with cubes so I am new at
this
as you can tell by couple of my questions I posted earier today.

Sorry,
--
Marty

"zdrakec" wrote:

Hello Marty:

Thank you for the info. Unfortunately, that is exactly what I had done,
but with no luck. I did get it to work by adding my Windows user as a
valid login to the database; but this is not the route I wanted to
take.

Any other thoughts?

Thanks again,

zdrakec

Marty wrote:
I had the same issue and this is what worked for me. Under the general
tab of
the Datasource --> Edit button --> this is where I used the SA username
and
password but under the Impersonation tab I selected "Use the service
account"

It is worth a shot
--
Marty

"zdrakec" wrote:

Hello all:

Trying my hand at an analysis services project, but the Deploy fails
with the error:

"The following system error occurred: Logon failure: unknown user
name

or bad password."

Okey-dokey, says I; I pull up the datasource editor, go to the
"Impersonation Information" tab, select the "Use a specific name and
password" option, and put in the "sa" userid and password, and think
that oughtta do it.

It don't. I get the same error.

???

Many thanks,

zdrakec

#7

Aha! That certainly explains it!

Thanks much,

zdrakec

Akshai Mirchandani [MS] wrote:

Quote:

This is quite a common mistake. The Impersonation for a datasource can be
set to a particular User -- but that user is a Windows user and not a
username/password in the relational database.

If you need to specify a username/password for SQL Authentication to the
relational database then it should be specified in the connection dialog and
not as an Impersonation configuration (the impersonation should stay as the
service account normally)...

Specifying a username/password in the Impersonation dialog says:
- impersonate this Windows user
- connect to the SQL Server database while running as this user
(normally using Windows authentication)

Since 'sa' isn't a Windows user, I guess it is failing for you...

HTH,
Akshai

--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Marty" <Marty (AT) discussions (DOT) microsoft.com> wrote in message
news:BA0C1A1F-C56F-4743-8800-BC5AAEA1B2CF (AT) microsoft (DOT) com...
Nope, That taps me out, This is my third day with cubes so I am new at
this
as you can tell by couple of my questions I posted earier today.

Sorry,
--
Marty

"zdrakec" wrote:

Hello Marty:

Thank you for the info. Unfortunately, that is exactly what I had done,
but with no luck. I did get it to work by adding my Windows user as a
valid login to the database; but this is not the route I wanted to
take.

Any other thoughts?

Thanks again,

zdrakec

Marty wrote:
I had the same issue and this is what worked for me. Under the general
tab of
the Datasource --> Edit button --> this is where I used the SA username
and
password but under the Impersonation tab I selected "Use the service
account"

It is worth a shot
--
Marty

"zdrakec" wrote:

Hello all:

Trying my hand at an analysis services project, but the Deploy fails
with the error:

"The following system error occurred: Logon failure: unknown user
name

or bad password."

Okey-dokey, says I; I pull up the datasource editor, go to the
"Impersonation Information" tab, select the "Use a specific name and
password" option, and put in the "sa" userid and password, and think
that oughtta do it.

It don't. I get the same error.

???

Many thanks,

zdrakec

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Miserable failure deploying cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Miserable failure deploying cube - 11-09-2006 , 01:33 PM

RE: Miserable failure deploying cube - 11-09-2006 , 03:08 PM

Re: Miserable failure deploying cube - 11-09-2006 , 03:26 PM

Re: Miserable failure deploying cube - 11-09-2006 , 03:41 PM

Re: Miserable failure deploying cube - 11-10-2006 , 02:37 PM

Re: Miserable failure deploying cube - 11-22-2006 , 07:47 PM

Re: Miserable failure deploying cube - 11-22-2006 , 09:05 PM