Find Jobs
Hire Freelancers

microsoft analysis server OLAP error

€8-30 EUR

Færdiggjort
Slået op over 3 år siden

€8-30 EUR

Betales ved levering
Dear freelancers, I need assistance to guide me through an issue with our database. No remote access will be possible, you would have to guide me while I narrate the issue. My cubes were working fine and were processed daily in SSMS until some Microsoft security updates were installed & the server was restarted. I receive the error message when processing the cubes and dimensions. I already deleted the security updates but I am still getting the same error. In the windows services -> SQL Server Analysis i have a service account with all the rights in SQL server (read, write, process, admin). I am working on SQL Server 2014. I tried to: restart the SQL Server Analysis set up new accounts with read,process and admin rights on the SQL server and analysis server. to put in the "SQL Server Analysis" to put the Local account Create a new cube but Dimension can still not be processed. change the provider from "SQL Server Native Client 11.0" to "Microsoft OLE DB Provider for SQL server" and we also checked the "allow inprocess" checkbox in SSMS in Server Objects -> Linked Servers -> Providers. Nothing worked of the points above. I hope someone can help us. Error message: OLE DB error: OLE DB or ODBC error: Incorrect syntax near the keyword 'JOIN'.; 42000. Errors in the OLAP storage engine: An error occurred while the dimension,
Projekt-ID: 27290302

Om projektet

4 forslag
Projekt på afstand
Aktiv 4 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
I can try to help you because I have a very good troubleshooting skills. Also I am Senior SQL Developer with 10+ years experience.
€35 EUR på 1 dag
5,0 (21 anmeldelser)
4,2
4,2
Brug Avatar.
Hi, I have good experience in ssas build and deploying [login to view URL] I can help you fix the issue as soon as possible
€26 EUR på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
4 freelancere byder i gennemsnit €31 EUR på dette job
Brug Avatar.
Hi, I am an MSBI expert with proficiency in creating SSAS cubes and writing SQL queries. Let me know if you would like me to hire for this position so that I can show my skill to you.
€34 EUR på 1 dag
4,0 (3 anmeldelser)
3,1
3,1
Brug Avatar.
I am expert in SQL and SSIS development with more than 10 years of experience. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. I only take projects which I am sure I can do quickly.
€30 EUR på 2 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for SPAIN
Madrid, Spain
5,0
2
Betalingsmetode verificeret
Medlem siden jul. 31, 2020

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.