21,719 questions with SQL Server-related tags

Sort by: Updated
2 answers

How to stop my query editor from closing on its own

I'm constantly getting a pop up asking me to save queries I am still working on. Sometimes I open an instance that has been idle just to realize the query I had open has been closed or disappeared. Plus I have checked the copy with header option in the…

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,175 questions
asked 2026-08-06T17:19:36.4333333+00:00
Tameka 0 Reputation points
answered 2026-08-07T15:09:38.1766667+00:00
Deepesh Dhake 820 Reputation points
2 answers

Database refresh from Production to Dev

We want to restore some databases from Production server to Dev server. We want to create a job that automatically restores a fresh copy of these databases to Dev server on 10th of each month. Could you please advise on how to do this.

SQL Server Database Engine
asked 2026-08-06T19:39:45.92+00:00
Chaitanya Kiran 841 Reputation points
commented 2026-08-07T14:16:35.41+00:00
Deepesh Dhake 820 Reputation points
6 answers One of the answers was accepted by the question author.

AdventureWorksDW2020 DB is missing a table

Hi, I'm trying to go through the PowerBI lab at this url: https://learn.microsoft.com/en-gb/learn/modules/get-data/lab-prepare I downloaded the AdventureWorksDW2020 from GitHub and loaded into SQL server management studio. 6 tables are…

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,175 questions
asked 2020-10-18T18:54:21.503+00:00
Philip O'Donnell 26 Reputation points
commented 2026-08-07T06:46:15.92+00:00
Acram Twaib 0 Reputation points
2 answers

sql server management studio 2018 user setup

how to set up user account and login for sql server management studio 2018 and connect to database

SQL Server Database Engine
asked 2026-07-06T22:12:14.9133333+00:00
Candace Snipes 20 Reputation points
commented 2026-08-06T14:47:22.72+00:00
Ganesh Chelluri 110 Reputation points Microsoft External Staff Moderator
3 answers

Issue in the Installing the SQL Server

Hi Team, I'm using the Window 11 OS and the Processor - Intel(R) Core(TM) i3-10110U CPU @ 2.10GHz, 2592 Mhz, 2 Core(s), 4 Logical Processor(s). When i tried to install Microsoft SQL I was getting this error, please help me to resolve the issue.

SQL Server Database Engine
asked 2026-07-30T17:17:19.8333333+00:00
Dhivya Krishnan 0 Reputation points
commented 2026-08-06T10:07:23.5733333+00:00
Dhivya Krishnan 0 Reputation points
1 answer

SQL LICENSE

I have a product key, and I'd like to know what type of license it corresponds to.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,785 questions
asked 2026-08-06T08:16:21.9333333+00:00
Luca Facchetti 0 Reputation points
commented 2026-08-06T09:38:53.4066667+00:00
Luca Facchetti 0 Reputation points
1 answer

SSIS installed on Azure Marketplace SQL Server 2025 VM, but SSIS Catalog components are missing

I deployed a VM from the Azure Marketplace image: Publisher: microsoftsqlserver Offer: sql2025-ws2025 Plan: standard-gen2 Environment: SQL Server Version Microsoft SQL Server 2025 (RTM-CU7) (KB5096981) 17.0.4065.4 (X64) Standard Edition SSMS…

SQL Server Integration Services
SQL Server Integration Services

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

2,802 questions
asked 2026-08-05T09:05:51.61+00:00
Kris Reynolds 0 Reputation points
edited the question 2026-08-05T09:37:04.7+00:00
Erland Sommarskog 136.2K Reputation points MVP Volunteer Moderator
1 answer

how to override the database selected in the available database dropdown

I need to union results from two databases using fully qualified objects/views but the query after the union returns zero rows.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,785 questions
asked 2026-08-04T13:37:55.46+00:00
Lindbom, Peter 0 Reputation points
answered 2026-08-04T21:18:20.71+00:00
Erland Sommarskog 136.2K Reputation points MVP Volunteer Moderator
5 answers

sql server job is not running based on schedule

hi all: I have a very interesting case . There is a Database Full backup job and it had a schedule to run on a daily basis at 12am. I've changed it to run on a weekly basis but after a few days, I was surprised to find that this job was still…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,785 questions
asked 2021-02-04T06:48:06.343+00:00
Shi, Hui 1 Reputation point
answered 2026-08-04T20:34:01.3066667+00:00
Derek Wallace 0 Reputation points
6 answers One of the answers was accepted by the question author.

Where are the SQL Server developer edition downloads

Where are the developer edition download files for SQL Server 2022, SQL Server 2019, and SQL Server 2017?

SQL Server Database Engine
asked 2026-03-24T22:21:49.96+00:00
Steve Margolis 30 Reputation points
commented 2026-08-04T16:52:30.9366667+00:00
Steve Margolis 30 Reputation points
1 answer

SQL server 2025 training

Hi Team, We are looking for SQL Server 2025 training for our Database Administration team. Could you please share: Available SQL Server 2025 training programs Course content and duration Virtual and instructor-led options Team pricing for…

SQL Server Database Engine
asked 2026-08-04T14:05:26.3633333+00:00
ashutosh 0 Reputation points
answered 2026-08-04T16:11:51.6833333+00:00
Julian Sharp 38,651 Reputation points
1 answer

How to add table permission in Power platform entity

How to add table permission in Power platform entity

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,785 questions
asked 2026-07-07T17:22:22.5966667+00:00
Mohit Sharma (HCL Technologies Corporate Ser) 0 Reputation points Microsoft External Staff
commented 2026-08-04T15:43:56.04+00:00
Mohit Sharma (HCL Technologies Corporate Ser) 0 Reputation points Microsoft External Staff
4 answers

SQL Server 2022 Database Engine Recovery Handle Failed on Clean Windows 11 Installation

Hello, I am unable to install SQL Server 2022 (Express and Developer) on my Windows 11 Home laptop. Every installation fails with the following error: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential…

SQL Server Database Engine
asked 2026-08-03T02:16:40.6166667+00:00
Kiara Keys 0 Reputation points
answered 2026-08-03T08:33:09.4966667+00:00
Erland Sommarskog 136.2K Reputation points MVP Volunteer Moderator
1 answer

How to access the accounts under SSRS Builtin\Administrators

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,175 questions
asked 2026-08-03T02:27:44.84+00:00
Amanda 0 Reputation points
answered 2026-08-03T03:31:26.3066667+00:00
Deepesh Dhake 820 Reputation points
2 answers

Restoring last SQL transaction log

Hi expert, I've ended my large DB from Log shipping process and it has many transaction log files created, and now how to make my DB on secondary instance taking online? what is the steps should I do? great thanks & appreciation for all reply warmest…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,785 questions
asked 2026-07-31T08:18:26.8633333+00:00
Urbel 665 Reputation points
answered 2026-07-31T19:09:26.57+00:00
Deepesh Dhake 820 Reputation points
1 answer

Clarification on SQL Server License Compliance during FCI Migration (VMware to Hyper-V)

Hello everyone, I am currently executing an internal infrastructure migration project moving our environment from VMware to Microsoft Hyper-V, and I need some clarification on SQL Server licensing compliance during the transition phase. Current…

SQL Server Database Engine
asked 2026-07-30T16:48:14.3766667+00:00
Sang. Truong Tan 0 Reputation points
answered 2026-07-30T21:47:33.2+00:00
Erland Sommarskog 136.2K Reputation points MVP Volunteer Moderator
1 answer

SQL Server 2019 Express installation fails on Windows 11 with SQLWriter service and Windows Installer DLL errors

I am trying to install Microsoft SQL Server 2019 Express on Windows 11 (64-bit). The installation fails with the following errors: Service 'SQL Server VSS Writer' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system…

SQL Server Database Engine
asked 2026-07-23T08:25:34.99+00:00
sagar miroliya 0 Reputation points
edited an answer 2026-07-30T20:38:58.7566667+00:00
Deepesh Dhake 820 Reputation points
1 answer

SSMA Server-seitige Datenmigrations-Engine

Problemzusammenfassung: Die Server Side Data Migration Engine in SSMA für Oracle 10.5 schlägt sofort ohne Datenmigration und ohne Erstellung eines SQL-Agent-Jobs fehl. Client-seitige Migration funktioniert erfolgreich.    Environment  Oracle Database 12c…

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.

609 questions
asked 2026-07-30T12:51:12.61+00:00
Benjamin Durst 0 Reputation points
commented 2026-07-30T13:14:31.98+00:00
Benjamin Durst 0 Reputation points
2 answers

PowerBI Report Server can't connect sql server (basic auth) in Direct Query Mode

I'm trying to connect to sql server using basic auth in PBIRS Direct query mode, it pass the connection test but when I open the report I get "We couldn't connect to the Analysis Services server. Make sure you've entered the connection string…

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,175 questions
asked 2026-07-30T10:15:54.3033333+00:00
IsraMavaldi-8048 0 Reputation points
answered 2026-07-30T11:48:56.6566667+00:00
Senthil kumar 1,730 Reputation points
1 answer

How to enable SQL Server linked server credential delegation on Linux?

I have two SQL Server instances, "main" and "linked", deployed on Docker, and both are configured for Active Directory authentication using a local test AD. I want to add "linked" as a linked server on "main", and…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,785 questions
asked 2026-07-28T09:55:45.4+00:00
Vasil 0 Reputation points
commented 2026-07-29T14:24:48.89+00:00
Bruce (SqlWork.com) 84,856 Reputation points