18,643 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
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,324 questions
asked 2024-06-24T15:08:42.51+00:00
Aleksey Vitsko 20 Reputation points
commented 2024-07-19T21:34:10.5+00:00
Aleksey Vitsko 20 Reputation points
3 answers

Database User dbo is orphaned- How to fix

Hello All All feedback is welcome ALTER USER [dbo] WITH LOGIN = [ww] GO Msg 15150, Level 16, State 1, Line 14 Cannot alter the user 'dbo'.

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,324 questions
asked 2024-07-18T14:38:25.7933333+00:00
Stephen Keogh 20 Reputation points
commented 2024-07-19T21:21:06.33+00:00
Ben Miller-(DBADuck) 10 Reputation points MVP
3 answers

VS2017 - SSIS Project

Hello Team, We are using VS2017 with SSDT installed (PFB the screenshot) We cannot find BI projects, unable to create SSIS projects. Please advice. Regards, Nagesh CL

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,873 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,521 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,677 questions
asked 2024-06-24T16:16:33.29+00:00
Nagesh CL 641 Reputation points
edited the question 2024-07-19T20:15:41.65+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
1 answer

Transcript Not Sowing Exam Passed May 9, 2024

When logged in here I can see Exam titleExam numberPassed dateAdministering Microsoft Azure SQL SolutionsDP-300May 9, 2024Administering Microsoft Azure SQL SolutionsDP-300May 9, 2024But the anonymous validation does not show it            …

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,324 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,677 questions
asked 2024-06-27T15:16:51.19+00:00
REGAN WICK 0 Reputation points
edited the question 2024-07-19T20:13:15.1466667+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
3 answers

SQL login issue

I'm trying to connect via local SSMS to the SQL Server on my Azure VM but it's failing saying the Server is not found or accessible. I can RDP into my VM without issue. Any ideas please?

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,324 questions
asked 2024-06-10T10:03:55.5233333+00:00
Gurpreet Khaira 0 Reputation points
commented 2024-07-19T20:08:19.6966667+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
1 answer

Additional Cost for Verify Function in SQL DB Backups to Blob Storage

I have a plan to move my SQL backups directly to Blob Storage and want to know what additional costs I may encounter when using the Verify function in my T-SQL query. I have read that Verify may increase costs tenfold, but I need more detail and…

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,338 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,618 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,324 questions
asked 2024-06-06T20:53:53.0733333+00:00
Jordan Algar 0 Reputation points
edited the question 2024-07-19T20:06:58.1666667+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
6 answers

SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…

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,324 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,521 questions
asked 2021-11-19T14:32:00.537+00:00
Alex Fletcher 51 Reputation points
commented 2024-07-19T18:06:09.3933333+00:00
Janya Lee Erwin 246 Reputation points
3 answers One of the answers was accepted by the question author.

DPM 2022 installation: "SQL Server Management Tools not installed on this machine" error during install

Hy! I am deploying a DPM 2022 evironment. A have a separate SQL server and a DPM server. The SQL server has SSMS 19.0.1 (latest). I have installed this SSMS version on DPM server before install the DPM 2022. THE DPM installation show the following error…

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
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,324 questions
asked 2023-03-13T10:37:19.7733333+00:00
adam900331 50 Reputation points
answered 2024-07-19T17:23:40.62+00:00
Mame Meier 50 Reputation points
1 answer One of the answers was accepted by the question author.

Getting errors trying to import data from an SAP Cloud for Customer tenant using OData API in SSIS

Hello, So, I am attempting to import data from an SAP Cloud for Customer (C4C) System into an SQL Server Table using SSIS on Visual Studio 2022. I am using the Odata Source tool to connect to the system and the connection is successful. I can even see…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,873 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,324 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,521 questions
asked 2024-07-18T15:55:39.1166667+00:00
Amogh Sharma 20 Reputation points
accepted 2024-07-19T15:09:19.19+00:00
Amogh Sharma 20 Reputation points
3 answers

[Error] SQL Server closes automatically when trying to import files into a database

Hello! During the process of importing files into a database ("Tasks" > "Import flat file" > "Browse"), SQL closes automatically. It doesn't display any error message, it just closes. I've already uninstalled all 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,324 questions
asked 2024-07-16T09:29:00.7333333+00:00
Martin Mulloschadt 0 Reputation points
commented 2024-07-19T14:01:58.3333333+00:00
Erin Stellato 631 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

SQL Server Reporting Services installer not found

All links from all versions of SQL Server Reporting Services are returning the error $set_redirect('https://www.microsoft.com/library/errorpages/smarterror.aspx?correlationId=$(cvToken)') Internal Server Error. The server encountered an internal error…

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.
2,869 questions
asked 2024-07-16T19:50:17.82+00:00
Lucas Gabriel de Oliveira Silva - Valcann 20 Reputation points
accepted 2024-07-19T13:00:06.57+00:00
Lucas Gabriel de Oliveira Silva - Valcann 20 Reputation points
0 answers

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,324 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,141 questions
asked 2024-07-19T10:42:32.6633333+00:00
Gonçalo J P Carvalho 0 Reputation points
commented 2024-07-19T12:47:13.4266667+00:00
Nandan Hegde 31,346 Reputation points MVP
4 answers

Share mailbox not same as desktop version, why?

Hi, would like to use internet version for my emails but the shared mailbox favorites doesn't act like the desktop version. Desktop version: instant notifications Web version: just takes forever, the main inbox mailbox is ok, but takes forever to see it…

Outlook
Outlook
A family of Microsoft email and calendar products.
3,406 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,324 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,609 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
5,066 questions
asked 2024-07-18T15:05:18.8466667+00:00
James Champagne 0 Reputation points
commented 2024-07-19T12:20:56.4266667+00:00
James Champagne 0 Reputation points
2 answers

SQL Query Split

Hello, I have query with result like below pic, now i want to separate the value to 5 columns based on value of al, av, date, int and KB so the expected final result is 07/18/2024 17:47:35 , 1.415.174.0, 07/15/2024 00:00:00, False and 5040430. And also…

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,324 questions
asked 2024-07-19T03:07:46.9366667+00:00
Handian Sudianto 4,471 Reputation points
commented 2024-07-19T12:20:00.6966667+00:00
Yitzhak Khabinsky 25,726 Reputation points
1 answer

"Incompatible" project

(Relatively new to SSIS so apologies if this is an easy one) I set up a data flow in the community version of VS as a proof of concept. Then moved to the enterprise version but opened the old project before installing SSIS and of course it said the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,521 questions
asked 2024-07-16T14:40:52.23+00:00
Lusk, Colin 0 Reputation points
edited an answer 2024-07-19T12:18:33.27+00:00
Yitzhak Khabinsky 25,726 Reputation points
0 answers

Customer Best Practices Assessment: exclude checks/false positives

Is there any way to customize the BPA in Azure ARC for SQL to exclude certain checks or to flag issues as false positives? I've got certain issues being flagged by the BPA however these can't be resolved as the application accessing the database requires…

Azure SQL Database
Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
383 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,324 questions
asked 2024-07-19T09:42:13.16+00:00
Berend Broekhoff 0 Reputation points Microsoft Employee
commented 2024-07-19T11:24:16.1466667+00:00
ShaktiSingh-MSFT 14,381 Reputation points Microsoft Employee
2 answers

Facing issues to connect with synapse workspace/azure sql db via oauth

I want to connect to and access my Synapse Workspace and SQL Pool using OAuth. For this purpose, I have created an app in Azure and assigned the following API permissions: Microsoft Graph: Directory.Read.All (Delegated) Directory.ReadWrite.All…

Azure SQL Database
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,671 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,324 questions
asked 2024-07-15T05:04:01.89+00:00
SUBHAM KUMAR 0 Reputation points
commented 2024-07-19T09:26:18.05+00:00
phemanth 8,645 Reputation points Microsoft Vendor
0 answers

Power BI Report Schedule Refresh Error

In the report server database est connection is successful but whenever doing schedule refresh its not connecting. throwing error like "an error occurred within the report server database. this may be due to a connection failure, timeout or low disk…

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,324 questions
asked 2024-07-19T08:55:53.56+00:00
Zubeyr Aydogan 0 Reputation points
3 answers

Connection to SQL Server from .NET Core on Ubuntu fails with SSL/TLS handshake error

I have a .NET Core console application that connects to a SQL Server database. The application works fine on Windows, but I'm encountering an SSL/TLS handshake failure when running it on an Ubuntu 22.04 LTS VM  class Program { static void Main() …

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,626 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,324 questions
asked 2024-07-18T15:56:42.1666667+00:00
Ansh 0 Reputation points
commented 2024-07-19T08:37:43.9566667+00:00
Hongrui Yu-MSFT 945 Reputation points Microsoft Vendor
3 answers

Cluster error

Cluster with Alwayson unreachable: Errors: 00000ef4.00000a74::2024/07/17-13:51:50.791 ERR [API] AccessCheck[AndAuditAlarm] failed. status = 0x00000005 00000ef4.00000a74::2024/07/17-13:51:53.512 WARN [API] s_ApiOpenResourceEx: Resource Scaleout Master…

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,324 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,609 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
978 questions
asked 2024-07-17T15:53:45.3366667+00:00
Dario Bodini 1 Reputation point
commented 2024-07-19T07:51:22.39+00:00
LucyChenMSFT-4874 2,985 Reputation points