18,732 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
7 answers One of the answers was accepted by the question author.

SQL Express 2019 - Can't remotely connect

I have a fresh Windows Server 2019 with a fresh copy of SQL Server 2019 Express. Windows Firewall is turned off. I installed under default (not named) instance, and have no problems connecting locally with SSMS 2019. However, I can't remotely…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2021-02-26T21:09:15.44+00:00
Hugh O'Donnell 101 Reputation points
commented 2024-07-30T04:27:38.8366667+00:00
Dave Mescher 0 Reputation points
2 answers

Looping through excel files

I am trying to load multiple excel files using for each loop container. In my 'Excel Connection Manger' I am accessing the data through 'SQL Command from variable'. I am getting an error message when I try to make the filename dynamic in the connection…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,532 questions
asked 2024-07-28T23:22:23.42+00:00
Ali Ahad 111 Reputation points
commented 2024-07-30T02:48:06.83+00:00
ZoeHui-MSFT 35,556 Reputation points
3 answers

can we analyize data in sql? how? please tell me

can we analyize data in sql? how? please tell me

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-27T10:39:26.8333333+00:00
adamrez 20 Reputation points
commented 2024-07-30T01:48:21.3366667+00:00
CathyJi-MSFT 21,136 Reputation points Microsoft Vendor
1 answer

TSQL returning the wrong calculation results

I'm very confused. I've been working on this for hours. I have a query: set @interest = @balance * power(1.0 + @curIrate / 365.0,@days) - @balance select @checkDate checkDate, @interest interest, @balance balance, @curIrate curIrate, @days days The…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,606 questions
asked 2024-07-29T22:30:04.77+00:00
OHPRS Admin 211 Reputation points
edited the question 2024-07-30T00:57:02.3466667+00:00
LiHongMSFT-4306 25,726 Reputation points
1 answer

Cannot create and start Extended Events session in Azure SQL Managed Instance

Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-06-24T15:08:42.51+00:00
Aleksey Vitsko 25 Reputation points
commented 2024-07-30T00:47:00.78+00:00
Oury Ba-MSFT 18,026 Reputation points Microsoft Employee
1 answer

Azure SQL Server Entra ID only authentication in ARM

Greetings, I am trying to create an Azure SQL Server with Entra ID only authentication using ARM templates as the title suggest. However if I don't add the administratorLogin and administratorPassword fields for the classis SQL server admin, the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,691 questions
asked 2024-01-25T11:44:18.1433333+00:00
Dimitar Grozev 60 Reputation points
commented 2024-07-30T00:36:33.8433333+00:00
Oury Ba-MSFT 18,026 Reputation points Microsoft Employee
3 answers

Always Encrypted" column in SQL server

I can't decrypt the "Always Encrypted" column in SQL server using the keys in azure key vault, I am using Go language for the process and I can't find any reference reagrding the decryption, please guide me to decrypt the data in SQL server,…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-27T14:31:40.0633333+00:00
Mohammed Izzath 0 Reputation points
answered 2024-07-29T21:53:19.7633333+00:00
Erland Sommarskog 107.4K Reputation points MVP
0 answers

Unable to connect to Azure Virtual Machine(VM) with SQL Server Analysis Services(SSAS) installed using SQL Server Management Studio(SSMS)

I'm trying to deploy an MSOLAP multidimensional cube, using Visual Studio, to Azure VM with SSAS installed. However, the deployment failed due to the following error Severity Code Description Project File Line Suppression State Error The project could…

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,265 questions
asked 2024-07-29T20:42:58.5333333+00:00
Sunny Juneja 0 Reputation points
1 answer One of the answers was accepted by the question author.

Issue creating Service-Based SQL Database in Visual Studio 2022

I am attempting to create an SQL Database in visual studio 2022: I get the following error: even though sql client has been added as a package reference: Any thoughts? thanks

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,900 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.
13,390 questions
asked 2024-07-27T06:44:54.7333333+00:00
John Dyson 20 Reputation points
accepted 2024-07-29T17:43:55.88+00:00
John Dyson 20 Reputation points
0 answers

How to Retrieve SQL Server Instance Details from SQL IaaS Agent Extension Using Azure CLI

Hello Azure Community, I am working with SQL Virtual Machines in Azure and using the SQL Server IaaS Agent Extension to manage my SQL Server instances. In the Azure portal, under the "SQL Virtual Machine" service, I can view detailed SQL Server…

SQL Server on Azure Virtual Machines
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-26T12:15:01.9433333+00:00
FERNANDO ARTERO SERRANO 0 Reputation points
commented 2024-07-29T16:23:44.6233333+00:00
Oury Ba-MSFT 18,026 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Does Microsoft Permit Access to Source Code

Our corporate auditors asked if I had access to SQL Server Reporting Services source code. I told them I do not, but they need to hear it from Microsoft. Can you state that for them please? Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-29T13:05:24.7966667+00:00
PhilCBowman-7252 20 Reputation points
accepted 2024-07-29T16:17:46.2633333+00:00
PhilCBowman-7252 20 Reputation points
2 answers

SQL audit (Server audit specification > SERVER_STATE_CHANGE_GROUP) log sa user instead DOMAIN\USERNAME

Hi all, I am testing audit for SQL Server currently running on a IAAS VM (Win server 2022, SQL Server 2022 CU14). I have created an audit which log file in a file. I have created a Server audit specification which include the action…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-25T17:04:58.85+00:00
Alessandro Colombi 0 Reputation points
commented 2024-07-29T16:12:12.4433333+00:00
Alessandro Colombi 0 Reputation points
0 answers

CDC Attunity : Async switch from online redo log to archived log when online logs are not available

My organization has been using the CDC Attunity tool for the past three years to manage data replication between an Oracle 11g source database and a SQL Server 2016 destination database. Recently, we have encountered an issue where the tool is unable to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-29T14:16:57.0366667+00:00
Krutika Shirbhate 0 Reputation points
9 answers

SQL Server install error Wait on the Database Engine Recovery Handle Failed

SQL Server 2019 install error Wait on the Database Engine Recovery Handle Failed this error is coming and i have tried everything on the internet to solve this but it still isnt installing can anyone tell me how to remove this error

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
48 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.
13,390 questions
asked 2021-07-28T10:27:04.27+00:00
Priyanshu Singh 31 Reputation points
commented 2024-07-29T10:24:39.9733333+00:00
Mluleki Memela 0 Reputation points
0 answers

Azure Synapse "Message Type Not Found" error when running stored procedure: Appears when lines of code reach certain line length

Hi, We need some technical guidance from either a Azure Synapse specialist to resolve an issue which we are unable to understand / fix despite running through the sql logic bit-by-bit, line-by-line. Any guidance or help would be much appreciated. We have…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,710 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,265 questions
asked 2024-07-22T17:24:40.0233333+00:00
Michael King 0 Reputation points
commented 2024-07-29T08:22:44.43+00:00
NIKHILANETHIKUNTA 160 Reputation points Microsoft Vendor
1 answer

Query stuck with HTDELETE for hours eventually timing out

We have an Azure SQL Database to manage our Customer data. I have a reasonably complicated query that has been getting stuck with an HTDELETE wait. Most recently it timed out after 4 hours. This was in our QA environment. The same query finishes in less…

Azure SQL Database
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.
73 questions
asked 2024-07-26T00:53:55.72+00:00
Nick Ryan 221 Reputation points
commented 2024-07-29T08:13:35.05+00:00
Erland Sommarskog 107.4K Reputation points MVP
1 answer

Linked service authentication options for SQL Server are different amongst ADF within same subscription

In the same Azure subscription, I have several resource groups and each has data factories, however, the linked service authentication options are not the same among them, why? Here is an example: ADF1: SQL SERVER Linked service authentication…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,227 questions
asked 2024-07-19T10:42:32.6633333+00:00
Gonçalo J P Carvalho 0 Reputation points
commented 2024-07-29T05:54:54.01+00:00
Smaran Thoomu 12,695 Reputation points Microsoft Vendor
1 answer

error in import and export wizard of sql server management studio

installed sql server management studio server but cant able to do import data into sql server however installed import export wizard although facing error it shows below image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-29T05:10:22.6233333+00:00
LoyalImran-8972 0 Reputation points
commented 2024-07-29T05:11:10.05+00:00
LoyalImran-8972 0 Reputation points
4 answers

KB5040948 security patch crashed SQL Server

KB5040948 security patch corrupted master database. Script level upgrade for database 'master' failed because upgrade step 'ssis_discovery' encountered error 35262, state 4, severity 10. It succeeded on standalone servers, but crashed on servers with…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-10T22:46:18.8233333+00:00
bukkybu 361 Reputation points
answered 2024-07-29T02:12:42.1066667+00:00
Craig Rowe 0 Reputation points
0 answers

SQL Server 2022: Blocking Issues with sp_help_jobhistory and sp_jobhistory_row_limiter Procedures

Hello All, I'm experiencing persistent blocking issues in SQL Server 2022, specifically related to the sp_help_jobhistory and sp_jobhistory_row_limiter procedures. Here’s the background and the steps I've taken so far: Background: SQL Agent History…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-28T18:36:52.0533333+00:00
Vinith 45 Reputation points
commented 2024-07-28T21:45:26.7633333+00:00
Erland Sommarskog 107.4K Reputation points MVP