1,328 questions with SQL Server Analysis Services tags

Sort by: Updated
1 answer

Can't enable change feed.

Hi All, My SQL SERVER is 2022 CU 16 and while try to enable change feed, Im getting this error I have run the query using sa EXECUTE sys.sp_change_feed_enable_db; error: Msg 22710, Level 16, State 1, Procedure…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-03-06T06:46:04.3666667+00:00
Vignesh K 20 Reputation points
answered 2025-03-07T02:03:31.5266667+00:00
LiHongMSFT-4306 30,996 Reputation points
1 answer One of the answers was accepted by the question author.

i cannot able to install SQL express edition, it is showing error.

i tried to install sql developer edition and express edition but both showing error, cannot able to install it. Please help me.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-03-03T20:44:24.13+00:00
Sindhu Nidadavolu 20 Reputation points
accepted 2025-03-03T22:52:40.9066667+00:00
Sindhu Nidadavolu 20 Reputation points
0 answers

MAP - Microsoft Assesment tool does not pull correct (refreshed) data in sql server database details report

MAP - Microsoft Assesment tool does not pull correct (refreshed) data in SQL Server database details report. To check, I created a user XX on the SQL Server instance with the db_owner grant on the base and ran the report again. There is no user XX in…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-03-03T13:00:29.5333333+00:00
User91 0 Reputation points
edited the question 2025-03-03T13:03:45.3466667+00:00
simo-k 3,530 Reputation points
1 answer One of the answers was accepted by the question author.

Unable to install SQL Server

I've been trying to install SQL server and keep getting hooked with this error description. I've tried with 2019 version and it's the same thing. Summary.txt I have attached the Summary.txt above. Please, can I get any assistance in resolving this?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-03-01T20:38:25.7466667+00:00
Amarachi Ugwu 20 Reputation points
accepted 2025-03-02T11:15:54.9333333+00:00
Amarachi Ugwu 20 Reputation points
0 answers

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 Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-25T20:49:48.49+00:00
MrBill 0 Reputation points
commented 2025-03-01T15:03:55.44+00:00
Erland Sommarskog 118.9K Reputation points MVP
1 answer One of the answers was accepted by the question author.

SQL Server Issue

I cannot install any of the SQL Server versions. See a sample error I got from installing version 2014: TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: Unknown error (0xe0000235) For help, click:…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-28T20:43:48.33+00:00
Bola Elebiyo 20 Reputation points
accepted 2025-02-28T22:21:23.2533333+00:00
Bola Elebiyo 20 Reputation points
2 answers

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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-24T09:42:05.1833333+00:00
Boopathi S 3,671 Reputation points
commented 2025-02-28T20:50:17.3566667+00:00
Erland Sommarskog 118.9K Reputation points MVP
3 answers

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.…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-27T02:32:16.4366667+00:00
Xianjun Zhan 0 Reputation points
commented 2025-02-28T20:27:06.9833333+00:00
Erland Sommarskog 118.9K Reputation points MVP
1 answer

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…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-27T11:33:30.2533333+00:00
Marius Smit 5 Reputation points
answered 2025-02-28T16:07:00.42+00:00
Marius Smit 5 Reputation points
0 answers

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…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-27T12:35:24.5+00:00
Soubhik Bhattacharya 0 Reputation points
commented 2025-02-28T02:21:19.42+00:00
LiHongMSFT-4306 30,996 Reputation points
2 answers

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…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-26T12:57:46.69+00:00
CELINE KUAN XIN YI 0 Reputation points
answered 2025-02-27T03:01:45.5666667+00:00
LiHongMSFT-4306 30,996 Reputation points
1 answer

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…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-25T02:10:32.68+00:00
Jeeyoon Oh 0 Reputation points
commented 2025-02-25T22:02:19.4133333+00:00
Erland Sommarskog 118.9K Reputation points MVP
1 answer

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…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-25T00:02:56.9566667+00:00
rhhutchins4292 0 Reputation points
answered 2025-02-25T01:56:17.35+00:00
ZoeHui-MSFT 41,286 Reputation points
1 answer

Execute TMSL in SSMS

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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-24T05:52:34.35+00:00
Hammad Ahmed 0 Reputation points
answered 2025-02-24T07:46:11.05+00:00
Olaf Helper 46,201 Reputation points
0 answers

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…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-20T09:09:59.5633333+00:00
Hammad Ahmed 0 Reputation points
3 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-11T07:24:18.6333333+00:00
PANDEY Prashant 145 Reputation points
answered 2025-02-20T05:43:43.6466667+00:00
PANDEY Prashant 145 Reputation points
0 answers

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…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-17T07:32:15.36+00:00
PANDEY Prashant 145 Reputation points
edited the question 2025-02-17T08:47:10.2466667+00:00
PANDEY Prashant 145 Reputation points
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-14T21:39:47.3366667+00:00
D N Sangamesh 0 Reputation points
commented 2025-02-17T06:25:50.2966667+00:00
ZoeHui-MSFT 41,286 Reputation points
2 answers

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked 2025-02-04T10:14:50.5333333+00:00
D2d3d4d5 20 Reputation points
commented 2025-02-14T16:24:07.1266667+00:00
Smaran Thoomu 20,935 Reputation points Microsoft External Staff
2 answers

"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 ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
474 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,789 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 5 Reputation points
commented 2025-02-14T15:11:44.54+00:00
Richard Price 0 Reputation points