SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,721 questions
0 answers
WCF EndpointNotFoundException when connecting to
System.ServiceModel.EndpointNotFoundException: Could not connect to the remote endpoint 18775299031 Server stack trace: at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at…
SQL Server Integration Services
asked 2025-08-28T14:42:13.1433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 2%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
shreyansh raj
0
Reputation points
commented 2025-08-28T21:17:28.2533333+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
2 answers
Cores Per Socket Best Practices for VMs
Hello, What configuration offers better performance for SQL Server Enterprise Edition Running on virtual machines like VMWare: multiple sockets with one core each (e.g., 8 sockets, 1 core per socket) or a multi-core setup (e.g., 1 socket, 8 cores)?…
SQL Server Database Engine
334 questions
asked 2025-07-22T19:08:33.1466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 1%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWG%3C/text%3E%3C/svg%3E)
Wallace, Glenn
20
Reputation points
commented 2025-08-28T16:41:47.5533333+00:00
Ben Miller-(DBADuck)
195
Reputation points MVP
1 answer
I have a 2019 SQL database which is the primary, I want to set up a secondary server using logshipping. What is the highest version on SQL server I can install. Upgrading the primary is not an option.
The supplier has a transactional database that is on a SQL 2019 server. They provide us a reporting copy using logshipping. We would like to install the latest possible version of SQL server that would be compatible. Will be able to get away with a SQL…
SQL Server Database Engine
334 questions
asked 2025-08-28T12:47:25.7833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 46%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Shipra Bajpai NHS
0
Reputation points
answered 2025-08-28T15:08:51.2166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
79,526
Reputation points
Volunteer Moderator
0 answers
How to resolve issue of Audit log table containing incorrect data?
We have created a parent table & child table in SQL Server database. For one parent record, there are multiple child records. When a child record in updated, a Stored Procedure is called in which a few fields of all the child records are updated that…
SQL Server | Other
14,530 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 57.00000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
3 answers
What is Microsoft Plan for upgrading SSRS Report Viewer Control to Unified .NET platform
What is the Microsoft Plan for upgrading SSRS Report Viewer Control to Unified .NET platform? Link…
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,075 questions
asked 2025-03-12T20:54:28.5033333+00:00
Ambar Prajapati
0
Reputation points
answered 2025-08-28T09:34:38.75+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 87%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Sathesh Dhanasekaran
0
Reputation points
1 answer
sql cluster failover slower failover when only cluster and client network fails much faster when all networks fail
We have setup a simple two node SQL Server Cluster using SQL cluster (not WSFC windows cluster), plus witness disk, with two network adaptors on each node Cluster network 1 = 'Cluster and Client' / Cluster network 2 = 'Cluster only'. SQL server version -…
SQL Server | Other
14,530 questions
asked 2025-08-12T14:58:24.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 22%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Pal Ban
0
Reputation points
answered 2025-08-28T07:03:27.9666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 55.00000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
Nam Bui (WICLOUD CORPORATION)
80
Reputation points Microsoft External Staff
Moderator
1 answer
Cannot connect to SQL Server - username issue
Trying to connect to SQL Server and getting "Login failed for user '<username>'. (Microsoft SQL Server, Error: 18456). My other colleagues are using the same credentials to log in with success. Don't know what else to do.
SQL Server Database Engine
334 questions
asked 2025-08-26T15:19:50.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 72%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hugo Mendonca
0
Reputation points
commented 2025-08-28T06:27:10.5166667+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
1 answer
Performance degrade after migrating to SQL server 2022
Application performance degraded by 15-20 % after moving the database from SQL server 2019 to 2022 on a stand alone server. The resources and maintenance remains the same as the 2019.
SQL Server Database Engine
334 questions
asked 2025-08-27T13:56:31.7266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 63%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Ginesh
0
Reputation points
answered 2025-08-27T21:28:12.16+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
1 answer
Can I safely use NORECOVERY option when restoring a database by a BAK file?
Hello, I am trying to extract the data from a customer-provided BAK file and then discard the SQL server container after. I am using the syntax below. RESTORE DATABASE [ABC123] FROM DISK = '/var/opt/mssql/data/ABC123.bak' WITH MOVE 'ABC123.mdf'…
SQL Server Database Engine
334 questions
asked 2025-08-22T21:26:12.3866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 48%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
dave
0
Reputation points
commented 2025-08-27T21:02:13.0733333+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
1 answer
SQL 2025 release candidate - 180day expiration too for (free edition) express version?
SQL 2025 release candidate - 180day expiration too for (free edition) express version?
SQL Server Database Engine
334 questions
asked 2025-08-27T07:20:53.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Salka, Milan
21
Reputation points
edited an answer 2025-08-27T17:39:42.6766667+00:00
Bruce (SqlWork.com)
79,526
Reputation points
Volunteer Moderator
1 answer
Error execute a SSIS Packed with SQL Agent
Hello, we have a very strange problem when executing an SSIS package with the SQL Agent. The package has the following tasks for an Excel file: 1. Check file in the source path. 2. Copy file to the destination path. 3. Open file in the destination…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,721 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 15%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
1 answer
SQL cluster cannot failover. SQL services cannot start
Hi, I have a 2 node SQL server cluster which cannot failover. The SQL program and DB are located in the shared disk When we try to failover the resource, it cannot auto failover from node A to B. We need to stop node A, manual active all resource in node…
Windows for business | Windows Server | Storage high availability | Clustering and high availability
SQL Server | Other
14,530 questions
asked 2024-08-12T04:36:02.9333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 43%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Chong
871
Reputation points
commented 2025-08-27T12:14:05.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 64%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Spencer Cook
0
Reputation points
2 answers
One of the answers was accepted by the question author.
MSOLEDBSQL19 driver seems to ignore TrustServerCertificate=yes if SQL Server Force Encryption is yes
Microsoft SQL Server 2019 with GDR 2101 (KB5021125) is installed on a Windows Server 2019 computer. The SQL Server has a self-signed certificate and is configured with Force Encryption = yes. A Windows Server 2012 R2 computer has Microsoft OLEDB…
SQL Server | Other
14,530 questions
asked 2023-06-29T16:59:55.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 88%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mitch Gershonowitz
25
Reputation points
commented 2025-08-26T22:25:44.45+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 48%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENL%3C/text%3E%3C/svg%3E)
Nayak, Lakshminarayan
20
Reputation points
1 answer
installation Signing Certificate Authority pour MSSQL.
Il semble que le problème ne soit pas lié à l'application, mais plutôt à SQL Server qui tombe en panne. Ainsi, si MM Server et Client sont en cours d'exécution et que SQL Server tombe en panne, MM Client ne peut pas charger/actualiser les données de la…
SQL Server Database Engine
334 questions
asked 2025-08-26T16:46:04.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 96%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
ANDRE CONGO
0
Reputation points
answered 2025-08-26T21:38:45.5433333+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
3 answers
Best practice with sp_syspolicy_events_reader and ##MS_PolicyEventProcessingLogin##
The SQL Server logs on our primary replica (Microsoft SQL Server 2022 with Always On) has been filling up with this repeated message: The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'SQLAG1_msdb.dbo.syspolicy_event_queue'…
SQL Server Database Engine
334 questions
asked 2025-08-05T14:53:19.4333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 74%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
anna@tec
0
Reputation points
answered 2025-08-26T20:36:57.6366667+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
1 answer
"Is it okay to run Ola Hallengren’s index rebuild and stats update script from a separate database instead of master, and will this impact fragmentation handling?"
In my organisation, we run Ola Hallengren’s index rebuild and update stats script on a separate database instead of the master database. Is this a recommended practice, and will it affect index fragmentation or reorganisation?"
SQL Server Database Engine
334 questions
asked 2025-08-26T18:17:37.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 72%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
N B
0
Reputation points
edited an answer 2025-08-26T19:56:26.97+00:00
Alberto Morillo
34,926
Reputation points MVP
Volunteer Moderator
1 answer
I have a two procedure, first one for Insert and the second one for update, When I update the table using "prcImage", it doesn't update. Can anyone help me to solve this. I provide the table and store procedures check it and also I provide the .cs Code
This is my table CREATE TABLE [dbo].[UserProfile] ON [PRIMARY] This is my 1st Store Procedure ALTER proc [dbo].[prcDataSubmit] @fname varchar(20), @lname varchar(10), @contact char(15), @password varchar(50) as begin declare @yy char(4) declare @mm…
Developer technologies | ASP.NET | Other
3,611 questions
SQL Server | Other
14,530 questions
asked 2025-01-22T21:25:30.67+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 90%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Md Khalid Hossain
0
Reputation points
answered 2025-08-26T15:42:09.6466667+00:00
Bruce (SqlWork.com)
79,526
Reputation points
Volunteer Moderator
1 answer
How to simulate "DB Offline Errors" in SQL server
The SQLServer:SQL Errors object provides counters to monitor errors in Microsoft SQL Server. I wanted to get the DB Offline Errors metric value through performance counters. when i set a particular database offline the offline event is showing as User…
SQL Server Database Engine
334 questions
asked 2025-08-25T10:39:27.6+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 9%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
Joice Joy
20
Reputation points
answered 2025-08-25T21:05:27.68+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
2 answers
Patching is breaking the Master Database of SQL Server Installed
Hello, I am operating Microsoft SQL Server 2019 Enterprise Edition within our environment. One of our SQL Server instances, which is hosted on a virtual machine (VM), has SQL Server Integration Services (SSIS) installed. We’ve encountered a recurring…
SQL Server Database Engine
334 questions
asked 2025-07-29T17:16:10.94+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 28.000000000000004%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Tendongho, Charles
0
Reputation points
edited an answer 2025-08-25T20:44:13.19+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
3 answers
Using Parallels, am I able to run MS SQL Server 2019 Dev Edition on a Macbook Pro M1?
Hello all, I'm currently a student and need to have this software for my class. My professor warned us that Macbook users with apple chips are unable to use these programs. I already have Parallels installed but I'd like to get the communities' input.…
SQL Server Database Engine
334 questions
asked 2025-08-22T20:04:59.77+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 88%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDJ%3C/text%3E%3C/svg%3E)
David J. Castellanos
0
Reputation points
edited an answer 2025-08-25T19:30:23.2333333+00:00
Bruce (SqlWork.com)
79,526
Reputation points
Volunteer Moderator