21,489 questions with SQL Server-related tags

Sort by: Updated
1 answer

Stored Procedure running longer hours

Hello, I am facing currently issue as stored procedure running very longer hours although my DB is not that big means around 20 GB. We are also running OLA's maintenance solution for Update Stats Daily and Index maintenance weekly basis. Stored procedure…

SQL Server | SQL Server Transact-SQL
asked 2026-03-21T16:55:37.63+00:00
pdsqsql 436 Reputation points
commented 2026-03-21T17:05:19.05+00:00
pdsqsql 436 Reputation points
2 answers

I can't install SQL SERVER 2025 EXPRESS

Hi. I am trying to install SQL SERVER 2025 EXPRESS in Basic mode . but it keeps failing and giving me this error code. I tried multiple things and finally decided to format my computer.Even that didn' work. Please, if you had this error and know how to…

SQL Server Database Engine
asked 2026-03-21T14:23:01.2433333+00:00
Azra KARAAĞAÇ 0 Reputation points
answered 2026-03-21T15:01:57.9566667+00:00
Erland Sommarskog 133.5K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

How Can I Resolve SQL Server 2022 Installation Issues on Windows 11?

I’m struggling to install SQL Server 2022 on my Lenovo laptop running Windows 11. Despite following the installation steps and meeting system requirements, the process either fails to complete or doesn’t configure correctly. Here’s what I’ve tried so…

SQL Server | Other
asked 2024-12-31T15:51:47.9533333+00:00
Qhamani Twaku 25 Reputation points
answered 2026-03-21T02:55:58.4566667+00:00
Himanshi vaid 0 Reputation points
2 answers

Act! V22: Windows 11 preventing installation of ACT! V22because of SQL and Shell issues. Help?

I have ACT! v22 which is on a Desktop and a Laptop. Both have Windows 11 and work fine. I just purchased a new laptop and I cannot get ACT! V22 to install. The error message is related to Windows 11 not allowing SQL 2014 and Shell 2 (I believe) to…

SQL Server | Other
asked 2026-03-20T22:32:03.4466667+00:00
David Shear 0 Reputation points
answered 2026-03-20T22:42:49.8433333+00:00
Erland Sommarskog 133.5K Reputation points MVP Volunteer Moderator
2 answers

user map is auto unchecking sql?

hi all, iv tried to give access to a specific db for a user, via gui ( instance -> security -> logins -> user -> right click properties -> user mapping ) where I'm checking map -> and gave access as a DB writer and clicked ok the…

SQL Server | Other
asked 2021-07-15T04:13:50.28+00:00
Seshagiri Rao Vadrevu 101 Reputation points
answered 2026-03-20T22:06:27.38+00:00
JEFFREY WONG 0 Reputation points
2 answers

SQL Server Course: 10987c - Performance Tuning and Optimizing SQL Databases

I need the Labs of mail subject course. Anyone can share please?   Also, this course was retired by Microsoft, does anyone know the current alternative? please share material & Labs accordingly?

SQL Server | Other
asked 2026-03-20T12:32:48.48+00:00
Amr Darwish 0 Reputation points
commented 2026-03-20T17:37:45.2633333+00:00
Amr Darwish 0 Reputation points
2 answers One of the answers was accepted by the question author.

Power Query or SQL

I connected my Excel and Power B through Power Query to SQL Server Database to get data for analysis. I am able to do all analysis I do in SQL in Excel and Power BI Power Query. Should I continue like this or which route is better: Excel & Power BI…

SQL Server | Other
asked 2026-03-20T12:43:47.16+00:00
Oladimeji Olutoye 35 Reputation points
commented 2026-03-20T17:14:42.4366667+00:00
Oladimeji Olutoye 35 Reputation points
2 answers

ACE.OLEDB.12.0 provider is not registered on the local machine

Hello, We have a client that tried to import an excel using the import and export wizard and he recceived the following error:     The operation could not be completed. Additional information:      The 'Microsoft.ACE.OLEDB.12.0' provider is not…

SQL Server Database Engine
asked 2026-03-04T07:35:23.9466667+00:00
Admin Team TGS 0 Reputation points
recommended 2026-03-20T12:24:14.4266667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

sql server 2022 wın 11 pro da kurulum sırasında sürekli aynı hata veriyor. ve kuramıyorum

kurumda yaşadığım probleminin sebebi nedir.? 2019, 2022, 2025 sqlserver kurulumlarıda aynı şekilde hata verdi.

SQL Server Database Engine
asked 2026-03-05T23:46:06.63+00:00
Destek Bilgisayar 0 Reputation points
recommended 2026-03-20T12:24:00.44+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

sql server 2019 kurulum problemi

Hatalı kurulan SQL Server 2019 bileşenleri nasıl tamamen kaldırılır? temizleme işini otomatik yapacak bir uygulamanız yok mu ?

SQL Server Database Engine
asked 2026-03-05T20:51:37.03+00:00
Destek Bilgisayar 0 Reputation points
recommended 2026-03-20T12:23:47.96+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

how to fix error 1205 on mssql 2022

Riscontro vari errori 1205 nei log e dopo alcuni di questi, si verifica l'errore 824

SQL Server | SQL Server Transact-SQL
asked 2026-02-23T19:02:26.01+00:00
Luca Benedetto 20 Reputation points
recommended 2026-03-20T12:23:16.2066667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

SQL Server Assessment tool

Hi Expert, what is reliable tools for Assessment and migration SQL Server database? thank you regards, Urbel

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.

605 questions
asked 2026-02-23T15:59:19.7233333+00:00
Urbel 465 Reputation points
recommended 2026-03-20T12:22:44.8266667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

TITLE: Error ------------------------------ A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server

TITLE: Error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote…

SQL Server | Other
asked 2026-02-20T07:27:25.2866667+00:00
Bhoomi Chauhan 0 Reputation points
recommended 2026-03-20T12:22:08.2033333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

CDC change Data Capture on High availibility AlwaysOn 2019

Hello,  I have three nodes (SQL Server 2019) Always On availability group configuration -FYI. I have applied the CDC (Change Data Capture) jobs [cdc.DBName_capture] and [cdc.DBName_cleanup] on all three nodes. However, when a failover occurs from the…

SQL Server Database Engine
asked 2026-02-19T08:29:44.65+00:00
Mona Seddik 20 Reputation points
recommended 2026-03-20T12:21:54.7566667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Licensing SSIS on a server used for deploying code via Visual Studio and SSIS to a SQL Server production server running on another server

See subject. Is it allowed to use Visual Studio on a management server used by a developer to deploy code via SSIS integration to a SQL server production environment that runs on a different server or will the management server be regarded as a part of…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,779 questions
asked 2026-03-19T08:33:18.6333333+00:00
Leo van Mourik 0 Reputation points
commented 2026-03-19T21:46:01.12+00:00
Erland Sommarskog 133.5K Reputation points MVP Volunteer Moderator
4 answers

Problem with SQL Server Managment Studio 2012 (Replication)

Hi I have a problem with replication in SQL Server Managment Studio 2012. I have to replicate 140 locations and when I start from beginning (0 locations) everything is fine. I do 70-80 replications for 2-3 days and there is no problem with that.…

SQL Server | Other
asked 2021-03-18T14:27:36.837+00:00
DymekPL 1 Reputation point
edited an answer 2026-03-19T15:59:16.7366667+00:00
DillanSimmons 6 Reputation points Admin
1 answer

How to prove that the purchased SQL is genuine

We purchased an SQL from the distributor. How can we prove that the SQL we bought is genuine and not pirated? If you have any questions, please contact me at the email address <mod: PII removed>@net.

SQL Server | Other
asked 2026-03-18T09:01:30.4866667+00:00
Wali Tai 0 Reputation points
edited the question 2026-03-18T21:29:10.6866667+00:00
Erland Sommarskog 133.5K Reputation points MVP Volunteer Moderator
2 answers

Access to SQL

How can we request access for someone in our company to SQL Server Reporting Services?

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,147 questions
asked 2026-03-18T18:03:35.4933333+00:00
Janet Taglianetti 0 Reputation points
answered 2026-03-18T21:28:25.8266667+00:00
Erland Sommarskog 133.5K Reputation points MVP Volunteer Moderator
1 answer

Queries have been running really slowly since upgrading the database to SQL Server 2025.

After upgrading my SQL Server from versions 2014 and 2022 to 2025, the queries have become noticeably slower.

SQL Server Database Engine
asked 2025-11-23T09:59:35.84+00:00
Amin 10 Reputation points
commented 2026-03-18T21:23:13.7+00:00
Erland Sommarskog 133.5K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

SQL Connection

When trying to create a new SQL connection under visual studio code 2026 i get the following error message - A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not…

SQL Server Database Engine
asked 2026-03-17T19:35:35.4133333+00:00
Michael Ashby 80 Reputation points
commented 2026-03-18T15:35:52.6233333+00:00
Michael Ashby 80 Reputation points