SQL Server Analysis Services

a lot of SQL Server dump files generated almost on the same time in C disk whic

The version is Microsoft SQL Server 2017 - 14.0.3460.9. The issue happened on midnight, The application using SQL server didn't perform any Query ,Insert, Update ,Delete operation. We see a lot of error almost at the same time on Windows 10 event log.…

Downlaod updated version of Microsoft OLE DB Driver for Microsoft SQL

Helo Team, Please let me know how to get the updated version for "Microsoft OLE DB Driver for Microsoft SQL" Below are other SQL applications installed

Unable to connect to DB due to full storage

due to replication slots filling the DB the storage gets full and crashes issue seems to be occurring every 2 weeks or so and can you help me to identify the reason why this occurs similar databases are set upped in the qa and the prod environment which…

When trying to Restore SSAS Database get error The Request is not supported

Good Day, I am trying to restore a SSAS Database on SQL 2019, however keep getting the error: The following system error occurred: The request is not supported. (Microsoft.AnalysisServices.Core) I have tried running SSMS as admin and made sure my use…

How to fix Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.

I am facing the difficulty of downloading Microsoft SQL Server. Unable to install SQL Server (setup.exe). Exit code (Decimal): -2068052377 Error description : Invalid command line argument. Consult the Windows Installer SDK for detailed command line…

Unable to open visual design tools in SSMS 20 or SSMS 21

Unable to open Visual Design tools in SSMS with 'sa' logon.

SQL Server 2017 Express Installation Error: INSTALLSHAREDWOWDIR Directory is Compressed

Here’s how you can write your question in English for platforms like Microsoft Q&A or Stack Overflow: Title SQL Server 2017 Express Installation Error: INSTALLSHAREDWOWDIR Directory is Compressed Details Hello, I encountered an issue while trying to…

How Do I Add SSDT to MS SQL Server that's already installed and in use

I installed MS SQL Server (2022) a couple of week ago. I now have it tame enough to allow me to use SSMS to create a few tables, run a few queries etc. At 83 I'm a complete novice to RDBMS in general and SQL in particular; although I was a COBOL…

Execute TMSL in SSMS

I have a tmsl code which looks something like this: { "createOrReplace": { "object": { "database": "TabularProject1" }, "database": { "name":…

Deploying SSAS Tabular Project from Server 1 to Server 2

I am developing and environment in my organization. Here is the description of what I want to achieve in the environment setup: It consists of 2 servers (computers). 1st server has a default instance sql server 2022 installed with database engine and…

Build SSAS Tabular Daliy Partition from SQL Server

Hello Experts, We are using SQL Server and SSAS Services, have to automate the process of building daily partition on fact table (TMSL code mentioned below). this should be called from Stored Procedure. I have to code such a way to build daily partitions…

SSAS Tabular delta schema changes and processing

Hello Experts, We are using AWS hosted SQL and SSAS Tabular both on same instance and the plan is to build environments as Dev & Test Environment: 3 & 6 months respectively, UAT: 1 Year Pre Production: 5 Years Production: 10 Years Our product…

Microsoft SQL Server 2022 Setup error

The following error has occurred: An error occurred while installing extensibility feature with error message: AppContainer Creation Failed with error message CREATING_FIREWALL_RULES, state Could not load file or assembly…

SSAS Development How to fix "Cannot open BIM Model. Localhost server unreachable" ?

Hello everyone ! I've had a weird problem during the last couple of days. I downloaded a SSAS project from Azure to work on it with some people. I set it up to use "Integrated workspace", and I left everything else as default. The first time I…

"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."

One of the users receive this error. is this issue at our end or at microsofts ?

SSAS Hidden "Unknown Member" But Still Show On Power BI

Hi Expert It's setting Unknown Member "Hidden" for every dimensions on SSAS, and it's display normal on excel 2016 above, but on the Power BI still show "Unknown" in dimensions. Can anyone who will solve it?

Can only select both tables filter direction in SSAS tabular

Hi, I use the same SQL server database to do an import in Power BI Desktop as for my model created in SSAS Tabular SQL Server 2019 with Visual Studio 2019. My issue is in the create relationships. In Power BI Desktop I can do: In Visual Studio I…

Unable to install SQL server

Execute XMLA on a Unix server

Hello, I would like to know what the best option is to trigger a SSAS cube refresh from an Unix server.   Today I am using powershell on windows with the powershell command line: Invoke-ASCmd -Server myserver:port -InputFile my_refresh_instruction.xmla. …

AWS Linked Sever from SQL to SSAS Tabular Model

Hello Experts, We are using SQL Server enterprise edition where both SQL and SSAS(Tabular) are deployed on same RDS. I have to make Linked Server from SQL to SSAS Tabular database so that TMSL data processing/partitions query can be called from stored…