18,175 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

SSRS Report Server 22 Native Scale Out with a network Load Balancer not working as expected.

I have setup a 2022 SQL Instance. Using the DB from a 2012 r2 instance. I have looked over documentation. I can only get the last report server joined to the instance to display the webserver and the reports server. Example node1, 2 and 3 were installed…

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,925 questions
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,831 questions
asked 2024-05-29T23:10:13.39+00:00
AP 0 Reputation points
2 answers

sql server agent alert failed

hello I have this problem with my SQL Server Agent, the service is working properly but when I make alert by some program running by SQL Server it shows that SQL Server agent is not working even if it is working, where should the problem be?

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,925 questions
asked 2024-05-29T07:47:16.79+00:00
Ahmed Al Mohalami 0 Reputation points
answered 2024-05-29T21:51:11.7333333+00:00
Erland Sommarskog 102.4K Reputation points
1 answer

Invalid column

Hi When I execute below SP gives me invalid column error. Sometime it will work and sometime it gives this error create proc test as Begin Select * into #Temp from table1 begin ALTER TABLE #Temp ADD IsOn BIT NOT NULL DEFAULT(1) UPDATE #Temp SET…

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,925 questions
asked 2024-05-29T11:43:16.77+00:00
SVA 86 Reputation points
answered 2024-05-29T21:44:46.7666667+00:00
Erland Sommarskog 102.4K Reputation points
0 answers

SQL Server 2022 Express installation - how to fix 'error while checking Rules of Sql Server set up'?

Hello, I am having trouble installing SQL Server 2022 Express Edition, Basic installation type. I keep getting this error during installation: "There was an error while checking Rules of Sql Server setup" I have so far tried: Restarting my…

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,925 questions
asked 2024-05-29T12:02:47.3133333+00:00
Mariel 0 Reputation points
commented 2024-05-29T21:41:21.0666667+00:00
Erland Sommarskog 102.4K Reputation points
0 answers

exit code (decimal): -2068052377error description: invalid command line argument. consult the window installer sdk for detailed command line help

This morning I was still able to use sql, I was curious and deleted something like SQLEXPRESS16, then I uninstalled all sql and reinstalled it all, and used quite a few cmd commands that I didn't know to uninstall but still nothing. I can't remove them,…

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,925 questions
asked 2024-05-29T14:08:19.1766667+00:00
Dukanhh 0 Reputation points
commented 2024-05-29T21:35:20.4766667+00:00
Erland Sommarskog 102.4K Reputation points
4 answers

Upgrade required

Hi Team, I am having SQL Server 2022 Developer edition on my windows machine. I need to upgrade below (to avoid any security vulnerability) - SQL Server 2022 Developer edition OLEDB ODBC Please let me know the steps(links) for same. Let me know if…

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.
12,925 questions
asked 2024-05-29T18:03:08.4666667+00:00
Salil Singh 20 Reputation points
answered 2024-05-29T21:31:11.24+00:00
Erland Sommarskog 102.4K Reputation points
3 answers

SQL Server Non Clustered Index CREATE taking forever to cancel

I ran a CREATE NON CLUSTERED INDEX command for 1.5 hours. Decided to cancel it because it was stopping other things running. The command has now been running for 22 hours. What is it doing that takes so long to roll back? The table is 2 billion rows and…

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,925 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.
51 questions
asked 2024-05-23T00:03:03.8166667+00:00
Nick Ryan 221 Reputation points
commented 2024-05-29T21:20:39.37+00:00
Erland Sommarskog 102.4K Reputation points
3 answers

Downgrade SQL Server 2022 to SQL Server 2019

We just purchased SQL licensing for 32 cores at 2,500 per month, 1 year. We have the media to download for SQL2022; however, we need SQL Server 2019 in order to make our application work. How do we go about downgrading the instance? We have an…

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,925 questions
asked 2023-10-04T21:44:26.0633333+00:00
Sculimbrene, Paula 5 Reputation points
commented 2024-05-29T21:17:41.35+00:00
Erland Sommarskog 102.4K Reputation points
0 answers

Connecting Azure web app service (.net8) to SSRS on Azure VM by using private DNS

My azure web app service(.net8) connect to SSRS on VM by using the private DNS name provided by Azure to the VM, but my credentials did not work when I run the report on my azure web app server. The private DNS name works fine with my credentials via url…

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,831 questions
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
788 questions
asked 2024-05-29T19:10:30.8133333+00:00
Billey 0 Reputation points
edited the question 2024-05-29T20:20:03.2666667+00:00
kobulloc-MSFT 24,326 Reputation points Microsoft Employee
1 answer

Error when installing SSIS

I am trying to install SSIS after the install of VS 2019 and I keep running into an issue. I have a WIN 2011 machine. I have tried with VS2022 / VS 2019 Profession as well as community editions. I have installed and uninstalled many times with the hope…

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,925 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,470 questions
asked 2024-05-29T15:36:03.54+00:00
Rajsekhar Patlola 0 Reputation points
answered 2024-05-29T19:55:41.4866667+00:00
Yitzhak Khabinsky 25,206 Reputation points
2 answers

How to install SQL Server 2022 on Ubuntu Server 24.04 LTS

I couldn't find a proper way to install the SQL Server 2022 on Ubuntu Server 24.04 LTS, I tryed to use the microsoft SQL Server 2022 from Ubuntu 22.04 repo, but couldn't get the service running properly. I ended with this service status (see print). Is…

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,925 questions
asked 2024-05-24T00:46:20.3866667+00:00
Michael F. Assis 5 Reputation points
edited an answer 2024-05-29T17:03:38.87+00:00
isaul carquin 0 Reputation points
1 answer

"Sync to other databases" is missing

Under Data management, select Sync to other databases is missing, I'm the Global Admin / Owner of the Database and Subscription so I think this can't be an access Issue.

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.
12,925 questions
asked 2024-05-29T08:24:57.7533333+00:00
Erick Rae Q. Nobleza 0 Reputation points
answered 2024-05-29T15:51:01.2933333+00:00
Alberto Morillo 33,001 Reputation points MVP
8 answers

SQL SERVER 2022 - certificate error when creating a job for integration services

In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…

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,925 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,470 questions
asked 2024-04-10T03:35:21.82+00:00
Marcio Matos 40 Reputation points
answered 2024-05-29T15:14:11.22+00:00
na 121 Reputation points
1 answer

delimited split gives null for some items

hi all, I am using a function to split a string into multiple rows. The function is available here: https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-%e2%80%9ccsv-splitter%e2%80%9d-function What I am trying to figure out is how 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,925 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.
51 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,565 questions
asked 2024-05-29T13:43:14.27+00:00
elsvieta 346 Reputation points
commented 2024-05-29T15:01:51.0966667+00:00
elsvieta 346 Reputation points
0 answers

How to change the logo for SQL Server Master Data Services (MDS) in 2019

This used to be accomplished in the SQL Server Master Data Services (MDS) 2016 version by changing the logo.png file.

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,925 questions
asked 2024-05-29T13:40:17.81+00:00
Novicki, Joseph 0 Reputation points
3 answers

We are seeing an issue with SQL Linked Servers and Windows 11. Kerberos doesn't seem to be passing credentials

All of our existing Windows 10 computers work fine, but the newer Windows 11 computers throw the anonymous error on the linked server. Kerberos is configured correctly along with SPN's. We can't seem to figure out why Windows 11 can't do a double hop…

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,925 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,465 questions
asked 2023-07-11T19:30:02.36+00:00
Thomas McKane 5 Reputation points
commented 2024-05-29T12:38:36.8033333+00:00
Greg Arnold 26 Reputation points
1 answer One of the answers was accepted by the question author.

Is It Possible To View Which Users Belong To Which Security Group In SSRS

Hi I am new to Sql/SSRS and I have been looking at security roles. It looks like the secrity roles are applied at group level. I was wondering if there is a way I can tell which users belong to which security group from the reporting server. If it is…

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,925 questions
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,831 questions
asked 2024-05-29T10:08:57.7866667+00:00
Kuda 0 Reputation points
commented 2024-05-29T10:55:46.22+00:00
Kuda 0 Reputation points
1 answer

Quick Connection to SQL Server in Management Studio

Hello, I am using Management Studio to manage my databases, and I have multiple servers with several different databases. Is there a way to avoid having to enter the server name and user name every time? Perhaps by presetting all connection settings?

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,925 questions
asked 2024-05-29T09:59:12.3566667+00:00
Andrey Istomin 0 Reputation points
answered 2024-05-29T10:24:38.79+00:00
Olaf Helper 41,571 Reputation points
2 answers

Debugging SQL Server on Linux from remote VS 2022 pc

Is it possible to debug an SQL-Server on an Ubuntu 22 machine from Visual Studio 2022? I can reach the server an can execute queries from within VS2022. But debugging fails with no useful message (error 80004005). Firewall on the server pc is inactive.…

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,925 questions
asked 2024-05-28T18:57:39.8333333+00:00
Torsten Kiltz 0 Reputation points
answered 2024-05-29T09:30:30.0633333+00:00
MikeyQiao-MSFT 655 Reputation points Microsoft Vendor
0 answers

Microsoft (R) Visual Basic Compiler asking the upgrade the version.

We are trying to Execute SSRS report using rs.exe and will store result in CSV file. For this We have prepared (.rss) file, and executed from command prompt with following command. rs -i filename.rss -s https://server_name/ReportServer -v…

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,831 questions
.NET F#
.NET F#
.NET: Microsoft Technologies based on the .NET software framework.F#: A strongly typed, multi-paradigm programming language developed by the F# Software Foundation, Microsoft, and open contributors.
97 questions
asked 2024-05-29T09:11:40.0433333+00:00
Kalee Mamillapalli 0 Reputation points