18,035 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

SQL Connectivity Issue From Cloud app to on-prem server

hi, I have deployed a .net core MVC app in azure app service as a webapp. I have to connect to a on-prem sql server to retrieve data. I have setup Azure relay/hybrid connection for the same. Also I have installed hybrid connection manager in on-prem…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,207 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.
12,804 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,952 questions
asked 2024-05-07T10:38:07.05+00:00
Santhi Dhanuskodi 145 Reputation points
commented 2024-05-08T05:05:00.6333333+00:00
Olaf Helper 41,001 Reputation points
1 answer

Change the code and used in existing Views

Hi There is Scalar UDF used many places in views and SP. I need to change the Scalar UDF from all views and SPs. What is the alternate way to replace it. Is it good that I can replace the Scalar UDF with Inline table valued function. Appreciate your…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,804 questions
asked 2024-05-07T12:57:39.02+00:00
SVA 86 Reputation points
answered 2024-05-08T05:00:58.7+00:00
Olaf Helper 41,001 Reputation points
2 answers

Downloading the Server

I am not able to download the developer version of the SQL server 2022. It shows the same message again and again. What shall be done and why is it showing so? Kindly, have a look at the picture below. It's the message the pops-up repeatedly. Screenshot…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,804 questions
asked 2024-05-07T13:04:36.5366667+00:00
Yashvi Govil 0 Reputation points
answered 2024-05-08T02:34:34.84+00:00
MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
1 answer

How to pass multiple value for a postgres function in SSRS

I have created a report which is using postgres sql function and there are parameters for start date, end date and physician name. I am trying to pass multiple value for physician name and it is not working for me: This is how I am calling the function…

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,813 questions
asked 2024-05-07T14:10:33.6366667+00:00
Ali Ahad 91 Reputation points
answered 2024-05-08T02:23:42.25+00:00
ZoeHui-MSFT 33,296 Reputation points
0 answers

Ununable to install sql server (setup.exe) Exit code (Decimal): -2147467259 Error description: The service did not respond to the start or control request in a timely fashion.

I'm trying to download SQL express through the installation process it gives me an error Oops... Unable to install sql server (setup.exe) Exit code (Decimal) -2147467259E Error description: The service did not respond to the start or control request in…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,804 questions
asked 2024-04-30T15:39:20.9433333+00:00
moris shehady 0 Reputation points
commented 2024-05-07T21:15:27.4233333+00:00
Erland Sommarskog 101.7K Reputation points MVP
2 answers

Error description: The system cannot find the path specified while installing SQL server management studio

I am facing an error while installing Microsoft SQL Server 2022, In the log file the error says : Component name: SQL Server Database Engine Services Instance Features Component error code: 0x80004005 Error description: …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,804 questions
asked 2024-05-06T16:23:40.68+00:00
Nikita Gaur 0 Reputation points
answered 2024-05-07T21:01:20.62+00:00
Erland Sommarskog 101.7K Reputation points MVP
2 answers

How to fix NT AUTHORITY\ANONYMOUS LOGON login failure during MS SQL Server installation

Hi - I'm trying to install MS SQL Server on Microsoft Windows Server 2022 Standard 10.0.20348 Build 20348. I've tried installing both MS SQL Server 2019 and 2022. The installation fails with: Detailed results: Feature: 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.
12,804 questions
asked 2024-05-02T14:35:00.5566667+00:00
Lemons, Terry 1 Reputation point
commented 2024-05-07T13:19:06.6166667+00:00
Lemons, Terry 1 Reputation point
4 answers One of the answers was accepted by the question author.

Is there a 64 bit SSMS?

I‘ve already downloaded and installed SQL Server and SSMS on my computer and then I noticed that the SSMS running on my computer is a 32-bit program. I wonder if there a 64-bit SSMS, for I didn't find it anawhere, including the MicroSoft offical webpage.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,804 questions
asked 2021-09-29T11:48:06.173+00:00
子明 李 21 Reputation points
commented 2024-05-07T10:37:11.39+00:00
Vladimir Bazanov 0 Reputation points
0 answers

The target principal name is incorrect

Hi Team, I've got the error "The target principal name is incorrect. Cannot generate SSPI context" when I tried to connect to SQL Server from other server. I've checked sql logs and I found info SPN was registered . I've run Kerberos…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,804 questions
asked 2024-05-06T13:06:14.6233333+00:00
Marcin Woszczyna 0 Reputation points
commented 2024-05-07T09:39:12.2266667+00:00
MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

Power BI Reporting Server on Standard DB Engine

Is it possible for the .pbix files to work correctly when the Power BI reporting server (PBIRS) is installed on a Standard DB Engine? According to the below link, it looks contradictory as while it states that Standard edition is possible, it also…

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,813 questions
asked 2024-05-01T18:27:45.1366667+00:00
Jessy 20 Reputation points
accepted 2024-05-07T09:24:20.3433333+00:00
Jessy 20 Reputation points
2 answers

The transaction log for database is full due to 'REPLICATION'

Hi! I have a SQL 2019 database that is a member of 3 node always on availability group. It is also the subscriber being populated from a DB2 database. The log keeps filling up and I am unable to shrink or backup.. I get the message: The transaction log…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,804 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,558 questions
asked 2022-04-25T08:33:47.077+00:00
zoe Ohara 286 Reputation points
commented 2024-05-07T09:12:45.76+00:00
Rishi Sethi 0 Reputation points
0 answers

Key store providers cannot be set more than once(Always Encrypted with JDBC and Java 8)

We are trying to use SQL Always Encrypted feature in our Java Web Application. Java 8 is the JRE and uses mssql-jdbc-9.2.1.jre8.jar as the jdbc driver. Azure-Key-vault as the column master key store provider Our application uses below code 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.
12,804 questions
asked 2021-11-09T04:53:17.773+00:00
Subin Sankaran 1 Reputation point
commented 2024-05-07T09:07:01.79+00:00
Manjunatha Bhimanna (Aspiresys Consultant) 0 Reputation points
2 answers One of the answers was accepted by the question author.

Integration service on dedicated SQL instance

Based on an assessment I did on a client's server, I have to move all the integration services to a dedicated machine. We decided to separate ETL and data on two machines. My question is: having a dedicated instance, how do I manage the memory CAP on…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,804 questions
asked 2024-05-06T09:26:30.6333333+00:00
Alen Cappelletti 931 Reputation points
accepted 2024-05-07T07:29:42.83+00:00
Alen Cappelletti 931 Reputation points
1 answer

Scripting out 'Create Merge Replication' does not include 'processing_order'

We use Merge Replication and have defined a specific 'processing_order' for the Articles in the Publication. The Articles include tables, functions and stored procedures. When we want to setup or refresh a test environment, we will script out 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.
12,804 questions
asked 2024-05-03T03:20:20.6466667+00:00
Greg Youdale 5 Reputation points
commented 2024-05-07T06:16:19.72+00:00
Greg Youdale 5 Reputation points
4 answers One of the answers was accepted by the question author.

How to install sql server on windows 11 using UTM on mac,

Hello everyone Please help me. I am stuck here for 2 days. I am trying to install sqlserver 2022 on windows 11 using UTM on mac m1. I am getting this error.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,804 questions
asked 2023-01-25T16:38:55.61+00:00
Malik Allahyar Nawabi 20 Reputation points
commented 2024-05-07T02:53:33.55+00:00
Merna 0 Reputation points
2 answers

Text delimiter file

Hi, I have two tables: one for headers with 9 fields and another for lines with 6 fields. Both header and lines are highlited in yellow. I need to combine both the headers and lines using a UNION operation to display the result below. From the line…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,804 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
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.
47 questions
asked 2024-05-06T14:48:13.48+00:00
Vicki 46 Reputation points
answered 2024-05-07T02:18:28.6533333+00:00
CosmogHong-MSFT 23,321 Reputation points Microsoft Vendor
1 answer

Performance Monitoring tools used for 4 hrs

Using Performance Monitoring tool to check on the performance of the database server. I cannot extend the duration to more than 1000 secs. What are the other options for performance monitoring so that I can get the data for 4 hrs

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,813 questions
asked 2024-05-01T22:28:33+00:00
Avyayah 1,231 Reputation points
commented 2024-05-07T01:08:43.2566667+00:00
CosmogHong-MSFT 23,321 Reputation points Microsoft Vendor
4 answers One of the answers was accepted by the question author.

SSIS Error when deploying package, the locale identifier LCID is not supported by SQL Server

Hi I am unable to deploy my project from Visual Studio to SSISDB. I have tried to change my localename and locale as well as my region. I have also made MYSQL Server login local but the below error still persists. Can anyone provide guidance TITLE: SQL…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
719 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.
12,804 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
asked 2021-05-03T11:51:51.583+00:00
Lynn Carelse 21 Reputation points
answered 2024-05-06T23:54:14.06+00:00
Santiago Guerrero Toro 0 Reputation points
2 answers

Named Pipes Provider: Could not open a connection to SQL Server

Hi, Named Pipes Provider: Could not open a connection to SQL Server error (53) from public facing Server to Local SQL Server but Local to DMC Server possible Please any one can you advice to me Kind Regards R.Raja

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,804 questions
asked 2024-05-02T05:30:16.5+00:00
Raja Raju 0 Reputation points
commented 2024-05-06T20:43:46.97+00:00
Erland Sommarskog 101.7K Reputation points MVP
3 answers

how troubleshoot SqlDumpExceptionHandler: Process 113 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process

We use Cumulative Update 21 for SQL Server 2019, Always on with 1 Primary plus 2 secondary replicas. Recently we noticed our SQL Server had some dumps, like below. Can anyone pls help advise how troubleshoot it? Thanks SqlDumpExceptionHandler: Process…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,804 questions
asked 2024-05-02T02:52:39.4733333+00:00
Ted Yin 0 Reputation points
edited an answer 2024-05-06T09:36:23.28+00:00
LucyChen-MSFT 1,200 Reputation points Microsoft Vendor