dbTalk Databases Forums  

OLAP-Client not in Domain

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


Discuss OLAP-Client not in Domain in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jam96-BuffaloJoe
 
Posts: n/a

Default OLAP-Client not in Domain - 12-02-2004 , 02:53 PM






HI,

;} in advance for your help!

My bank does not include my computer in a domain.

I can not connect to my Analysys services server.

I am advanced. I used SSPI at Cendant.

Server responds with Unknown username or bad password, as it
is trying to use my PC name as my domain!?

All is fine as Server Analysis Manager is AOK.

No connectivity from client. I tried to prefix my real domain to my user,
name no help.

Thank You.


Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: OLAP-Client not in Domain - 12-02-2004 , 06:01 PM






SSAS Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
see the section titled "Security Administration"
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"jam96-BuffaloJoe" <jam96BuffaloJoe (AT) discussions (DOT) microsoft.com> wrote in
message news:BED49B7F-47B7-4934-B05F-681E5F29CC89 (AT) microsoft (DOT) com...
Quote:
HI,

;} in advance for your help!

My bank does not include my computer in a domain.

I can not connect to my Analysys services server.

I am advanced. I used SSPI at Cendant.

Server responds with Unknown username or bad password, as it
is trying to use my PC name as my domain!?

All is fine as Server Analysis Manager is AOK.

No connectivity from client. I tried to prefix my real domain to my user,
name no help.

Thank You.




Reply With Quote
  #3  
Old   
jam96-BuffaloJoe
 
Posts: n/a

Default Re: OLAP-Client not in Domain - 12-03-2004 , 08:29 AM



Great Information Dave.
In Novell, with no utilization of the local C:,
What would the connection string look like?

What is the best install for the Pivot Table Service on the client?

Is telling my database services group to drop my server and re-install
Olap with Anonymus my only option?

P.S.
Your information on Repository Audit Triggers was impressive.


Joe

"Dave Wickert [MSFT]" wrote:

Quote:
SSAS Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
see the section titled "Security Administration"
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"jam96-BuffaloJoe" <jam96BuffaloJoe (AT) discussions (DOT) microsoft.com> wrote in
message news:BED49B7F-47B7-4934-B05F-681E5F29CC89 (AT) microsoft (DOT) com...
HI,

;} in advance for your help!

My bank does not include my computer in a domain.

I can not connect to my Analysys services server.

I am advanced. I used SSPI at Cendant.

Server responds with Unknown username or bad password, as it
is trying to use my PC name as my domain!?

All is fine as Server Analysis Manager is AOK.

No connectivity from client. I tried to prefix my real domain to my user,
name no help.

Thank You.





Reply With Quote
  #4  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: OLAP-Client not in Domain - 12-03-2004 , 10:56 AM



Ref: the question about connect strings with Novell, sorry, I don't
understand. Are you asking from a domain perspective, network type, or what?

Ref: best install of PTS? Use the version of ptslite.exe or ptsfull.exe
which comes in the \msolap\install\pts folder of the SP3 Analysis Services
distribution.

Ref: dropping the server and re-install -- what technique outlined in the
Operations Guide are you trying to use? None of the techniques required a
reinstall of Analysis Services, so I am a bit confused.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"jam96-BuffaloJoe" <jam96BuffaloJoe (AT) discussions (DOT) microsoft.com> wrote in
message news:B572E83E-E695-4CF0-9B53-5A5A85B7FB8B (AT) microsoft (DOT) com...
Quote:
Great Information Dave.
In Novell, with no utilization of the local C:,
What would the connection string look like?

What is the best install for the Pivot Table Service on the client?

Is telling my database services group to drop my server and re-install
Olap with Anonymus my only option?

P.S.
Your information on Repository Audit Triggers was impressive.


Joe

"Dave Wickert [MSFT]" wrote:

SSAS Operations Guide

http://www.microsoft.com/technet/pro.../anservog.mspx
see the section titled "Security Administration"
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"jam96-BuffaloJoe" <jam96BuffaloJoe (AT) discussions (DOT) microsoft.com> wrote in
message news:BED49B7F-47B7-4934-B05F-681E5F29CC89 (AT) microsoft (DOT) com...
HI,

;} in advance for your help!

My bank does not include my computer in a domain.

I can not connect to my Analysys services server.

I am advanced. I used SSPI at Cendant.

Server responds with Unknown username or bad password, as it
is trying to use my PC name as my domain!?

All is fine as Server Analysis Manager is AOK.

No connectivity from client. I tried to prefix my real domain to my
user,
name no help.

Thank You.







Reply With Quote
  #5  
Old   
jam96-BuffaloJoe
 
Posts: n/a

Default Re: OLAP-Client not in Domain - 12-14-2004 , 11:57 AM



Dave,

Thank You for your time, I have been busy, late to respond. Sorry.

To get to my point, my connection string snipit:

Provider=MSOLAP;user id=Domain\Username;

How can I pass in User ID and Domain?

Joe

"Dave Wickert [MSFT]" wrote:

Quote:
Ref: the question about connect strings with Novell, sorry, I don't
understand. Are you asking from a domain perspective, network type, or what?

Ref: best install of PTS? Use the version of ptslite.exe or ptsfull.exe
which comes in the \msolap\install\pts folder of the SP3 Analysis Services
distribution.

Ref: dropping the server and re-install -- what technique outlined in the
Operations Guide are you trying to use? None of the techniques required a
reinstall of Analysis Services, so I am a bit confused.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"jam96-BuffaloJoe" <jam96BuffaloJoe (AT) discussions (DOT) microsoft.com> wrote in
message news:B572E83E-E695-4CF0-9B53-5A5A85B7FB8B (AT) microsoft (DOT) com...
Great Information Dave.
In Novell, with no utilization of the local C:,
What would the connection string look like?

What is the best install for the Pivot Table Service on the client?

Is telling my database services group to drop my server and re-install
Olap with Anonymus my only option?

P.S.
Your information on Repository Audit Triggers was impressive.


Joe

"Dave Wickert [MSFT]" wrote:

SSAS Operations Guide

http://www.microsoft.com/technet/pro.../anservog.mspx
see the section titled "Security Administration"
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"jam96-BuffaloJoe" <jam96BuffaloJoe (AT) discussions (DOT) microsoft.com> wrote in
message news:BED49B7F-47B7-4934-B05F-681E5F29CC89 (AT) microsoft (DOT) com...
HI,

;} in advance for your help!

My bank does not include my computer in a domain.

I can not connect to my Analysys services server.

I am advanced. I used SSPI at Cendant.

Server responds with Unknown username or bad password, as it
is trying to use my PC name as my domain!?

All is fine as Server Analysis Manager is AOK.

No connectivity from client. I tried to prefix my real domain to my
user,
name no help.

Thank You.








Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.