Trying to process cube on server erroring with No Logon servers available

i trying deploy cube on remote server first time.

i used deployment wizard build xmla script ran on server.

the datasource set use network credentials login. works fine when run cube locally.

however after running xmla script , try process cube, error :

there no logon servers available service logon request.

i don't know windows security, , stumped next.

not sure if doing right first bi project, there better way deploy , update cube?

or recommended settings.

any appreciated.

thanks

jon

hi,

i hope have proper admin rights when perform above mentioned steps. try following , see whether works you. if create "cube" user local user have select server name locations box follows;

also copy , paste "%windir%\security\logs\winlogon.log" in run command , open log file. scroll way down bottom of log , see further details. if continue "no mapping between account names , security ids done" error copy log file information analyse further.

i not sure root cause never encounter such error when map user name. have wait other pros' comments if continuously getting error.

best regards...

---

chandima lakmal fonseka

SQL Server  >  SQL Server Analysis Services