20,387 questions with SQL Server-related tags

Sort by: Updated
0 answers

I am not seeing any option to upgrade. I am trying to connect to my Azure SQL datadase from ssms

I am not seeing any option to upgrade. I am trying to connect to my Azure SQL datadase from ssms

SQL Server Database Engine
asked 2025-05-03T19:29:31.69+00:00
Moyan Martin 0 Reputation points
commented 2025-05-04T07:57:22.12+00:00
Erland Sommarskog 120.3K Reputation points MVP
2 answers

SQL Server Buffer Pool Persistence Feature Request

SQL Server Buffer Pool Persistence Feature Request Could SQL Server implement a feature to export buffer pool data? This would eliminate the need for data warm-up after database restarts or initial startups. By directly importing previously saved buffer…

SQL Server Database Engine
asked 2025-05-03T14:12:23.3433333+00:00
Steven Lam 20 Reputation points
commented 2025-05-04T07:54:31.1833333+00:00
Erland Sommarskog 120.3K Reputation points MVP
0 answers

MSSQL connection in Visual Studio Mac->(Socket Exception)

HI Community! I am facing the following problem and it is driving me crazy. I was creating a SQL Server in Azure, and I was trying to connect via Visual Studio Code, but using the exactly same configuration n Mac I am getting this error…

SQL Server Database Engine
asked 2025-05-03T20:21:38.7133333+00:00
moialbla 5 Reputation points
1 answer

Can I do an SQL Server Edition upgrade from Express to Developer on Azure VM?

I'm trying to upgrade an SQL Express database that comes with an application to SQL Developer edition. The machine is an Azure VM, not Azure SQL server instance. The application is Best Practice, a medical practice management software. The base…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
564 questions
asked 2025-05-01T23:21:26.8166667+00:00
Melchor Buenaflor Admin 0 Reputation points
commented 2025-05-03T15:39:16.3566667+00:00
Erland Sommarskog 120.3K Reputation points MVP
1 answer

Unable to install SQL server. Error code : -2068119551

I keep fail to install the SQL server. I have already tried using Basic and Media which is ISO. When i used ISO, the error is -The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an…

SQL Server Database Engine
asked 2025-05-02T17:11:52.83+00:00
Blaze 0 Reputation points
answered 2025-05-03T15:34:43.4633333+00:00
Erland Sommarskog 120.3K Reputation points MVP
2 answers

Msg 206, Level 16, State 2, Line 9 Operand type clash: int is incompatible with date (I want only year not full date then how I get)

CREATE TABLE employe ( ID INT, YEar DATE, FirstName VARCHAR(50), LastName VARCHAR(50), ); Insert into employe values (1,2020, 'John', 'Doe'), (2, 2021,'Jane', 'Smith'), (3, 2022,'Alice', 'Johnson')

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
15 questions
asked 2025-05-03T13:48:28.6233333+00:00
pallavi potnuru 0 Reputation points
answered 2025-05-03T15:33:40.6633333+00:00
Erland Sommarskog 120.3K Reputation points MVP
2 answers

Error when installing SQL server 2022 - Log attached

Hello! Im trying to install microsoft SQL server but im stuck. Im getting this error page: I have tried most of the possible solutions from different forum pages, everything from deleting files and changing the registry. I have downloaded and run the…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
12,074 questions
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,494 questions
asked 2023-05-12T09:32:44.8533333+00:00
Johan Karlsson 0 Reputation points
commented 2025-05-03T09:48:41.98+00:00
UNKNOW 0 Reputation points
1 answer

How to fix SSRS issues when running them on Windows 11?

SSRS reports that had been running on Windows 10 are not running on Windows 11. Kerberos authentication issues.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,042 questions
asked 2025-05-02T21:27:00.1733333+00:00
Sleight, Jeannette 0 Reputation points
commented 2025-05-02T22:10:23.88+00:00
Sleight, Jeannette 0 Reputation points
5 answers One of the answers was accepted by the question author.

Analysis Services Processing Task: Error A connection cannot be made

Hi, We are executing an SSIS package.. it fails with the below error Analysis Services Processing Task: Error A connection cannot be made. Ensure that the server is running. We have a separate SSAS instance on this server which is up and running.…

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,339 questions
asked 2024-09-03T04:30:09.63+00:00
Bilal H. Bhatt 136 Reputation points
commented 2025-05-02T21:54:39.98+00:00
Gary Melhaff - US 6 Reputation points
1 answer

Polybase accessing s3 storage error - Content of the directory cannot be listed

I have the following script for accessing on-prem S3-compatible storage. CREATE DATABASE SCOPED CREDENTIAL s3 WITH IDENTITY = 'S3 Access Key', SECRET = '****:****' ; END GO CREATE EXTERNAL DATA SOURCE ds_s3 WITH ( LOCATION =…

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,494 questions
asked 2024-08-14T00:24:25.8666667+00:00
Haijin Li 21 Reputation points
commented 2025-05-02T18:54:34.21+00:00
Punit R 0 Reputation points
1 answer

Problem upgrading encryption for multidimensional analysis services database in SQL 2022

I am migrating 2 analysis services databases that are in multidimensional mode from a 2017 instance to a 2022 instance that has had the CU1 update applied. I need to upgrade the encryption on these DBs so i can amend the connection string. This article…

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,494 questions
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,494 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,339 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,339 questions
asked 2023-08-09T11:11:35.6666667+00:00
Jim Dale 15 Reputation points
commented 2025-05-02T16:09:13.2066667+00:00
Céline Rodríguez 16 Reputation points
1 answer

Problem upgrading encryption for multidimensional analysis services database in SQL 2022

I am migrating 2 analysis services databases that are in multidimensional mode from a 2017 instance to a 2022 instance that has had the CU1 update applied. I need to upgrade the encryption on these DBs so i can amend the connection string. This article…

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,494 questions
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,494 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,339 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,339 questions
asked 2023-08-09T11:11:35.6666667+00:00
Jim Dale 15 Reputation points
commented 2025-05-02T16:09:13.2066667+00:00
Céline Rodríguez 16 Reputation points
1 answer

How to fix SQL Server Setup has encountered the following error: Failed to retrieve data for this request..

I'm trying to patch SQL Server 2019 in a clustered environment. The setup is failing with this error: Setup has encountered the following error: Failed to retrieve data for Summary.txtthis request..Detail.txt

SQL Server Database Engine
asked 2025-05-02T08:55:59.86+00:00
Talent Mabuto 0 Reputation points
answered 2025-05-02T10:01:10.67+00:00
Alban Berisha 80 Reputation points
2 answers One of the answers was accepted by the question author.

Why TUF file is required in Log shipping when uncommitted transactions are already in memory?

I know that while restoring the log backup, un-committed transactions will be recorded to the undo file and only committed transactions will be written to disk there by making users to read the database. When we restore next Tlog backup SQL server will…

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,494 questions
asked 2023-04-10T14:18:55.13+00:00
Chirag Sachdeva 281 Reputation points
commented 2025-05-02T07:35:20.0533333+00:00
YaragoppaSunil-3326 0 Reputation points
1 answer

Issue to restore the schema

Dear all, How to resolve it below? Exclusive access could not be obtained because the database is in use. I ran the following     USE db_to_restore       go       ALTER DATABASE db_to_restore SET SINGLE_USER WITH ROLLBACK IMMEDIATE       go   but it…

SQL Server Database Engine
asked 2025-04-25T03:14:41.97+00:00
Peter_1985 2,731 Reputation points
edited a comment 2025-05-02T06:48:40.9333333+00:00
Peter_1985 2,731 Reputation points
1 answer

I need to find a missing report

I'm searching for a report for one of our specialists on 04/07/25 who is no longer with TD as of this month. However the specialist name is no longer listed under the team manager for TD bank. I've left a comment but I have no idea who it goes to our…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,042 questions
asked 2025-04-29T12:38:40.2833333+00:00
Gordon, Cliff (he/him/his) 0 Reputation points
commented 2025-05-02T05:52:30.48+00:00
Olaf Helper 46,636 Reputation points
1 answer

Third party backup tools for SQL server

Anyone please share a few names of good and faster backup tools for SQL server? Preferably a snapshot of physical file backup It is for stand-alone server and should support VM too.

SQL Server Database Engine
asked 2025-04-24T18:18:03.1466667+00:00
Asharaf Pattarathil 0 Reputation points
commented 2025-05-02T05:48:02.1333333+00:00
Olaf Helper 46,636 Reputation points
1 answer

Sql Server to Excel

Hi Trying to export data from sql server to a Table formated excel. But after the data insert the Format of excel not coming properly. I mean the odd and even rows with different color Thanks

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
177 questions
asked 2025-05-01T10:49:51.06+00:00
SVA 116 Reputation points
answered 2025-05-02T05:44:35.3033333+00:00
Olaf Helper 46,636 Reputation points
1 answer

SQL Server Management Studio 18 - Maintenance Plan

I have setup SQL backups to run daily at midnight for 5 servers, all works fine except 1 server does not run/create backup files. No errors or logs just does not run and not sure why. Any suggestions? Thanks! David

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
177 questions
asked 2025-05-01T12:56:03.21+00:00
Chun, David 0 Reputation points
answered 2025-05-02T05:42:54.2466667+00:00
Olaf Helper 46,636 Reputation points
0 answers

MDS migration - No data in the mdm view MasterDataServices

Hi , I migrated a model of Master Data Services using MDSModelDeploy.exe createpackage -package "C:\temp\pck.pkg" -model "Product" -service MDS1 -includedata -version VERSION_1 and MDSModelDeploy.exe deploynew -package…

SQL Server Database Engine
asked 2025-05-01T09:43:27.76+00:00
Maneesh Murali 0 Reputation points
edited the question 2025-05-01T10:15:07.23+00:00
simo-k 7,885 Reputation points