Cannot Deploy Cube to Server

Hi,

I have created a new Cube where the data source itself is not on a SQL Server (DB2 in my case). Now if I try to deploy my Cube it brings an error messages:

(Translated from German)

System error: Login failed: Unknown user or bad password

I could break down the problem until the point that I assume it has to do with the fact that during the deployment process the BI Studio tries to use the same account defined in my data source to access the non SQL Data source as well as the login for the SQL Server 2005 database to store the analysis data.

How can I change the deployment process so it will use one account for the source data and another one as a login for the analysis database?

Thanks.

Ertan

I would guess that connection is attempted under your Analysis Sever service account.

Check if that has sufficient privileges.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Where do I have to set or check this?|||

To see the account your Analysis Server is running you can use SQL Server Configuration Manager application installed SQL Installation->Configuration and Tools.

See what user Analysis Server is running under and try connecting to your Oracle database under it's credentials.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Also, what is the impersonation account specified for your data source? You can set this either to Service Account or a specified user account - this would enable you to specify a user account to connect to the underlying data source (giving this account the appropriate permissions) rather than giving these permissions to the Analysis Services service account.|||

Actually let me correct myself here.

Connecting to Oracle you should check:

First. The account under which your data source connection is impersonated should have sufficient privileges to connect Oracle machine. Deepened on the way you specified data source can be impersonated under service account or under specific user credentials you specified as part of your data source.

Second. When connecting to Oracle machine, you should specify correct user name and password as part of your connection string.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Cannot Deploy Cube to Server

Hi,

I have created a new Cube where the data source itself is not on a SQL Server (DB2 in my case). Now if I try to deploy my Cube it brings an error messages:

(Translated from German)

System error: Login failed: Unknown user or bad password

I could break down the problem until the point that I assume it has to do with the fact that during the deployment process the BI Studio tries to use the same account defined in my data source to access the non SQL Data source as well as the login for the SQL Server 2005 database to store the analysis data.

How can I change the deployment process so it will use one account for the source data and another one as a login for the analysis database?

Thanks.

Ertan

I would guess that connection is attempted under your Analysis Sever service account.

Check if that has sufficient privileges.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Where do I have to set or check this?|||

To see the account your Analysis Server is running you can use SQL Server Configuration Manager application installed SQL Installation->Configuration and Tools.

See what user Analysis Server is running under and try connecting to your Oracle database under it's credentials.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Also, what is the impersonation account specified for your data source? You can set this either to Service Account or a specified user account - this would enable you to specify a user account to connect to the underlying data source (giving this account the appropriate permissions) rather than giving these permissions to the Analysis Services service account.|||

Actually let me correct myself here.

Connecting to Oracle you should check:

First. The account under which your data source connection is impersonated should have sufficient privileges to connect Oracle machine. Deepened on the way you specified data source can be impersonated under service account or under specific user credentials you specified as part of your data source.

Second. When connecting to Oracle machine, you should specify correct user name and password as part of your connection string.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Cannot Deploy Cube to Server

Hi,

I have created a new Cube where the data source itself is not on a SQL Server (DB2 in my case). Now if I try to deploy my Cube it brings an error messages:

(Translated from German)

System error: Login failed: Unknown user or bad password

I could break down the problem until the point that I assume it has to do with the fact that during the deployment process the BI Studio tries to use the same account defined in my data source to access the non SQL Data source as well as the login for the SQL Server 2005 database to store the analysis data.

How can I change the deployment process so it will use one account for the source data and another one as a login for the analysis database?

Thanks.

Ertan

I would guess that connection is attempted under your Analysis Sever service account.

Check if that has sufficient privileges.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Where do I have to set or check this?|||

To see the account your Analysis Server is running you can use SQL Server Configuration Manager application installed SQL Installation->Configuration and Tools.

See what user Analysis Server is running under and try connecting to your Oracle database under it's credentials.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Also, what is the impersonation account specified for your data source? You can set this either to Service Account or a specified user account - this would enable you to specify a user account to connect to the underlying data source (giving this account the appropriate permissions) rather than giving these permissions to the Analysis Services service account.|||

Actually let me correct myself here.

Connecting to Oracle you should check:

First. The account under which your data source connection is impersonated should have sufficient privileges to connect Oracle machine. Deepened on the way you specified data source can be impersonated under service account or under specific user credentials you specified as part of your data source.

Second. When connecting to Oracle machine, you should specify correct user name and password as part of your connection string.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Cannot connect to database

I have SQL Server 2000 Developers Edition install at work and home
machines., I configure as Windows Authentication.
I am using the CASE Tools DBDesigner to connect to SQL Server.
However, I got probelm in connecting to SQL SErver 2000 at home, the
scenario is below:
1)I create a Windows user in Windows 2000 Professional by Control Panel
2)Go to SQL Server Enterprise Manager
3)Goto Security, create Logins
4)Goto Northwind database
5)Add Database User from Users folder
The problem is it works at work machine, but when I do the same at home
machine, I got different things.
At home machine, I got the new user has domain name prefix, it does not
appear in my work machine.
Now, at home machine, I tried to connect from DBDesigner 4, I got the error
something like the login is not associated with trusted login.
Why it was happened like this ?Alan
Try to switch Authentication to SQL Server and Windows.
Connect to SQL Server as 'sa'
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:e%23AlYYoTEHA.1548@.TK2MSFTNGP11.phx.gbl...
> I have SQL Server 2000 Developers Edition install at work and home
> machines., I configure as Windows Authentication.
> I am using the CASE Tools DBDesigner to connect to SQL Server.
> However, I got probelm in connecting to SQL SErver 2000 at home, the
> scenario is below:
> 1)I create a Windows user in Windows 2000 Professional by Control Panel
> 2)Go to SQL Server Enterprise Manager
> 3)Goto Security, create Logins
> 4)Goto Northwind database
> 5)Add Database User from Users folder
> The problem is it works at work machine, but when I do the same at home
> machine, I got different things.
> At home machine, I got the new user has domain name prefix, it does not
> appear in my work machine.
> Now, at home machine, I tried to connect from DBDesigner 4, I got the
error
> something like the login is not associated with trusted login.
> Why it was happened like this ?
>|||What is the exact error you are getting?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Sorry for late reply.
Now I need to list my details of my work machine SQL Server Developer
editions within Enterprise Manager:
- Use Windows authentication
- I add one login eg. 'bbb', password with 'bbb' from Security|Logins
I have NOT added user in Northwind database yet.
Now leave Enterprise Manager.
Goto DBDesigner 4, select the option reverse engineering, select the
connection to Northwind database, type in 'bbb' with password 'bbb'.
Magic is coming out: DBDesigner can reengineer the logical database
structure for me.
This is so far so good in my working place machine.
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:W4ql$9uTEHA.304@.cpmsftngxa10.phx.gbl...
> What is the exact error you are getting?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>

Cannot connect to database

I have SQL Server 2000 Developers Edition install at work and home
machines., I configure as Windows Authentication.
I am using the CASE Tools DBDesigner to connect to SQL Server.
However, I got probelm in connecting to SQL SErver 2000 at home, the
scenario is below:
1)I create a Windows user in Windows 2000 Professional by Control Panel
2)Go to SQL Server Enterprise Manager
3)Goto Security, create Logins
4)Goto Northwind database
5)Add Database User from Users folder
The problem is it works at work machine, but when I do the same at home
machine, I got different things.
At home machine, I got the new user has domain name prefix, it does not
appear in my work machine.
Now, at home machine, I tried to connect from DBDesigner 4, I got the error
something like the login is not associated with trusted login.
Why it was happened like this ?Alan
Try to switch Authentication to SQL Server and Windows.
Connect to SQL Server as 'sa'
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:e%23AlYYoTEHA.1548@.TK2MSFTNGP11.phx.gbl...
> I have SQL Server 2000 Developers Edition install at work and home
> machines., I configure as Windows Authentication.
> I am using the CASE Tools DBDesigner to connect to SQL Server.
> However, I got probelm in connecting to SQL SErver 2000 at home, the
> scenario is below:
> 1)I create a Windows user in Windows 2000 Professional by Control Panel
> 2)Go to SQL Server Enterprise Manager
> 3)Goto Security, create Logins
> 4)Goto Northwind database
> 5)Add Database User from Users folder
> The problem is it works at work machine, but when I do the same at home
> machine, I got different things.
> At home machine, I got the new user has domain name prefix, it does not
> appear in my work machine.
> Now, at home machine, I tried to connect from DBDesigner 4, I got the
error
> something like the login is not associated with trusted login.
> Why it was happened like this ?
>|||What is the exact error you are getting?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Sorry for late reply.
Now I need to list my details of my work machine SQL Server Developer
editions within Enterprise Manager:
- Use Windows authentication
- I add one login eg. 'bbb', password with 'bbb' from Security|Logins
I have NOT added user in Northwind database yet.
Now leave Enterprise Manager.
Goto DBDesigner 4, select the option reverse engineering, select the
connection to Northwind database, type in 'bbb' with password 'bbb'.
Magic is coming out: DBDesigner can reengineer the logical database
structure for me.
This is so far so good in my working place machine.
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:W4ql$9uTEHA.304@.cpmsftngxa10.phx.gbl...
> What is the exact error you are getting?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>

Cannot connect to database

I have SQL Server 2000 Developers Edition install at work and home
machines., I configure as Windows Authentication.
I am using the CASE Tools DBDesigner to connect to SQL Server.
However, I got probelm in connecting to SQL SErver 2000 at home, the
scenario is below:
1)I create a Windows user in Windows 2000 Professional by Control Panel
2)Go to SQL Server Enterprise Manager
3)Goto Security, create Logins
4)Goto Northwind database
5)Add Database User from Users folder
The problem is it works at work machine, but when I do the same at home
machine, I got different things.
At home machine, I got the new user has domain name prefix, it does not
appear in my work machine.
Now, at home machine, I tried to connect from DBDesigner 4, I got the error
something like the login is not associated with trusted login.
Why it was happened like this ?
Alan
Try to switch Authentication to SQL Server and Windows.
Connect to SQL Server as 'sa'
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:e%23AlYYoTEHA.1548@.TK2MSFTNGP11.phx.gbl...
> I have SQL Server 2000 Developers Edition install at work and home
> machines., I configure as Windows Authentication.
> I am using the CASE Tools DBDesigner to connect to SQL Server.
> However, I got probelm in connecting to SQL SErver 2000 at home, the
> scenario is below:
> 1)I create a Windows user in Windows 2000 Professional by Control Panel
> 2)Go to SQL Server Enterprise Manager
> 3)Goto Security, create Logins
> 4)Goto Northwind database
> 5)Add Database User from Users folder
> The problem is it works at work machine, but when I do the same at home
> machine, I got different things.
> At home machine, I got the new user has domain name prefix, it does not
> appear in my work machine.
> Now, at home machine, I tried to connect from DBDesigner 4, I got the
error
> something like the login is not associated with trusted login.
> Why it was happened like this ?
>
|||What is the exact error you are getting?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Sorry for late reply.
Now I need to list my details of my work machine SQL Server Developer
editions within Enterprise Manager:
- Use Windows authentication
- I add one login eg. 'bbb', password with 'bbb' from Security|Logins
I have NOT added user in Northwind database yet.
Now leave Enterprise Manager.
Goto DBDesigner 4, select the option reverse engineering, select the
connection to Northwind database, type in 'bbb' with password 'bbb'.
Magic is coming out: DBDesigner can reengineer the logical database
structure for me.
This is so far so good in my working place machine.
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:W4ql$9uTEHA.304@.cpmsftngxa10.phx.gbl...
> What is the exact error you are getting?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>